Users in vBulletin but not vbGallery??

[Leanne]

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

[Chuck S]

Is your vbgallery a brand new install?

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

[Leanne]

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

[Chuck S]

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