General Error Can't create/write to file

Discussion in 'Free Hosting' started by Jessica.C, Mar 18, 2015.

  1. Jessica.C

    Jessica.C Member Prime Account

    Messages:
    379
    Likes Received:
    5
    Trophy Points:
    18
    I'm able to access pretty much all pages except the index page on my site (http://chenschool.elementfx.com/phpBB3/index.php), which is where I get an error:

    General Error
    SQL ERROR [ mysql4 ]

    Can't create/write to file '/tmp/#sql_865e0_0.MAI' (Errcode: 28) [1]

    SQL

    SELECT f.*, ft.mark_time, fa.user_id, t.topic_id, t.topic_title, t.topic_title_colour, t.icon_id, t.topic_status, t.topic_moved_id, t.topic_attr_id, t.topic_attr_user, t.topic_attr_time FROM (phpbb_forums f) LEFT JOIN phpbb_forums_track ft ON (ft.user_id = 2 AND ft.forum_id = f.forum_id) LEFT JOIN phpbb_forums_access fa ON (fa.forum_id = f.forum_id AND fa.session_id = '5165679cc140cdf81b9552a0cf7b3586') LEFT JOIN phpbb_topics t ON (f.forum_last_post_id = t.topic_last_post_id) GROUP BY f.forum_id ORDER BY f.left_id

    BACKTRACE

    FILE: (not given by php)
    LINE: (not given by php)
    CALL: msg_handler()

    FILE: [ROOT]/includes/db/dbal.php
    LINE: 757
    CALL: trigger_error()

    FILE: [ROOT]/includes/db/mysql.php
    LINE: 193
    CALL: dbal->sql_error()

    FILE: [ROOT]/includes/functions_display.php
    LINE: 181
    CALL: dbal_mysql->sql_query()

    FILE: [ROOT]/index.php
    LINE: 165
    CALL: display_forums()


    I thought it might be x10 since I didn't touch any files or whatever since the time I was able to get on the index page (a couple days ago)
     
  2. leafypiggy

    leafypiggy Manager of Pens and Office Supplies Staff Member

    Messages:
    3,819
    Likes Received:
    163
    Trophy Points:
    63
    This has been resolved.
     
  3. xrms3ux1

    xrms3ux1 New Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
  4. romzwall

    romzwall New Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    same issue for my site http://romzwall.elementfx.com, i'm getting a General error: 1 Can't create/write to file '/dev/shm/#sql_96b_0.MAI' (Errcode: 13 "Permission denied")
    How did you resolved these kind of issue?
     
  5. epicure2

    epicure2 New Member

    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    I can confirm that I'm experiencing similar issue on a freshly installed phpbb forum. Seems related to issues with disk/sql as suggested by other threads in the last 24 hours.

    General Error
    SQL ERROR [ mysqli ]

    Can't create/write to file '/dev/shm/#sql_96b_0.MAI' (Errcode: 13 "Permission denied") [1]

    SQL

    SELECT f2.* FROM phpbbim_forums f1 LEFT JOIN phpbbim_forums f2 ON (f1.left_id BETWEEN f2.left_id AND f2.right_id) WHERE f1.forum_id = 1 ORDER BY f2.left_id ASC

    BACKTRACE

    FILE: (not given by php)
    LINE: (not given by php)
    CALL: msg_handler()

    FILE: [ROOT]/phpbb/db/driver/driver.php
    LINE: 855
    CALL: trigger_error()

    FILE: [ROOT]/phpbb/db/driver/mysqli.php
    LINE: 193
    CALL: phpbb\db\driver\driver->sql_error()

    FILE: [ROOT]/phpbb/db/driver/factory.php
    LINE: 329
    CALL: phpbb\db\driver\mysqli->sql_query()

    FILE: [ROOT]/includes/functions_admin.php
    LINE: 317
    CALL: phpbb\db\driver\factory->sql_query()

    FILE: [ROOT]/includes/acp/acp_forums.php
    LINE: 817
    CALL: get_forum_branch()

    FILE: [ROOT]/includes/functions_module.php
    LINE: 674
    CALL: acp_forums->main()

    FILE: [ROOT]/adm/index.php
    LINE: 81
    CALL: p_master->load_active()
     

Share This Page