Merging Classifieds users With vBulletin

StuntLife · October 17th, 2006, 10:21 AM

I have over 1000 users on the classifieds and a fresh install of vbulletin with just myself as a user.

How do I get all my classifieds users on my vBulletin database?

Chuck S · October 17th, 2006, 10:23 AM

You can use vbulletin's impex importer to import Photopost user's so since the classifieds and photopost users tables are the same just import the photopost users into your vbulletin with there script

StuntLife · October 17th, 2006, 01:30 PM

On to step one. Seems vbulletin wont help because photopost isnt thiers... hmmm...

Anyway. Do I need to change photoposts table prefix's?
Any suggestions?

------------------------------------------------------------
Altering tables
ImpEx will now Alter the tables in the vB database to include import id numbers.This is needed during the import process for maintaining refrences between the tables during an import.If you have large tables (i.e. lots of posts) this can take some time.They will also be left after the import if you need to link back to the origional vB userid.
moderator - importmoderatorid Completed
usergroup - importusergroupid Completed
ranks - importrankid Completed
poll - importpollid Completed
forum - importforumid Completed
forum - importcategoryid Completed
user - importuserid Completed
style - importstyleid Completed
thread - importthreadid Completed
post - importthreadid Completed
thread - importforumid Completed
smilie - importsmilieid Completed
pmtext - importpmid Completed
avatar - importavatarid Completed
customavatar - importcustomavatarid Completed
customprofilepic - importcustomprofilepicid Completed
post - importpostid Completed
attachment - importattachmentid Completed
pm - importpmid Completed
usernote - importusernoteid Completed
phrase - importphraseid Completed
subscription - importsubscriptionid Completed
subscriptionlog - importsubscriptionlogid Completed

Valid found tables :

user found.

Possiablly custom tables or incorrect prefix :

admingroups NOT found.
admlog NOT found.
categories NOT found.
comments NOT found.
ecards NOT found.
exif NOT found.
favorites NOT found.
ipcache NOT found.
iponline NOT found.
laston NOT found.
notify NOT found.
perpage NOT found.
photos NOT found.
settings NOT found.
sort NOT found.
sortmemb NOT found.
usergroups NOT found.
users NOT found.

If you have all red tables, i.e. none correct this could possible be your table prefix :

pp_

Chuck S · October 17th, 2006, 02:20 PM

They are not going to help you with a photopost product no but they should help you with there importer

I think on your impex config file you need to specify the proper database info and table prefix to grab the info. Like I said the classifieds and photopost users tables are exact so there import script for photopost pro to grab users should work fine

StuntLife · October 17th, 2006, 07:35 PM

Thanks ill try that

StuntLife · October 17th, 2006, 08:10 PM

ok now its a new one. i cant find any documentation about this one. The prefix helped with most all the tables.

------------------------------------------------

ImpEx Database errormysql error: Invalid SQL:
SELECT * FROM pp_user
ORDER BY userid
LIMIT 0,2000

mysql error: Table 'stuntlife1.pp_user' doesn't exist

mysql error number: 1146

Date: Tuesday 17th of October 2006 05:46:43 PM
Database: stuntlife1
MySQL error: Table 'stuntlife1.pp_user' doesn't exist

Chuck S · October 17th, 2006, 08:13 PM

thats an error with there impex script you want to report to them and they can fix the table is users not user.

StuntLife · October 17th, 2006, 08:20 PM

Ahh ok Ill try that. It did find users but not user...
----------------------
Valid found tables :

pp_admingroups found.
pp_admlog found.
pp_categories found.
pp_comments found.
pp_favorites found.
pp_ipcache found.
pp_iponline found.
pp_laston found.
pp_notify found.
pp_settings found.
pp_sort found.
pp_usergroups found.
pp_users found.

Possiablly custom tables or incorrect prefix :

pp_ecards NOT found.
pp_exif NOT found.
pp_perpage NOT found.
pp_photos NOT found.
pp_sortmemb NOT found.
pp_user NOT found.

StuntLife · October 18th, 2006, 08:09 AM

Been trying at vBulletin as well. No luck so far there either. ack...

They say I have the wrong version even though I JUST downloaded from them and installed it today!

Chuck S · October 18th, 2006, 09:52 AM

They have the users table misspelled you need to correct that mistake in there import file as its there mistake. dont worry about photopost tables that do not exist. The vbulletin Photopost importer only imports users nothing else and thats what you want

StuntLife · October 18th, 2006, 03:16 PM

Ok thanks. Too bad i dont know where to change the table name! lol

Ill try back with them again. They just keep telling me that Im wrong about various things... ahhh frustrating.

Chuck S · October 18th, 2006, 03:37 PM

No they are wrong on there importer they are looking for user table we dont have one we have a users table and you can tell them Photopost told you so

StuntLife · October 18th, 2006, 05:17 PM

Ohhhh I think Im screwed.... Here is my conversation with vBulletin...

I posted....
According to PhotoPost support, "They have the users table misspelled you need to correct that mistake in thier import file as its thier mistake. dont worry about photopost tables that do not exist. The vbulletin Photopost importer only imports users, nothing else and thats what you want."

Here is the latest quote from Jerry the vBulletin/ImpEx Developer

They are wrong on both points, unless they have changed their user table name for the first part, and for the second part it imports more than the users, I know I wrote it and have been dealing with photopost imports for quite a while now.

I believe I have the ticket assigned to me, I will confirm both points soon.

StuntLife · October 18th, 2006, 05:21 PM

Persistance pays off! lol

Jerry is going to take care of my support ticket!

"Then it has changed since the last update I did for that importer, I done a lot of photopost imports (and more than just users) and it was user then.

I've just checked and I don't have a support ticket for this one, you'll have to open it and ask for me."

Chuck S · October 18th, 2006, 07:07 PM

Jerry is completely wrong our table has always been named users as long as Photopost Pro has been out. If he looks at our upgrade script that goes all the way back to the perl he can clearly see there is nothing where we change table names. We have not done so ever.

StuntLife · October 18th, 2006, 07:41 PM

Well they fixed it with the help ticket... finally!

Now I have another issue/question... Now that the user table has been imported... How do i merge the two so they run off of the same database?

As of now, when someone registers on photopost, they arent added to vbulletin and vice versa... How do i get them to use the same database?

StuntLife · October 18th, 2006, 10:41 PM

Can I tell photopost to start reading users from vbulletin's user database table and let the rest of the program continue on as usual?

Chuck S · October 19th, 2006, 08:37 AM

You need to delete all entries under the usergroups table of photopost and rerun install.php and input all the proper info to integrate with vb3. There are also manual instructions posted in many threads under the keywords switch integration on a search

Your previous photos comments categories will not be deleted

StuntLife · October 19th, 2006, 10:26 AM

Thanks Chuck, I was about to pull out all thats left of my hair!

The search for switch integration is supposed to show me this thread?
http://www.photopost.com/forum/showp...15&postcount=2

StuntLife · October 19th, 2006, 01:13 PM

Quote:

Originally Posted by Chuck S

You need to delete all entries under the usergroups table of photopost

I did this...

Quote:

Originally Posted by Chuck S

and rerun install.php and input all the proper info to integrate with vb3.

I did this as well...

Quote:

Originally Posted by Chuck S

Your previous photos comments categories will not be deleted

Uhhh they were all there and working before i ran install again... now they are all gone! I have 1000 users and NO photos, comments, categories, etc!

HELP!!!