General Error

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
Locked
Khamosh-Saya
Registered User
Posts: 23
Joined: Mon Feb 02, 2009 7:23 am

General Error

Post by 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.
User avatar
Erik Frèrejean
Registered User
Posts: 207
Joined: Thu Oct 25, 2007 2:25 pm
Location: surfnet
Contact:

Re: General Error

Post by Erik Frèrejean »

This is a MySQL related error. You have to contact your host about this.
Available on .com
Support Toolkit developer
Khamosh-Saya
Registered User
Posts: 23
Joined: Mon Feb 02, 2009 7:23 am

Re: General Error

Post by Khamosh-Saya »

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?
User avatar
Erik Frèrejean
Registered User
Posts: 207
Joined: Thu Oct 25, 2007 2:25 pm
Location: surfnet
Contact:

Re: General Error

Post by 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.
Available on .com
Support Toolkit developer
Khamosh-Saya
Registered User
Posts: 23
Joined: Mon Feb 02, 2009 7:23 am

Re: General Error

Post by Khamosh-Saya »

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

Re: General Error

Post by 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')
User avatar
ChrisRLG
Registered User
Posts: 160
Joined: Wed Oct 11, 2006 9:47 am
Contact:

Re: General Error

Post by ChrisRLG »

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:

Re: General Error

Post by ToonArmy »

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.
Chris SmithBlogXMOOhlohArea51WikiNo support via PM/IM
Image
Khamosh-Saya
Registered User
Posts: 23
Joined: Mon Feb 02, 2009 7:23 am

Re: General Error

Post by 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.
Locked