Advertisement:

Author Topic: [SMF Converter] MyBB 1.2.x  (Read 235583 times)

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] MyBB 1.2.x
« Reply #140 on: May 20, 2008, 02:08:16 AM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline osgeld

  • Semi-Newbie
  • *
  • Posts: 16
Re: [SMF Converter] MyBB 1.2.x
« Reply #141 on: May 20, 2008, 02:30:03 AM »
the max_join_size is already reporting as 100,000,000

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] MyBB 1.2.x
« Reply #142 on: May 20, 2008, 05:44:28 PM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline osgeld

  • Semi-Newbie
  • *
  • Posts: 16
Re: [SMF Converter] MyBB 1.2.x
« Reply #143 on: May 20, 2008, 08:25:53 PM »
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
« Last Edit: May 20, 2008, 10:10:11 PM by osgeld »

Offline saab

  • Newbie
  • *
  • Posts: 2
  • Gender: Male
Re: [SMF Converter] MyBB 1.2.x
« Reply #144 on: June 08, 2008, 10:10:56 AM »
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?

Offline saab

  • Newbie
  • *
  • Posts: 2
  • Gender: Male
Re: [SMF Converter] MyBB 1.2.x
« Reply #145 on: June 08, 2008, 10:14:29 AM »
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:

Code: [Select]
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?

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] MyBB 1.2.x
« Reply #146 on: June 08, 2008, 01:18:07 PM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline scan06disk

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] MyBB 1.2.x
« Reply #147 on: June 10, 2008, 09:05:24 AM »
Hi,

I am getting this error what must i do...? Thank You ! :)
Code: [Select]
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)



Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] MyBB 1.2.x
« Reply #148 on: June 10, 2008, 12:20:06 PM »
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline scan06disk

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] MyBB 1.2.x
« Reply #149 on: June 11, 2008, 07:36:19 AM »
Thank You ! All fixed :D You Guys ROCK ! :D
If you have time check out my website ;)

hxxp:www.jatsim.com [nonactive]

Regards,
Scanny

Offline juliocqw

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] MyBB 1.2.x
« Reply #150 on: June 27, 2008, 12:49:36 PM »
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!
« Last Edit: June 27, 2008, 12:51:32 PM by juliocqw »

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] MyBB 1.2.x
« Reply #151 on: June 27, 2008, 01:20:00 PM »
Find:
Code: [Select]
SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,
Replace:
Code: [Select]
    SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn, 1, 255) AS MSN,
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline juliocqw

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] MyBB 1.2.x
« Reply #152 on: June 27, 2008, 01:53:02 PM »
Find:
Code: [Select]
SUBSTRING(yahoo, 1, 32) AS YIM, SUBSTRING(msn AS MSN, 1, 255) AS MSN,
Replace:
Code: [Select]
    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!

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] MyBB 1.2.x
« Reply #153 on: June 27, 2008, 01:55:20 PM »
Give this file a try:
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline juliocqw

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] MyBB 1.2.x
« Reply #154 on: June 27, 2008, 02:28:15 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!

Offline Gene Steinberg

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] MyBB 1.2.x
« Reply #155 on: June 27, 2008, 08:16:24 PM »
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

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] MyBB 1.2.x
« Reply #156 on: June 28, 2008, 01:08:34 AM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline Hime

  • Newbie
  • *
  • Posts: 5
  • Gender: Male
Re: [SMF Converter] MyBB 1.2.x
« Reply #157 on: June 28, 2008, 08:31:29 AM »
Code: [Select]
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!

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] MyBB 1.2.x
« Reply #158 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.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Hime

  • Newbie
  • *
  • Posts: 5
  • Gender: Male
Re: [SMF Converter] MyBB 1.2.x
« Reply #159 on: June 28, 2008, 03:10:28 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.