Internal Server Error Help Please

[marcus1lane]

I am not sure what went wrong actually. I was on my forum checking on the who's online at the very bottom and it said this

Database error

Database error in vBulletin 4.1.4:

Invalid SQL:

	SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
	, user.market_username_color, 
user.market_username_glow, market_username_subscript
	FROM session as session
	
	WHERE session.lastactivity > 1311555908
	
	
	
	GROUP BY isuser;

MySQL Error   : Unknown column 'user.market_username_color' in 'field list'
Error Number  : 1054
Request Date  : Sunday, July 24th 2011 @ 08:20:08 PM
Error Date    : Sunday, July 24th 2011 @ 08:20:08 PM
Script        : http://www.zupek.com/forums/online.php
Referrer      : http://www.zupek.com/forums/forum.php
IP Address    : 67.1.6.241
Username      : marcus1lane
Classname     : vB_Database
MySQL Version : 5.1.52

And then I went to my admins page but this displayed

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@zupek.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Apache/2.2.19 (Unix) mod_ssl/2.2.19 OpenSSL/0.9.8r DAV/2 mod_fcgid/2.3.6 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.zupek.com Port 80

So I am very lost everything else seems to work fine but this. I just recently install point market system and I thought that was the problem so I removed it other than the plugin in the admin section. Any help would be great!

What I have just recently installed
point market system
antispam or something similar to that
vbexperience
downloadsII

Regards
Marcus

[Eric]

Within your /includes/config.php file add this line just after <?php

PHP Code:

define('DISABLE_HOOKS', true); 


You should then (hopefully) be able to login to the AdminCP. Once there, disable or uninstall the point market system product.

The database error is happening because the product is trying to select those fields in the mentioned query, which does not have access to the "user" table. The 500 error may be happening due to the product being removed but not disabled/uninstalled from within the AdminCP.

[marcus1lane]

Originally Posted by Eric

Within your /includes/config.php file add this line just after <?php

PHP Code:

define('DISABLE_HOOKS', true); 


You should then (hopefully) be able to login to the AdminCP. Once there, disable or uninstall the point market system product.

The database error is happening because the product is trying to select those fields in the mentioned query, which does not have access to the "user" table. The 500 error may be happening due to the product being removed but not disabled/uninstalled from within the AdminCP.

After doing what you said I am able to access the whos online but when I click on the admin section it still displays the 500 internal error message.

--------------- Added [DATE]1311562661[/DATE] at [TIME]1311562661[/TIME] ---------------

I just solved it finally
If anyone is having the same problem change the permissions to 755. I accidentally changed mine from 755 to 777. Thanks for your help Eric

[Videx]

Change the permissions on what?

[marcus1lane]

In My FTP I changed the adminCP permissions from 777 to 755 and that seemed to work