Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Forum rules
Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Khamosh-Saya
Registered User
Posts: 23 Joined: Mon Feb 02, 2009 7:23 am
Post
by Khamosh-Saya » Fri Feb 06, 2009 6:21 pm
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
Registered User
Posts: 207 Joined: Thu Oct 25, 2007 2:25 pm
Location: surfnet
Contact:
Post
by Erik Frèrejean » Fri Feb 06, 2009 6:22 pm
This is a MySQL related error. You have to contact your host about this.
Khamosh-Saya
Registered User
Posts: 23 Joined: Mon Feb 02, 2009 7:23 am
Post
by Khamosh-Saya » Fri Feb 06, 2009 6:32 pm
Erik Frèrejean wrote: 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
Registered User
Posts: 207 Joined: Thu Oct 25, 2007 2:25 pm
Location: surfnet
Contact:
Post
by Erik Frèrejean » Fri Feb 06, 2009 6:37 pm
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
Registered User
Posts: 23 Joined: Mon Feb 02, 2009 7:23 am
Post
by Khamosh-Saya » Fri Feb 06, 2009 6:41 pm
If i will delete mine Some Database
Right now i have delete mine 2 Database which was unuse
Khamosh-Saya
Registered User
Posts: 23 Joined: Mon Feb 02, 2009 7:23 am
Post
by Khamosh-Saya » Fri Feb 06, 2009 8:37 pm
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
Registered User
Posts: 160 Joined: Wed Oct 11, 2006 9:47 am
Contact:
Post
by ChrisRLG » Fri Feb 06, 2009 8:46 pm
Erik Frèrejean wrote: 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
Registered User
Posts: 335 Joined: Fri Mar 26, 2004 7:31 pm
Location: Bristol, UK
Contact:
Post
by ToonArmy » Fri Feb 06, 2009 8:47 pm
Erik Frèrejean wrote: This is a MySQL related error. You have to contact your host about this.
Khamosh-Saya wrote: 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
Registered User
Posts: 23 Joined: Mon Feb 02, 2009 7:23 am
Post
by Khamosh-Saya » Fri Feb 06, 2009 8:50 pm
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.