PhotoPost Community - View Single Post

Leanne · July 22nd, 2008, 08:44 AM

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

July 22nd, 2008, 08:44 AM	#1 (permalink)
Leanne Junior Member Verified Customer Join Date: Jul 2008 Posts: 8	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 Last edited by Leanne; July 22nd, 2008 at 08:58 AM. Reason: Added some ideas?