error when i add new post or reply to post

I have the exact same problem having made a fresh install today.
All going well until this point.
The posts and replies do stick though it's just I get the warning.

Upgraded from 4.7.2 to 4.7.4 (forgot earlier) and the problem remains.

# user warning: Unknown column 'TotalPostCount' in 'field list' query: UPDATE F_Forums SET TotalPostCount='1' WHERE ForumID=2 in.............bla bla bla

There is an extra field added by the .install file - but it isn't added by default by drupal (why it doesn't cycle through the damned updates I don't know)
When you go to your modules page there's a link to "update.php" - I've been told that this will solve that for you, but I haven't tried it myself.

If you give it a go, let me know how it runs for you!

Seriously - this whole .install thing is driving me insane. If there are updates to be run, it should bloody run the things *angry*

Try these queries - it should fix it for you!

ALTER TABLE F_Forums ADD COLUMN TotalThreadCount int(12) DEFAULT '0';
ALTER TABLE F_Forums ADD COLUMN TotalPostCount int(12) DEFAULT '0';

Daniel

Great work Guys - forum is great :)

I am using 4.7 and I have tried running the update.php script but I am still getting this error when I try to post something:

user warning: Unknown column 'TotalPostCount' in 'field list' query: UPDATE F_Forums SET TotalPostCount='1' WHERE ForumID=2 in /home/liskidde/public_html/etsyglass/main/includes/database.mysql.inc on line 121.
user warning: Unknown column 'TotalPostCount' in 'field list' query: UPDATE F_Forums SET TotalPostCount='1' WHERE ForumID=1 in /home/liskidde/public_html/etsyglass/main/includes/database.mysql.inc on line 121.
user warning: Unknown column 'TotalThreadCount' in 'field list' query: UPDATE F_Forums SET TotalThreadCount='1' WHERE ForumID=2 in /home/liskidde/public_html/etsyglass/main/includes/database.mysql.inc on line 121.
user warning: Unknown column 'TotalThreadCount' in 'field list' query: UPDATE F_Forums SET TotalThreadCount='1' WHERE ForumID=1 in /home/liskidde/public_html/etsyglass/main/includes/database.mysql.inc on line 121.

Also the images are broken (e.g. report post, etc)

I swear to god, the new drupal install stuff will drive me insane. If there's an update to run, it should bloody well run it when installing :/
I'll have a look for you, but I'm off on holidays for 2 and a half weeks tomorrow, so it's unlikely I'll get anything done until I get back!

Daniel

I had the same problem. But I ran the ALTER TABLE queries above, and everything worked fine afterwards.
I had made some test posts, which I deleted, though, and then I got negative total thread and total post counts.
I fixed this simply by resetting the counters in the admin area.

I had the same problem. But I ran the ALTER TABLE queries above, and everything worked fine afterwards.
I had made some test posts, which I deleted, though, and then I got negative total thread and total post counts.
I fixed this simply by resetting the counters in the admin area.