| Author |
 Topic  |
|
|
Webbo
Average Member
United Kingdom
982 Posts |
 Posted - 20 September 2002 : 20:22:00
|
Hi everyone,
Firstly can I say 3.4.03 is an excellent piece of kit 
I'm not sure if this next bit is down to me but in a Moderated forum, when a new post has been made, the folder icon in default.asp is not showing as awaiting approval ie  and to see if there are any posts within that forum I have to actually view the forum.
My previous version 3.3.03 showed the folder icon when there was a post awaiting approval.
Any ideas ?
Regard, Dave |
Edited by - Webbo on 20 September 2002 20:26:15 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 20 September 2002 : 20:28:36
|
Moderation has changed in v3.4 from how it was in v3.3.03. There were simply too many database calls the way it was implemented in v3.3.03.
in v3.4 on default.asp, if there are any unmoderated posts, this icon:  will show up in the top right hand corner of the table (along with the other Admin icons). Clicking on it will take you to a new page where you'll get a list of unmoderated posts. |
 |
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 20 September 2002 : 20:34:26
|
Thanks Richard for the prompt reply.
It's not an issue as I subscriptions on and receive notification, just thought I'd check.
Keep up the good work,
Regards, Dave |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 20 September 2002 : 20:35:13
|
| you're welcome |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 20 September 2002 : 20:41:33
|
 Whoops, I found the icon but when I clicked it I have received this error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC]Column: 'TOPIC_ID' in field list is ambiguous
/forum/moderate.asp, line 145
Line 145-148 reads:
set rsCount = my_Conn.Execute(strSql1 & strSql2 & strSql3)
iPageTotal = rsCount(0).value
rsCount.close
set rsCount = nothing
The database is a MySql
Dave
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 20 September 2002 : 21:00:43
|
in moderate.asp on line #143
change this:
strSql1 = "SELECT COUNT(TOPIC_ID) AS PAGECOUNT "
to this:
strSql1 = "SELECT COUNT(DISTINCT T.TOPIC_ID) AS PAGECOUNT " |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 20 September 2002 : 21:05:26
|
That's done the trick,
Thanks once again Richard, that has fixed it.
I'm going to call it a night now as it is 1.54am at this side of thebig pond,
So Goodnight, Dave |
|
|
| |
Topic |
|
Topic Locked
