Author Topic: HELP PLEASE!! Database Errors  (Read 864 times)

Offline Desktop

  • Semi-Newbie
  • *
  • Posts: 96
  • Gender: Male
    • SF Forum
HELP PLEASE!! Database Errors
« on: January 27, 2007, 05:25:10 PM »
SMF Version: SMF 1.1.1
I have a biography mod installed, which I've had no problems with until earlier today when I tried repairing the database in phpmyadmin (I was trying to repair it to solve a different issue - which is now solved). All the tables repaired without issue except for smf_log_errors:

hostspro_sf.smf_log_errors     repair     error     122 when fixing table
hostspro_sf.smf_log_errors    repair    error    Can't copy datafile-header to tempfile, error 9
hostspro_sf.smf_log_errors    repair    status    Operation failed

I'm not sure if this is the cause of the problem but since then, trying to view any threads, theres an error in their pageview miniprofile:

View Profile8: Undefined index: bio
File: /home/hostspro/public_html/forum/Themes/classic/Display.template.php (main sub template - eval?)
Line: 328

What can I do to fix it? Please help, thanks!

Offline SleePy

  • Site Manager
  • Project Support
  • SMF Super Hero
  • *
  • Posts: 25,270
  • Gender: Male
    • SleePy Code - My personal very outdated development site
Re: HELP PLEASE!! Database Errors
« Reply #1 on: January 28, 2007, 12:18:07 AM »
From a quick google search I get:
Error code 122: Disk quota exceeded

Is your mysql server out of space?
Jeremy D — Site Manager — Master Web
- No PMs for support
Support the SMF Support team!
if ($context['user']['name'] == 'Norv')
     annoyUser();

Offline Desktop

  • Semi-Newbie
  • *
  • Posts: 96
  • Gender: Male
    • SF Forum
Re: HELP PLEASE!! Database Errors
« Reply #2 on: January 28, 2007, 03:25:29 AM »
Oh yeah of course, sorry! Yeah, it WAS out of space (that was the original problem) and I cleared the TMP dir... but I guess the table couldn't repair while the tmp dir was full and I didn't think to try it again until you mentioned it. Thanks for your help!