[SMF Converter] MyBB 1.6

[Marshall007]

HI All, Getting this error when convertin.

Converting...
Converting moderators... Successful.
Converting topic view logs... Successful.
Converting attachments... Successful.
Recalculating forum statistics... Duplicate column name 'id_member'

[DanThemes]

I get this error when trying to convert MyBB 1.6.8 to SMF 2 RC3:

Image url: hxxp:awesomescreenshot.com/0c0cbnb11 [nonactive]

[xanenightwing]

Hello. even with the updated .sql file, I keep getting the birthday error. what would the best fix be?

nevermind. everything is fixed.

[jaacobbi]

When I go to convert.php it shows this:


And I picked 1.4 and this happend:


Now I can't go back and pick that other. So whats the problem?

[jaacobbi]

Got new problem : http://www.simplemachines.org/community/index.php?topic=487390.msg3413633#msg3413633.

[zapex]

Do i need to upload zip via package manager or? How to use it.

[gonss]

And i have this error

Code Select Expand

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.6. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: SELECT command denied to user 'lolserbi_stefan'@'localhost' for table 'mybb_users'
bump

[gonss]

Okey I fix problem, now I have this:

Code Select Expand

Successful.
Recalculating forum statistics...
That mean I need to wait?

[rodelio.lagahit]

is this the right mod where i'm going to upload myBB database to SMF database?

I have a myBB database and I wanted it merge to my existing SMF database. Can someone point me to the right direction? Thanks in advance

[KaJzEr 283]

I have this error

Unsuccessful!
This query:
SELECT value
FROM `hightech_mybb313`.mybb_settings
WHERE variable = 'attachmentUploadDir'
LIMIT 1;
Caused the error:
Unknown column 'variable' in 'where clause'

[adbrad]

I'm geting this error

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.6. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: SELECT command denied to user 'web1-smf-1'@'localhost' for table 'mybb_users'

anyone know the fix, I have seen people post the same error but never get a reply.

[Arantor]

Well, the error seems fairly clear: you've set up MyBB in a database and it has a username and a password. SMF has a username and a password but you've put it in a different database and the username and password SMF has can't get to the MyBB database... so there's no way SMF can import it.

Install SMF into the same database with the same user and password as MyBB is currently installed in (using smf_ as the prefix to avoid collision) and then it'll work.

This is the same error everyone else has and is the same error as the very first entry in http://www.simplemachines.org/community/index.php?topic=146192.0 and it's also mentioned in http://wiki.simplemachines.org/smf/Converting

[adbrad]

Thanks arantor i sort of did that but did it the other way round and had to set the mybb database config to the smf data base but then i get the birthday error.

[lifesucks]

Hi,

I am trying to convert from mybb 1.6 to smf and i am facing these issues. Can someone help me here

Converting members...Wrong value type sent to the database. Date expected. (birthdate)

Then i did this

Code: [Select]
---* {$to_prefix}members

add after:
Code: [Select]
---{
/* fix invalid birthdates */
if(!preg_match('/\d{4}-\d{2}-\d{2}/', $row['birthdate']))
   $row['birthdate'] = '0001-01-01';
---}




Then also i am getting the same error message

Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)

[JCatalan55]

Hola, gracias por el aporte, pero no hay manera de ponerlo... Alguna ayuda? Gracias!

[Klevron]

When im Converting

Code Select Expand

MyBulletinBoard 1.6 to SMF Converter
Converting...
Converting members... Unsuccessful!
This query:
ALTER TABLE `oldschoo_oldsc991_mybb123`.smf_members
CHANGE COLUMN passwordSalt passwordSalt varchar(8) NOT NULL default '';
Caused the error:
Unknown column 'passwordSalt' in 'smf_members'

[Klevron]

Problem as Always

Code Select Expand

Converting...
Converting topics...
Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Unsuccessful!
This query:
SELECT
p.pid AS id_poll, SUBSTRING(p.question, 1, 255) AS question, p.closed AS voting_locked,
t.uid AS id_member,
IF(p.timeout = 0, 0, p.dateline + p.timeout * 86400) AS expire_time,
SUBSTRING(t.username, 1, 255) AS poster_name
FROM `oldschoo_oldsc991_mybb123`.mybb_polls AS p
LEFT JOIN `**************`.mybb_threads AS t ON (t.tid = p.tid)
LIMIT 0, 500;
Caused the error:
BIGINT value is out of range in '(`*******************`.`p`.`timeout` * 86400)'

[saosangmo]

hi,
Does anyone convert mybb 1.6.7 to SMF 2.0.x?
thanks

[AllanD]

If you go to mybb converters download the bottom one that says mybb to smf 2-0 
Here is the link  http://download.simplemachines.org/?converters;software=mybb

I have used this several times without errors.

[bobmail]

Hi

I have the following error, trying to convert from Mybb 1.6.9:

Converting posts (this may take some time)...The database value you're trying to insert does not exist: poster_email

Is there an updated .sql file that would work better?

Thanks!