I'm having the same problem, ammong others. I also took the same upgrade root as you. But if I find the users through system instead of extended profiles, I can still edit them.

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.

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