Users in vBulletin but not vbGallery??
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?
Is your vbgallery a brand new install?
You could disable all plugins in vbgallery to see if this helps as well.
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.
I would suggest uninstalling vbgallery and then reinstalling after importing users and see if that helps.
|All times are GMT -5. The time now is 12:42 AM.|
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0