Jump to content
horst

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

Share this post


Link to post
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 ?

 

Share this post


Link to post
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. ?

Share this post


Link to post
Share on other sites

@horst There's another thread,

SVG files do not seem to be involved there.

  • Like 1

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

Thanks to this thread (and Adminer in TracyDebugger) I was able to fix a similar issue I encountered today! This community is awesome! 👍

  • Like 2

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.

×
×
  • Create New...