SMF Thailand.
SMF Support => General Thai Support => ข้อความที่เริ่มโดย: firstsmart ที่ 31/08/06, 19:21:04
-
Converting members... Unsuccessful!
This query:
SELECT
u.user_id AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
SUBSTRING(u.username, 1, 255) AS realName,
SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS lastLogin,
u.user_regdate AS dateRegistered,
SUBSTRING(u.user_from, 1, 255) AS location,
u.user_posts AS posts, IF(u.user_level = 1, 1, mg.ID_GROUP) AS ID_GROUP,
u.user_new_privmsg AS instantMessages,
SUBSTRING(u.user_email AS emailAddress, 1, 255) AS emailAddress,
u.user_unread_privmsg AS unreadMessages,
SUBSTRING(u.user_msnm AS MSN, 1, 255) AS MSN,
SUBSTRING(u.user_aim AS AIM, 1, 16) AS AIM,
SUBSTRING(u.user_icq, 1, 255) AS ICQ,
SUBSTRING(u.user_yim, 1, 32) AS YIM,
SUBSTRING(u.user_website, 1, 255) AS websiteTitle,
SUBSTRING(u.user_website, 1, 255) AS websiteUrl,
u.user_allow_viewonline AS showOnline, u.user_timezone AS timeOffset,
IF(u.user_viewemail = 1, 0, 1) AS hideEmail, u.user_avatar AS avatar,
REPLACE(u.user_sig, '\n', '<br />') AS signature,
u.user_sig_bbcode_uid AS signature_uid, u.user_avatar_type,
u.user_notify_pm AS pm_email_notify, u.user_active AS is_activated,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
'' AS personalText, '' AS timeFormat, '' AS usertitle, '' AS memberIP,
'' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
'' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
'' AS memberIP2
FROM `twoteen`.phpbb_users AS u
LEFT JOIN `twoteen`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
LEFT JOIN `twoteen`.smf_membergroups AS mg ON (BINARY mg.groupName = CONCAT('phpBB ', r.rank_title))
WHERE u.user_id != -1
GROUP BY u.user_id
LIMIT 0, 500;
Caused the error:
You have an error in your SQL syntax near 'AS emailAddress, 1, 255) AS emailAddress,
u.user_unread_privmsg AS unreadMessag' at line 9
นะครับ ตัว convert โหลดมาจากเว็บ smf นะคับ
ยังไงขอคำชี้แนะด้วยนะครับ
ขอบคุณ
-
ผมเคยพยายามเปลี่ยนจาก phpbb เป็น smf 1.1 rc2 แต่ไม่สำเร็จครับ มี error เพียบเลย ผมเลยใช้วิธีเปลี่ยนจาก phpbb เป็น smf 1.0.7 ซะก่อน แล้วจึงอัพเกรดเป็น smf 1.1 rc2 ทุกอย่างผ่านฉลุยครับ
-
Yeezy Slides (https://www.yeezysslides.us.com/)
Yeezy Official Website (https://www.yeezyofficialwebsite.us.com)
Jordan 1 (https://www.jordans1.us.com/)
Jordan 12 (https://www.airjordan12.us.com/)
Jordan 11 (https://www.airjordan11.us.com/)
Yeezy Slides (https://www.yeezyslideswebsite.us.com/)
NFL Shop (https://www.nfl-shop.us.com/)
NFL Store (https://www.nfl-store.us.com/)
Yeezy Slides (https://www.yeezyslides.mx/)
Yeezy 350 (https://www.yeezy350.mx/)
Jordan 4 (https://www.jordan4.mx/)
Yeezy Supply (https://www.yeezysupplywebsite.us.com)
Jordan 4 (https://www.jordan4.us.com/)
Yeezy Website (https://www.yeezywebsite.us.com/)
Yeezy Slides (https://www.yeezyslidesofficials.us.com/)
Jordan 12 (https://www.jordan12.us.com/)
Jordan 11 (https://www.jordans11.us.com/)
Jordan 1 (https://www.jordan1.us.com/)
Air Jodan (https://www.air-jordan.us.com/)
NFL Jerseys (https://www.nfl-jerseys.us.com/)
Yeezy Slides (https://www.yeezyslideswebsites.us.com/)
Yeezy Website (https://www.yeezyslideswebsites.us.com/)
Yeezy Supply (https://www.yeezysupplywebsites.us.com/)
Yeezy Store (https://www.yeezy-stores.us.com)
Yeezy Slides (https://www.yeezyslidesstore.us.com)
Yeezy Store (https://www.yeezyslidesstore.us.com)
Louis Vuitton (https://www.lvoutlets.us.com)
Louis Vuitton Outlet (https://www.lvoutlets.us.com)
Louis Vuitton (https://www.lvoutlet.us.com)
Louis Vuitton Outlet (https://www.lvoutlet.us.com)
Louis Vuitton (https://www.louis-vuitton-outlets.us.com)
Louis Vuitton Outlet (https://www.louis-vuitton-outlets.us.com)
Louis Vuitton (https://www.lv-outlet.us.com)
Louis Vuitton Outlet (https://www.lv-outlet.us.com)
Yeezy Shoes (https://www.yeezyshoes.de/)
Yeezy Supply (https://www.yeezysupplys.de/)
Yeezy Slides (https://www.yeezy-slides.de/)
Yeezy 350 (https://www.yeezy-350.de/)
Yeezy Slides (https://www.yeezy-slidess.us/)
Yeezy Adidas (https://www.yeezyadidas.us.com/)
Yeezy Official Website (https://www.yeezyofficialwebsites.us.com)
Adidas Yeezy (https://www.adidasyeezys.us.com)
Yeezy Supply (https://www.yeezys-supplys.us.com)
Yeezy Slides (https://www.yeezy-slidess.us.com)
Yeezy Slides (https://www.yeezyslidesofficial.us.com)
Yeezy Official (https://www.yeezyslidesofficial.us.com)
Yeezy 350 (https://www.yeezyboost350v2.us.com)
Tags:Yeezy Shoes,Yeezy Slides,Jordan 1,Air Jordan,Jordan