• Registered: 2016-12-08
  • Posts: 2

Topic: Problem about not delete record in Website.

I'm designing a website for learning and sharing information.

File: forum/include/functions.php
Line: 250
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='83.21.75.15'

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!

  • Registered: 2015-05-02
  • Posts: 541

Re: Problem about not delete record in Website.

Why do you need this? may have other solutions.

  • From: Siberia
  • Registered: 2013-08-05
  • Posts: 408

Re: Problem about not delete record in Website.

@thanhvanchi, very few people use PostgreSQL.
The dblayer/pgsql.php driver is badly tested because of it.
PunBB v1.2.x isn't supported long ago.
PunBB v1.4.x too is almost not supported (officially there is only 1 developer).

ForkBB
I speak only Russian  :P

Visman's Website