Announcement

Collapse
No announcement yet.

30+ vBulletin database error

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

  • Paul M
    replied
    Originally posted by Set3sh View Post
    I am trying to understand what was the man who configured your server thinking?
    Anything MySQL related should not be stored within /tmp folder.
    MySQL uses the /tmp folder for temp operations, just like most applications do.

    Error 28 means it ran out of space - so either /tmp needs clearing out, or it needs to be bigger.
    Running a CHMOD command will have zero effect on this issue as permissions are not the problem.

    Leave a comment:


  • Pogo
    replied

    Errcode: 28 means that the partition containg the /tmp directory has no space left. So you or your host should delete the contents in /tmp and check that the partition has enough free space and /tmp is regularly cleared .

    Leave a comment:


  • Set3sh
    replied
    Hello,


    Please run this command in your ssh console:

    chmod -R 0777 /tmp


    It's not the best way to fix your problem but it's the fastest.
    I am trying to understand what was the man who configured your server thinking?
    Anything MySQL related should not be stored within /tmp folder.

    Because:
    > /tmp is meant for storing files temporary
    > it's world readable/writeable/executable
    > some distros clear /tmp before the OS is restarted.


    Anyway contact your system administrator and ask him to reconfigure MySQL with a chroot jail.
    If he doesn't have a clue what are you talking about, hire somebody else.


    Kind regards,
    George.

    Leave a comment:


  • Arkamek
    started a topic 30+ vBulletin database error

    30+ vBulletin database error

    Hello, when i wake up today i get 30+ emails with this:

    Code:
    [COLOR=#222222][FONT=arial]Database error in vBulletin 4.2.2:[/FONT][/COLOR]
    
    [COLOR=#222222][FONT=arial]Invalid SQL:[/FONT][/COLOR]
    
    [COLOR=#222222][FONT=arial]                                SELECT post.dateline, post.pagetext AS message, post.allowsmilie, post.postid,[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                                        thread.threadid, thread.title, thread.prefixid, post.attach,[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                                        forum.forumid,[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                                        user.*[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                                        ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.[/FONT][/COLOR][COLOR=#222222][FONT=arial]width AS avwidth,customavatar.height AS avheight[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                                FROM post AS post[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                                JOIN thread AS thread ON (thread.threadid = post.threadid)[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                                JOIN forum AS forum ON(forum.forumid = thread.forumid)[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                                LEFT JOIN user AS user ON (post.userid = user.userid)[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                                LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                        WHERE 1=1[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                                AND thread.forumid IN(3,1,2,4,5,8,24,25,26,27,28,[/FONT][/COLOR][COLOR=#222222][FONT=arial]29,30,31,32,33,34,35,36,37,40,[/FONT][/COLOR][COLOR=#222222][FONT=arial]38,41,39,42,43,6,9,10,11,12,[/FONT][/COLOR][COLOR=#222222][FONT=arial]13,14,15,7,19,20,21,22,23,16,[/FONT][/COLOR][COLOR=#222222][FONT=arial]17,18)[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                                AND thread.visible = 1[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                                AND post.visible = 1[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                                AND thread.open <> 10[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                                AND post.dateline > 1430807436[/FONT][/COLOR]
    
    
    [COLOR=#222222][FONT=arial]                        ORDER BY post.dateline DESC[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]                        LIMIT 0,5;[/FONT][/COLOR]
    
    [COLOR=#222222][FONT=arial]MySQL Error   : Can't create/write to file '/tmp/#sql_e42_0.MYI' (Errcode: 28)[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]Error Number  : 1[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]Request Date  : Thursday, June 4th 2015 @ 08:30:36 AM[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]Error Date    : Thursday, June 4th 2015 @ 08:30:36 AM[/FONT][/COLOR]



    There was many users/ip then i have no idea why is that, someone can help?

Related Topics

Collapse

  • aelalfey
    Database error in vBulletin 5.1.8
    by aelalfey
    I started getting this error about 6 days "about 10 emails everyday" ago with no certain reason.
    Code:
    [COLOR=#222222][FONT=arial]Database error in vBulletin 5.1.8:[/FONT][/COLOR]
    
    [COLOR=#222222][FONT=arial]                        Invalid SQL:[/FONT][/COLOR]
    [COLOR=#222222][FONT=arial]CREATE[/][/]
    ...
    Fri 25 Sep '15, 4:00am
  • nsglazer
    Database Error
    by nsglazer
    I've received hundreds of emails since our upgrade to vBulletin 5.1.3 Patch Level 1 all pretty similar to these. Any idea what's going on?

    Database error in vBulletin 5.1.3:

    ...
    Sun 16 Nov '14, 1:27pm
  • vskylabv
    Error while upgrading vb5.0.2 to vb5.0.3
    by vskylabv
    Since the support tickets have gone on vacation, I figured I'd asked on here.

    Here's the error I'm receiving while upgrading.
    Code:
    [COLOR=#000000][FONT=arial][SIZE=12px]<?xml version="1.0" encoding="window[/][/][/]
    ...
    Sat 29 Jun '13, 4:57pm
  • marky
    Database error in vBulletin 5.1.0
    by marky
    Got an error today (everything is verbatim except the bolded part):

    Invalid SQL:
    /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'node_10_lvl1data' AND event = 'nodeChg_10')...
    Tue 22 Apr '14, 1:29pm
Working...
X