No announcement yet.

Can't create table taggregate_temp

  • Filter
  • Time
  • Show
Clear All
new posts

  • Can't create table taggregate_temp

    Since last 2 days, I am getting these db related errors:
    Database error in vBulletin 3.8.0:
    Invalid SQL:
            CREATE TABLE IF NOT EXISTS taggregate_temp_1243763760 (
                    threadid INT UNSIGNED NOT NULL DEFAULT '0',
                    views INT UNSIGNED NOT NULL DEFAULT '0',
                    KEY threadid (threadid)
            ) ENGINE = MEMORY;
    MySQL Error   : Error writing file './mysite_com_mydb/taggregate_temp_1243763760.frm' (Errcode: 28)
    Error Number  : 3
    Request Date  : Sunday, May 31st 2009 @ 09:55:16 AM
    Error Date    : Sunday, May 31st 2009 @ 09:55:16 AM
    Script        : [U][/U]
    Referrer      :
    IP Address    :
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :
    I searched on Internet and found this:

    where Steve suggests -
    "You need to edit the db user permissions to make sure it has full permissions to that database, including CREATE"

    But I did not changed anything at the database layer, so how come these errors start to pop-up??? Secondly, I would appreciate if someone can tell who is trying to create this table and why?

    The only change I remember is I changed the administrator of the control panel to some other user using tools.php but I don't see any reason as to how this can cause this issue?


  • #2
    That error means:

    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:
    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 a lot for being the saviour again


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