Problems when running "Fix Unique Indexes" and DB errors. Search Index is messed up! [Archive]

Fungsten

07-14-2010, 07:08 PM

When I first ran "Fix Unique Indexes" I came up with this:

____________________________________________
Table access already has a unique index
Table adminhelp already has a unique index
Table attachmentpermission already has a unique index
Table bbcode already has a unique index
Table bbcode_video already has a unique index
Table action already has a unique index

__________________________________________________ _____________

It stopped at the above point when trying to the "Fix Unique Indexes" in Maintenance.Now when trying to run it, it just goes to the blue background.

Also, when going into "Maintenance" and "Update Counters" only half of the options show up. None show anything beyond Rebuild Search Index and only half of that shows.

So, I'm quite sure it's a bad search index.

Also, when members click on a thread, "new posts", try to PM, etc., they get DB errors.

Am running 4.0.4 PL1. TIA.

Fungsten

07-14-2010, 07:53 PM

What DB errors exactly do users get ?

I get sent a lot of these.

Database error in vBulletin 4.0.4:

Invalid SQL:

(SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid,
package.productid AS productid, if(package.productid = 'vbulletin', 1, product.active) AS enabled,
package.class AS class, -1 as isaggregator
FROM package AS package
LEFT JOIN product AS product
ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin'
)

UNION

(SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid,
1, 1, contenttype.class AS class , contenttype.isaggregator
FROM contenttype AS contenttype
INNER JOIN package AS package ON package.packageid = contenttype.packageid
LEFT JOIN product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );

MySQL Error : Table 'XXXXXXXX.contenttype' doesn't exist
Error Number : 1146
Request Date : Wednesday, July 14th 2010 @ 11:26:01 AM
Error Date : Wednesday, July 14th 2010 @ 11:26:02 AM
Script : http://www.XXXXXXXXXXXXXXXXXX.com/forum/showthread.php?88-BBW-thread.
Referrer :
IP Address : XX.XXX.XXX.XXX
Username : Unregistered
Classname : vB_Database
MySQL Version :

And I get this if I click on a thread:

Database error in vBulletin 4.0.4:
Invalid SQL:
(SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid,
package.productid AS productid, if(package.productid = 'vbulletin', 1, product.active) AS enabled,
package.class AS class, -1 as isaggregator
FROM package AS package
LEFT JOIN product AS product
ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin'
)
UNION
(SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid,
1, 1, contenttype.class AS class , contenttype.isaggregator
FROM contenttype AS contenttype
INNER JOIN package AS package ON package.packageid = contenttype.packageid
LEFT JOIN product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );
MySQL Error : Table 'XXXXXXXXXXXXXX.contenttype' doesn't exist
Error Number : 1146
Request Date : Wednesday, July 14th 2010 @ 03:50:58 PM
Error Date : Wednesday, July 14th 2010 @ 03:50:59 PM
Script : http://www.XXXXXXXXXXXXX.com/forum/showthread.php?108360-RIP
Referrer : http://www.XXXXXXXXXXXXXXX.com/forum/index.php
IP Address :
Username : XXXXXXXXXXXXXX
Classname : vB_Database
MySQL Version : 5.0.91-community