Users in vBulletin but not vbGallery??
 

Hi,

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:

Invalid SQL:

SELECT activationid, dateline
FROM useractivation
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
Referrer :
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?

Thanks,
Leanne

Is your vbgallery a brand new install?

You could disable all plugins in vbgallery to see if this helps as well.

Hi Chuck,

Yes it is all new installs, the site is yet to go live. I have installed vBulletin, then vbGallery. I have then done the import of users.

I added one of the imported users into the ppgal_user table and the reset password function now works, so it seems because the user record was missing from the vbGallery user table then it was not working.

If I go and manually add all the imported userids into the ppgal_user table, can you think of anything else that could cause a problem because I have imported users into the vBulletin database, rather than adding users the normal way.

Thanks,
Leanne

I would suggest uninstalling vbgallery and then reinstalling after importing users and see if that helps.