Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 11 Sep 2010, 21:26
Fungsten's Avatar
Fungsten Fungsten is offline
 
Join Date: Jul 2006
Unhappy 500 Internal Server Error when clicking on a post.

Hello Everyone,

On my test forum I am running 4.0.6. Whenever I click on a post I get the Internal Error. I have also disabled the Hooks/Plugins and it comes up with a database error.

Database error in vBulletin 4.0.6:
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 : Incorrect information in file: './XXXXXX_vb/contenttype.frm'
Error Number : 1033
Request Date : Saturday, September 11th 2010 @ 03:19:39 PM
Error Date : Saturday, September 11th 2010 @ 03:19:40 PM
Script : http://www.XXXXXXXXX.net/test_vb/for...hread.php?t=43
Referrer : http://www.XXXXXXXXXX.net/test_vb/fo...isplay.php?f=5
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.91-community
Also not all the options are showing up under ACP - Maintenance - Update counters. The list stops half way between the Rebuild Search Index.

Anyone have a solution for these? TIA.
__________________
My Mods:
Missing Images
Styles:
Hell Eye Shock
Reply With Quote
  #2  
Old 12 Sep 2010, 16:40
ragtek's Avatar
ragtek ragtek is offline
 
Join Date: Mar 2006
Location: austria, croatia
Incorrect information in file: './XXXXXX_vb/contenttype.frm
I think your database is broken. Try to repair it.

--------------- Added 12 Sep 2010 at 16:41 ---------------

http://www.vbulletin.com/forum/showt...air-a-database
__________________
my addons: http://ragtek.github.com

Last edited by ragtek; 12 Sep 2010 at 16:41. Reason: Auto-Merged DoublePost
Reply With Quote
  #3  
Old 13 Sep 2010, 21:57
Fungsten's Avatar
Fungsten Fungsten is offline
 
Join Date: Jul 2006
Originally Posted by ragtek View Post
I think your database is broken. Try to repair it.

--------------- Added 12 Sep 2010 at 08:41 ---------------

http://www.vbulletin.com/forum/showt...air-a-database
I'll try what's at the link. BTW I would have tried through the ACP but the option to repair is not shown! The options stop at Repair Search or something.

--------------- Added 13 Sep 2010 at 14:06 ---------------

Originally Posted by ragtek View Post
I think your database is broken. Try to repair it.

--------------- Added 12 Sep 2010 at 08:41 ---------------

http://www.vbulletin.com/forum/showt...air-a-database
Here's the error code during the repair:

XXXXX_vb.contenttype
Error : Incorrect information in file: './XXXXX_vb/contenttype.frm'
error : Corrupt
XXXXX_vb.cpsession
note : The storage engine for the table doesn't support repair
__________________
My Mods:
Missing Images
Styles:
Hell Eye Shock

Last edited by Fungsten; 13 Sep 2010 at 22:06. Reason: Auto-Merged DoublePost
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 23:40.

Layout Options | Width: Wide Color: