PDA

View Full Version : help with database

ChanServ
Sat 27th Jul '02, 6:03pm
There seems to have been a slight problem with the Video Game Theater Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

I am getting this whenever i try to get on my forum o.O
Steve Machol
Sat 27th Jul '02, 6:05pm
What's the URL to your forums? Also please post the complete error message. You can find that by viewing the page source in your broswer.
ChanServ
Sat 27th Jul '02, 6:09pm
Originally posted by smachol
What's the URL to your forums? Also please post the complete error message. You can find that by viewing the page source in your broswer.


www.videogametheater.com/forum/

and the full error message is



<html><head><title>Video Game Theater Forums Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>

<!-- Database error in vBulletin 2.2.6:

Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
mysql error: Can't open file: 'user.MYD'. (errno: 145)

mysql error number: 1016

Date: Saturday 27th of July 2002 05:03:06 PM
Script: http://www.videogametheater.com/forum/forum/
Referer:
-->

</table></td></tr></table></form>
<blockquote><p>&nbsp;</p><p><b>There seems to have been a slight problem with the Video Game Theater Forums database.</b><br>
Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:Jeff@videogametheater.com">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p></blockquote></body></head></html>
Steve Machol
Sat 27th Jul '02, 6:14pm
145 = Table was marked as crashed and should be repaired

Your user table crashed. To fix it run this query in phpMyAdmin:

REPAIR TABLE user;
ChanServ
Sat 27th Jul '02, 6:15pm
Originally posted by smachol
145 = Table was marked as crashed and should be repaired

Your user table crashed. To fix it run this query in phpMyAdmin:

REPAIR TABLE user;

THANKS!
Steve Machol
Sat 27th Jul '02, 6:16pm
No problem! :)
ChanServ
Sat 27th Jul '02, 6:25pm
argh whenever i try and et into my admin cp i get this

Warning: Cannot add header information - headers already sent by (output started at /home/videogam/public_html/forum/admin/config.php:41) in /home/videogam/public_html/forum/admin/functions.php on line 1579

Warning: Cannot add header information - headers already sent by (output started at /home/videogam/public_html/forum/admin/config.php:41) in /home/videogam/public_html/forum/moderator.php on line 24

and this as well

Warning: Cannot add header information - headers already sent by (output started at /home/videogam/public_html/forum/admin/config.php:41) in /home/videogam/public_html/forum/admin/functions.php on line 1579

Warning: Cannot add header information - headers already sent by (output started at /home/videogam/public_html/forum/admin/config.php:41) in /home/videogam/public_html/forum/admin/functions.php on line 1579

Warning: Cannot add header information - headers already sent by (output started at /home/videogam/public_html/forum/admin/config.php:41) in /home/videogam/public_html/forum/admin/functions.php on line 1579

Warning: Cannot add header information - headers already sent by (output started at /home/videogam/public_html/forum/admin/config.php:41) in /home/videogam/public_html/forum/admin/global.php on line 205
Steve Machol
Sat 27th Jul '02, 6:26pm
Make sure there are no extra lines or whitespace in your config.php file either before the <?php or after the ?>.
ChanServ
Sat 27th Jul '02, 6:28pm
Originally posted by smachol
Make sure there are no extra lines or whitespace in your config.php file either before the <?php or after the ?>.

since i havent dont anything to the config.php could i just reupload it to my server?
Steve Machol
Sat 27th Jul '02, 6:32pm
That depends on whether or not that copy of config.php will work. However you must have done something to it because the default config.php only has 39 lines and your error shows a problem on line 41.
ChanServ
Sat 27th Jul '02, 6:47pm
Originally posted by smachol
That depends on whether or not that copy of config.php will work. However you must have done something to it because the default config.php only has 39 lines and your error shows a problem on line 41.

ok i checked for extra spaces and i am still having the same error except now its on line 40
ChanServ
Sat 27th Jul '02, 6:52pm
I could give you access to my server, and mabye you could check it out?

cus im an idiot at this stuff -_-
Steve Machol
Sat 27th Jul '02, 6:53pm
I'm leaving and won't be back for a few hours but you can out a support ticket at:

http://www.vbulletin.com/members/support_form.php

Be sure to include the login info to your Admin CP and FTP.
ChanServ
Sat 27th Jul '02, 7:08pm
Originally posted by smachol
I'm leaving and won't be back for a few hours but you can out a support ticket at:

http://www.vbulletin.com/members/support_form.php

Be sure to include the login info to your Admin CP and FTP.

*hits himself on head*
Lol, that was such a simple mistake.

after the ?> in the last line of the of the script I made two blank lines. So I guess I created a loop or something.

but its fixed now, thanks for all your help =D
Steve Machol
Sat 27th Jul '02, 9:59pm
Isn't that what I said to look for? ;)

Originally posted by smachol
Make sure there are no extra lines or whitespace in your config.php file either before the <?php or after the ?>.
ChanServ
Sun 28th Jul '02, 12:31am
Originally posted by smachol
Isn't that what I said to look for? ;)



Bah! *hits head* sorry, im not to daft when i havent had my coffee ;)