Can't Merge Users

sjoudi · April 20th, 2011, 02:20 PM

Hi;

Whenever I try to merge users, I face the following MySQL error:

Quote:

Database error in vBulletin 4.1.3:

Invalid SQL:

DELETE FROM ppgal_subscribeimage AS subi1
WHERE userid = 150;

MySQL Error : 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 'WHERE userid = 150' at line 2
Error Number : 1064
Classname : vB_Database
MySQL Version : 5.0.91-community

Any suugestion please?

vBulletin 4.1.3
vBGallery v3.01

Chuck S · April 20th, 2011, 02:37 PM

You can try editing the includes\vbgallery\vbgallery_usermerge.php file line 170

Code:

Content visible to verified customers only.

change to

Code:

Content visible to verified customers only.

sjoudi · April 21st, 2011, 11:36 AM

Thank you for the reply, but the suggested change didn't work too.

I have removed the alias name, and it worked:

Code:

Content visible to verified customers only.

Is that right?

Chuck S · April 21st, 2011, 12:33 PM

well either should work but glad removing that worked.

LaBella · April 27th, 2011, 07:27 PM

Database error in vBulletin 4.1.3:

Invalid SQL:

DELETE FROM ppgal_subscribeimage AS subi1
WHERE userid = 9733;

MySQL Error : 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 'WHERE userid = 9733' at line 2
Error Number : 1064
MySQL Version : 5.0.92-community-log

Chuck, you *just did* my install yesterday evening

LaBella · April 27th, 2011, 07:53 PM

Quote:

Originally Posted by Chuck S

You can try editing the includes\vbgallery\vbgallery_usermerge.php file line 170

Code:

Content visible to verified customers only.

change to

Code:

Content visible to verified customers only.

I had my server company try this, no one answered the email or anything...

Database error in vBulletin 4.1.3:

Invalid SQL:

DELETE FROM ppgal_subscribeimage AS subi1
WHERE subi1.userid = 9733;

MySQL Error : 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 'WHERE subi1.userid = 9733' at line 2
Error Number : 1064
Request Date : Wednesday, April 27th 2011 @ 08:50:56 PM
Error Date : Wednesday, April 27th 2011 @ 08:50:57 PM

Chuck S · April 27th, 2011, 08:15 PM

well I would help if I had server access. if you dont send it with the actual work documents it does not get saved

The fix is this

Can't Merge Users

LaBella · April 27th, 2011, 08:20 PM

I think my server company has it sorted. Will report back

Chuck S · April 27th, 2011, 09:10 PM

I sent you via email a fixed file.