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

Reply
 
Thread Tools Display Modes
  #1  
Old 01-12-2007, 01:23 PM
hawks_mp hawks_mp is offline
 
Join Date: Jan 2007
Location: SC
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database error

Is there anyway to find out what is causing this error? All is says when I go to the site is:

Code:
Database error
Thanks for anyone that can help.
Reply With Quote
  #2  
Old 01-12-2007, 03:11 PM
Tuk4 Tuk4 is offline
 
Join Date: Feb 2003
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

that there's DB error. how the hell should we know if we cant see the error itself.
try to look at the source sometimes its in comments.
Reply With Quote
  #3  
Old 01-12-2007, 03:16 PM
hawks_mp hawks_mp is offline
 
Join Date: Jan 2007
Location: SC
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I know what you mean...but that's all the page says:

Code:
Database error
The MP Forum database has encountered a problem.
Please try the following:

    * Load the page again by clicking the Refresh button in your web browser.
    * Open the www.mediaphilez.com home page, then try to open another page.
    * Click the Back button to try another link.

The www.mediaphilez.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.
There's no more info. Just didn't know if anyone could help me with some troubleshooting.
Reply With Quote
  #4  
Old 01-12-2007, 03:21 PM
noppid noppid is offline
 
Join Date: Mar 2003
Location: Florida
Posts: 1,875
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The error should be going to the admin in set in the config.php. Get the email and post the error.
Reply With Quote
  #5  
Old 01-12-2007, 03:22 PM
Tuk4 Tuk4 is offline
 
Join Date: Feb 2003
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I loaded the page myself. and got this

Code:
Database error in vBulletin 3.6.4:

Invalid SQL:

				SELECT *
				FROM session
				WHERE userid = 0
					AND host = '*******'
					AND idhash = '0807f79e20cb4062f233ed871bb9e1d0'
				LIMIT 1;

MySQL Error  : Table 'mediaphi_vb.session' doesn't exist
Error Number : 1146
Date         : Friday, January 12th 2007 @ 06:21:27 PM
Script       : http://www.mediaphilez.com/
Referrer     :
session table isnt exists.
or DB crashed.
Reply With Quote
  #6  
Old 01-12-2007, 03:29 PM
hawks_mp hawks_mp is offline
 
Join Date: Jan 2007
Location: SC
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Tuk4 View Post
I loaded the page myself. and got this

Code:
Database error in vBulletin 3.6.4:

Invalid SQL:

				SELECT *
				FROM session
				WHERE userid = 0
					AND host = '*******'
					AND idhash = '0807f79e20cb4062f233ed871bb9e1d0'
				LIMIT 1;

MySQL Error  : Table 'mediaphi_vb.session' doesn't exist
Error Number : 1146
Date         : Friday, January 12th 2007 @ 06:21:27 PM
Script       : http://www.mediaphilez.com/
Referrer     :
session table isnt exists.
or DB crashed.
Yeh I just saw this. How can I repair this or remedy it?
Reply With Quote
  #7  
Old 01-12-2007, 03:36 PM
Tuk4 Tuk4 is offline
 
Join Date: Feb 2003
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Dont know what you changed latley so i cant really tell you where its coming from.
If you added some new hack and it showed up, just disable the hook and see where its from.
Check if Session is exists, or DB didnt crash.

Give me some more information so ill be able to asist you there mate.
Reply With Quote
  #8  
Old 01-12-2007, 03:38 PM
hawks_mp hawks_mp is offline
 
Join Date: Jan 2007
Location: SC
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well I haven't changed anything in several days. The site was working fine last night. I can't even get in the admincp to disable anything. I looked at my DB and noticed the session, and user table are missing (and possibly others). Unfortunately I don't have a backup of my DB from before this happened as I had just started the site.

Should I contact my webhost? Could it be that they are having problems?

Got it working, well almost, but I'm gettin it. Thanks everyone for the help.
Reply With Quote
  #9  
Old 01-12-2007, 04:45 PM
noppid noppid is offline
 
Join Date: Mar 2003
Location: Florida
Posts: 1,875
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Tuk4 View Post
I loaded the page myself. and got this


session table isnt exists.
or DB crashed.
It didn't spit that out for me. Good catch.

If this is a preview of the quality of your hosting, you may want to move now.
Reply With Quote
  #10  
Old 01-12-2007, 04:47 PM
Tuk4 Tuk4 is offline
 
Join Date: Feb 2003
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yups, that what i would do mate.
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 01:23 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.05946 seconds
  • Memory Usage 2,249KB
  • Queries Executed 11 (?)
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
  • (4)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_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