1054 Unknown column field_fieldname.filedata in field list

Recommended Posts

Posted (edited)

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:


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:


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:


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

Edited by Klenkes
added filedata info

Share this post

Link to post
Share on other sites


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


  • 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...

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.