General Error when accessing PM

A place for general not CMSimple related discussions
Post Reply
johnjdoe
Posts: 571
Joined: Tue May 20, 2008 6:32 am

General Error when accessing PM

Post by johnjdoe » Wed Jul 08, 2009 7:40 am

Hi,

when I try to access my new messages here in the board I receive the follwing error wich I haven't yesterday:

SQL ERROR [ mysqli ]

Got error 28 from storage engine [1030]

SQL

SELECT DISTINCT u.user_id, u.username, u.username_clean, u.user_colour, 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 = 55 AND z.friend = 1 AND u.user_id = z.zebra_id GROUP BY z.zebra_id, u.user_id, u.username_clean, u.user_colour, u.username ORDER BY u.username_clean ASC

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: ucp.php
LINE: 282
CALL: dbal_mysqli->sql_query()

Holger
Site Admin
Posts: 3470
Joined: Mon May 19, 2008 7:10 pm
Location: Hessen, Germany

Re: General Error when accessing PM

Post by Holger » Wed Jul 08, 2009 7:56 am

Yes, now I have this problem too.
Seems to be a problem with the MySQL index.

I'll try to fix ASAP.

Holger

Post Reply