VB 2.3.5 --> VB 3.5.2 upgrade woes

**Steve Machol** · Fri 23 Dec '05, 2:23pm

The search index and Fulltext are mutually exclusive. Check each of your forums in the Forum Manager and make sure that this option is set to 'Yes':

Admin CP -> Forums & Moderators -> Forum Manager -> Edit Forum -> Index New Posts in Search Engine

**tekn0mage** · Fri 23 Dec '05, 2:52pm

actually yes, all forums are.

I used a handy-dandy SQL statement that you provided in a previously answered question.

Muchos gracias for that, by the way

Might I add Steve, that you have possibly the highest post count I have ever seen in any forum. - edit -

**Steve Machol** · Fri 23 Dec '05, 2:55pm

Originally posted by tekn0mage

Might I add Steve, that you have possibly the highest post count I have ever seen in any forum. - edit -

I'm afraid that goes hand-in-hand with either having no life and/or being obsessive.

**tekn0mage** · Fri 23 Dec '05, 3:30pm

can you provide any thing I can look for as to why this search index table is not filling up?

I dont even see a searchindex.* file in the /var/lib/mysql directory...

Weirdness

**tekn0mage** · Fri 23 Dec '05, 5:14pm

While Rebuilding... the browser refreshes quite rapidly while displaying something like this:

Building Search Index Post Queried

Processing: xxxxx ... Querying first post of thread... Done
Processing: xxxxx ... Querying first post of thread... Done
Processing: xxxxx ... Querying first post of thread... Done
Processing: xxxxx ... Done
Processing: xxxxx ... Done
Processing: xxxxx ... Querying first post of thread... Done
Processing: xxxxx ... Querying first post of thread... Done

where x = post #

Does this mean its working?

When I check the searchindex table... there still is none. The search table still shows 0 bytes.

**Steve Machol** · Fri 23 Dec '05, 9:21pm

If you are running fulltext, then the searchindex table is not used. What are you doing exactly?

**tekn0mage** · Sat 24 Dec '05, 1:40am

I would like to have the search feature of the bulletin system working. I've tried a number of options, none of which have worked. After the first import, I tried rebuilding the search index. After that operation completed, I tried a test search for something simple and got no results.

After coming back on the forums to search for a potential solution, I found a number of things to try... most of which were covered in my first post. As of now, the search feature still does not return any results on any posts.

I am definitely missing something.

**tekn0mage** · Sat 24 Dec '05, 3:18am

aha! problem solved.

I disabled the MySQL search feature and then did the other steps to rebuild the indexes. All seems to be well.

Are the search terms no longer in the 'searchindex' table? It seems that the 'word' table is what has grown in its place.

Also... what are the advantages of the MySQL search feature over the Vbulletin search feature?

Is one faster than the other?

**Steve Machol** · Sat 24 Dec '05, 8:24am

In 3.5, the searchindex table is no longer used. Instead when you rebuild the search index, you are rebuilding the postindex and word tables.

**tekn0mage** · Sat 24 Dec '05, 3:48pm

Thanks for implementing that change!!! The VB2 searchindex table has over 20 MILLION records. That's ridiculous.

Glad you guys found a thinner way to do it...

Any word on the advantages / disadvantages of doing the MySQL version of search instead of the Vbulletin version?

Thanks for your time, and Merry Christmas everyone!!

**Mireade** · Fri 30 Dec '05, 10:32am

need help !

Hello,

I'm upgrading from vB2 to vB3.52
It's ok but for the search system and the similar threads system.

The rebuid function did not work for the searchindex.
It says rebuid is running and blinks
duration of the treatment = 0,01 s
total posts worked = 0

The search engine does not work at all.

I'm not running "fulltext" option.

The similar threads rebuild seemed to do his work (during a very long time) but Similar threads do not appear.

What could I do ?

Thank you for your help

Michel

**Steve Machol** · Fri 30 Dec '05, 2:41pm

Mireadde, if you want further help please start your own thread with all the relevant info. Thank you.

P.S. You do not need to rebuild the search index if you are using fulltext mode.

**Mireade** · Sat 31 Dec '05, 2:08am

Originally posted by Steve Machol

Mireadde, if you want further help please start your own thread with all the relevant info. Thank you.

P.S. You do not need to rebuild the search index if you are using fulltext mode.

Ok Steve Thanks
I understood search index is not used in fulltext searching

Thanks for your support

Michel

Here are some informations you could find relevant I guess :

Server Version: Apache/1.3.33 (Unix) PHP/4.3.10
Mysql version 4.0.24
1 Gig Ram
mono proc 2.8Ghz

