MySQL error in Version 6.0
 

hi,
here is an sql error in version 6.0 with vbulletin 3.6.8 integration.


An error was encountered during execution of the query:

UPDATE photo_photos SET username='XXXXXX' WHERE userid=XXXXX

The query returned with an errorcode of:

Unknown column 'username' in 'field list'




Peter

I get the same error.

Can you please explain what action you are taking in the program when you get this error.

I dont know if there are other areas but line 4273 of pp-inc.php should be this in bold user not username for the query. If there is anything else you need let me know.

Seems to happen when a user enters the gallery who hasn't viewed the Gallery since the upgrade and only seems to happen once from what i can tell.
BTW my photopost is integrated with VB 3.6.8.

in pp-inc.php around line 4283:

username should be user

ok will do

Theres quite a few lines there with users too? should all instances of users be user?

Still having the same problem.

If you edit the line Michael and I both pointed out in pp-inc.php your error should be corrected and I beleive Michael has also updated the build download on this issue.