View Full Version : dates all from 1970 after import
red4
Fri 24th Feb '06, 5:44pm
i have read through the HOW-TO thread, imported all of my threads/forums/ posts, updated all of my counters, but still i get dates of 01/01/1970 on all of my posts.
what can i do to remedy this problem?
Jerry
Fri 24th Feb '06, 6:34pm
Going to need some more details of the source data to help :
http://www.vbulletin.com/forum/showthread.php?t=161907
red4
Fri 24th Feb '06, 6:39pm
Clean import
Source - phpBB2 - 2.0.19
Target - vBulletin 3.5.4
I imported all of my information from another board. After importing the posts, threads, and forums successfully, I ran the various Counter Rebuilds. Even after that, the dates on all of my posts and threads read as 01/01/1970.
Jerry
Fri 24th Feb '06, 6:44pm
Was it a MySQL or MSSQL source database ?
Did you update the counters in order : threads > forums > rebuild forum cache ?
red4
Fri 24th Feb '06, 6:50pm
Was it a MySQL or MSSQL source database ?
Did you update the counters in order : threads > forums > rebuild forum cache ?
MySQL database. i had to edit some of the table names in teh MyPHP section to allow for me to import them into vBulletin.
i am almost positive i updated them in that order, but i will try once more.
one thing i did notice was that when i tried to rebuild the post cache it came up as saying "0 posts edited."
EDIT: i just rebuilt in that order and it did say "7200 posts edited" when rebuilding the post cache. however, the dates are still wrong.
Jerry
Fri 24th Feb '06, 6:57pm
What tables are you editing ? If you have to hack the source database its probably not a default phpBB2 forum database ?
red4
Fri 24th Feb '06, 7:00pm
What tables are you editing ? If you have to hack the source database its probably not a default phpBB2 forum database ?
my database was named jdmcoupe_phpbb1, and inside of that i had to hack the phpbb_privmsgs to make it say phpbb_prv_msg in order for it to import correctly. there were a couple other tables like thread title i think as well.
Jerry
Fri 24th Feb '06, 7:05pm
Sounds like you are using the phpBB1 importer to import a phpBB2 board, you don't need to change table names to get ImpEx to work.
red4
Fri 24th Feb '06, 7:43pm
Sounds like you are using the phpBB1 importer to import a phpBB2 board, you don't need to change table names to get ImpEx to work.
looks like that was the problem. i had used the wrong imported to bring my information over.
i recovered by backup for the original site and reinstalled that, then ran ImpEx again with the phpBB2 importer, Updated Counters, and eveything is going smoothly.
thanks for your quick support! :D
vBulletin® v3.8.0 Beta 3, Copyright ©2000-2008, Jelsoft Enterprises Ltd.