PDA

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