Unknown column 'b.ID_LAST_TOPIC' in 'on clause'
File: /home/campt/domains/camptour.net/public_html/forum/Sources/Recent.php
Line: 45
(ใช้ php YaBBSE forum ) ครับ
Tag : - - - -
Date :
20 มี.ค. 2551 10:19:38
By :
tawat
View :
1329
Reply :
2
No. 1
Guest
ค้นหาเองจนเจอครับ ผิดนิดเดียว
ไปแก้ที่ Recent.php ครับ (แก้ตัวอักษรสีแดงครับ)
SELECT m.posterTime, m2.subject, m.ID_TOPIC, t.ID_BOARD, m.posterName, t.numReplies, t.ID_FIRST_MSG
FROM {$db_prefix}boards AS b, {$db_prefix}categories AS c
LEFT JOIN {$db_prefix}topics AS t ON (t.ID_TOPIC= 'b.ID_LAST_TOPIC')
LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG= 't.ID_LAST_MSG')
LEFT JOIN {$db_prefix}messages AS m2 ON (m2.ID_MSG= 't.ID_FIRST_MSG') 'b.ID_LAST_TOPIC') 't.ID_LAST_MSG') 't.ID_FIRST_MSG')
Date :
22 มี.ค. 2551 02:18:10
By :
tawat
No. 2
Guest
SELECT m.posterTime, m2.subject, m.ID_TOPIC, t.ID_BOARD, m.posterName,
t.numReplies, t.ID_FIRST_MSG
FROM {$db_prefix}boards AS b, {$db_prefix}categories AS c
LEFT JOIN {$db_prefix}topics AS t ON (t.ID_TOPIC='b.ID_LAST_TOPIC')
LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG='t.ID_LAST_MSG')
LEFT JOIN {$db_prefix}messages AS m2 ON (m2.ID_MSG= 't.ID_FIRST_MSG')
Load balance : Server 05
