TBDev Forum
Programming board
Main Page Forum Rules Privacy Policy Members Contact Us
Welcome Guest (Login | Register)
TBDev Forum TBDev.net - Help General Support Forum not updating

Forum not updating

2006-07-30 12:21:00
Group: Member
Posts: 64
Topics participated: 35
Topics started: 5
First post: 2006-06-04 20:29:00
Last post: 2008-12-04 10:52:00
Hello.

I have a small problem, my forum always shows 0 in topic and posts at the mainpage of the forum even if it is posts and topics inside.



But when i press ex. Cheaters and check the post count there, it is correct.
What can the problem be?

My forum.php

Well, seems like i can't use the codebox tag :(


And don't get me wrong now, i am NOT expecting that anyone will fix it for me, but if someone could tell me whats's wrong and tell me what to do about it it would be greate. I really want to learn...
 
2006-07-30 02:07:00
Group: Member
Posts: 461
Topics participated: 232
Topics started: 10
First post: 2006-03-21 13:50:00
Last post: 2008-12-23 18:24:00
The post count on the main page is cached into the 'posts' table, and updated everytime the cleanup runs. If the post count isn't being updated, then this means that cleanup isn't being run, or that cleanup cannot run.

Check you bittorrent.php file, and make sure that the docleanup() function isn't commented out.
 
2006-07-30 11:13:00
Group: Member
Posts: 64
Topics participated: 35
Topics started: 5
First post: 2006-06-04 20:29:00
Last post: 2008-12-04 10:52:00
Aha ok. Well here's how it starts in bittorrent.php

docleanup();
}

function unesc($x) {
 
2006-07-30 11:48:00
Group: Member
Posts: 461
Topics participated: 232
Topics started: 10
First post: 2006-03-21 13:50:00
Last post: 2008-12-23 18:24:00
In bittorrent.php, the variable...

$autoclean_interval = 900;


should be declared.

In the 'avps' table, there should be a row that has 'arg' set as 'lastcleantime' and 'value_u' which should contain a value. If needs be, reset this value to 0, to force a cleanup.

There is also a script that can be run, called docleanup.php, that can force a cleanup to be done immediately.

What you need to discover is whether to code to call cleanup(), or the cleanup.php scritp itself, is not working.
 
2006-07-30 16:25:00
Group: Member
Posts: 64
Topics participated: 35
Topics started: 5
First post: 2006-06-04 20:29:00
Last post: 2008-12-04 10:52:00
My arg in the table avps looks like ... where should the lastcleantime go?
 
2006-07-30 18:56:00
Group: Member
Posts: 461
Topics participated: 232
Topics started: 10
First post: 2006-03-21 13:50:00
Last post: 2008-12-23 18:24:00
'arg' is the fieldname, and is correctly defined. What you probably need to do is to pull the 'arg' and 'value_u' fields, so you get a listing similar to...

=================
|
 
2006-09-27 08:16:00
Group: Member
Posts: 33
Topics participated: 17
Topics started: 4
First post: 2006-09-20 05:43:00
Last post: 2006-11-01 23:41:00
Check yer error logs

i have this error when i try to run doccleanup.php...

SQL Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 604800' at line 1

in /var/www/virtual/sc3ne.byethost33.com/htdocs/include/cleanup.php, line 123

how do you guys no what lines 123? help!

 

Similar threads

Topic Posts Last post
Stats not updating 2 2008-01-23 19:05:00
Stats not updating 1 2007-09-17 18:28:00
Updating tracker 1 2007-10-07 15:44:00
Shoutboux updating wrong.. 2 2007-03-07 05:57:00
I get /// between words when updating the New section 1 2008-06-09 01:29:00