Announcement

Collapse
No announcement yet.

30+ vBulletin database error

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

  • 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?


  • #2
    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.

    Comment


    • #3

      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 .
      this is my sig

      Comment


      • #4
        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.

        Baby, I was born this way

        Comment

        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