Auto Update
problem after auto-update to 5.1.11
Version: 5.1.11
URL:
Print Auto Update | |
|
mervyn
Beginner Usergroup: Customer Joined: Nov 25, 2006 Total Topics: 3 Total Posts: 3 |
 #1
Just carried out the auto update to version 5.1.11 and this message appears on the main site when selecting any category: An error occured while processing this page: Error occurred at http://be-nosey.net/search/wsnlink...tion=displaycat&catid=1112 on 2009-11-14 13:50:32. Error text: Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in /homepages/35/d208063677/htdocs/benosey.net/search/wsnlinks/databases/mysqli.php on line 72. Last SQL error: Can't find FULLTEXT index matching the column list An error occured while processing this page: Error occurred at http://be-nosey.net/search/wsnlink...tion=displaycat&catid=1112 on 2009-11-14 13:48:59. Error text: Error #2: 'mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given' in /homepages/35/d208063677/htdocs/benosey.net/search/wsnlinks/databases/mysqli.php on line 75. Last SQL error: Can't find FULLTEXT index matching the column list Can you advise please Mervyn |
|
Paul
developer  Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 65 Total Posts: 7614 |
#2
The similar listings and similar categories options require FULLTEXT indexes, but somehow these have been mysteriously lost (maybe on a database restoration or mysql upgrade or server move). Try running this in the SQL box at Admin -> Miscellaneous -> Advanced Options: ALTER TABLE {PREFIX}links ADD FULLTEXT `titleindex` (`title`);That should fix it. Edited by Paul on 11/16/09 - 6:46 AM |
Sorry, you don't have permission to post. Log in, or register if you haven't yet.