inhaco Posted October 23, 2008 Share Posted October 23, 2008 Hi, I run a website based on wordpress. I use the plugin "myGallery" and I added some pictures to my "myGallery" plugin, like I have done several times before. Now I get this error message at: http://www.photomvision.com/today/?page_id=19 WordPress Datenbank-Fehler: [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 '35,36,38,39,40,41,42,43,44,46)' at line 1] SELECT COUNT(id) FROM wp_mygallery WHERE id IN (34,31,33,32,30,,35,36,38,39,40,41,42,43,44,46) WordPress Datenbank-Fehler: [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 '35,36,38,39,40,41,42,43,44,46) ORDER BY wp_mygallery.id DESC' a] SELECT * FROM wp_mygallery WHERE id IN (34,31,33,32,30,,35,36,38,39,40,41,42,43,44,46) ORDER BY wp_mygallery.id DESC I am able to log on to my database mySQL Admin at the providers interface but I don't know anything about mySQL and I don't want to rune my whole database by doing something stupid. Can anybody help me to solve this SQL syntax error? Thank you! Quote Link to comment https://forums.phpfreaks.com/topic/129743-solved-wordpress-mygallery-mysql-syntax-error/ Share on other sites More sharing options...
fenway Posted October 23, 2008 Share Posted October 23, 2008 Yeah, you have two commas there... but if WP is to blame, yell at them! Quote Link to comment https://forums.phpfreaks.com/topic/129743-solved-wordpress-mygallery-mysql-syntax-error/#findComment-673229 Share on other sites More sharing options...
inhaco Posted November 13, 2008 Author Share Posted November 13, 2008 Yeah, you have two commas there... but if WP is to blame, yell at them! I see the two commas. But how do I get to change that. Where does the line come from? mySQL? should I change somethin in the database or does the error come from wp? Quote Link to comment https://forums.phpfreaks.com/topic/129743-solved-wordpress-mygallery-mysql-syntax-error/#findComment-689361 Share on other sites More sharing options...
fenway Posted November 13, 2008 Share Posted November 13, 2008 Yeah, you have two commas there... but if WP is to blame, yell at them! I see the two commas. But how do I get to change that. Where does the line come from? mySQL? should I change somethin in the database or does the error come from wp? MySQL is being told to run a query by WP -- so you'd have to figure out which file is doing it, but this sounds ilke an error on their part. Quote Link to comment https://forums.phpfreaks.com/topic/129743-solved-wordpress-mygallery-mysql-syntax-error/#findComment-689620 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.