vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Internal Server Error Help Please (https://vborg.vbsupport.ru/showthread.php?t=267365)

marcus1lane 07-25-2011 12:24 AM
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

Eric 07-25-2011 12:42 AM
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 07-25-2011 01:03 AM
Quote:
Originally Posted by Eric (Post 2224569)
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 07-26-2011 01:04 AM
Change the permissions on what?

marcus1lane 07-26-2011 02:44 AM
In My FTP I changed the adminCP permissions from 777 to 755 and that seemed to work :)


All times are GMT. The time now is 03:54 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01007 seconds
  • Memory Usage 1,730KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete