Post by teevclothing » Sun Aug 04, 2013 1:33 pm

Hey guys,

I'm getting this error popping up when I am logged in on the front end of my shop, clicking any clothing item.
Strange thing is that it doesn't happen if I'm not logged in?

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'op LEFT JOIN oc_`order` o ON (op.order_id = o.order_id) WHERE o.customer_id = '2' at line 1
Error No: 1064
SELECT COUNT(*) AS total FROM oc_`order_product` op LEFT JOIN oc_`order` o ON (op.order_id = o.order_id) WHERE o.customer_id = '2' AND op.product_id = '43'AND o.order_status_id = '5' in /home/teevcom/public_html/system/database/mysql.php on line 50

Any help would be appreciated :)

Newbie

Posts

Joined
Sun Aug 04, 2013 1:29 pm

Post by i2Paq » Sun Aug 04, 2013 4:35 pm

Clean install of upgrade?

Custome theme or default?

We need more info (link)?

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 wholesellerstore » Tue Aug 13, 2013 11:33 pm

I do have the same error while upgrading...
Its an custom theme.

http://www.vtrade.in/install/index.php?route=upgrade

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AFTER `price`' at line 1
Error No: 1064
ALTER TABLE `oc_profile` CHANGE `frequency` `frequency` ENUM AFTER `price` in /home2/sf7xtep5/public_html/www.vtrade.in/system/database/mysql.php on line 50

Kindly do the needful.


Posts

Joined
Tue Apr 10, 2012 5:21 pm


Post by manoetalk » Fri Aug 16, 2013 12:14 pm

Maybe your can not your case, but I will give a hint to the solution of this error.

This happens in the following case
Are you using a regular user account (registered customers in the store) in maintenance mode enabled in the store.
When you turn a product, this error appears on page totalmnte white.
The problem is related to the fact that this restricted access to the system.

Newbie

Posts

Joined
Thu Aug 01, 2013 3:26 am
Who is online

Users browsing this forum: No registered users and 29 guests