Announcement

Collapse
No announcement yet.

MySQL Error : Can't create/write to file '/var/tmp/#sql_8fda_0.MYI'

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

  • MySQL Error : Can't create/write to file '/var/tmp/#sql_8fda_0.MYI'

    Anyone can help me with this?

    Database error in vBulletin 3.5.0:

    Invalid SQL:

    SELECT setting.*, settinggroup.grouptitle
    FROM settinggroup AS settinggroup
    LEFT JOIN setting AS setting USING(grouptitle)
    WHERE settinggroup.displayorder <> 0
    ORDER BY settinggroup.displayorder, setting.displayorder;

    MySQL Error : Can't create/write to file '/var/tmp/#sql_8fda_0.MYI' (Errcode: 13)
    Error Number : 1

    I just moved from one server to another

  • #2
    This error means:

    System error: 13 = Permission denied

    The directory in that error either does not exist, or it is not world-readable and writable (chmod777.) You need to check and correct both situations to fix this error.
    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.


    Comment


    • #3
      Originally posted by Steve Machol
      This error means:

      System error: 13 = Permission denied

      The directory in that error either does not exist, or it is not world-readable and writable (chmod777.) You need to check and correct both situations to fix this error.
      there is no "var" or "tmp" directory on MySQO or in on my server. i am not sure how to edit it. i know how to edit permissions, i just don't know what folder

      Comment


      • #4
        Your host will need to create this under the root server directory.
        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.


        Comment


        • #5
          Originally posted by Steve Machol
          Your host will need to create this under the root server directory.
          there is no way i can do this myself? i have a Virtually Private Server with iPower web. and if i have to go to them, what exactly is it i am asking for?

          and Happy New Year Mr. Machol! i appreciate all the answers you've giving us in the past, i stay seeing you working hard on here, so just make sure you don't drink too LITTLE tonight.

          Comment


          • #6
            You can always try. You will need root access to this server to do this.

            If you need to ask them, tell them to create a /tmp direcotry on this server off the root directory and chmod it to 777.
            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.


            Comment


            • #7
              Originally posted by Steve Machol
              You can always try. You will need root access to this server to do this.

              If you need to ask them, tell them to create a /tmp direcotry on this server off the root directory and chmod it to 777.
              can't i just FTP to the server and do that myself? After they/I create that directory, what do I add? The problem will be fixed just by adding that directory and chmod it to 777?

              i don't remember seeing this on my old server though [i recently transfered, dec 21st, 2005]. what about that "var" directory? i don't know what that is , do i have to add that as well?
              Last edited by Wordz; Sat 31st Dec '05, 2:09pm.

              Comment


              • #8
                No. You need root access to the server to do this.
                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.


                Comment


                • #9
                  so all they have to do is add a "tmp" directory, chmod it to 777 and the problem will be fixed?

                  Comment


                  • #10
                    If they do this correctly, yes.
                    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.


                    Comment


                    • #11
                      Originally posted by Steve Machol
                      If they do this correctly, yes.
                      last question concerning this (pardon me drawing it out). but what about that "var"? i don't need them to add that as well?

                      Comment


                      • #12
                        Actually tell them to create a /var/tmp directory on this server and chmod it to 777.
                        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.


                        Comment


                        • #13
                          If he has a Virtual Private Server, then he does have root.

                          Comment


                          • #14
                            Originally posted by feldon23
                            If he has a Virtual Private Server, then he does have root.
                            i am new to the VPS. do you know how i can go about doing this?

                            Comment


                            • #15
                              You need to ask your host to do this.
                              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.


                              Comment

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