SweetLoveFC
20-09-2011, 09:41
Em thử gửi bài trong diễn đàn của em thì nó báo lỗi như vầy
Database error in vBulletin 4.0.7:
Invalid SQL:
SELECT searchgroup.groupid, MATCH(searchgroup_text.title) AGAINST ('[THÔNG BÃO] Diá»…n Ä‘Ã n đã gá»i bà i được') AS score
FROM searchgroup AS searchgroup JOIN searchgroup_text AS searchgroup_text ON
(searchgroup.searchgroupid = searchgroup_text.searchgroupid)
WHERE MATCH(searchgroup_text.title) AGAINST ('[THÔNG BÃO] Diá»…n Ä‘Ã n đã gá»i bà i được') AND
searchgroup.contenttypeid = 2
HAVING score > 4
LIMIT 5;
MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Tuesday, September 20th 2011 @ 10:38:16 AM
Error Date : Tuesday, September 20th 2011 @ 10:38:17 AM
Script : http://tuoitrelongan.com/diendan/newthread.php?do=postthread&f=46
Referrer : http://tuoitrelongan.com/diendan/newthread.php?do=newthread&f=46
IP Address : 183.80.117.44
Username : SweetLoveFC
Classname : vB_Database
MySQL Version : 5.0.45-community-nt
Xin mọi người giúp em ạ ! Huhu
Database error in vBulletin 4.0.7:
Invalid SQL:
SELECT searchgroup.groupid, MATCH(searchgroup_text.title) AGAINST ('[THÔNG BÃO] Diá»…n Ä‘Ã n đã gá»i bà i được') AS score
FROM searchgroup AS searchgroup JOIN searchgroup_text AS searchgroup_text ON
(searchgroup.searchgroupid = searchgroup_text.searchgroupid)
WHERE MATCH(searchgroup_text.title) AGAINST ('[THÔNG BÃO] Diá»…n Ä‘Ã n đã gá»i bà i được') AND
searchgroup.contenttypeid = 2
HAVING score > 4
LIMIT 5;
MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Tuesday, September 20th 2011 @ 10:38:16 AM
Error Date : Tuesday, September 20th 2011 @ 10:38:17 AM
Script : http://tuoitrelongan.com/diendan/newthread.php?do=postthread&f=46
Referrer : http://tuoitrelongan.com/diendan/newthread.php?do=newthread&f=46
IP Address : 183.80.117.44
Username : SweetLoveFC
Classname : vB_Database
MySQL Version : 5.0.45-community-nt
Xin mọi người giúp em ạ ! Huhu