26

Re: NEW POSTS NOT SHOWN! This problem does us. We are just upset. HELP!!!

it's a small problem,easy to solve:

delete this

??????????: ????????? ?????????? ??????? Tuz       
??????????: ???? ????? 2000 ??????? druid

delete all topics which had been moved,you will find your old topics,

the problem always happened in my forum,i'd ever posted on Punbb.org,none could say one word abt it,then i solved it myself.

Re: NEW POSTS NOT SHOWN! This problem does us. We are just upset. HELP!!!

qie wrote:

it's a small problem,easy to solve:

delete this

??????????: ????????? ?????????? ??????? Tuz       
??????????: ???? ????? 2000 ??????? druid

delete all topics which had been moved,you will find your old topics,

the problem always happened in my forum,i'd ever posted on Punbb.org,none could say one word abt it,then i solved it myself.

What are you suggesting? hmm

28

Re: NEW POSTS NOT SHOWN! This problem does us. We are just upset. HELP!!!

Smartys wrote:

What are you suggesting? hmm

i do not know.

29 (edited by yannlog 2006-10-29 13:46)

Re: NEW POSTS NOT SHOWN! This problem does us. We are just upset. HELP!!!

Hello, it seems i've got a similar problem with my forum http://www.poliskarr.org/punbb/upload/
Sometimes, when registered users post new messages or when i post a new message, we can't read our last messages in the topic but the messages have been well written in the table. Very strange ... 
I don't know why ? Is it the big size of the data (more than 69000 posts) ... Is it a query problem ?
Thank you for your help ...

I'm running Punbb 1.2.5

PunBB version
    PunBB 1.2.5 - Check for upgrade
    © Copyright 2002, 2003, 2004, 2005 Rickard Andersson
Server load
    Not available (9 users online)
Environment
    Operating system: Linux
    PHP: 4.4.4 - Show info
    Accelerator: N/A
Database
    MySQL 4.1.21-max-log
    Rows: 377709
    Size: 51.86 MB

Re: NEW POSTS NOT SHOWN! This problem does us. We are just upset. HELP!!!

Size of the database has nothing to do with it wink
Did you modify viewtopic.php?

31 (edited by yannlog 2006-10-29 13:52)

Re: NEW POSTS NOT SHOWN! This problem does us. We are just upset. HELP!!!

i use a lot of plugins before but the problem came suddenly ...

here is one of the query in Viewtopic :

// Retrieve the posts (and their respective poster/online status)

$result = $db->query('SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, u.imgaward, u.country, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'users AS u ON u.id=p.poster_id INNER JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id LEFT JOIN '.$db->prefix.'online AS o ON (o.user_id=u.id AND o.idle=0) WHERE p.topic_id='.$id.' ORDER BY p.id LIMIT '.$start_from.','.$pun_user['disp_posts'], false) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error()); //Attachment Mod, changed the true to false...//

Do you think there is something to change somewhere in viewtopic ? roll

Re: NEW POSTS NOT SHOWN! This problem does us. We are just upset. HELP!!!

And you have the exact same issue as the previous poster tongue
http://dev.punbb.org/changeset/172
You're missing that changeset

Re: NEW POSTS NOT SHOWN! This problem does us. We are just upset. HELP!!!

It means that i've to change (o.user_id=u.id AND o.idle=0) by the following code (o.user_id=u.id AND o.user_id!=1 AND o.idle=0)

It is correct ?

Re: NEW POSTS NOT SHOWN! This problem does us. We are just upset. HELP!!!

Right

Re: NEW POSTS NOT SHOWN! This problem does us. We are just upset. HELP!!!

a very big thank Smartys wink

36 (edited by Jérémie 2006-10-30 06:00)

Re: NEW POSTS NOT SHOWN! This problem does us. We are just upset. HELP!!!

I had the same problem for some time (althought not often). And I don't have all those mods.

I'll check the changeset, and I will be baaaack

Edit : Ok, it seems it was the same for me, that changeset diff was never applied for a unknown reason. I'll wait to see if anyone report another temporary missing posts, but it seems ok now.

Re: NEW POSTS NOT SHOWN! This problem does us. We are just upset. HELP!!!

if you don't follow the installation guide for the attachment mod, and that you only search for part of the query (or go by linenumbers), you'll get that error... as you copy over the changeset (as you see a little note that the attachment mod has altered that line) wink