Quote:
Originally Posted by sergio00
I get " Database Error" too:
my Vbulletin version: 3.8.5
Code:
Database error in vBulletin 3.8.5:
Invalid SQL:
SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=11
AND MATCH(pmtext.title, pmtext.message) AGAINST ('+encuentro' IN BOOLEAN MODE)
ORDER BY pmtext.dateline DESC;
MySQL Error : The used table type doesn't support FULLTEXT indexes
Error Number : 1214
Request Date : Thursday, May 16th 2013 @ 04:12:35 PM
Error Date : Thursday, May 16th 2013 @ 04:12:35 PM
Script : http://www.aeromodelismovirtual.com/private.php?pmsearch=1
Referrer : http://www.aeromodelismovirtual.com/private.php?pmsearch=1
IP Address : 80.36.255.96
Username : sergio00
Classname : vB_Database
MySQL Version : 5.0.96-community-log
Can any help me?
BEst Regards for the support!!
|
Quote:
The used table type doesn't support FULLTEXT indexes
|
Which version MySQL is installed on the server?
Type tables: MyISAM or InnoDB?