PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |
Old April 20th, 2011, 02:20 PM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: Jul 2010
Posts: 17
Can't Merge Users

Hi;

Whenever I try to merge users, I face the following MySQL error:

Quote:
Database error in vBulletin 4.1.3:

Invalid SQL:

DELETE FROM ppgal_subscribeimage AS subi1
WHERE userid = 150;

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 'WHERE userid = 150' at line 2
Error Number : 1064
Classname : vB_Database
MySQL Version : 5.0.91-community
Any suugestion please?

vBulletin 4.1.3
vBGallery v3.01
__________________
Samer Joudi
http://www.cadmagazine.net

sjoudi is offline   Reply With Quote
Old April 20th, 2011, 02:37 PM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,689
You can try editing the includes\vbgallery\vbgallery_usermerge.php file line 170

Code:
Content visible to verified customers only.
change to

Code:
Content visible to verified customers only.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old April 21st, 2011, 11:36 AM   #3 (permalink)
Junior Member
Verified Customer
 
Join Date: Jul 2010
Posts: 17
Thank you for the reply, but the suggested change didn't work too.

I have removed the alias name, and it worked:

Code:
Content visible to verified customers only.
Is that right?
__________________
Samer Joudi
http://www.cadmagazine.net

sjoudi is offline   Reply With Quote
Old April 21st, 2011, 12:33 PM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,689
well either should work but glad removing that worked.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old April 27th, 2011, 07:27 PM   #5 (permalink)
Junior Member
Verified Customer
 
LaBella's Avatar
 
Join Date: Nov 2005
Posts: 26
Send a message via AIM to LaBella Send a message via MSN to LaBella Send a message via Yahoo to LaBella Send a message via Skype™ to LaBella
Unhappy Me too. Maybe a bug?

Database error in vBulletin 4.1.3:

Invalid SQL:

DELETE FROM ppgal_subscribeimage AS subi1
WHERE userid = 9733;

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 'WHERE userid = 9733' at line 2
Error Number : 1064
MySQL Version : 5.0.92-community-log

Chuck, you *just did* my install yesterday evening
__________________
JerzeeDevil
LaBella is offline   Reply With Quote
Old April 27th, 2011, 07:53 PM   #6 (permalink)
Junior Member
Verified Customer
 
LaBella's Avatar
 
Join Date: Nov 2005
Posts: 26
Send a message via AIM to LaBella Send a message via MSN to LaBella Send a message via Yahoo to LaBella Send a message via Skype™ to LaBella
Exclamation

Quote:
Originally Posted by Chuck S View Post
You can try editing the includes\vbgallery\vbgallery_usermerge.php file line 170

Code:
Content visible to verified customers only.
change to

Code:
Content visible to verified customers only.
I had my server company try this, no one answered the email or anything...

Database error in vBulletin 4.1.3:

Invalid SQL:

DELETE FROM ppgal_subscribeimage AS subi1
WHERE subi1.userid = 9733;

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 'WHERE subi1.userid = 9733' at line 2
Error Number : 1064
Request Date : Wednesday, April 27th 2011 @ 08:50:56 PM
Error Date : Wednesday, April 27th 2011 @ 08:50:57 PM
__________________
JerzeeDevil
LaBella is offline   Reply With Quote
Old April 27th, 2011, 08:15 PM   #7 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,689
well I would help if I had server access. if you dont send it with the actual work documents it does not get saved

The fix is this

Can't Merge Users
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old April 27th, 2011, 08:20 PM   #8 (permalink)
Junior Member
Verified Customer
 
LaBella's Avatar
 
Join Date: Nov 2005
Posts: 26
Send a message via AIM to LaBella Send a message via MSN to LaBella Send a message via Yahoo to LaBella Send a message via Skype™ to LaBella
I think my server company has it sorted. Will report back
__________________
JerzeeDevil
LaBella is offline   Reply With Quote
Old April 27th, 2011, 09:10 PM   #9 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,689
I sent you via email a fixed file.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to merge categories ? nasko Classifieds How do I...? 3 November 15th, 2009 11:17 AM
Merge 2 photoposts into 1? b6gm6n Photopost Pro How Do I...? 2 November 10th, 2006 07:38 PM
Merge user Smoothie Photopost Pro How Do I...? 7 October 15th, 2006 02:18 PM
How do I merge my liscences under 1 ID? PhoenixDown21 General Discussion 1 November 22nd, 2005 09:44 AM
Photopost 4.8.2 How can I merge 2 users Geiri General Discussion 1 December 5th, 2004 09:50 AM


All times are GMT -5. The time now is 10:42 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0