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 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 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
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`); ALTER TABLE {PREFIX}categories ADD FULLTEXT `nameindex` (`name`);
That should fix it.
0/5
1
2
3
4
5
Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.
Comments on Auto Update
Beginner
Usergroup: Customer
Joined: Nov 25, 2006
Total Topics: 3
Total Comments: 3
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 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 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
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
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`);ALTER TABLE {PREFIX}categories ADD FULLTEXT `nameindex` (`name`);
That should fix it.