Announcement

Collapse
No announcement yet.

Database screwed up!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Nintendo
    replied
    Thanks! I see where it is! I think there's massive logs some where!

    Leave a comment:


  • Steve Machol
    replied
    Error code 28: No space left on device

    One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums (if you can) and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.

    Here is an explanation of the error on the MySQL site:

    http://www.mysql.com/news-and-events...000000249.html

    Once the space issue is resolved you will need to run repair on your tables since at least two of then are now corrputed.

    Leave a comment:


  • Nintendo
    started a topic Database screwed up!

    Database screwed up!

    At first I was geting this error
    Code:
    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
    /home/full_path/includes/class_core.php on line 273
    I restarted mySQL and the server, and then databases started having to be repaired. phpMyAdmin couldn't repair them, so I had to do

    cd /var/lib/mysql/DATABASE-NAME
    myisamchk -r *.MYI

    in SSH. Now the kind of errors I get are...

    Code:
    Invalid SQL:
    
    			SELECT pm.*, pmtext.*
    				, icon.title AS icontitle, icon.iconpath
    			FROM pm AS pm
    			LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
    			LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
    			WHERE pm.userid=1 AND pm.folderid=0
    			ORDER BY pmtext.dateline DESC
    			LIMIT 0, 50;
    
    MySQL Error  : Got error 28 from table handler
    showing up in the PM page.

    Right after I did a mySQL restart, I got an error and had to repair the database via SSH to view a board.

    You can barly even post. The post gets created but the browser just sits there like it's doing nothing, and nothing is updated, like the number of replies.
    Last edited by Nintendo; Thu 25 Jan '07, 9:57pm.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X