General Error Can't create/write to file

[Jessica.C]

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)

 

[leafypiggy]

This has been resolved.

 

[xrms3ux1]

I got the same error.
Can't create/write to file '/dev/shm/#sql_96b_0.MAI' (Errcode: 13 "Permission denied")
my web site http://xrms3u.x10host.com/xrms/private/home.php
Can anyone help?

 

[romzwall]

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?

 

[epicure2]

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()