Announcement

Collapse
No announcement yet.

Help, site down, database Errors

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

  • Help, site down, database Errors

    Woke up to this database error, can anyone help. I can access admin, but everywhere else results in this error. Thanks


    PHP Code:
    Database error in vBulletin 3.8.7:

    Invalid SQL:

    SELECT eventiduseridevent.titlerecurringrecuroptiondateline_fromdateline_toevent.calendarid, IF (dateline_to 010) AS singledaycustomfields,
    dateline_from AS dateline_from_userdateline_to AS dateline_to_userutcdst
    FROM event 
    AS event
    INNER JOIN calendar 
    AS calendar USING (calendarid)
    WHERE ((dateline_to >= 1394687145 AND dateline_from 1436936745) OR (dateline_to AND dateline_from >= 1394687145 AND dateline_from <= 1436936745 ))
    AND 
    visible 1
    AND calendar.options 512
    ORDER BY dateline_from
    ;

    MySQL Error Got error 28 from storage engine
    Error Number 
    1030
    Request Date 
    SaturdayMarch 15th 2014 05:05:45 AM
    Error Date 
    SaturdayMarch 15th 2014 05:05:45 AM
    Script 
    http://www.mysite.co.uk/
    Referrer :
    IP Address 81.135.116.95
    Username 
    Jim
    Classname 
    vB_Database
    MySQL Version 
    5.5.33-cll-lve 


    I have two other VB forums on the same dedicated server and they are working OK
    Last edited by jimjam; Fri 14 Mar '14, 10:03pm.

  • #2
    It's a server error.....please contact your host.
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.6.3 Demo
    AdminAmmo - My Cloud Demo

    Comment


    • #3
      Thanks Mark,

      Sorted it, since last April a Mysql backup script had been writing to a file, which eventually got to 200gb and filled my server hard drive :doh:

      Comment


      • #4
        For the next person who finds this topic: MySQL Error : Got error 28 from table handler
        Error Code 28 (No space left on device):
        Got error 28 from table handler means your server's mysql partition for your mysql database ran out of disk space or that the /tmp directory ( http://www.mysql.com/doc/T/e/Temporary_files.html )on your server doesn't have enough space, you need to
        1. close your forum to prevent further posting or writing to the database
        2. contact your web host
        3. or if your host yourself on a dedicated server, you need to move your mysql partition to a larger disk or change the /tmp directory location via your servers my.cnf file

        Comment

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