Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-25-2011, 12:24 AM
marcus1lane marcus1lane is offline
 
Join Date: Jun 2011
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Internal Server Error Help Please

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
Code:
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

Quote:
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
Reply With Quote
  #2  
Old 07-25-2011, 12:42 AM
Eric's Avatar
Eric Eric is offline
 
Join Date: May 2006
Location: Kentucky
Posts: 792
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 07-25-2011, 01:03 AM
marcus1lane marcus1lane is offline
 
Join Date: Jun 2011
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Eric View Post
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
Reply With Quote
  #4  
Old 07-26-2011, 01:04 AM
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
Posts: 3,085
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Change the permissions on what?
Reply With Quote
  #5  
Old 07-26-2011, 02:44 AM
marcus1lane marcus1lane is offline
 
Join Date: Jun 2011
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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


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

Forum Jump


All times are GMT. The time now is 10:09 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03946 seconds
  • Memory Usage 2,210KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (2)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete