Jump to content

stgeorge

Members
  • Posts

    101
  • Joined

  • Last visited

Posts posted by stgeorge

  1. Well at least I am not the only one.

     

    I am getting white screened on cPanel Login and I am getting SQL data base error:

     

    DB function failed with error number 1030

    Got error 28 from storage engine SQL=SELECT m.*, u.name AS editor, g.name AS groupname, MIN(mm.menuid) AS pages FROM jos_modules AS m LEFT JOIN jos_users AS u ON u.id = m.checked_out LEFT JOIN jos_groups AS g ON g.id = m.access LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.client_id = 0 GROUP BY m.id ORDER BY m.position , m.ordering ASC LIMIT 0, 20

     

    in my Joomla installation when I try to access Modules, Plugins and other areas of the admin backend.

     

    I am also getting this error on some of my tables when I try to access them in mySQL:

     

    Error

     

    SQL query: Edit

     

    SHOW FULL FIELDS FROM `jos_plugins` ;

     

    MySQL said: Documentation

    #1030 - Got error 28 from storage engine

     

    Below From:

     

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

     

    What is error 28 and how can I avoid it?

     

    Using the command line tool perror you can find out, what the error 28 means.

     

    > perror 28

    Error code 28: No space left on device

     

    If you get his error, you need to check all filesystems where MySQL operates. It may be single filesystem or as we recommend you can have datadir, tmpdir and log files split into dedicated filesystems. MySQL often creates temporary tables for some queries - most of them are placed in tmpdir, but some into database directory (e.g. ALTER TABLE). You must ensure, that there is enough free disk space available for MySQL.

     

    You can check out, that environment variables for MySQL are properly set.

     

    Check the value of tmp_table_size:

     

    I would write a ticket but cannot of course.

     

    That is why I am here in the hope someone from HelioHost admin will read the board and realize there is a problem.

×
×
  • Create New...