Announcement

Collapse
No announcement yet.

A serious problem.

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

  • A serious problem.

    Heya,

    I recently moved my forum to a semi-dedicated server but I am having a problem.

    The Forum was backed up and transfered to the new server then I am getting this error.

    Code:
    <!-- Database error in vBulletin: Invalid SQL: 
    SELECT
    session.userid AS sessionuserid,
    post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
    attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
    ,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
    FROM post
    LEFT JOIN icon ON icon.iconid=post.iconid
    LEFT JOIN user ON user.userid=post.userid
    LEFT JOIN userfield ON userfield.userid=user.userid
    LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                           LEFT JOIN customavatar ON customavatar.userid=user.userid
    LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
    LEFT JOIN session ON (session.userid = user.userid
                                                AND session.userid > 0
                                                
                                                AND session.lastactivity>998890922)
    WHERE post.postid IN (0,21468,21587,21591,21618)
    ORDER BY dateline 
    
    mysql error: Can't create/write to file '/tmp/#sql6187_16d_0.MYI' (Errcode: 13)
    mysql error number: 1
    Date: Monday 27th of August 2001 01:57:02 AM
    Script: /forum/showthread.php?threadid=1827
    Referer: http://66.33.97.99/forum/forumdisplay.php?forumid=2
     -->
    The only difference between the old server and new server is mySQL version...

    The old server has MySQL 3.23.32
    And the new server has MySQL 3.23.39

    My question is that does MySQL 3.23.39 have a known problem with VB?

    By the way, I checked repair.php, all tables are reporting normal.

  • #2
    c:\mysql\bin>perror 13
    Error code 13: Permission denied
    Sounds like the permissions are messed up somewhere along the way.

    Comment


    • #3
      But could it be? I tried a clean install and it's working as well as all other mysql scripts are working.

      Comment

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