PHPBB 3 -> smf 1.1.13

[mwedner]

Hi,

I do not know if this is the right forum for issues, but could not find a more suitable. After that, I must say that my English is not interesting so I use a program that translates text to me. I would like to convert my phpBB3 to smf, but unfortunately during the process of converting the following error occurs:

Converting ranks... Successful.
Converting groups... Successful.
Converting members... Unsuccessful!
This query:

    SELECT ID_ATTACH, filename
    FROM `overtistest`.strawww_attachments;

Caused the error:

    Unknown column 'ID_ATTACH' in 'field list'

Could someone help me? I do not know too much on this, and would depend on me to convert. I used the bracket Polish aid, advice from other forums but unfortunately no one can help me. Even in the MySQL database, I used a command to create the column:

CREATE TABLE IF NOT EXISTS `smf_attachments` (
  `ID_ATTACH` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ID_THUMB` int(10) unsigned NOT NULL DEFAULT '0',
  `ID_MSG` int(10) unsigned NOT NULL DEFAULT '0',
  `ID_MEMBER` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `attachmentType` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `filename` tinytext NOT NULL,
  `file_hash` varchar(40) NOT NULL DEFAULT '',
  `size` int(10) unsigned NOT NULL DEFAULT '0',
  `downloads` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `width` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `height` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID_ATTACH`),
  UNIQUE KEY `ID_MEMBER` (`ID_MEMBER`,`ID_ATTACH`),
  KEY `ID_MSG` (`ID_MSG`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

It is clear however desired, unfortunately the error still repeats the same content.

Thank you in advance for your help.

[IchBin™]

Sorry, I know very little about the conversion tools and processes we have here. But looking at what you posted, I see that it is looking for the strawww_attachments table, but you have stated that you added the smf_attachments table?

[mwedner]

No, I just changed the prefix "smf_" the "strawww_". Would depend on my help, because at the different ways I tried to fix but it's not possible.

[mwedner]

Hi,

if anyone can help me or do I have to suffer this phpBB3? I could use your script, but unfortunately without your help I will not succeed.

Greetings to all and in advance thank you very much for your help.

[Norv]

Sorry for the delay on this, mwedner.

Can you please tell, what converter did you use?

Right now, the 1.1.13 converters can be found here:
http://download.simplemachines.org/?archive;version=58

[mwedner]

It does not matter, but I really care for this assistance. I used the newest converter placed on your site, and later with the other converter 1.1.9. Still says the same thing.

[mwedner]

that is, no one will help me? Too bad, and hoped for some guidance on this matter.

[Norv]

Apologies for the delay, mwedner!

Please if you wish, try using the converter I attach to my post.

[mwedner]

Never mind. I am glad that someone replied.

But this is a. Sql instead. Php.
I have this file to import with phpmyadmin panel to the base?
Do as I use it?
I ask because I see a converter for the first time in this form and not in the file. Php

[Norv]

Ah. Please download this package: http://download.simplemachines.org/index.php?thanks;filename=smf_1-1-14_phpbb3_converter.zip
and de-archive it.

You will find 2 files, convert.php and an .sql file. Please upload on your forum directory convert.php and the .sql file I attached myself above. (it has a couple of fixes right now, comparing to the version for download - for the moment).

And run convert.php.