1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

DataBase Error, How to fix this..

Discussion in 'vBulletin' started by kiddie, Jan 1, 2012.

  1. #1
    I am getting this error.
    SEMrush
    Database error in vBulletin 3.8.7:
    
     Invalid SQL:
    
                    SELECT * FROM icc_question_queue
                    WHERE postdate = 0 AND status < 3
                    AND forumid = 47
                    ORDER BY RAND() LIMIT 1;
    
     MySQL Error   : Can't create/write to file '/tmp/#sql_7ece_1.MYD' (Errcode: 17)
     Error Number  : 1
     Request Date  : Sunday, January 1st 2012 @ 03:53:41 AM
     Error Date    : Sunday, January 1st 2012 @ 03:53:41 AM
     Script        : http://domain.com/forum/index.php
     Referrer      :
     IP Address    : 66.91.131.131
     Username      : Unregistered
     Classname     : vB_Database
     MySQL Version :
    Code (markup):
    How to fix this??
     
    Solved! View solution.
    kiddie, Jan 1, 2012 IP
    SEMrush
  2. #2
    looks like your /tmp might be out of space
    check that folder first
     
    lachrymologist, Jan 1, 2012 IP
  3. kiddie

    kiddie Peon

    Messages:
    76
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    i did not get any tmp folder. where to look this?
     
    kiddie, Jan 1, 2012 IP
  4. amigoserv.com

    amigoserv.com Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    is your forum on openvz vps or on xen vps server?

    if you have xen or kvm or vmware vps other than OpenVZ vps, you can create partition tmp symlinked to /var/tmp and /tmp with e.g 10 GB and the forum will wok well
     
    amigoserv.com, Jan 4, 2012 IP
  5. kiddie

    kiddie Peon

    Messages:
    76
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I contact my host and they solve my problem. Thanks lachrymologist for hint.
     
    kiddie, Jan 5, 2012 IP