What do you mean?Ralficzek wrote:i see error that some tables from SMF are missed
Does your SMF board even work? (Particularly personal messages)?Ralficzek wrote:I don't have subforums, i wrote about it in SimpleMachines Official Support, maybe someone from phpbb knows how to help me because they don't
http://www.simplemachines.org/community ... c=232396.0
Code: Select all
CREATE TABLE prefix_personal_messages (
ID_PM int(10) unsigned NOT NULL auto_increment,
ID_MEMBER_FROM mediumint(8) unsigned NOT NULL default '0',
deletedBySender tinyint(3) unsigned NOT NULL default '0',
fromName tinytext NOT NULL,
msgtime int(10) unsigned NOT NULL default '0',
subject tinytext NOT NULL,
body text NOT NULL,
PRIMARY KEY (ID_PM),
KEY ID_MEMBER (ID_MEMBER_FROM, deletedBySender),
KEY msgtime (msgtime)
) TYPE=MyISAM;
CREATE TABLE prefix_pm_recipients (
ID_PM int(10) unsigned NOT NULL default '0',
ID_MEMBER mediumint(8) unsigned NOT NULL default '0',
labels varchar(60) NOT NULL default '-1',
bcc tinyint(3) unsigned NOT NULL default '0',
is_read tinyint(3) unsigned NOT NULL default '0',
deleted tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (ID_PM, ID_MEMBER),
UNIQUE ID_MEMBER (ID_MEMBER, deleted, ID_PM)
) TYPE=MyISAM;
CREATE TABLE prefix_ban_items (
ID_BAN mediumint(8) unsigned NOT NULL auto_increment,
ID_BAN_GROUP smallint(5) unsigned NOT NULL default '0',
ip_low1 tinyint(3) unsigned NOT NULL default '0',
ip_high1 tinyint(3) unsigned NOT NULL default '0',
ip_low2 tinyint(3) unsigned NOT NULL default '0',
ip_high2 tinyint(3) unsigned NOT NULL default '0',
ip_low3 tinyint(3) unsigned NOT NULL default '0',
ip_high3 tinyint(3) unsigned NOT NULL default '0',
ip_low4 tinyint(3) unsigned NOT NULL default '0',
ip_high4 tinyint(3) unsigned NOT NULL default '0',
hostname tinytext NOT NULL,
email_address tinytext NOT NULL,
ID_MEMBER mediumint(8) unsigned NOT NULL default '0',
hits mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (ID_BAN),
KEY ID_BAN_GROUP (ID_BAN_GROUP)
) TYPE=MyISAM;
CREATE TABLE prefix_ban_groups (
ID_BAN_GROUP mediumint(8) unsigned NOT NULL auto_increment,
name varchar(20) NOT NULL default '',
ban_time int(10) unsigned NOT NULL default '0',
expire_time int(10) unsigned,
cannot_access tinyint(3) unsigned NOT NULL default '0',
cannot_register tinyint(3) unsigned NOT NULL default '0',
cannot_post tinyint(3) unsigned NOT NULL default '0',
cannot_login tinyint(3) unsigned NOT NULL default '0',
reason tinytext NOT NULL,
notes text NOT NULL,
PRIMARY KEY (ID_BAN_GROUP)
) TYPE=MyISAM;
Is the subcategory itself not showing up, or is it showing up with no posts in it?PTVDesign wrote:posts in subcategories in smf is not converting
Is there a way to avoid that?functions_smf11.php [ 1326 ]:
Post ID: Message parser error:
Your message contains too few characters.
How did you check this? The skip rows is not always accurate.However it occurred to me that the converter made 500K+ entries in the topics table.
Good to know. It may be quirks with our board which has quite the history of conversions already.I developed the convertor on MySQL5 in strict mode, so that shouldn't be the cause.
How did you check this? The skip rows is not always accurate.However it occurred to me that the converter made 500K+ entries in the topics table.
Code: Select all
mysql> select count(*) from phpbb_topics;
+----------+
| count(*) |
+----------+
| 2999 |
+----------+
1 row in set (0.03 sec)
Let me take a closer look at my results...Attachment handling is intermittent ... I've had a number of boards do it successfully, and a number not.
Code: Select all
mysql> select count(*) from phpbb_attachments;
+----------+
| count(*) |
+----------+
| 12941 |
+----------+
1 row in set (0.06 sec)
mysql> select count(*) from smf_attachments;
+----------+
| count(*) |
+----------+
| 13189 |
+----------+
1 row in set (0.01 sec)
Post away good sir, I'm willing to start the test conversion anew to see if I can help work this out.Before you invest any time in it, I have some other code sitting around that may work better than what is currently posted here.
No, that doesn't look "quite right"! And you allowed the topics conversion step to run all the way to completion?DynaBonk wrote:Hmm... that does not look right either! I would be expecting ~ 44854 topics.Code: Select all
mysql> select count(*) from phpbb_topics; +----------+ | count(*) | +----------+ | 2999 | +----------+ 1 row in set (0.03 sec)
phpBB stores its attachments on the disk. Feel free to try thisAttachment handling is intermittent ... I've had a number of boards do it successfully, and a number not.
Close... but it does not appear to have copied them on disk... does phpbb store them as blobs in the db?
Post away good sir, I'm willing to start the test conversion anew to see if I can help work this out.Before you invest any time in it, I have some other code sitting around that may work better than what is currently posted here.
Well I wasn't sure if it was supposed to make a topic entry for every post... and I never checked the actual count on the table until that post. At least I figured I better look into it before sitting through the posts conversion.No, that doesn't look "quite right"! And you allowed the topics conversion step to run all the way to completion?
Cool! I'll give that a go tomorrow morning and let you know what I get.Feel free to try this
This happened to me too. I tried running every .php file in the convertor archive after uploading them to the correct folders, and they all gave me a blank page, nothing at all happened....I'm converting from SMF 1.1.4 to a freshly installed phpBB 3.0. Any help would be greatly appreciated. Thanks!Ralficzek wrote:You explained it very very bad! FIRSTLY i have to upload normal phpBB3 or what? please tell me? Because when i enter to auth_smf.php file it shows me Blank page, tell me please
The convertor uses the same class to connect to the database as the phpBB core does.DynaBonk wrote:I forgot to mention, it appears conversion does not account for connection to MySQL by socket or named pipe only (I have disabled tcp/ip in MySQL). I edited it to correct that last time, I just need to find where to make that edit again. I can't recall if it was in the converter files or somewhere within the phpbb conversion framework. phpbb itself will install just fine with tcp/ip disabled.
Auto pruning settings default to off.Another question (apologies if it has already been answered): is auto pruning disabled completely? I thought that might explain why I only got 2999 topics last time...
There are no significant DB changes from 3.0.0 to 3.0.1. Just added a column to each of the sessions and the users table table.Also: would the converter be affected by the db changes from phpbb 3.0.0 -> 3.0.1?