News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

phpbb 2.0.17 to SMF 1.1 RC2

Started by DeathfireD, January 28, 2006, 04:40:25 AM

Previous topic - Next topic

DeathfireD

I happend to notice the converter wasnt working with RC2 so I changed the Version info in the php script and managed to convert half my database. It seems it wont convert my members and private messages. When it gets to members it shows successfull but really it didnt even touch the 740 mebers in the phpbb database. When it gets to the private messages it hangs up for a good 2 mins then the page times out and I get a 404 errors message.

Im assuming the members issue is due to phpbb maby changing its members field name and the converter is looking for somthing else..I dont know though. As for the messages I think ill try deleting them all, it may be timing out becuse theres no members to place the private messages in.

CAn anyone help me with these issues? Iv very much like to use this forum software but I dont wanna start over and have all my users reregister :(

Fizzy

Hi,

Can you post the phpbb2 members table structure please so we can verify that the convertor will be searching for the right table and field content.

You should be able to access it in phpmyadmin / phpbb2 database name / members table name
"Reality is merely an illusion, albeit a very persistent one." - A.E.


DeathfireD

it also seems member groups dont convert eaithor. Anything to do with users seems to hang up.

Heres the users structure:
CREATE TABLE phpbb_users (
  user_id mediumint(8) NOT NULL default '0',
  user_active tinyint(1) default '1',
  username varchar(25) NOT NULL default '',
  user_password varchar(32) NOT NULL default '',
  user_session_time int(11) NOT NULL default '0',
  user_session_page smallint(5) NOT NULL default '0',
  user_lastvisit int(11) NOT NULL default '0',
  user_regdate int(11) NOT NULL default '0',
  user_level tinyint(4) default '0',
  user_posts mediumint(8) unsigned NOT NULL default '0',
  user_timezone decimal(5,2) NOT NULL default '0.00',
  user_style tinyint(4) default NULL,
  user_lang varchar(255) default NULL,
  user_dateformat varchar(14) NOT NULL default 'd M Y H:i',
  user_new_privmsg smallint(5) unsigned NOT NULL default '0',
  user_unread_privmsg smallint(5) unsigned NOT NULL default '0',
  user_last_privmsg int(11) NOT NULL default '0',
  user_emailtime int(11) default NULL,
  user_viewemail tinyint(1) default NULL,
  user_attachsig tinyint(1) default NULL,
  user_allowhtml tinyint(1) default '1',
  user_allowbbcode tinyint(1) default '1',
  user_allowsmile tinyint(1) default '1',
  user_allowavatar tinyint(1) NOT NULL default '1',
  user_allow_pm tinyint(1) NOT NULL default '1',
  user_allow_viewonline tinyint(1) NOT NULL default '1',
  user_notify tinyint(1) NOT NULL default '1',
  user_notify_pm tinyint(1) NOT NULL default '0',
  user_popup_pm tinyint(1) NOT NULL default '0',
  user_rank int(11) default '0',
  user_avatar varchar(100) default NULL,
  user_avatar_type tinyint(4) NOT NULL default '0',
  user_email varchar(255) default NULL,
  user_icq varchar(15) default NULL,
  user_website varchar(100) default NULL,
  user_from varchar(100) default NULL,
  user_sig text,
  user_sig_bbcode_uid varchar(10) default NULL,
  user_aim varchar(255) default NULL,
  user_yim varchar(255) default NULL,
  user_msnm varchar(255) default NULL,
  user_occ varchar(100) default NULL,
  user_interests varchar(255) default NULL,
  user_actkey varchar(32) default NULL,
  user_newpasswd varchar(32) default NULL,
  user_whosonline_color int(11) NOT NULL default '0',
  karma_plus mediumint(9) NOT NULL default '0',
  karma_minus mediumint(9) NOT NULL default '0',
  karma_time bigint(20) NOT NULL default '0',
  PRIMARY KEY  (user_id),
  KEY user_session_time (user_session_time)
) TYPE=MyISAM;


heres the user group struct:
CREATE TABLE phpbb_user_group (
  group_id mediumint(8) NOT NULL default '0',
  user_id mediumint(8) NOT NULL default '0',
  user_pending tinyint(1) default NULL,
  KEY group_id (group_id),
  KEY user_id (user_id)
) TYPE=MyISAM;

Fizzy

#3
Well this is the section of the convertor that deals with members relationships between tables.


// *** SMF column => other forum's column. ************************************
$members_table = array(
'ID_MEMBER' => 'user_id',
'memberName' => 'username',
'dateRegistered' => 'user_regdate',
'posts' => 'user_posts',
'ID_GROUP' => "IF(user_level = 1, '1', '0')",
'lngfile' => '',
'lastLogin' => 'user_lastvisit',
'realName' => 'username',
'instantMessages' => 'user_new_privmsg',
'unreadMessages' => 'user_unread_privmsg',
'im_ignore_list' => '',
'passwd' => 'user_password',
'emailAddress' => 'user_email',
'personalText' => '',
'gender' => '',
'birthdate' => '',
'websiteTitle' => 'user_website',
'websiteUrl' => 'user_website',
'location' => 'user_from',
'ICQ' => "IF(user_icq = 0, '', user_icq)",
'AIM' => 'user_aim',
'YIM' => 'user_yim',
'MSN' => 'user_msnm',
'hideEmail' => "IF(user_viewemail = 1, '0', '1')",
'showOnline' => 'user_allow_viewonline',
'timeFormat' => '',
'signature' => "REPLACE(REPLACE(IF(user_sig_bbcode_uid = '', user_sig, REPLACE(REPLACE(user_sig, CONCAT(':1:', user_sig_bbcode_uid), ''), CONCAT(':', user_sig_bbcode_uid), '')), '\\n', '<br />'), '\"', '&quot;')",
'timeOffset' => 'user_timezone',
'avatar' => 'user_avatar',
'im_email_notify' => 'user_notify_pm',
'karmaBad' => '',
'karmaGood' => '',
'usertitle' => '',
'notifyAnnouncements' => '',
'secretQuestion' => '',
'secretAnswer' => '',
'additionalGroups' => '',
'is_activated' => 'user_active',
);


I can't see anything obvious in structure that would make it trip during conversion.

When you are running the conversion do you get to see "Converting members..." in your browser ?
Are you writing the SMF tables in the same database where you have phpbb? If not, try that. The tables won't overwrite as they should have different prefixes.
Most importantly, is your SMF clean install running ok?
"Reality is merely an illusion, albeit a very persistent one." - A.E.


DeathfireD

Well it goes to fast to see. As soon as I view the php file I get "Success", Success, success all the way down till it gets to messages and posts then it goes converting posts please wait. Then after that it goes to private messages and times out.

So for some reason it seems like its not touching the members table.

Offtopic: I had a karma mod in the users sql code, you can see the lines karma_plus mediumint(9) NOT NULL default '0',
  karma_minus mediumint(9) NOT NULL default '0',
  karma_time bigint(20) NOT NULL default '0',
But I doubt thats the problem.

Any more ideas?

Fizzy

OK,

So let's start with step one and work through systematically.
Can you provide a link to your installed SMF Forum and also your phpbb2 forum. (feel free to PM me if you don't want them public)
"Reality is merely an illusion, albeit a very persistent one." - A.E.


Advertisement: