Advertisement:

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

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] MyBB 1.2.x
« Reply #40 on: August 08, 2007, 01:43:57 AM »
The SMF converters do not have UTF-8 support yet. But hopefully they will in the future.
The query error is an issue with mysql. You should ask your host to upgrade.
You can also remove that query from the sql file and it will work just fine without it.
I guess you missed the UTF-8 Conversion topic. ::)

Also are you guys still having problems with this converter?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline CSpili

  • Newbie
  • *
  • Posts: 5
  • Gender: Male
Re: [SMF Converter] MyBB 1.2.x
« Reply #41 on: August 08, 2007, 10:02:49 AM »
Hey Jay!

Just tested the latest one you got here and had alien symbols.  I'm now checking the UTF-8 Conversion Topic and will let you know.  Thanks for the great work Jay!

Cheers,
Constantinos

Offline EximTrak

  • Semi-Newbie
  • *
  • Posts: 33
  • Gender: Male
    • ForumExi
Re: [SMF Converter] MyBB 1.2.x
« Reply #42 on: August 25, 2007, 06:28:41 PM »
Can we convert banned members?

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] MyBB 1.2.x
« Reply #43 on: August 26, 2007, 08:43:06 PM »
You mean set the banned status for those members that are banned?  If so I'll look and see how MyBB handles it.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline EximTrak

  • Semi-Newbie
  • *
  • Posts: 33
  • Gender: Male
    • ForumExi
Re: [SMF Converter] MyBB 1.2.x
« Reply #44 on: August 27, 2007, 11:41:44 AM »
You mean set the banned status for those members that are banned?  If so I'll look and see how MyBB handles it.

Yeah i mean this ;) I have lots of banned members and to set their status to banned will take long time :(

Also can we convert the locked topics?

Thanks..
« Last Edit: August 27, 2007, 11:47:59 AM by EximTrak »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] MyBB 1.2.x
« Reply #45 on: August 28, 2007, 10:40:55 PM »
Ok added to the todo list.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline Minare

  • Sophist Member
  • *****
  • Posts: 1,233
  • Gender: Male
  • Yapayalnız Kalmak İskelelerde !
    • Meryemce
Re: [SMF Converter] MyBB 1.2.x
« Reply #46 on: August 31, 2007, 05:06:59 AM »
I got this error :

Code: [Select]
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 `ea2_`.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 signa
O güzel Râsulu Yesrip yolunda
Hicret coşkusuyla aramalısın
Ayrılık Anne'den Baba'dan Yâr'dan
Ezelden geçerek kavuşmalısın

http://www.meryemce.biz

Offline Minare

  • Sophist Member
  • *****
  • Posts: 1,233
  • Gender: Male
  • Yapayalnız Kalmak İskelelerde !
    • Meryemce
Re: [SMF Converter] MyBB 1.2.x
« Reply #47 on: August 31, 2007, 05:01:22 PM »
What can I  do, any ideas ?  :(
O güzel Râsulu Yesrip yolunda
Hicret coşkusuyla aramalısın
Ayrılık Anne'den Baba'dan Yâr'dan
Ezelden geçerek kavuşmalısın

http://www.meryemce.biz

Offline EximTrak

  • Semi-Newbie
  • *
  • Posts: 33
  • Gender: Male
    • ForumExi
Re: [SMF Converter] MyBB 1.2.x
« Reply #48 on: September 03, 2007, 01:36:05 AM »
Try to use the latest convert.php and mybb12_to_smf.sql ;)

Offline Minare

  • Sophist Member
  • *****
  • Posts: 1,233
  • Gender: Male
  • Yapayalnız Kalmak İskelelerde !
    • Meryemce
Re: [SMF Converter] MyBB 1.2.x
« Reply #49 on: September 03, 2007, 03:08:04 AM »
Try to use the latest convert.php and mybb12_to_smf.sql ;)

