vb.org Archive - Database error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Database error (https://vborg.vbsupport.ru/showthread.php?t=136283)

hawks_mp

01-12-2007 01:23 PM

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.

Tuk4	01-12-2007 03:11 PM

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.

hawks_mp

01-12-2007 03:16 PM

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.

noppid

01-12-2007 03:21 PM

The error should be going to the admin in set in the config.php. Get the email and post the error. ;)

Tuk4	01-12-2007 03:22 PM

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.

hawks_mp

01-12-2007 03:29 PM

Quote:

Originally Posted by Tuk4 (Post 1157145)

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?

Tuk4	01-12-2007 03:36 PM

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.

hawks_mp

01-12-2007 03:38 PM

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.

noppid

01-12-2007 04:45 PM

Quote:

Originally Posted by Tuk4 (Post 1157145)

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.

Tuk4	01-12-2007 04:47 PM

Yups, that what i would do mate.

All times are GMT. The time now is 04:23 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01542 seconds Memory Usage 1,734KB 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 (4)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)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
Messages: