En cours

google feed generator, sql syntax Error No: 1064, opencart site

We submit 9 google feeds for google shopping. Currently our feed generator is not working.

The error it produces is

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 'Array GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE([url removed, login to view]) ASC LIMIT ' at line 1

Error No: 1064

SELECT p.product_id, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND [url removed, login to view] = '1' GROUP BY r1.product_id) AS rating FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND [url removed, login to view] = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'Array GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE([url removed, login to view]) ASC LIMIT 0,20000 in /home/gobstock/public_html/system/database/[url removed, login to view] on line 49

We need someone to help us fix it.

Compétences : Apache, MySQL, PHP

Voir plus : error 1064 opencart, error 1064, opencart error 1064, error sql site shopping, error 1064 mysql opencart, working from home review, working for google from home, working for google at home, submit your feed, google working from home, asc it, error 1064 mysql opencart line, p sql, syntax, Sql 2012, google shopping, google shopping feed, google review, google feeds, php sql syntax error, opencart syntax error, google shopping feeds, google select, apache server 2012, 1064 php

Concernant l'employeur :
( 49 commentaires ) palatine, United States

N° du projet : #2394210

Décerné à :

exitsol

can get started right away. its a simple fix

40 $ USD en 0 jours
(105 Commentaires)
5.8

5 freelance ont fait une offre moyenne de 79 $ pour ce travail

azaqero

Hello Can fix it right now :)

75 $ USD en 0 jours
(24 Commentaires)
4.6
chienthuatxd

very simple, I will start now, please pm for me

30 $ USD en 0 jours
(26 Commentaires)
4.6
hbthosting

we can do it prompt

100 $ USD en 0 jours
(0 Commentaires)
0.0
KasunKeaz

sir im a IT undergraduate student. I have a good knowledge about mysql. i think i can correct your error. thank you.

150 $ USD en 1 jour
(0 Commentaires)
0.0