Türkçe Smf Teknik Destek Sitesi

Bu özellik size üyenin attığı tüm iletileri gösterme olanağı sağlayacaktır. Not sadece size izin verilen bölümlerdeki iletilerini görebilirsiniz.

#3

Çözülenler / Mybb'den SMF geçiş

25 Haz 2017, 21:56

mybb sürümüm 1.8.7 geçiş sırasında hata alıyorum

Kod Seç Genişlet

SELECT
uid AS id_member, SUBSTRING(username, 1, 255) AS member_name,
SUBSTRING(username, 1, 255) AS real_name, email AS email_address,
SUBSTRING(password, 1, 64) AS passwd, SUBSTRING(salt, 1, 8) AS password_salt,
postnum AS posts, SUBSTRING(usertitle, 1, 255) AS usertitle,
lastvisit AS last_login, IF(usergroup = 4, 1, 0) AS id_group,
regdate AS date_registered, SUBSTRING(website, 1, 255) AS website_url,
SUBSTRING(website, 1, 255) AS website_title,
SUBSTRING(icq, 1, 255) AS icq, SUBSTRING(aim, 1, 16) AS aim,
SUBSTRING(yahoo, 1, 32) AS yim, SUBSTRING(msn, 1, 255) AS msn,
SUBSTRING(signature, 1, 65534) AS signature, hideemail AS hide_email,
SUBSTRING(buddylist, 1, 255) AS buddy_list,
SUBSTRING(regip, 1, 255) AS member_ip, SUBSTRING(regip, 1, 255) AS member_ip2,
SUBSTRING(ignorelist, 1, 255) AS pm_ignore_list,
timeonline AS total_time_logged_in,
CASE
WHEN birthday = '' THEN '0001-01-01'
ELSE CONCAT_WS('-', RIGHT(birthday, 4), SUBSTRING(birthday, LOCATE('-', birthday) + 1, LOCATE('-', birthday, LOCATE('-', birthday) + 1) - LOCATE('-', birthday) - 1), LEFT(birthday, LOCATE('-', birthday) - 1))
END AS birthdate
FROM `ni286172_1sql1`.mybb_users
LIMIT 0, 500;
Caused the error: