I am running vBulletin 3.7.2 with vbGallery.
I have imported users and posts from a yahoo group using vBulletin's IMPEX tool.
The problem I am now having is that when I have vbGallery installed I am getting an error when I go into the adminCP and go to users and select 'Send Password to User', it sends to my email account a reset password email. In the email it contains a link to reset my password, if I click on this I get the following database error -
Database error in vBulletin 3.7.2:
SELECT activationid, dateline
WHERE type = 1
AND userid =;
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 '' at line 4
Error Number : 1064
Request Date : Monday, July 21st 2008 @ 08:56:50 AM
Error Date : Monday, July 21st 2008 @ 08:56:50 AM
Script : http://www.xxx.com.au/xxx/xxx/login....758&i=29598174
IP Address : xxx.xxx.xxx.xx
Username : xxxxxxx
Classname : vB_Database
MySQL Version : 5.0.51a-community
This error only occurs for the imported users, users created through vBulletin are fine.
I have been in contact with vBulletin and they have informed me that the problem is with vbGallery and gave me the following information, which I am hoping will help solve the problem.
The plugin in question is 'Integrate Postbit Showthread' in PhotoPost_vBGallery.
The problem seems to be that if a user is in the system in vBulletin, but not in vBGallery, it will join empty rows, making vBulletin assume it's a guest, because no userid is set.
Can you please, please, please help me. As these are imported users they must reset their password as it is not imported, I need this function to work.
Just thought I would edit to add - If I import the users first and then install vbGallery, would it copy over all the users or could I manually edit them in the SQL table - is it just the one table?