Emperatour
19-07-07, 15:04
دوستان سلام. من میخام مای بیبی رو به اس ام اف یا phpbb یا هر سیستم رایگان که دردسرهای مای بیبی مثل کوکی رو نداشته باشه تبدیل کنم. تو تبدیل به اس ام اف مشکل دارم میشه کمک کنید ؟
اس ام اف در پوشه smf در پابلیک اچ تی ام ال نصبه و یک دیتابیس داره برا خودش و مای بیبی که الان نصبه هم در پوشه خودش و بانگ خودشو داره. من کانورتور رو در پئشه اس ام اف ریختم و اجرا کردم. این اومد:
مسیر اس ام اف، مسیر مای بی بی و پسورد دیتابیس رو خواست ازم. من هم همه چیز رو درست وارد کردم ولی بعد از مدتی بهم این ارور رو داد
MyBulletinBoard 1.0 to SMF Converter Converting... 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 `hamechiz_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 signature, hideemail ' at line 10
اس ام اف در پوشه smf در پابلیک اچ تی ام ال نصبه و یک دیتابیس داره برا خودش و مای بیبی که الان نصبه هم در پوشه خودش و بانگ خودشو داره. من کانورتور رو در پئشه اس ام اف ریختم و اجرا کردم. این اومد:
مسیر اس ام اف، مسیر مای بی بی و پسورد دیتابیس رو خواست ازم. من هم همه چیز رو درست وارد کردم ولی بعد از مدتی بهم این ارور رو داد
MyBulletinBoard 1.0 to SMF Converter Converting... 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 `hamechiz_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 signature, hideemail ' at line 10