Topic: Problem about not delete record in Website.
I'm designing a website for learning and sharing information.
PunBB reported: Unable to delete from online list
Database reported: ERROR: canceling statement due to statement timeout
Failed query: DELETE FROM pun_online WHERE ident='18.104.22.168'
Hi i got this error, I checked database and I have only one record in the pun_online. I can't delete this record...What should I do to solve that?
the line where is the problem is:
if ($cur_user['user_id'] == '1') $db->query('DELETE FROM '.$db->prefix.'online WHERE ident=\''.$db->escape($cur_user['ident']).'\'') or error('Unable to delete from online list', __FILE__, __LINE__, $db->error());
all code is stored in update_users_online() function.
Is there some kind of connection between some tables, therefore I can't delete this record?
Thank's a lot!