No announcement yet.

Database screwed up!

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database screwed up!

    At first I was geting this error
    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...

    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.
    Public Domain Content
    Amazon/Webmaster Services

  • #2
    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:

    Once the space issue is resolved you will need to run repair on your tables since at least two of then are now corrputed.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    • #3
      Thanks! I see where it is! I think there's massive logs some where!
      Public Domain Content
      Amazon/Webmaster Services


      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.