Had to wait for the weekend to try the above...
Drum roll please....
It didn't work, still the same issue as described above (for more info on the steps performed see below)
As a curious aside, one member was reporting that search was working for them. Turns out what they were doing was going into Advanced Search and under single content types selecting "show results as posts". Which is curious.
Quote:
|
Originally Posted by Stuff I Did
Quote:
|
Originally Posted by In vBulletin ACP
VB ACP -> Settings -> Options -> Turn Your vBulletin On and Off -> Turn site off
|
Quote:
|
Originally Posted by SSH to Server
[usr@xxxxxx ~]# /etc/init.d/mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
[usr@xxxxxx ~]# mysql -h 127.0.0.1 -p -u USERNAME DATABASENAME
Enter password:
mysql> REPAIR TABLE searchcore_text QUICK;
+--------------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+--------------------------------+--------+----------+----------+
| mydb.searchcore_text | repair | status | OK |
+--------------------------------+--------+----------+----------+
1 row in set (40.89 sec)
mysql> REPAIR TABLE searchgroup_text QUICK;
+---------------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------+--------+----------+----------+
| mydb.searchgroup_text | repair | status | OK |
+---------------------------------+--------+----------+----------+
1 row in set (0.10 sec)
mysql> exit
Bye
[usr@xxxxxx ~]# /etc/init.d/mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
[usr@xxxxxx ~]# mysql -h 127.0.0.1 -p -u USERNAME DATABASENAME
Enter password:
mysql> truncate searchcore;
Query OK, 0 rows affected (0.00 sec)
mysql> truncate searchcore_text;
Query OK, 0 rows affected (0.11 sec)
mysql> truncate searchgroup;
Query OK, 0 rows affected (0.01 sec)
mysql> truncate searchgroup_text;
Query OK, 0 rows affected (0.00 sec)
mysql> drop index text on searchcore_text;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> drop index grouptitle on searchgroup_text;
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> CREATE FULLTEXT INDEX text ON searchcore_text (title, keywordtext);
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> CREATE FULLTEXT INDEX grouptitle ON searchgroup_text (title);
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> exit
Bye
[usr@xxxxxx]# php searchindex.php
Please enter the path to your vBulletin directory: /var/www/vhosts/mysite.co.uk/httpdocs/
Rebuild Search Index
--------------------
Note:
You should not normally need to empty the search index, however if items are showing in search results after they have been permanently deleted then emptying the index and rebuilding the search index will fix this. Search will not work correctly after emptying the index until the index is fully rebuilt.
Click Here to empty the search index.
Empty Index [0/1,Default=0]: 1
0) All
3) Forums
1) Posts
7) Groups
5) Group Messages
11) Visitor Messages
16) Blog Comments
15) Blog Entries
Content type to index [Default=0]: 0
Turn off DB indexes during rebuild [0/1,Default=0]: 0
Item id to start at [Default=0]: 0
Number of items to process per batch [Default=10000]: 1000
Building Search Index Forums ...
IDs 0-140 ... Done (0.11 sec)
Building Search Index Forums: Done
Building Search Index Posts ...
IDs 0-1000 ... Done (2.94 sec)
IDs 1000-2000 ... Done (2.44 sec)
IDs 2000-3000 ... Done (2.61 sec)
IDs 3000-4000 ... Done (2.97 sec)
<SNIP SNIP SNIP>
<SNIP SNIP SNIP>
<SNIP SNIP SNIP>
<SNIP SNIP SNIP>
<SNIP SNIP SNIP>
IDs 2347000-2348000 ... Done (3.50 sec)
IDs 2348000-2349000 ... Done (3.88 sec)
IDs 2349000-2350000 ... Done (2.75 sec)
IDs 2350000-2350784 ... Done (2.58 sec)
Building Search Index Posts: Done
Building Search Index Groups ...
IDs 0-48 ... Done (0.14 sec)
Building Search Index Groups: Done
Building Search Index Group Messages ...
IDs 0-1000 ... Done (3.30 sec)
IDs 1000-2000 ... Done (3.14 sec)
IDs 2000-3000 ... Done (3.87 sec)
IDs 3000-4000 ... Done (3.48 sec)
IDs 4000-5000 ... Done (2.17 sec)
IDs 5000-6000 ... Done (3.24 sec)
IDs 6000-7000 ... Done (3.05 sec)
IDs 7000-8000 ... Done (1.84 sec)
IDs 8000-9000 ... Done (3.54 sec)
IDs 9000-9584 ... Done (0.33 sec)
Building Search Index Group Messages: Done
Building Search Index Visitor Messages ...
IDs 0-1000 ... Done (3.10 sec)
IDs 1000-2000 ... Done (3.42 sec)
IDs 2000-3000 ... Done (3.36 sec)
IDs 3000-3882 ... Done (2.81 sec)
Building Search Index Visitor Messages: Done
Building Search Index Blog Comments ...
IDs 0-1000 ... Done (0.85 sec)
IDs 1000-2000 ... Done (1.13 sec)
IDs 2000-3000 ... Done (3.13 sec)
IDs 3000-3345 ... Done (0.83 sec)
Building Search Index Blog Comments: Done
Building Search Index Blog Entries ...
IDs 0-1000 ... Done (2.89 sec)
IDs 1000-1265 ... Done (0.94 sec)
Building Search Index Blog Entries: Done
Building Search Index: 2 hours, 22 minutes and 35 seconds
[usr@xxxxxx]#
|
Quote:
|
Originally Posted by In vBulletin ACP
VB ACP -> Maintenance -> Repair / Optimize Tables -> Select POST table -> Continue
post Check Status: OK
post Optimize Status: OK
VB ACP -> Maintenance -> Repair / Optimize Tables -> Select all thread tables -> Continue
thread Check Status: OK
thread Optimize Status: OK
thread_serviceupdate Check Status: OK
thread_serviceupdate Optimize Note: Table does not support optimize, doing recreate + analyze instead
thread_serviceupdate Optimize Status: OK
threadrate Check Status: OK
threadrate Optimize Status: OK
threadread Check Status: OK
threadread Optimize Status: OK
threadredirect Check Status: OK
threadredirect Optimize Status: OK
threadviews Check Status: OK
threadviews Optimize Status: OK
VB ACP -> Forums & Moderators -> Forum Blocks Manager -> Reload Block Types
VB ACP -> Settings -> Options -> Turn Your vBulletin On and Off -> Turn site on
|
|
More Information