Tweet
I have tried to rebuild similar threads in a beta site on 4.2.5 beta 4 and 4.2.5 RC1 and get the same failure.
Update: I tried this on the original production system it was copied from running 4.2.3pl2 and it has the same error.
When it crashed, the last console message was Processing: 45111
Could that mean that my problem is with thread 45111 ?
/showthread.php?4511 displays just fine.
Does anybody have a clue as to what this might be? Note the mysterious message in the AGAINST
Any Clues would be greatly appreciated. The database has no crashed tables.
Thank you in advance!
Rebuild Similar Threads beta/vbfs
Database error in vBulletin 4.2.5 Beta 4:
Invalid SQL:
SELECT searchgroup.groupid, MATCH(searchgroup_text.title) AGAINST ('* * Does anyone know what this is for? * *') AS score
FROM searchgroup AS searchgroup JOIN searchgroup_text AS searchgroup_text ON
(searchgroup.searchgroupid = searchgroup_text.searchgroupid)
WHERE MATCH(searchgroup_text.title) AGAINST ('* * Does anyone know what this is for? * *') AND
searchgroup.contenttypeid = 2
AND searchgroup.groupid <> 45112
HAVING score > 4
LIMIT 5;
MySQL Error : syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'
Error Number : 1064
Request Date : Thursday, April 6th 2017 @ 02:27:28 PM
Error Date : Thursday, April 6th 2017 @ 02:27:29 PM
Script : http://beta.domain.com/vbfs/admincp/...t=45043&pp=100
Referrer : https://beta.domain.com/vbfs/admincp...t=44943&pp=100
IP Address :
Username : rick
Classname : vB_Database_MySQLi
MySQL Version : 10.1.21-MariaDB
Server :
User Agent :
Update: I tried this on the original production system it was copied from running 4.2.3pl2 and it has the same error.
When it crashed, the last console message was Processing: 45111
Could that mean that my problem is with thread 45111 ?
/showthread.php?4511 displays just fine.
Does anybody have a clue as to what this might be? Note the mysterious message in the AGAINST
Any Clues would be greatly appreciated. The database has no crashed tables.
Thank you in advance!
Rebuild Similar Threads beta/vbfs
Database error in vBulletin 4.2.5 Beta 4:
Invalid SQL:
SELECT searchgroup.groupid, MATCH(searchgroup_text.title) AGAINST ('* * Does anyone know what this is for? * *') AS score
FROM searchgroup AS searchgroup JOIN searchgroup_text AS searchgroup_text ON
(searchgroup.searchgroupid = searchgroup_text.searchgroupid)
WHERE MATCH(searchgroup_text.title) AGAINST ('* * Does anyone know what this is for? * *') AND
searchgroup.contenttypeid = 2
AND searchgroup.groupid <> 45112
HAVING score > 4
LIMIT 5;
MySQL Error : syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'
Error Number : 1064
Request Date : Thursday, April 6th 2017 @ 02:27:28 PM
Error Date : Thursday, April 6th 2017 @ 02:27:29 PM
Script : http://beta.domain.com/vbfs/admincp/...t=45043&pp=100
Referrer : https://beta.domain.com/vbfs/admincp...t=44943&pp=100
IP Address :
Username : rick
Classname : vB_Database_MySQLi
MySQL Version : 10.1.21-MariaDB
Server :
User Agent :
Comment