Post by anastamir » Sat Nov 19, 2011 12:59 pm

hi,
i have upgrade my website to new version,all the step i will do and is OK,but can't show any product , in sitmap i can see all product ,also i can search product but when i click show this error :

Notice: Error: Unknown column 'sort_order' in 'order clause'
Error No: 1054
SELECT * FROM a_product_image WHERE product_id = '146' ORDER BY sort_order ASC in /home/aelabcn/public_html/system/database/mysql.php on line 49

also show product name but can't show any photo

So Please help me to solve this problem,thanks

New member

Posts

Joined
Wed Oct 27, 2010 7:38 pm

Post by i2Paq » Sat Nov 19, 2011 6:20 pm

Did you use our FREE search on: "Unknown column 'sort_order' in 'order clause'"?

Did you run the upgrade script?

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by anastamir » Sun Nov 20, 2011 10:27 am

thanks for your help,i have check all post,again i use 1.5.1.3 upgrade,now everything is ok,can see product,but only have problem for show photo,in any place can't see any photo , please help me to solve this problem .

New member

Posts

Joined
Wed Oct 27, 2010 7:38 pm

Post by i2Paq » Sun Nov 20, 2011 5:48 pm

Please post a link to your store.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands
Who is online

Users browsing this forum: No registered users and 4 guests