PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |
Old November 14th, 2011, 07:24 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Oct 2003
Posts: 76
Merge Users Error

Getting the following error when trying to merge users:

DELETE FROM ppgal_subscribeimage
WHERE subi1.userid = 1391;

MySQL Error : Unknown column 'subi1.userid' in 'where clause'
Error Number : 1054


Any help would be appreciated.

Regards
Arachnopets is offline   Reply With Quote
Old November 14th, 2011, 07:47 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,937
HMM try redownloading the software and reimport the plugins option from the install script this is an old bug.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old November 14th, 2011, 12:09 PM   #3 (permalink)
Member
Verified Customer
 
Join Date: Oct 2003
Posts: 76
As per your instructions, I downloaded the newest package, uploaded the files to my server, ran the install and selected: "Reinstall the templates, phrases and plugins."

I am still getting the above error
Arachnopets is offline   Reply With Quote
Old November 14th, 2011, 12:59 PM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,937
HMM what version are you trying to download?
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old November 14th, 2011, 01:12 PM   #5 (permalink)
Member
Verified Customer
 
Join Date: Oct 2003
Posts: 76
I just downloaded 3.01 for vb 4.0
Arachnopets is offline   Reply With Quote
Old November 14th, 2011, 02:36 PM   #6 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,937
Interesting I will check it out but probally this was applied to the code base from what I see. I am looking at the code base and see no instance of a code like that maybe your vbgallery_usermerge.php has not been updated?

Anyway in your forum include/vbgallery directory in the vbgallery_usermerge.php file lines 169-173 should read this

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 offline   Reply With Quote
Old November 14th, 2011, 03:11 PM   #7 (permalink)
Member
Verified Customer
 
Join Date: Oct 2003
Posts: 76
So I should change it to what you just posted?

When I just checked it, lines 169-173 have the following:

Code:
Content visible to verified customers only.
Arachnopets is offline   Reply With Quote
Old November 14th, 2011, 06:04 PM   #8 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,937
yeah I do not show that in our code so yes it should read what I wrote.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   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
Can't Merge Users sjoudi Bugs - vBulletin 4.0 8 April 27th, 2011 09:10 PM
Array merge Error! Cheertobi Installs and Upgrade - vBulletin 3.6x 1 July 21st, 2007 08:49 AM
Merge 2 photoposts into 1? b6gm6n Photopost Pro How Do I...? 2 November 10th, 2006 07:38 PM
function.array-merge error Bryant Bugs - vBulletin 3.5.X 12 January 12th, 2006 09:50 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 01:01 AM.

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