I thought that I did as u said. Can u pls give me the links to those sources for guarentee ?
O güzel Râsulu Yesrip yolunda
Hicret coşkusuyla aramalısın
Ayrılık Anne'den Baba'dan Yâr'dan
Ezelden geçerek kavuşmalısın

http://www.meryemce.biz

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline xScopex

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] MyBB 1.2.x
« Reply #51 on: September 18, 2007, 10:19:49 PM »
When I tried this I got
Code: [Select]
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 `clanfall_mybb`.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 sign
I am running on MyBB1.2.9 would this be the problem>

NVM: I got it to work.
« Last Edit: September 18, 2007, 10:40:31 PM by xScopex »

Offline dudeness3

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] MyBB 1.2.x
« Reply #52 on: October 03, 2007, 01:42:16 AM »
I got this error

Code: [Select]
Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `dude`.smf_smileys
    ORDER BY LENGTH(code) DESC;

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 'LENGTH(code) DESC' at line 2

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] MyBB 1.2.x
« Reply #53 on: October 03, 2007, 01:50:04 AM »
Don't worry about that error.  Just run Find and Repair errors in Admin > Forum Maintenance then do a stats recount and you should be fine.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline dudeness3

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] MyBB 1.2.x
« Reply #54 on: October 03, 2007, 02:08:27 AM »
Don't worry about that error.  Just run Find and Repair errors in Admin > Forum Maintenance then do a stats recount and you should be fine.
Thanks, it worked out fine :)

Offline marc25v

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] MyBB 1.2.x
« Reply #55 on: October 08, 2007, 08:17:48 PM »
Hello,  I am trying to convert my MyBB forum to SMF.  I used the script located in this thread and the convert.php in the one that links to this one (has all the forum choices) . 

Step 1 never loads, it loads a white page in firefox and a Connection Error in IE.  If I change the step1 in the URL to step2, the page loads with the following error.  Everything seems imported other than the posts and threads.  Also, these are the only errors I get.  These are all seen on the step2 page where it says Conversion Successful...

Code: [Select]
Recalculating forum statistics...
Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 930

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 939

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 949

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 957

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 967

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 972

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 980

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 993

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1032

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1039

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1041

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1047

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1053

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1058

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1064

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1065

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1073

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1075

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1081

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1082

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1088

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1089

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1105

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1113

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1115

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1121

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1133

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1151

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1158

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1160

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1192

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1197

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1198

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1227

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1235

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1240

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1301

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1303

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1329

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1339

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1358

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1363

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Notice: Undefined index: substep in /home/zendurl/public_html/~/~forum/convert.php on line 1376

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1845

Notice: Undefined variable: result in /home/zendurl/public_html/~/~forum/convert.php on line 1846

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1381

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/zendurl/public_html/~/~forum/convert.php on line 1382
Successful.

Offline Clarky

  • Semi-Newbie
  • *
  • Posts: 16
Re: [SMF Converter] MyBB 1.2.x
« Reply #56 on: October 13, 2007, 06:52:39 AM »
Im getting the below error. Please help!

Code: [Select]
Recalculating forum statistics... Unsuccessful!
This query:
UPDATE `rcforum_smf`.smf_boards
SET ID_LAST_MSG = 1053, lastUpdated = 1190815870
WHERE ID_BOARD = 4
LIMIT 1;
Caused the error:

Unknown column 'lastUpdated' in 'field list'

Offline Clarky

  • Semi-Newbie
  • *
  • Posts: 16
Re: [SMF Converter] MyBB 1.2.x
« Reply #57 on: October 15, 2007, 03:07:55 AM »
Successfully converted :D

I wasnt using the latest convert.php :) :D

www.rc-forums.co.uk [nofollow]

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] MyBB 1.2.x
« Reply #58 on: October 16, 2007, 06:05:44 PM »
marc25v what permission is the file set to?  Also who is your host?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline marc25v

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] MyBB 1.2.x
« Reply #59 on: October 16, 2007, 07:44:31 PM »
Hello, my permissions are all set to 777 and I own my own server.  It is a dedicated server which costs me a lot.

Waiting for your reply.