Server settings
Variable Valeur pour la session Valeur globale
back log 50 50
basedir /usr/local/mysql/ /usr/local/mysql/
binlog cache size 32768 32768
bulk insert buffer size 8388608 8388608
character set latin1 latin1
character sets latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
concurrent insert ON ON
connect timeout 5 5
convert character set
datadir /home/mysql/ /home/mysql/
default week format 0 0
delay key write ON ON
delayed insert limit 100 100
delayed insert timeout 300 300
delayed queue size 1000 1000
flush OFF OFF
flush time 0 0
ft boolean syntax + -><()~*:""&| + -><()~*:""&|
ft min word len 4 4
ft max word len 254 254
ft max word len for sort 20 20
ft stopword file (built-in) (built-in)
have bdb NO NO
have crypt YES YES
have innodb YES YES
have isam YES YES
have raid NO NO
have symlink YES YES
have openssl NO NO
have query cache YES YES
init file
innodb additional mem pool size 1048576 1048576
innodb autoextend increment 8 8
innodb buffer pool size 8388608 8388608
innodb data file path ibdata1:10M:autoextend ibdata1:10M:autoextend
innodb data home dir
innodb file io threads 4 4
innodb force recovery 0 0
innodb thread concurrency 8 8
innodb flush log at trx commit 1 1
innodb fast shutdown ON ON
innodb flush method
innodb lock wait timeout 50 50
innodb log arch dir ./ ./
innodb log archive OFF OFF
innodb log buffer size 1048576 1048576
innodb log file size 5242880 5242880
innodb log files in group 2 2
innodb log group home dir ./ ./
innodb mirrored log groups 1 1
innodb max dirty pages pct 90 90
innodb max purge lag 0 0
innodb table locks ON ON
interactive timeout 28800 28800
join buffer size 131072 131072
key buffer size 268435456 268435456
language /usr/local/mysql/share/mysql/french/ /usr/local/mysql/share/mysql/french/
large files support ON ON
license GPL GPL
local infile ON ON
locked in memory OFF OFF
log OFF OFF
log update OFF OFF
log bin OFF OFF
log slave updates OFF OFF
log slow queries OFF OFF
log warnings 1 1
long query time 10 10
low priority updates OFF OFF
lower case file system OFF OFF
lower case table names 0 0
max allowed packet 1047552 1047552
max binlog cache size 4294967295 4294967295
max binlog size 1073741824 1073741824
max connections 200 200
max connect errors 10 10
max delayed threads 20 20
max insert delayed threads 20 20
max heap table size 16777216 16777216
max join size 4294967295 4294967295
max relay log size 0 0
max seeks for key 4294967295 4294967295
max sort length 1024 1024
max user connections 0 0
max tmp tables 32 32
max write lock count 4294967295 4294967295
myisam max extra sort file size 268435456 268435456
myisam max sort file size 2147483647 2147483647
myisam repair threads 1 1
myisam recover options OFF OFF
myisam sort buffer size 67108864 67108864
net buffer length 16384 16384
net read timeout 30 30
net retry count 10 10
net write timeout 60 60
new OFF OFF
open files limit 1024 1024
pid file /home/mysql/t187.pid /home/mysql/t187.pid
log error
port 0 0
protocol version 10 10
query alloc block size 8192 8192
query cache limit 2097152 2097152
query cache size 67108864 67108864
query cache type ON ON
query cache wlock invalidate OFF OFF
query prealloc size 8192 8192
range alloc block size 2048 2048
read buffer size 1044480 1044480
read only OFF OFF
read rnd buffer size 262144 262144
rpl recovery rank 0 0
server id 1 1
slave net timeout 3600 3600
skip external locking ON ON
skip networking ON ON
skip show database OFF OFF
slow launch time 2 2
socket /var/adm/mysql/mysql.sock /var/adm/mysql/mysql.sock
sort buffer size 1048568 1048568
sql mode 0 0
table cache 256 256
table type MYISAM MYISAM
thread cache size 8 8
thread stack 196608 196608
tx isolation REPEATABLE-READ REPEATABLE-READ
timezone CET CET
tmp table size 33554432 33554432
tmpdir /tmp/ /tmp/
transaction alloc block size 8192 8192
transaction prealloc size 4096 4096
version 4.0.24 4.0.24
version comment Source distribution Source distribution
version compile os pc-linux-gnu pc-linux-gnu
wait timeout 10 10

**Mireade** · Tue 3 Jan '06, 2:27am

So please what could be the reason why the re-indexation does not work ? What can I do to solve this ?

VB 2.3.5 --> VB 3.5.2 upgrade woes

VB 2.3.5 --> VB 3.5.2 upgrade woes

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment