PhotoPost Community - View Single Post - Need some help after switching to VBulletin

Mr Gixxer · April 6th, 2006, 02:21 AM

I posted this on their site and they said "go ask here..."

I just realised tonite that all the member numbers are wrong compared to what they used to be

We recently moved from UBBThreads and the import worked great! We moved over 55,000 members and over 1 million posts

Now to get all the other apps to work well

It seems that UBB likes to reserve UID #1 for the install, anyways now our admin was user number 4 (forget when it started, could be as far back as when we ran classic?)

So duh of course now there will be a problem with PhotoPost, Reviewpost, and PhotoClassifieds that we run since they are pointing to incorrect user numbers now

Do you think there might be a chance to run some sql to increment by 2 or 3 or whatever it takes so that what Photopost thinks is number 4 is actually member number 1 ?

Then I pray that they are all just shifted by that amount

edit: I just checked and the offset is random

guess I am screwed?

April 6th, 2006, 02:21 AM	#1 (permalink)
Mr Gixxer Junior Member Verified Customer Join Date: Apr 2006 Posts: 6	Need some help after switching to VBulletin I posted this on their site and they said "go ask here..." I just realised tonite that all the member numbers are wrong compared to what they used to be We recently moved from UBBThreads and the import worked great! We moved over 55,000 members and over 1 million posts Now to get all the other apps to work well It seems that UBB likes to reserve UID #1 for the install, anyways now our admin was user number 4 (forget when it started, could be as far back as when we ran classic?) So duh of course now there will be a problem with PhotoPost, Reviewpost, and PhotoClassifieds that we run since they are pointing to incorrect user numbers now Do you think there might be a chance to run some sql to increment by 2 or 3 or whatever it takes so that what Photopost thinks is number 4 is actually member number 1 ? Then I pray that they are all just shifted by that amount edit: I just checked and the offset is random guess I am screwed?