News:

Wondering if this will always be free?  See why free is better.

Main Menu

[SMF Converter] MyBB 1.2.x

Started by JayBachatero, January 24, 2007, 11:57:28 AM

Previous topic - Next topic

SleePy

Can you change the mysql settings?
You could set the max_join_size to something bigger and have it allow this

I haven't dug into it, but I am wanting to make the convert.php in the future try to allow big selects by setting it at the start of the conversion and when it detects the error.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

osgeld

the max_join_size is already reporting as 100,000,000

SleePy

Am I able to give this a try and see what i can come up with to get it to convert?

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

osgeld

#143
yea ill set you up on my test server
the production site isnt mine, and only has php 5 which this does not seem to like at all, besides all these errors have been with my site anyway, using php 4(again the production site just dies with no error message on php 5)

again i consider getting an error a step forward

anywho keep an eye out for a PM

saab

Hello,
I am trying to convert from mybb 1.2.13 to SMF 1.1.5,
Thanks to your big help I could convert members but I got following error in second tap of converting process:


Converting members... Successful.
Converting categories... Unsuccessful!
This query:

    INSERT INTO `xxxx_smfxxx`.smf_categories
    (ID_CAT, name, catOrder)
    VALUES ('1', '????? ?? ???????', '1'),
    ('5', ' ????? ????? ???????', '2'),
    ('9', '????? ????? ? ????? ??????', '3'),
    ('12', '????? ?????', '4'),
    ('27', '????? ???? dvb', '5'),
    ('33', '????? ????????', '6'),
    ('39', '????? ??????', '28'),
    ('43', '????? ???', '29'),
    ('50', '????? ??????', '35'),
    ('59', '????? ? ??????? ?????????', '7'),
    ('291', ' ????? ??????? ????? ??????? ??', '8'),
    ('307', '????? ??????? ????? ?????????', '9'),
    ('314', '????? ?????(?????)', '30');

Caused the error:

    Duplicate entry '255' for key 1

May you help me please continuing convertion and come to Great SMF Community?

saab

Hello,
I am trying to convert from mybb 1.2.13 to SMF 1.1.5,
Thanks to your big help I could convert members but I got following error in second tap of converting process:

Converting members... Successful.
Converting categories... Unsuccessful!
This query:

    INSERT INTO `xxxx_smfxxx`.smf_categories
    (ID_CAT, name, catOrder)
    VALUES ('1', '????? ?? ???????', '1'),
    ('5', ' ????? ????? ???????', '2'),
    ('9', '????? ????? ? ????? ??????', '3'),
    ('12', '????? ?????', '4'),
    ('27', '????? ???? dvb', '5'),
    ('33', '????? ????????', '6'),
    ('39', '????? ??????', '28'),
    ('43', '????? ???', '29'),
    ('50', '????? ??????', '35'),
    ('59', '????? ? ??????? ?????????', '7'),
    ('291', ' ????? ??????? ????? ??????? ??', '8'),
    ('307', '????? ??????? ????? ?????????', '9'),
    ('314', '????? ?????(?????)', '30');

Caused the error:

    Duplicate entry '255' for key 1


May you help me please continuing convertion and come to Great SMF Community?

SleePy

Common conversion errors.

I added it to the common conversion errors page.
I am going to work on writing up a script to also fix the categories ids to prevent possible future upgrade issues. Which would basically recount them using lower values.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

scan06disk

Hi,

I am getting this error what must i do...? Thank You ! :)
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user '[s]asudgausdg[/s]'@'localhost' for table 'mybb_users'


Regards,
Scanny 8)



SleePy

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

scan06disk

Thank You ! All fixed :D You Guys ROCK ! :D
If you have time check out my website ;)

hxxp:www.jatsim.com [nonactive]

Regards,
Scanny

juliocqw

#150
Hello Im getting the following error while trying to convert MyBB to SMF:

