phpBB to Nuke Conversion Tool Conversion regdate troubles :: Archived

[euology2000]

I recently converter a phpbb database over to my dragonfly CMS database. I used the phpBB to Nuke Conversion Tool and everything transfered fine except the user reg dates. They are all showing up as 31-Dec-1969.

I most unfortunately have limited acces to the actual database, (not my site) so it's excessively difficult for me to really get in there and modify stuff on the fly. I did pull a database back up however, so I can poke aronund it at least.

However, I'm wonder if perhaps the conversion tool is possibly the problem and is simply missing the regdate data from phpbb all together or if it's not getting transfered into dragonfly properly :/ or if there something more going on.

I hopeing a modification to this part of the conversion file.....

Code::

// phpbb_users echo "Exporting {$p_prefix}_users to {$n_prefix}_users<br>"; $result=$dbp->sql_query("SELECT * FROM {$p_prefix}_users ORDER by user_id ASC"); $count=$dbp->sql_numfields($result); while($row=$dbp->sql_fetchrow($result)) { fixQuotes(); $row['user_regdate'] = date("M j, Y", $row['user_regdate']); $dbn->sql_query("INSERT INTO {$n_prefix}_users SET user_id='{$row['user_id']}', user_active_cp='{$row['user_active']}', name='{$row['username']}', username='{$row['username']}', user_password='{$row['user_password']}', user_session_time='{$row['user_session_time']}', user_lastvisit='{$row['user_lastvisit']}', user_regdate='{$row['user_regdate']}', user_level='{$row['user_active']}', user_posts='{$row['user_posts']}', user_timezone='{$row['user_timezone']}', user_style='{$row['user_style']}', user_lang='{$row['user_lang']}', user_dateformat='{$row['user_dateformat']}', user_new_privmsg='{$row['user_new_privmsg']}', user_unread_privmsg='{$row['user_unread_privmsg']}', user_last_privmsg='{$row['user_last_privmsg']}', user_emailtime='{$row['user_emailtime']}', user_viewemail='{$row['user_viewemail']}', user_attachsig='{$row['user_attachsig']}', user_allowhtml='{$row['user_allowhtml']}', user_allowbbcode='{$row['user_allowbbcode']}', user_allowsmile='{$row['user_allowsmile']}', user_allowavatar='{$row['user_allowavatar']}', user_allow_pm='{$row['user_allow_pm']}', user_allow_viewonline='{$row['user_allow_viewonline']}', user_notify='{$row['user_notify']}', user_notify_pm='{$row['user_notify_pm']}', user_popup_pm='{$row['user_popup_pm']}', user_rank='{$row['user_rank']}', user_avatar='{$row['user_avatar']}', user_email='{$row['user_email']}', user_icq='{$row['user_icq']}', user_website='{$row['user_website']}', user_from='{$row['user_from']}', user_sig='{$row['user_sig']}', user_aim='{$row['user_aim']}', user_yim='{$row['user_yim']}', user_msnm='{$row['user_msnm']}', user_occ='{$row['user_occ']}', user_interests='{$row['user_interests']}', user_actkey='{$row['user_actkey']}', user_newpasswd='{$row['user_newpasswd']}' "); $dbn->sql_query("Update {$n_prefix}_users set user_id='1' where username='Anonymous'"); } $dbp->sql_freeresult($result); echo "Done <br><br>";

....is all I need do, but I'm thinkin there may be more to it. And I'm not savvy enough to really know what to mangle...*cough* er change...to get the reg dates to import/convert properly.

I'm not a super duper advanced user, I know enough to look, add, find and modify items, but that about the extend of my skills. Any help would be uber appreciated.

Currently using Dragonfly (9.1.2.1)
MySQL 4.0

[euology2000]

yes I know it says to nuke but its the modified one for CPG based off the nuke one. I failed to mention that above. At work and typing fast hehe. DOh!

[NanoCaiordo]

Code::

user_regdate='".strtotime($row['user_regdate'])."',

[euology2000]

NanoCaiordo wrote:

Code:: user_regdate='".strtotime($row['user_regdate'])."',

Hrm..I changed the

Code::

user_regdate='{$row['user_regdate']}',

and reran the conversion tool. Still showing the dates as 31-Dec-1969.

[NanoCaiordo]

what the original date looks like

[euology2000]

on the phpbb site my user account for example shows the registration date as:

06 Feb 2007

after using the coversion tool my user account registration date shows as:

31-Dec-1969


If I make a new account on dragonfly after the conversion the new account get's the proper registration date however.

[NanoCaiordo]

i mean on the user table

[euology2000]

euology2000 wrote:

after using the coversion tool my user account registration date shows as: 31-Dec-1969

after using the conversion tool my dragonfly user account registration date...

Can't edit so i quoted

[NanoCaiordo]

in the user table before the upgrade

[euology2000]

sorry if I'm being a noob, can you clarify for me I'm not quite sure which piece of info you're requesting.

Currently I haev no mysqadmin access to either the phpbb database nor the dragonfly database 0_o. I can get access but it always takes a few days -_-.

All I can really do atm is pull a backup of the dragonfly one and dig through it.


[edit] found a phpbb backup DB - not sure if this is what you meant tho 0_o [/edit]

Code::

`user_regdate` int(11) NOT NULL default '0', `user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',

[NanoCaiordo]

Code::

`user_regdate` int(11) NOT NULL default '0',

this is teh same format that we use so the original conversion tool should not fail. What will be handy is what is stored in the user_regdate field, is there all numbers? mixed data?

Just get few user_regdate and post them here please.

Code::

SELECT user_regdate FROM users LIMIT 10

[euology2000]

Still had my old test CMS Site up. I have access to it's sql tables via phpmysql so I can get you that info now, thankfully I didn't pull the site down.

Every user that was imported/converter over from phpbb has a 0 in the user_regdate.

[euology2000]

...no idea why i keep tying converter.... meant converted.. being at work and ninja'ing in forum time i suppose heh. To that regard I apologize if my grammar, train of thought and spelling is in the toilet.

[euology2000]

Nevermind that code you posted above got it working

I had to verify that the converter dump the cms_user table, once I was sure it was clean I re-ran the converter.

After that it seemed like it actually inserted new data instead of just avoiding it (it ran through the table conversions pretty fast the first time)

/shrug

All is good THANK YOU!!! so very very much for helping me out with this YOU ROCK!!!

I apologize for not ensureing the table was clean the first time, I asumed the converter cleaned out all the old data 0_o

[Zason]

OK I may have missed something. When I look in the User table and it lists all of the users and their reg dates. The listed dates show the transfered regdate from the PHPnuke site.

user_regdate
Jul 29, 2006
Jul 29, 2006
Aug 01, 2006
Aug 01, 2006
and so on...

However on the actual site it shows them all with the same date: Jan 01, 1970

Now my user_dateformat shows this:
D M d, Y g:i a

Do I need to change this?

And yes I am a noob >;+/

"Z"