The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Transferring 3.8.x users only to 4.1
I'd like to upgrade to 4.1 but because the forum software harkens back from vb2 days there are a lot of extras that are in the mix of database and file structure.
I want to start with a fresh 4.1 install, but I want to keep the users. How can I do this as easy as possible? Or can someone suggest a way to upgrade and clean up the database and the files? |
#2
|
||||
|
||||
I would set up a test site, try installing 4.1 and then, since you only want the users, try using Impex to only import the users. See if that works.
Optionally, use Calorie's database compare utility (do a search - it's in the 3.8 area) and see what extra tables/fields are in your database and do whatever with that info - delete them, keep them, you decide. Then do an upgrade. |
#3
|
||||
|
||||
Thanks. I'm using impex right now and it is importing the users just fine. The next question I have is how can I reset everyone that got imported to a new join date. I want to use a tool like vbexperience but if I keep the old join date, I have one of the same issues I have now.
|
#4
|
||||
|
||||
You could probably do a query to set them to all be some date. It's UNIX time, so google some conversion tool to set the date correctly.
|
#5
|
||||
|
||||
Quote:
I got the conversion for UNIX time. I am not very good with SQL nor queries. I have never been good with them for some reason. Hopefully someone else out there can give me a hand with the exact statement to use, save the UNIX time part. |
#6
|
||||
|
||||
Probably just something like (please backup your database first!!!!!):
Code:
UPDATE user SET joindate=xxxxxxx; |
#7
|
||||
|
||||
Thanks. I had the process die in the middle of import. I'm not sure if this is the correct place to post such a support issue, but I'll start it here and move it at your request.
When I got this the first time, I started over. It keeps failing at the user import script. Quote:
Quote:
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|