More Fun with DNNArticle - Providers - ZLDNN's DNNArticle

Module Support Forums

Forum metaPost Forums Providers - ZLD... More Fun with DNNArticle

3/10/2009 10:01 AM

Don Worthley
332 posts

Re: More Fun with DNNArticle

Hmmm. So, the versions of metaPost and DNNArticle are the same on the two systems, but it works fine on the one and on the other the categories are ignored? Which version of metaPost and DNNArticle are installed? Also, let me know if you need me to log in and take a look. I'm happy to help troubleshoot. The best case is for me to be able to duplicate the issue on my end, but sometimes logging in and testing can at least help eliminate issues related the client (WLW).

Thanks,

Don

3/10/2009 10:04 AM

CFWebmasters
14 posts

Re: More Fun with DNNArticle

yup, same exact versions, the only difference between the two hosts is the number of other modules installed. the test one only has the DNN base modules + DNNArticle and Metapost. The other host that has the problems has a whole slew of modules installed. I'm sending you login info via email so you can login and poke around.

3/10/2009 10:11 AM

Don Worthley
332 posts

Re: More Fun with DNNArticle

I just received your email and will post the reply here for others to see, since this is something I regularly use to troubleshoot issues. If you have't already downloaded Fiddler, you can download it here. Fiddler is an HTTP proxy that Microsoft bought a few years back. It's an indespensible tool for checking to see what's happening as traffic is sent back and forth between a browser and the server (in our case between WLW and the server).

Here’s a screenshot of Fiddler showing how I use the Raw view on the right to view the request and response for a particular request shown on the left:

3/10/2009 10:35 AM

CFWebmasters
14 posts

Re: More Fun with DNNArticle

Doh! Why didn't I think of that... yeah I'm a devout user of Fiddler with AJAX troubleshooting... I just lost my mind.

This is what I am seeing.

1. NewPost to metapost with the info (including the categories selected)
2. a second post with just the GetPost method that returns everything and shows the categories as empty.

So right now it looks like the problem in internal to the metapost code. The table ZLDNN_DNNArticle has the post in it but there is no corresponding DNNArticleCategory entry.

The next step would be to run a sql trace on the sql server to see what's being passed to the stored procs and thier results... can you give me a hint on which ones should be called when adding a new post? One of the other portals on this host is a bit busy and I'll have to comb thorugh a very large sql trace to find it.

3/10/2009 12:23 PM

CFWebmasters
14 posts

Re: More Fun with DNNArticle

OK, it looks like the stored procedure to assign categories is never called. From a sql trace this is what is happening.

1. It calls ZLDNN_Addarticle to insert the article.
2. It then immediatly calls "ZLDNN_GetArticleAssignedCategories" with the CatID and Article ID - this is a select only query and returns 0 results since the article does not exist in the categories yet. It appears to loop through every category.
3. The last step is ti run itcMetaPost_Set_Entry_Redirect_URL where it gets the info to redirect the user.

The metapost version is 1.03.04
DNNArticle Version is 6.01.03

Page 2 of 3

Forum

metaPost Forums

Providers - ZLD...

More Fun with DNNArticle