|
|
 Posted 12/06/2007 11:16:00 |
|
|
Forum Newbie
Group: Forum Members
Last Login: 05/08/2007 06:17:48
Posts: 2,
Visits: 13
|
|
When I try to create the DB for the script, I get this
Msg 209, Level 16, State 1, Procedure ikb_sp_GetArticles, Line 11
Ambiguous column name 'LastModified'.
not much information regarding this error here on the forum, but there is a KB article addressing this behaviour with the explanation from Mr. Carlos Muniz...
In this case you should alter the 2nd instance of LastModified to read "LastModified as LastModified2" in the ikb_sp_GetArticles stored procedure
Regards,
Carlos Muniz
so my question is. WHAT IN THE NAME OF GOD IS THIS SUPPOSED TO MEAN???? I guess Mr. Carlos forgets that he's actucally supposed to speak English, so non SQL experts can solve the issue ASAP and not waste their valuable time looking for help elswhere. Can someone please be so kind and translate this into plain English? Thank you!
|
|
|
|
| Posted 12/06/2007 13:12:21 |
|
|
Support Supremo
Group: Customers
Last Login: 13/11/2008 12:44:07
Posts: 568,
Visits: 2,507
|
|
Valter (6/12/2007)
When I try to create the DB for the script, I get this
Msg 209, Level 16, State 1, Procedure ikb_sp_GetArticles, Line 11
Ambiguous column name 'LastModified'.
not much information regarding this error here on the forum, but there is a KB article addressing this behaviour with the explanation from Mr. Carlos Muniz...
In this case you should alter the 2nd instance of LastModified to read "LastModified as LastModified2" in the ikb_sp_GetArticles stored procedure
Regards,
Carlos Muniz
so my question is. WHAT IN THE NAME OF GOD IS THIS SUPPOSED TO MEAN???? I guess Mr. Carlos forgets that he's actucally supposed to speak English, so non SQL experts can solve the issue ASAP and not waste their valuable time looking for help elswhere. Can someone please be so kind and translate this into plain English? Thank you!Dear Valter, Sorry if that wasn't clear. If you look in the body of the ... stored procedure, you would see that the same column name is being selected twice. The solution I gave above involved renaming the second instance of that column name. I am emailing you a modified installation script that you can use to resolve this issue.
|
|
|
|
| Posted 12/06/2007 13:14:21 |
|
|
Forum Newbie
Group: Forum Members
Last Login: 05/08/2007 06:17:48
Posts: 2,
Visits: 13
|
|
Thank you big time 
|
|
|
|
| Posted 27/07/2007 16:40:39 |
|
|
Forum Newbie
Group: Forum Members
Last Login: 28/07/2007 20:02:57
Posts: 5,
Visits: 3
|
|
| uhhhh, having same problem. Why keep resolution a secret, now I have to wait 12 hours for response to fix the error. Think maybe the resolution could be posted???
|
|
|
|
| Posted 27/07/2007 16:44:18 |
|
|
Forum Newbie
Group: Forum Members
Last Login: 28/07/2007 20:02:57
Posts: 5,
Visits: 3
|
|
| This worked, but it should have been posted. I installed today, error should have been corrected. Will this effect any tables or other sp's? CREATE Procedure ikb_sp_GetArticles ( @NodeID nvarchar(255) ) AS IF (@NodeID = 'Suggested') -- if nodeID is suggested return all articles for answer questions feature within the administration pages BEGIN SELECT QuestionText, LastModified, QuestionID, DateStamp, ArticleType FROM InstantKB_Articles WHERE SuggestedFlag =1 ORDER BY LastModified DESC, DateStamp DESC, QuestionText ASC END ELSE -- else this stored proc is being used to grab only the knowledge base articles with a publishtoweb status for the main default.aspx page BEGIN SELECT DISTINCT QuestionText, LastModified, InstantKB_Articles.QuestionID, ArticleType, LastModified as LastModified2, DateStamp FROM InstantKB_Articles LEFT JOIN InstantKB_ArticlesTreeNodes ON InstantKB_Articles.QuestionID = InstantKB_ArticlesTreeNodes.QuestionID WHERE InstantKB_ArticlesTreeNodes.NodeID = @NodeID AND PublishToWeb = 1 ORDER BY LastModified DESC, DateStamp DESC, QuestionText ASC END
|
|
|
|
| Posted 28/07/2007 16:16:14 |
|
|
Forum Newbie
Group: Forum Members
Last Login: 28/07/2007 20:02:57
Posts: 5,
Visits: 3
|
|
| After running script. Everything worked except you cannot manage any articles in Admin. I asked before and after I posted, would the script effect any other part of program. Evidently is does. Does anyone from InstantASP monitor this? I would really like to role my KB out.
|
|
|
|
| Posted 30/07/2007 06:17:00 |
|
|
Support Supremo
Group: Customers
Last Login: 13/11/2008 12:44:07
Posts: 568,
Visits: 2,507
|
|
cfh (7/28/2007)
After running script. Everything worked except you cannot manage any articles in Admin. I asked before and after I posted, would the script effect any other part of program. Evidently is does. Does anyone from InstantASP monitor this? I would really like to role my KB out. Please see this article link: http://kb.instantasp.co.uk/article.aspx?id=11412
|
|
|
|
| Posted 31/07/2007 09:51:04 |
|
|
Supreme Being
Group: Administrators
Last Login: 17/11/2008 13:47:50
Posts: 266,
Visits: 598
|
|
cfh (7/28/2007)
Does anyone from InstantASP monitor this?Yes we do, my colleague Carlos has already answered the thread though, but we're constantly watching the forums, and our email, to try and provide as much feedback and information to customers as possible (Whilst still developing the product line of course) sometimes odd threads are missed, but we do attempt to answer every thread within 48hrs, although inevitably the odd one slips through. In such a case, opening a support ticket or emailing support@instantasp.co.uk if you are an existing customer, will prompt us to visit your post if we've not seen it. We've recently reviewed our support provision to ensure that EVERY ticket or email from an existing customer gets a timely response.
Kindest Regards,
James Trott
Developer
|
|
|
|