Jump to content
Klenkes

1054 Unknown column field_fieldname.filedata in field list

Recommended Posts

I just encountered a weird problem with an installation.

I have some sort of a poor man's mediapool, which consists of a template with fields of type files(and a second with images)  to upload PDFs and images which will be linked to from other pages. This worked well for the last months.

This morning an editor called me and sent me this screenshot:

backend.JPG.75a73aebd48d306ce75aa1ae115b11e3.JPG

All files were gone in the backend but still accessable in the frontend and present in /assets/files/

True, there were no columns in the database table named filedata for the fields mediendateien and medienbilder:

fieledata-fehlt.thumb.JPG.c3688385bcec527c3423e88855a01c5d.JPG

I created them manually and the files were back again and the error messages gone.

But what happened?

What is filedata used for? It is of type mediumtext.(I checked other image and file fields) All the other image fields didn't show the missing column. Only those two...
I did an update from PW 3.0.62 to 3.0.98 last week.
Edit: Just discovered that filedata is used for focus information:
 

{"focus":{"top":33,"left":37.5,"zoom":0}}

I kinda fixed it for now, but it makes me nervous...
Anyone an idea?

Edited by Klenkes
added filedata info
  • Like 1

Share this post


Link to post
Share on other sites

Hey,

What happens if you go to the field and go to actions then Check field data? 

Thanks,

  • Like 1

Share this post


Link to post
Share on other sites

Ah, good idea. For now it report "No issues found" but then again I added the columns manually.

I will it check on a cloned site.

Share this post


Link to post
Share on other sites

I just updated a local copy of the site from 3.0.62 to 3.0.98 and the field mediendateien(files) and medienbilder(images) are missing the column filedata afterwards.
Other image or file fields are fine.

During update I hit F5 a few times, refreshed modules and saw that the fields file and image updated.

Then I hit "Check field data" of the fields with missing column filedata and I got an "All okay" 
But the column filedata is missing!

To sum up, there are 5 image fields:
image1 = updated (has data)
image2 = updated (has data)
image3 = not updated (but has no data in DB)
medienbilder = not updated (has data)
pageimages = updated (has data)

2 file fields
dateien = updated
mediendateien = not updated

There has to be raeson why some fields won't update...

  • Like 2

Share this post


Link to post
Share on other sites

I have this same error after updating to the latest version of PW:

Quote

 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_headshot.filedata' in 'field list'

I haven't explored further yet, working on other things, will get to this eventually. Any news what causes this?

  • Like 1

Share this post


Link to post
Share on other sites

I have had this too, today: 

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...