MySQL error in Version 6.0

gargoyl · September 21st, 2007, 04:44 PM

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

Arcade King · September 21st, 2007, 07:29 PM

I get the same error.

Chuck S · September 21st, 2007, 07:53 PM

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.

Code:

Content visible to verified customers only.

Arcade King · September 21st, 2007, 08:29 PM

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.

Michael P · September 21st, 2007, 08:41 PM

in pp-inc.php around line 4283:

Code:

Content visible to verified customers only.

username should be user

Arcade King · September 21st, 2007, 10:03 PM

ok will do

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

Arcade King · September 23rd, 2007, 07:49 PM

Still having the same problem.

Code:

Content visible to verified customers only.

Code:

Content visible to verified customers only.

Chuck S · September 23rd, 2007, 08:04 PM

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.