Error 1054 Unknown column

  • dmolina
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 8 months ago #2373 by dmolina
Error 1054 Unknown column was created by dmolina
Hi, i migrate my site from j1.5 to j3.4 and fine.

First with SP Upgrade the core elements, and after the differents components like Custom Properties, with your tutorials and support. All right.

But now i see this error if i click in a tag, inside the article (front-end):

1054 Unknown column 'cp.article_id' in 'field list' SQL=SELECT cp.article_id FROM nth9o_custom_properties_values AS cp WHERE cp.id = 2


Part of the message is hidden for the guests. Please log in or register to see it.


Can you helpme to resolve this?
Thanks a lot!

Please Log in or Create an account to join the conversation.

More
8 years 8 months ago #2374 by andrea_4g
Replied by andrea_4g on topic Error 1054 Unknown column
Hi,
something must have gone wrong during the upgrade. It looks like the DB tables have not been updated.
However there's a solution: you can manually run a few queries (see linked post).

www.solidsystem.it/forum/custom-properti...ml?limitstart=0#1943

Note: after you successfully updated the tables, you'll need to review and save each Custom Properties field, as detailed hereinafter:
www.solidsystem.it/forum/custom-properti...98.html?start=6#1949
The following user(s) said Thank You: dmolina

Please Log in or Create an account to join the conversation.

  • dmolina
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 8 months ago #2375 by dmolina
Replied by dmolina on topic Error 1054 Unknown column
Ok thanks Andrea, works fine!

Please Log in or Create an account to join the conversation.

Time to create page: 0.161 seconds