Converting members... Unsuccessful!
This query:
SELECT
uid AS ID_MEMBER, SUBSTRING(username, 1, 255) AS memberName,
SUBSTRING(username, 1, 255) AS realName,
SUBSTRING(password, 1, 64) AS passwd, email AS emailAddress,
postnum AS posts, SUBSTRING(usertitle, 1, 255) AS usertitle,
lastvisit AS lastLogin, IF(usergroup = 4, 1, 0) AS ID_GROUP,
regdate AS dateRegistered, SUBSTRING(website, 1, 255) AS websiteUrl,
SUBSTRING(website, 1, 255) AS websiteTitle,
SUBSTRING(icq, 1, 255) AS ICQ, SUBSTRING(aim, 1, 16) AS AIM,
SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,
SUBSTRING(signature, 1, 65534) AS signature, hideemail AS hideEmail,
SUBSTRING(buddylist, 1, 255) AS buddy_list,
SUBSTRING(regip, 1, 255) AS memberIP, SUBSTRING(regip, 1, 255) AS memberIP2,
SUBSTRING(ignorelist, 1, 255) AS pm_ignore_list,
timeonline AS totalTimeLoggedIn,
IF(birthday = '', '0001-01-01', CONCAT_WS('-', RIGHT(birthday, 4), SUBSTRING(birthday, LOCATE('-', birthday) + 1, LOCATE('-', birthday, LOCATE('-', birthday) + 1) - LOCATE('-', birthday) - 1), LEFT(birthday, LOCATE('-', birthday) - 1))) AS birthdate
FROM `nextgrul_meg`.mybb_users
LIMIT 0, 500;
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS MSN, 1, 255) AS MSN,
SUBSTRING(signature, 1, 65534) AS signature, hideemail ' at line 10


Can anyone help to solve this problem?

Thanks!

SleePy

Find:
SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,

Replace:
    SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn, 1, 255) AS MSN,
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

juliocqw

Quote from: SleePy on June 27, 2008, 01:20:00 PM
Find:
SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,

Replace:
    SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn, 1, 255) AS MSN,

Thanks a lot, SleePy. I made the change and ran the converter again. The initial problem was solved but now I get the following error:

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Unsuccessful!
This query:
INSERT INTO `nextgrul_meg`.smf_polls
(ID_POLL, SUBSTRING(p.question, 1, 255), votingLocked, ID_MEMBER, expireTime, posterName)
VALUES ('1', 'Do you find handy the proposed file\'s nomenclature?', 'no', '5', '0', 'karol');
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SUBSTRING(p.question, 1, 255), votingLocked, ID_MEMBER, expireTime, posterName)
' at line 2


I wonder if you or someone else could give me a hand to fix that.
Thanks again!

SleePy

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

juliocqw

Quote from: SleePy on June 27, 2008, 01:55:20 PM
Give this file a try:

I used the other .sql file and I still got some errors, but I was able to make the SMF work with the MyBB data.

I think I will leave it like that!

Thanks again!

Gene Steinberg

One down, one to go:

Got one working, but another MyBB board presents:

Notice: Undefined index: table_prefix in /home/rockoids/public_html/forum/convert.php(398) : eval()'d code on line 1

Can I get some direct help on this? Maybe someone can send me a PM on this subject -- the board has about 80-90 messages.

Peace,
Gene

SleePy

Gene,

Did you specify the correct path the the mybb board?
the table_prefix is a variable from the configuration file in mybb that tells us the prefix of the tables.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Hime

Converting members... Unsuccessful!
This query:

    ALTER TABLE `dotnxtc_dbmybb`.smf_members
    CHANGE COLUMN passwordSalt passwordSalt varchar(8) NOT NULL default '';

Caused the error:

    Unknown column 'passwordSalt' in 'smf_members'


Any help please!

SleePy

What version of SMF are you using?

It is telling me that the column is missing, which it shouldn't be if you are using SMF 1.1.
SMF 2.0 converters are not out yet.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Hime

Quote from: SleePy on June 28, 2008, 01:32:37 PM
What version of SMF are you using?

It is telling me that the column is missing, which it shouldn't be if you are using SMF 1.1.
SMF 2.0 converters are not out yet.

that explains everything....I have to roll back...

thanks.

Advertisement: