Hello. Glad to see there is now a forum for this. I have one small problem though but otherwise everything runs great. My problem is this: In the posts display of "blog stats" it only reads zero when I obviously have multiple posts. Here is my configuration:
Windows 2003, IIS 6 SQL Standard 2000. Not sure if I may have missed a setting. I know the archive count works as I can see it but I am confused on how to fix the post count. Here is my web log: http://netsda.antoniuk.net/logs/
Here is the plain text version of the missing trigger - you need to run this on the SQL server you're using: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE TRIGGER blog_Content_Trigger On blog_Content AFTER INSERT, UPDATE, Delete as Declare @BlogID
int --Get the current blogid Select @BlogID = BlogID From INSERTED --much more likely to be an insert than delete --need to run on updates as well, incase an item is marked as inactive if(@BlogID is null) Begin Select @BlogID = BlogID From DELETED End Update
blog_Config Set PostCount = (Select Count(*) From blog_Content Where blog_Content.BlogID = blog_Config.BlogID and PostType = 1 and Active = 1), CommentCount = (Select Count(*) From blog_Content Where blog_Content.BlogID = blog_Config.BlogID and PostType =
3 and Active = 1), StoryCount = (Select Count(*) From blog_Content Where blog_Content.BlogID = blog_Config.BlogID and PostType = 2 and Active = 1), PingTrackCount = (Select Count(*) From blog_Content Where blog_Content.BlogID = blog_Config.BlogID and PostType
= 4 and Active = 1) Where BlogID = @BlogID GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO - Nick Ryberg
Grazie! I knew it had to be something small. For now I am removing the whole stats section from my skin as it slow things down (I self host with SQL and the web server on the same box). Once removed my page loads much faster.
I executed the qeury but no results. I use the latest version of dottext 0.95. All the posts are about 0.94, is this the reason why it doesn't work?? Or do I have another problem?? Must this query be done while setup or does it not matter?? When it's not this
what do you think it's then?? Thank for your answers, Roel
transitbus
Member
95 Points
19 Posts
Post count
Nov 15, 2003 06:50 AM|LINK
Colt
All-Star
15569 Points
1986 Posts
ASPInsiders
MVP
Re: Post count
Nov 15, 2003 08:54 AM|LINK
Sunmast
Member
40 Points
8 Posts
Re: Post count
Nov 15, 2003 08:55 AM|LINK
NickRyberg
Member
60 Points
12 Posts
Re: Post count
Nov 15, 2003 02:45 PM|LINK
transitbus
Member
95 Points
19 Posts
Re: Post count
Nov 15, 2003 10:05 PM|LINK
RoelAlblas
Member
439 Points
218 Posts
Re: Post count
May 26, 2004 03:00 PM|LINK
www.gps2sms.nl
RoelAlblas
Member
439 Points
218 Posts
Re: Post count
May 27, 2004 06:13 PM|LINK
www.gps2sms.nl