PDA

View Full Version : Database error


hawks_mp
01-12-2007, 01:23 PM
Is there anyway to find out what is causing this error? All is says when I go to the site is:

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:

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


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
I loaded the page myself. and got this


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
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.