[SOLVED] Wordpress - MyGallery - mySQL Syntax Error

[inhaco]

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!

 

[fenway]

Yeah, you have two commas there... but if WP is to blame, yell at them!

[inhaco]

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?

[fenway]

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.