General Error

[Khamosh-Saya]

I am facing this Error Right now
need help Urjent

Code: Select all

General Error
SQL ERROR [ mysql4 ]

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

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

[Erik Frèrejean]

This is a MySQL related error. You have to contact your host about this.

[Khamosh-Saya]

This is a MySQL related error. You have to contact your host about this.

its mean its not my fault or not any phpbb related error
its related with host

right?

[Erik Frèrejean]

The error isn't directly related to phpBB. MySQL returns that it can't write a file. Maybe a permissions issue or a full disk.

[Khamosh-Saya]

If i will delete mine Some Database

Right now i have delete mine 2 Database which was unuse

[Khamosh-Saya]

Now it Giving me this error

Code: Select all

General Error
SQL ERROR [ mysql4 ]

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

SQL

SELECT DISTINCT u.user_id, u.username, u.user_colour, u.user_allow_viewonline, MAX(s.session_time) as online_time, MIN(s.session_viewonline) AS viewonline FROM (phpbb_users u, phpbb_zebra z) LEFT JOIN phpbb_sessions s ON (s.session_user_id = z.zebra_id) WHERE z.user_id = 53 AND z.friend = 1 AND u.user_id = z.zebra_id GROUP BY z.zebra_id, u.user_id, u.username, u.user_allow_viewonline, u.user_colour ORDER BY u.username_clean ASC LIMIT 3

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/db/mysql.php
LINE: 205
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 157
CALL: dbal_mysql->_sql_query_limit()

FILE: portal/block/friends.php
LINE: 89
CALL: dbal_mysql->sql_query_limit()

FILE: portal.php
LINE: 343
CALL: include('portal/block/friends.php')

[ChrisRLG]

The error isn't directly related to phpBB. MySQL returns that it can't write a file. Maybe a permissions issue or a full disk.

[ToonArmy]

This is a MySQL related error. You have to contact your host about this.

If i will delete mine Some Database

Right now i have delete mine 2 Database which was unuse

The server is probably out of temporary disc space, or the permissions are broken. There is nothing you can do but ask your host to fix it.

[Khamosh-Saya]

I have told them to upgrade mine php version
After that they said we have move ur server for php version 5
I have told them okz Move it

And then they said we have moved.
Check ur php version
i have check in mine forum
But still showing php version 4.0.3

and from that day i m facing General Error
But Today its take too much time and the error is diffrent.