Announcement

Collapse
No announcement yet.

MySQL Error

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

  • MySQL Error

    Get this message when i try to create a new treat or register a new user. This is a new installation.

    <!-- Database error in vBulletin: Invalid SQL: SELECT * FROM user,userfield WHERE 1=1 AND user.userid = userfield.userid ORDER BY username LIMIT 0,30
    mysql error: Can't create/write to file '/tmp/#sql6f76_5f7_3.MYI' (Errcode: 13)
    mysql error number: 1
    Date: Thursday 05th of April 2001 04:19:19 PM
    Script: /community/memberlist.php

  • #2
    This is a permission problem.... you either need to get your host to allow write permission to the /tmp directory, or change the temporary directory to one in your home area.

    Comment


    • #3
      The user for the database is root, and the vbulletin was created successfully without any problems. Where can I make the changes you are suggesting? (I`m not a programmer, just trying to get this to work )

      Thanks

      Comment


      • #4
        From a telnet/SSH prompt, try this:
        Code:
        chmod 5777 /tmp

        Comment


        • #5
          Thanks....it had 755 rights. Now it is 777 pluss sticky and is working great

          Thanks!

          Comment

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