Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

The best choice for your web site host, email hosting, and domain registration.
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
r2i.ntegrated
 


  Sponsors  

Meet Our Sponsors

The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Help Module [Le...  Script error while installing 2.0.3 in upgraded DNN 3.3
Previous Previous
 
Next Next
New Post 6/14/2006 11:58 AM
User is offline Hooligannes
1465 posts
www.nesinteractivos.com
6th Ranked






Script error while installing 2.0.3 in upgraded DNN 3.3 

I got this script error while installing the module in an upgraded DNN 3.3:

StartJob

Start Sql execution: 02.00.02.SqlDataProvider file

Failure

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 31: Incorrect syntax near '@Search'. 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


Do you know the truth when you hear it?
The Dúnadan Raptor
Check My Blog for DNN advice and more
 
New Post 6/15/2006 9:27 PM
User is offline Philip Beadle
1138 posts
www.philipbeadle.net
6th Ranked








Re: Script error while installing 2.0.3 in upgraded DNN 3.3 

I see yhe problem, the + symbols hae been removed.  I wil resave it as a UTF-8 file that should fix the problem.

A new drop will b ready early next week.


Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template
 
New Post 8/3/2006 10:21 AM
User is offline Jason Honingford
416 posts
www.portvista.com
8th Ranked


Re: Script error while installing 2.0.3 in upgraded DNN 3.3 
I get this error too. DNN 4.3.3. Will this affect anything? I think it's been over a week and this module comes with the release version. Supposed to be stable.
Jason Honingford - Web & Software Developer
www.PortVista.com
 
New Post 8/3/2006 9:11 PM
User is offline Philip Beadle
1138 posts
www.philipbeadle.net
6th Ranked








Re: Script error while installing 2.0.3 in upgraded DNN 3.3 
There is a new release of DNN now 4.3.4 and the new Help 2.0.5 is included which fixes this problem.
Philip Beadle (DNN Core Team)
My Blog
My DNN Blog
TDD DNN Module Template
 
New Post 8/4/2006 3:05 AM
User is offline Jason Honingford
416 posts
www.portvista.com
8th Ranked


Re: Script error while installing 2.0.3 in upgraded DNN 3.3 
Modified By Jason Honingford  on 8/4/2006 6:07:11 AM)
FYI 2.0.5 is not included. 2.0.4 is, but it gives the same error. I honetsly don't know what the help module is used for, just getting that error when I install it.
Jason Honingford - Web & Software Developer
www.PortVista.com
 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Help Module [Le...  Script error while installing 2.0.3 in upgraded DNN 3.3
 


Forum Policy

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.

 


Advanced Web Portals by Infoscaler
Infoscaler is a California based company that provides advanced Web Portals, E-commerce Sites, Database Applications and Intranet Solutions on the DotNetNuke and Microsoft.NET platforms.
www.infoscaler.com
DotNetNuke® in Sweden
All service of DotNetNuke® in Sweden.
Olsmar Konsult
Overlook Technology
Website Development, DotNetNuke Consulting, Module Development, Portal Management
OverlookTechnology.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP