Database error with 2.51/vb 3.8.6

[klaush]

Hello Chuck,

first, i did read the two threads about this problem. But we cannot fix that error, because it happens not always, when a new user registered.

In this case the database error happens when the registration link is clicked. You can´t also change the users status in the admin centrum, maybe from awaiting verifying email address to a registered user.

You first have to deactivate the gallery plugin, then all database errors are history.

Datenbankfehler in vBulletin 3.8.6:

Invalid SQL:

SELECT activationid, usergroupid, emailchange
FROM vb3_useractivation
WHERE activationid = '57076ech3d842264d3fd52f48f4dc7058757'
AND userid =
AND type = 0;

MySQL-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 'AND type = 0' at line 5
Fehler-Nr. : 1064
Fehler-Zeit : Thursday, 16.12.2010 @ 19:36:41
Datum : Thursday, 16.12.2010 @ 19:36:41
Skript : http://xxx/xxx/register.php?do=activate
Referrer : http://xxx/register.php?a=ver
IP-Adresse : 90.xxx.121.xxx
Benutzername : newuser
Klassenname : vB_Database

Any idea what could cause this?

Greetings

Klaus

[klaush]

Still have this issue when a user registrates.

When deactivating vbgallery it´s gone.

Greetings

Klaus

[Luciano]

did you try the fix here?
fetch_userinfo_query

[klaush]

Nope Luciano, but we will try it asap!

Thanks!

Originally Posted by Luciano

did you try the fix here?
fetch_userinfo_query

[Fenriz]

We have the same issue with 2.51/vb 3.8.6. Why there isn't any 2.52 with fixing that?

[klaush]

Lucianos fix solves this issue.

Originally Posted by Fenriz

We have the same issue with 2.51/vb 3.8.6. Why there isn't any 2.52 with fixing that?