Post by f1br3opt1c » Fri Apr 24, 2015 4:21 am

Hi,

I really would appreciate if someone could help me solve this problem im all of a sudden having with my Opencart 1.5.6.4 website.

It all of a sudden breaks a product and it seems to be doing it on my bestsellers. All of a sudden when i try to view that certain product, it shows this error:

Code: Select all

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 ') GROUP BY op.product_id ORDER BY no_sells DESC LIMIT 0,4' at line 3
Error No: 1064
SELECT op.product_id, SUM(op.quantity) as no_sells FROM oc_order_product op WHERE op.product_id !='82' AND op.order_id IN (3545,3544,3543,3539,3538,3532,3502,3501,3500,3499,3498,3494,3493,3490,3480,3474,3454,3442,3440,3419,3417,3416,3409,3387,3378,3376,3374,3373,3355,3353,3350,3330,3326,3323,3317,3311,3301,3300,3273,3253,3250,3249,3246,3245,3239,3238,3236,3228,3224,3222,3220,3213,3204,3182,3175,3159,3156,3152,3146,3133,3119,3116,3110,3098,3077,3059,3035,3015,3007,3006,2995,2993,2991,2951,2929,2873,2860,2859,2837,2784,2782,2777,2769,2752,2716,2701,2672,2671,2660,2643,2619,2596,2584,2575,2573,2531,2519,2481,2469,2450,2422,2393,2369,2363,2358,2355,2347,2327,2278,2271,2230,2184,2180,2178,2134,2117,2106,2092,2086,2084,2079,2077,2067,2063,2032,2026,1985,1978,1967,1948,1937,1936,1915,1914,1911,1889,1888,1883,1882,1881,1880,1870,1866,1850,1777,1776,1770,1757,1671,1657,1656,1655,1625,1595,1567,1566,1545,1544,1536,1490,1486,1485,1484,1460,1421,1418,1410,1409,1406,1403,1402,1401,1385,1377,1376,1375,1352,1348,1347,1279,1254,1220,1137,1100,1099,1093,1038,1036,1027,1017,1015,1013,961,799,748,747,648,647,620,619,618,479,478,477,291,236,226,225,) GROUP BY op.product_id ORDER BY no_sells DESC LIMIT 0,4 in /home2/luxurywa/public_html/.com/system/database/mysql.php on line 50
In the backend error log it shows:

Code: Select all

2015-04-23 15:03:10 - PHP 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 ')
						GROUP BY op.product_id ORDER BY no_sells DESC LIMIT 0,4' at line 3<br />Error No: 1064<br />SELECT op.product_id, SUM(op.quantity) as no_sells FROM oc_order_product op   
						WHERE op.product_id !='82'  
						AND op.order_id IN (3545,3544,3543,3539,3538,3532,3502,3501,3500,3499,3498,3494,3493,3490,3480,3474,3454,3442,3440,3419,3417,3416,3409,3387,3378,3376,3374,3373,3355,3353,3350,3330,3326,3323,3317,3311,3301,3300,3273,3253,3250,3249,3246,3245,3239,3238,3236,3228,3224,3222,3220,3213,3204,3182,3175,3159,3156,3152,3146,3133,3119,3116,3110,3098,3077,3059,3035,3015,3007,3006,2995,2993,2991,2951,2929,2873,2860,2859,2837,2784,2782,2777,2769,2752,2716,2701,2672,2671,2660,2643,2619,2596,2584,2575,2573,2531,2519,2481,2469,2450,2422,2393,2369,2363,2358,2355,2347,2327,2278,2271,2230,2184,2180,2178,2134,2117,2106,2092,2086,2084,2079,2077,2067,2063,2032,2026,1985,1978,1967,1948,1937,1936,1915,1914,1911,1889,1888,1883,1882,1881,1880,1870,1866,1850,1777,1776,1770,1757,1671,1657,1656,1655,1625,1595,1567,1566,1545,1544,1536,1490,1486,1485,1484,1460,1421,1418,1410,1409,1406,1403,1402,1401,1385,1377,1376,1375,1352,1348,1347,1279,1254,1220,1137,1100,1099,1093,1038,1036,1027,1017,1015,1013,961,799,748,747,648,647,620,619,618,479,478,477,291,236,226,225,)
						GROUP BY op.product_id ORDER BY no_sells DESC LIMIT 0,4 in /home2/luxurywa/public_html/.com/system/database/mysql.php on line 50
When i copy the same product and enable it, then it works fine.

I've also got a person who is very well knowledgeable about opencart to take a look at this but even he can't seem to pin point the exact problem that is causing it. I feel helpless....

I would really appreciate if someone could point me to the right direction of what is causing this. I tried uninstalling all my VQMODS but nothing seems to work :(
Last edited by f1br3opt1c on Sat Apr 25, 2015 11:34 pm, edited 1 time in total.

New member

Posts

Joined
Fri May 24, 2013 5:36 pm

Post by chulcha » Fri Apr 24, 2015 5:38 am

What is it

AND op.order_id IN (3545,3544,3543,3539,3538,353...
291,236,226,225,)

last coma

Active Member

Posts

Joined
Fri Jul 18, 2014 4:39 pm

Post by f1br3opt1c » Fri Apr 24, 2015 11:19 am

chulcha wrote:What is it

AND op.order_id IN (3545,3544,3543,3539,3538,353...
291,236,226,225,)

last coma
Is there anyway to know what is causing this? I wouldn't mind paying someone to fix it for me.

New member

Posts

Joined
Fri May 24, 2013 5:36 pm

Post by PeteA » Fri Apr 24, 2015 9:03 pm

This appears to be from an extension that you've got for handling best sellers. Happy to have a look if you let me know what extension (send the vqmod xml to me if you can).

New member

Posts

Joined
Wed Jul 30, 2014 5:46 pm

Post by f1br3opt1c » Sat Apr 25, 2015 11:34 pm

PeteA wrote:This appears to be from an extension that you've got for handling best sellers. Happy to have a look if you let me know what extension (send the vqmod xml to me if you can).
My theme might have came with a mod to handle bestsellers as i do not have any other mods i can remember of being installed to handle best sellers.

I can grant you FTP access to my site if thats okay with you?

New member

Posts

Joined
Fri May 24, 2013 5:36 pm

Post by PeteA » Wed Apr 29, 2015 4:29 pm

Hi, I sent you a PM on the 27th. Still happy to help on this if you let me have the FTP details via PM

New member

Posts

Joined
Wed Jul 30, 2014 5:46 pm
Who is online

Users browsing this forum: Amazon [Bot], Bing [Bot], edkny and 125 guests