Unholyxando Posted July 5, 2007 Report Share Posted July 5, 2007 Hi @ all ... habe folgendes Problem und leider noch keine Lösung gefunden... Wenn jemand in meinem Shop ein produkt bewertet funktioniert dieses zwar einwandfrei aber nach abschicken der Information erscheint bei mir die Fehlerseite... 1064 - 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 '-0, 0' at line 1 select r.reviews_id, left(rd.reviews_text, 250) as reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = '2' and rd.languages_id = '2' order by r.reviews_id DESC LIMIT -0, 0 ...hat wer ne Idee wo ich da was ändern muss...bin schon total kirre!^^ Danke im voraus^^ Gruß Xando Link to comment Share on other sites More sharing options...
Unholyxando Posted July 5, 2007 Author Report Share Posted July 5, 2007 hat sich erledigt /close/ Link to comment Share on other sites More sharing options...
JoeWied Posted July 17, 2007 Report Share Posted July 17, 2007 Hi @ all ... habe folgendes Problem und leider noch keine Lösung gefunden... Wenn jemand in meinem Shop ein produkt bewertet funktioniert dieses zwar einwandfrei aber nach abschicken der Information erscheint bei mir die Fehlerseite... 1064 - 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 '-0, 0' at line 1 select r.reviews_id, left(rd.reviews_text, 250) as reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = '2' and rd.languages_id = '2' order by r.reviews_id DESC LIMIT -0, 0 ...hat wer ne Idee wo ich da was ändern muss...bin schon total kirre!^^ Danke im voraus^^ Gruß Xando was war der Fehler, ich hab den auch... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.