Ever since I upgraded from 2.0.13 to 2.2.1 I've been getting syntax errors on both wordpress 1.5.1.3 and XF guestbook 2.22 whenever I try to post something (so i can't post). I made screenshots of the debug message:

Guestbook:
http://www.alcidelic.com/private/guestbookerror.jpg


Wordpress:
http://www.alcidelic.com/private/wordpresserror.jpg

These problems only occured after the 2.2.1 upgrade, they were working fine before that and I didn't change anything to the modules itself.

Yesterday I was also getting a similar syntax error on every single page but that one dissapeared after I deleted a test user which I created using the new extended profile options. I tried dissabling the extended profile module but that didn't fix anything. So maybe it was unrelated.

I'm currently using PHP Version 4.3.11 and MySQL version 4.0.22.

Does any one know how I can fix this?

Thanks in advance

I'm not familiar with either of those modules. But the MySQL error in both cases is due to a missing item in the value list (a comma with nothing after it):

Quote:

To track it down, you might need to locate where that query is generated in the code, and determine why that value is missing.

When I enable PHP debug I get these notices:

Guestbook:


which are these lines:

184: $msgpost->setVar('photo', $photo);

186: $nb_removed_tmp = xfgb_clear_tmp_files( $photos_dir ) ;

Wordpress:


which are these lines:

47: $postObject->setVar('post_excerpt', apply_filters('excerpt_save_pre',$excerpt));

50: $postObject->setVar('post_password', $post_password);

65: if (($user_level > 4) && $edit_date) {

But I'm not sure if this is related to the MySQL syntax error. I'm not that good with PHP.

I can post the full code for that part if needed.