InstantASP Community Forums / Old Forums / InstantKB.NET 1.x / SQL Error when creating the database / Latest Posts

RE: SQL Error when creating the database

James Trott — Tue, 31 Jul 2007 09:51:04 GMT

[quote][b]cfh (7/28/2007)[/b][hr]Does anyone from InstantASP monitor this?[/quote]

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.

RE: SQL Error when creating the database

Carlos Muniz — Mon, 30 Jul 2007 06:17:00 GMT

[quote][b]cfh (7/28/2007)[/b][hr]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.[/quote]

Please see this article link:

http://kb.instantasp.co.uk/article.aspx?id=11412

RE: SQL Error when creating the database

cfh — Sat, 28 Jul 2007 16:16:14 GMT

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.

RE: SQL Error when creating the database

cfh — Fri, 27 Jul 2007 16:44:18 GMT

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

RE: SQL Error when creating the database

cfh — Fri, 27 Jul 2007 16:40:39 GMT

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???

RE: SQL Error when creating the database

Valter — Tue, 12 Jun 2007 13:14:21 GMT

Thank you big time :)

RE: SQL Error when creating the database

Carlos Muniz — Tue, 12 Jun 2007 13:12:21 GMT

[quote][b]Valter (6/12/2007)[/b][hr]When I try to create the DB for the script, I get this

[b]Msg 209, Level 16, State 1, Procedure ikb_sp_GetArticles, Line 11
Ambiguous column name 'LastModified'.[/b]

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...

[i][b]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[/b][/i]

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![/quote]

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.

SQL Error when creating the database

Valter — Tue, 12 Jun 2007 11:16:00 GMT

When I try to create the DB for the script, I get this

[b]Msg 209, Level 16, State 1, Procedure ikb_sp_GetArticles, Line 11
Ambiguous column name 'LastModified'.[/b]

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...

[i][b]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[/b][/i]

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!