Arkadaşlar smf kurdum sonrada smfnin resmi sitesinden de çevirmek için gerekli mybb converter programını indirdim çevirirken şöyle bir hata verdi
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 `izmiraqu_emre`.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
NASIL SMF YE GEÇİCEM YARDIMLARINIZI BEKLİYORUM...
