| |
|
|
|
|
|
|
|
|
|
 |  | |
| | |
| | |
| | |
 | | |
|
|
|
| Re: Help module will not install |
|
|
philip.beadle wrote
You can paste the Uninstall script in the Uninstall.SQLDataProvider file into the Host/SQL window and mark it as Execute as Script. |
Excuse me, but since it does not work for me (fresh DNN 4.3.7 installation), I wonder if I do things correctly...
I have copied and pasted the script (exactly as it is in the Uninstall.SQLDataProvider file) into the Host/SQL window. I have marked it as "Execute as script". It executes and informs me that it has completed correctly. When I try to install the Help module again (in 4.3.7), I still have an error message similar to the one mentionned in this post...
I do something wrong ???
In the uninstall script (Uninstall.SQLDataProvider file), it is written at the top:
/***** Note: To manually execute this script you must *****/
/***** perform a search and replace operation *****/
/***** for {databaseOwner} and {objectQualifier} *****/
Do I have to change something manually ?? If yes, what ??? Sorry, I am a complete newbie...
Déclic Vidéo FX |
|
|
|
| |
|
|
| Re: Help module will not install |
|
|
yairt wrote
Hello
I Want to offer another solution to this problem for developers that have access to their site's DB, (a solution that I found thanks to a college of mine).
I work on dnn 4.0.2 using mssql 2005 express edition and I encountered exactly the same problem while installing the help module on my web site.
I opened the DB editor and created the problematic store procedure above (dbo.Help_SearchTutorials ), however in the WHERE clause of the SP I wrote:
WHERE (dbo.Help_Tutorials.Title LIKE N'%' + @Search + '%') OR (dbo.Help_Tutorials.KeyWords LIKE N'%' + @Search + '%') OR (dbo.Help_Tutorials.ShortDesc LIKE N'%' + @Search + '%') OR (dbo.Help_Tutorials.Description LIKE N'%' + @Search + '%')
and then the SP was created successfully.
hope its helpfull.
|
Hello,
Could you be more precise, because if I follow the first method written here (i.e. deleting the tables), the install does not work for me.
So, I assume your solution will work for me. Could you please add few details, so I can do it myself (I am a newby, please try to be as specific as possible, I have few knowledge en SQL and accessing my tables). Do I need to:
1- Install the help module before creating the procedure ?
2- Then creating the procedure you describe (please indicate the sql to create it)
3- Re-installing it or not ?
Here is the error message I have:
StartJob Start Sql execution: 02.00.02.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near '@Search'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** SQLDataProvider *****/ /***** Help *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ /* Insert here the code to create tables and stored procs */ CREATE PROCEDURE dbo.[Help_SearchTutorials] @Search nvarchar(100) AS SELECT dbo.Help_Tutorials.TutorialGUID, dbo.Help_Tutorials.TutorialID, dbo.Help_Tutorials.Title, dbo.Help_Tutorials.ProductImage, dbo.Help_Tutorials.Featured, dbo.Help_Tutorials.KeyWords, dbo.Help_Tutorials.DownloadName, dbo.Help_Tutorials.ShortDesc, dbo.Help_Tutorials.Archive, dbo.Help_Tutorials.Description, 0 AS ViewOrder FROM dbo.Help_Tutorials WHERE (dbo.Help_Tutorials.Title LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.KeyWords LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.ShortDesc LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.Description LIKE N'%' @Search '%')
EndJob End Sql execution: 02.00.02.SqlDataProvider file
Many Thanks.
Déclic Vidéo |
|
|
|
| |
|
|
| Re: Help module will not install |
|
|
Since you ran the script from the Host window, I do not believe you need to do the search and replace. DNN does that for you, when ran from Host/SQL. I'm pretty sure those instructions refer to running the script directly against the database, outside of DNN, such as through SQL Query Analyzer. But I'm also a newbie, so I'm not 100% sure of this.
I sure wish someone knowledgeable about the Help module's inner workings would participate in this forum more often.
Do you have have direct access to your database? Do you have some way to determine whether the Help_ tables and stored procedures were actually removed by the uninstall script? |
|
|
|
| |
|
|
| Re: Help module will not install |
|
|
JonRobertson wrote
{...}
Do you have have direct access to your database? Do you have some way to determine whether the Help_ tables and stored procedures were actually removed by the uninstall script?
{...} |
Yes, I have direct access, I have ran it again, I have verified, and ALL tables AND procedures have been deleted.
But as soon as I try to install the help module again, I have the error message listed above...
That's why I asked yairt to be more precise concerning his method. I am sure it will help me, but I need additionnal help. If you look at the end of my error message, it looks like that method suggested by yairt:
==============================
{...}
CREATE PROCEDURE dbo.[Help_SearchTutorials] @Search nvarchar(100) AS SELECT dbo.Help_Tutorials.TutorialGUID, dbo.Help_Tutorials.TutorialID, dbo.Help_Tutorials.Title, dbo.Help_Tutorials.ProductImage, dbo.Help_Tutorials.Featured, dbo.Help_Tutorials.KeyWords, dbo.Help_Tutorials.DownloadName, dbo.Help_Tutorials.ShortDesc, dbo.Help_Tutorials.Archive, dbo.Help_Tutorials.Description, 0 AS ViewOrder FROM dbo.Help_Tutorials WHERE (dbo.Help_Tutorials.Title LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.KeyWords LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.ShortDesc LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.Description LIKE N'%' @Search '%')
{...}
==============================
If anyone has an idea how to do this ?? (especially which instruction to put to create this procedure...)
Déclic Vidéo FX |
|
|
|
| |
|
|
| Re: Help module will not install |
|
|
The problem is
dbo.Help_Tutorials.Title LIKE N'%' @Search '%')
you need to make sure that the sql says dbo.Help_Tutorials.Title LIKE N'%' + @Search + '%'). For some reason when you are pasting the sql in (probably because the file isnt saved as UTF-8) the + are removed.
Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template
 |
|
|
|
| |
| | |
| | |
| | |
|  |
| |
|
|
|
These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.
For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
|
| |
|
|
|
|
|
|
|
|