- Posts: 26
- Thank you received: 0
Error 1054 Unknown column
- dmolina
- Topic Author
- Offline
- Junior Member
Less
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!
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.
- andrea_4g
- Offline
- Administrator
Less
More
- Posts: 1122
- Thank you received: 163
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
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
Less
More
- Posts: 26
- Thank you received: 0
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.125 seconds