db error with 10.0.5

[firstrebel]

Running vB 3.6.8 and vBPicGallery 10.0.6. I have been getting these errors these past 2 daysDatabase error in vBulletin 3.6.8:

Invalid SQL:
SELECT vbpicgallery_users.*,
user.username
FROM vb_vbpicgallery_users as vbpicgallery_users
LEFT JOIN vb_user as user
ON user.userid = vbpicgallery_users.userid
WHERE MATCH(text) AGAINST('white wall') LIMIT 100;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Date : Wednesday, December 19th 2007 @ 06:15:45 PM
Script : http://www.volvoforums.org.uk/vbpicgallery.php?do=search&q=white+wall&titlesonly=0&match=any
Referrer : http://www.volvoforums.org.uk/vbpicgallery.php?do=search&q=white&titlesonly=1&match=any
IP Address : 83.71.134.221
Username : mountain
Classname : vb_database

Bob

[Greg]

Did I supply an advance copy of .6 or something? I know what the problem is and it's an easy fix. But I think this was a bug in the first posted .5 that was flawed. A whole block of code got lost in the product.

Ok, no matter, you need a fix.... http://www.cpurigs.com/forums/showthread.php?t=4375

see the 3rd post and do that.

[firstrebel]

Got this when I ran the php file:Unable to add cookies, header already sent.
File: /home/sites/forum/add-search-indexes-5.php
Line: 1


Bob

[Greg]

Shoot. I'll download it and see why. My editor is ****ing me off about now.

the fix is to edit the file and remove the spaces before the <?php on the first line. I'll repost the fixed file in a minute.

[firstrebel]

I got a white screen with Done in the status bar, I presume this means it went OK. Thanks.

Bob

[firstrebel]

I am using 10.0.5 not .6, my bad. I seem still to have the problem after running the fixDatabase error in vBulletin 3.6.8:

Invalid SQL:
SELECT vbpicgallery_users.*,
user.username
FROM vb_vbpicgallery_users as vbpicgallery_users
LEFT JOIN vb_user as user
ON user.userid = vbpicgallery_users.userid
WHERE MATCH(text) AGAINST('122S') LIMIT 100;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Date : Thursday, December 20th 2007 @ 12:15:27 PM
Script : http://www.volvoforums.org.uk/vbpicgallery.php?do=search&q=122S&titlesonly=0&match=any
Referrer : http://www.volvoforums.org.uk/vbpicgallery.php?do=search&q=122S&titlesonly=1&match=any
IP Address : <-- removed -->
Username : <-- removed -->
Classname : vb_database

Bob

[firstrebel]

I can reproduce this error, but it only happens when selecting Search In: Description Only. But the error states search&q=444&titlesonlyDatabase error in vBulletin 3.6.8:

Invalid SQL:
SELECT vbpicgallery_users.*,
user.username
FROM vb_vbpicgallery_users as vbpicgallery_users
LEFT JOIN vb_user as user
ON user.userid = vbpicgallery_users.userid
WHERE MATCH(text) AGAINST('444') LIMIT 100;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Date : Thursday, December 20th 2007 @ 01:13:29 PM
Script : http://www.volvoforums.org.uk/vbpicgallery.php?do=search&q=444&titlesonly=0&match=any
Referrer : http://www.volvoforums.org.uk/vbpicgallery.php?do=search&q=120&titlesonly=1&match=any
IP Address : 80.168.254.234
Username : Bob
Classname : vb_database

Bob

[Greg]

The script should have given you feedback, not a white screen. So, something is up with that.

If you can PM access info, FTP and phpmyadmin, I'll take a look at it closer today. It's not adding up so far.

Re-download the 10.0.5 zip file in the first post of the download thread and overwrite your files please. Just the files in the forums folder for now.

[firstrebel]

The script should have given you feedback, not a white screen. So, something is up with that.

If you can PM access info, FTP and phpmyadmin, I'll take a look at it closer today. It's not adding up so far.

Re-download the 10.0.5 zip file in the first post of the download thread and overwrite your files please. Just the files in the forums folder for now.

Reuploaded the files, no change, still the error searching 'Descriptions only' option. Will PM you the details.

Bob

[Greg]

Took me a second, but you got a white screen because you were a guest or not set as "can admin vbpicgallery" in usergroup settings.

Check your PMs.