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:
QuoteConverting 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:
QuoteCREATE 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.
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?
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.
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.
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
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.
that is, no one will help me? Too bad, and hoped for some guidance on this matter.
Apologies for the delay, mwedner!
Please if you wish, try using the converter I attach to my post.
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
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.