Jump to content

[SOLVED] "Column Not Found ... field_fname.filedata" SQL Error after Update von PW 3.0.62 to 3.0.130


Recommended Posts

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

After upgrading a live site from 3.0.62 to 3.0.130 we get this error when in PageEditor with that field. It is an image field.

We also have done some field and template export and import from a local site to the live site, but nothing in regard to that field or the two templates that contain it.

On the pages that raise the error the field is empty. What is this {field_imagename}.filedata used for??

The DB-Dump shows the table is there and correct.

Link to comment
Share on other sites

EDIT: The error is raised also on pages that do not contain that field.

Why is it searching for the tablename with the added .filedata  and what / where is the 'field list' that do not contain the tablename.filedata ?


Link to comment
Share on other sites

Ok, I found out that there are 4 pages should contain an image. The images are SVGs and they reside in the respective folders. (As we haven't changed anything in that regard). On the editor pages, the images field is shown empty, even when it should contain one SVG image.

Now I think it can be something related to imagefiles especially and only SVG. ?

Link to comment
Share on other sites

@Lutz Heckelmann Oh, thanks a lot!

Now I know what is missing. The column filedata is available in my local version, but is missing in the live version.

Only difference between the upgrades from local and live is, that the local one was updated step by step since the last two years, as it is symlinked to my pw-dev-latest directory, but the live one was updated from 3.0.62 to 3.0.130 in one go.

So, now I will alter the table to add this missing column.


EDIT: Issue solved! ?

  • Like 3
Link to comment
Share on other sites

@horst Great, thanks for the explanation. Despite such rare errors I personally prefer those loose connections between Dev (local), Staging and Production, compared to the stricter ones you usually need with Craft.

  • Like 1
  • Haha 1
Link to comment
Share on other sites

  • 4 months later...

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