Announcement

Collapse
No announcement yet.

Can't create table taggregate_temp

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

  • micks80
    replied
    Thanks a lot for being the saviour again

    Leave a comment:


  • Steve Machol
    replied
    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:

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

    Leave a comment:


  • micks80
    started a topic Can't create table taggregate_temp

    Can't create table taggregate_temp

    Hi,
    Since last 2 days, I am getting these db related errors:
    Code:
    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]http://www.mysite.com/forum/cron.php?rand=1243778098[/U]
    Referrer      : http://www.mysite.com/forum/video.php
    IP Address    : 118.94.xxx.xx
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :
    I searched on Internet and found this:
    http://www.vbulletin.com/forum/showthread.php?t=276985

    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?

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