15 years on The Web
miniBB ® miniBB®
miniBB Support Forums
 | Forums | Register | Search | Statistics | Manual |
Re-cycled miniBB Support Forums / Re-cycled /   

External post insertion post count and latest post problem

Author realitybytes
#1 | Posted: 20 Jun 2006 17:59 | Edited by: realitybytes 
I have created several forum topics that have an external feed,

that is posts are inserted to them from outside of the forum which works well.

However I am running in to problems with post count and lastest posts. Here is what I have tried is there something I am missing.

I insert or update the following

All fields in posts table filled post id auto increment, forum id, topic id, poster id, poster name, post text, post ip, and status set to 3. (This works without a problem)

update topics table, topic last post id, posts count, topic last post time,
update table forums, posts count

However when i view the forum none of the counts are displayed and also latest discussion is not displaying the topic as having any new post.

Am I missing something to have the external post counted and updated in latest discussion, and the forum post counts?

Author Paul
Lead Developer
#2 | Posted: 20 Jun 2006 21:47 
I didn't understand your problem completely, however I think you need to update fields like "topics_count", "posts_count" in "forums" table, and similar fields in "topics" table, using count(*) function or something like that. It's not happening automatically... mySQL has no triggers ;-)

Author realitybytes
#3 | Posted: 22 Jun 2006 09:46 
Yeah solved my bad, I had left an unwanted , in the code so wasnt updating the fields.

Author Paul
Lead Developer
#4 | Posted: 22 Jun 2006 11:59 
Ok then. Be sure you have no SQL errors, debugging your requests ;-)

Re-cycled miniBB Support Forums / Re-cycled / External post insertion post count and latest post problem Top
This topic is closed. New replies are not allowed.
miniBB Support Forums Powered by Forum Software miniBB ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Try the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB