PunBB Resource

Your ultimate PunBB resource!

Keywords:

    (Extended)

You are not logged in.

#1 2009-08-18 10:19:26

jaason
Member
From: Poland
Registered: 2008-11-26
Posts: 29
Website

User online count problem

Hi again.
I have one strange problem right now with this;

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'

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:

Code:

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?

I've tried even TRUNCATE but the same result.
it's strange because I've got this error almost at once, but my phppgadmin says that query  time is: 2,004.566 ms. I'm using Postgre SQL database.

Last edited by jaason (2009-08-18 10:20:05)

Offline

 

#2 2009-08-18 20:06:53

Koos
Administrator
Registered: 2007-01-14
Posts: 524
Website

Re: User online count problem

Looks like a deadlock in your database. Contact your system administrator and ask them to restart the server for you.

Offline

 

#3 2009-08-19 08:57:21

jaason
Member
From: Poland
Registered: 2008-11-26
Posts: 29
Website

Re: User online count problem

Thx for Your reply. Probably it is a deadlock. It should work, I will ask administrator to do that.
Thx again.

Offline

 

Board footer

Based on PunBB
© Copyright 2002–2005 Rickard Andersson

© Copyright 2004–2006 Kristoffer Jansson

User contributed files are property of their respective owners.