hmm I thought its over I've change entry in common.php and functions.php
but still got this error:
and I don't know how to change this query to work properly ( I mean turn off inserting or updating selecting online tables)
in 150 line there is this function:

// Fill $pun_user with default values (for guests)
function set_default_user()

yes, there is but it's only remove users online box from the site. The queries still are working on my site in background mode.

Hi sometimes my database gives this error:
Error: Unable to fetch online list. or similar.

File: /path_to_site/forum/include/functions.php
Line: 245

PunBB reported: Unable to fetch old entries from online list

Database reported: ERROR: canceling statement due to statement timeout

Failed query: SELECT * FROM punbb_online WHERE logged<1260343238 

Is there maybe  a option to turn online users off?
How to do that?

Forum isn't so higly loaded. My site jgot something about 1k users per day only.
Average online users is about 4-5 max.
But right now I've turned off this query which was deleting from the punn_online.
Thats why I have now almost 1,5k users online  since 17 august tongue
I don't know how to check size of the database online but I'll try to check that... Right now I have 1 table which is bigger then normal ;]
this table tables is:
-users( almost 10 000 records)

I've tried that.
The same:

ERROR:  canceling statement due to statement timeout

I used this:


it's strange because I've got this error almost at once, but my phpmyadmin says that query  time is: 2,004.566 ms.
I thought that this have something to do with a temporary bans. When ban is being turned off maybe that happend, don't really know...

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=''

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?

I have some problems with extending search.php to find some more things.
I have add new column to pun_posts table and a <select> button with some <option> inside...
therefore I want to search forum for topics which are marked in that column...
how can I do that?

I've add this lines after 278 line in search.php

/ If it's a search for posts by a specific color
            if ($color)
                switch ($db_type)
                    case 'pgsql':
                        $result = $db->query('SELECT id FROM '.$db->prefix.'posts WHERE color = \''.$color.'\'') or error('Unable to fetch color', __FILE__, __LINE__, $db->error());

                        $result = $db->query('SELECT id FROM '.$db->prefix.'posts WHERE color = \''.$color.'\'') or error('Unable to fetch color', __FILE__, __LINE__, $db->error());

                if ($db->num_rows($result))

                    while ($row = $db->fetch_row($result))

                    $search_ids = array();
                    while ($row = $db->fetch_row($result))
                        $search_ids[] = $row[0];
                        //echo $search_ids;
                        //echo $row;



(4 replies, posted in PunBB 1.2 troubleshooting)

heh it's not the mod ;p
I've check and after manualy deleting some users from database I've forgot to change users_seq ;p
I was searching this in users table but it was in main"directory" of database:P
problem solved
thx for Your time.


(6 replies, posted in PunBB 1.2 discussion)

I mean on this forum... but like I see it's not solved yet here ;p
esupergood I only found Antibot but it's not what You've said.


(6 replies, posted in PunBB 1.2 discussion)

When I start to host my local forum on Internet I saw that there is a lot of new user registering with mail in domain or different, but still in this domain...
what can I do to prevent this?

and one more think, did You have the same problem with login in... after login its transfering me to RSS page ...


(4 replies, posted in PunBB 1.2 troubleshooting)

Is it possible to change value of pun_users_pkey?? I'm using PostgreSql.

This error appear when I tried to add new mod Anti-bot, beacause some Russian Bots (I think) registering on my forum.
I have already installed User Diaries, Users Online and Upload Images and as I remember everything works fine.


(4 replies, posted in PunBB 1.2 troubleshooting)

Hi What should I do with my postgre base when I got this error:

Database reported: ERROR: duplicate key value violates unique constraint "pun_users_pkey"

polish: ok dzięki, choć nie za wiele mi to mówi, jedyne co chcę to stworzyć cookie odpowiedzialny za logowanie punbb i pewnie jeszcze jakaś sesja...i wiem, że ta funkcja check_cookie to robi, dlatego chciałem ją wywołać by stworzyła mi te cookie jednak bez rezultatu... jak inaczej to zrobić??

english: ok, thx, but it still doesn't say enough to me, all I want  is to create a cookie responsible for punbb login stuff and perhaps a some session, I know that check_cookie function do it, thats why I've tried  to recall it , to create a cookie for me, but with no result. how can I do that in different way?

I've read I think almost important topics here, but none from here told me what I really have to do to make this working...
I want to integrate login page from my site with my forum...
I know what is being created when person is being logged on my page, I know cookie function of punbb but when I tried to use it doesn't worked.
what should I do , step by step anyone colud tell me, please?

define('PUN_ROOT', './forum/');
define('PUN_QUIET_VISIT', 1);
require PUN_ROOT.'include/common.php';
 define('PUN_ALLOW_INDEX', 1);
require PUN_ROOT.'include/parser.php';
check_cookie(&$id_user); // I've  tried that in different combinations, id_user its id of user in my web database