Can't create/write to file '#sql_570e_0.MYD' (Errcode: 17) [1]

Discussion in 'Site & Server Administration' started by bbrian017, Jul 8, 2009.

  1. #1
    How do I stop the following errors on my server?

    Godaddy will not help me!

    phpbb forums software

    General Error
    SQL ERROR [ mysql4 ]
    
    Can't create/write to file '#sql_570e_0.MYD' (Errcode: 17) [1]
    
    SQL
    
    SELECT * FROM phpbb_users WHERE user_type <> 2 AND user_type <> 1 ORDER BY RAND() LIMIT 1
    
    BACKTRACE
    
    FILE: includes/db/mysql.php
    LINE: 174
    CALL: dbal->sql_error()
    
    FILE: includes/db/mysql.php
    LINE: 221
    CALL: dbal_mysql->sql_query()
    
    FILE: includes/db/dbal.php
    LINE: 170
    CALL: dbal_mysql->_sql_query_limit()
    
    FILE: portal/block/random_member.php
    LINE: 51
    CALL: dbal->sql_query_limit()
    
    FILE: portal.php
    LINE: 212
    CALL: include('portal/block/random_member.php')
    Code (markup):
    wordpress software

    SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (880, 854, 826, 813, 780) ORDER BY t.name ASC
    Code (markup):
     
    bbrian017, Jul 8, 2009 IP
  2. gary4gar

    gary4gar Peon

    Messages:
    496
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
  3. bbrian017

    bbrian017 Well-Known Member

    Messages:
    2,990
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    170
    #3
    That discussion doesn't really answer my problem!

    I'm still getting the error and no solution' was found in any of the replies!

    Apparently it might be an issue with the LACK memory of my server!
     
    bbrian017, Jul 8, 2009 IP
  4. kailash

    kailash Well-Known Member

    Messages:
    1,248
    Likes Received:
    42
    Best Answers:
    0
    Trophy Points:
    190
    #4
    Sometime this happens if there is a permission problem with .MYD file or it may possible that the table is corrupted.
     
    kailash, Jul 8, 2009 IP
  5. bbrian017

    bbrian017 Well-Known Member

    Messages:
    2,990
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    170
    #5
    I did a quick Google search regarding this!

    Any suggestion on what I can read to fix this and stop it from happening?

    I search this, how to set .MYD permissions but not much came up.
     
    bbrian017, Jul 9, 2009 IP
  6. Bohra

    Bohra Prominent Member

    Messages:
    12,573
    Likes Received:
    537
    Best Answers:
    0
    Trophy Points:
    310
    #6
    There must be less space on ur server which is free .. check that and confirm
     
    Bohra, Jul 9, 2009 IP
  7. bbrian017

    bbrian017 Well-Known Member

    Messages:
    2,990
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    170
    #7
    Do you mean hard drive space?
     
    bbrian017, Jul 9, 2009 IP
  8. Bohra

    Bohra Prominent Member

    Messages:
    12,573
    Likes Received:
    537
    Best Answers:
    0
    Trophy Points:
    310
    #8
    Yes correct!
     
    Bohra, Jul 9, 2009 IP
  9. bbrian017

    bbrian017 Well-Known Member

    Messages:
    2,990
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    170
    #9
    out of 10 gigs I have 5 gigs free
     
    bbrian017, Jul 9, 2009 IP