BUG: Show New Count in Forum List is "Yes"

Hello,

I've been dabbling with the 5.2.1 Alpha release, and would like to report the following error: When I enable "Show New Count in Forum List=Yes" in the General Settings, and then return to the forum index, I get the error message below. If I go back to the admin panel and change this option to "No", then the message board loads correctly.

- Bob


Phorum Database Error
Sorry, a Phorum database error occurred.
Please try again later!

Error:
Column 'forum_id' in field list is ambiguous (1052): select forum_id, count(*) as count from jwtalk_user_newflags inner join jwtalk_messages using (message_id, forum_id) where jwtalk_user_newflags.user_id=1 and parent_id=0 and forum_id in (2,1,2,1) group by forum_id

Backtrace:
Function phorum_database_error called at
{path to Phorum}/include/db/mysql/mysql.php:158
----
Function phorum_db_interact called at
{path to Phorum}/include/db/mysql.php:4663
----
Function phorum_db_newflag_count called at
{path to Phorum}/include/index_new.php:84
----
Function include_once called at
{path to Phorum}/index.php:74

that means that you are using mysql < 5, you should consider an upgrade.

---

Thomas Seifert

Thank you Thomas for your quick response.

I'm currently at hostgator.com and suspect I wouldn't have much control over upgrading.

I've switched it to "No Count, Just Indicator" and it's working fine, although I haven't seen the indicator yet (but Im just making test posts under my own admin name; I'll create a fake user with another browser and play some more later).

Now to play with some MODS :-)

- Bob

you can also try a recent snapshot from
[dev.phorum.org]
the phorum5-dev-svn... one.

---

Thomas Seifert