Subject: Script error when upgrading to 1.2.0
Prev Next
You are not authorized to post a reply.

AuthorMessages
Mitchel SellersUser is Offline
Site Admin/Owner
Guru
Guru
Posts:6089

12/11/2007 1:36 PM  

If you received a script error regarding a syntax error near 'Cast(", you will need to manually execute a SQL Script to fix the stored procedures used by this module.  For one reason or another certain DNN installations do not handle the usage of a ' character in a SQL Script for module installation.

To complete the manual fix please follow the below instructions.  If you need assistance please let me know.

  1. Download the 01.02.00 Manual Fix file from the DNN Expandable Text/HTML page
  2. Copy the text from this file
  3. Login to your DNN site as Host
  4. From the Host menu select "SQL"
  5. Paste the query into the textbox
  6. Check the box for "Run as script"
  7. Execute the query

You should now see a success message regarding the execution of the query and you will be able to use all new functionality.  i appreciate your patience while I work towards the identification of a root cause.


-Mitchel Sellers
Microsoft C# MVP, MCITP
Director of Development
IowaComputerGurus Inc.

View Mitchel Sellers's profile on LinkedIn

For shared hosting I recommend PowerDNN

This site is hosted on a Dedicated Server from PowerDNN.com

To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs
Alexey SidorovUser is Offline
New Poster
New Poster
Posts:1

01/20/2008 10:54 AM  

Same problem in 1.3.0. 
Little bug in statement
SET @SQL = 'SELECT ModuleId, ItemId,  title, body,   lastUpdated, IsExpanded
FROM 
ICG_ETH_ExpandableTextHtml
WHERE 
  ModuleId = ' + CAST(@ModuleId AS VARCHAR) + ' '

when replaced .

Must be for example :

SET @SQL = 'SELECT ModuleId, ItemId,  title, body,   lastUpdated, IsExpanded
FROM ' + +'ICG_ETH_ExpandableTextHtml
WHERE 
  ModuleId = ' + CAST(@ModuleId AS VARCHAR) + ' '

 

 

Mitchel SellersUser is Offline
Site Admin/Owner
Guru
Guru
Posts:6089

01/20/2008 11:56 PM  
Alexey,

Thank you VERY MUCH!! I had been trying to figure out what was causing the issue and couldn't pinpoint it.

It didn't have issues on all machines, but this does appear to fix it.

I'll update the install packages soon and get a new version up!

-Mitchel Sellers
Microsoft C# MVP, MCITP
Director of Development
IowaComputerGurus Inc.

View Mitchel Sellers's profile on LinkedIn

For shared hosting I recommend PowerDNN

This site is hosted on a Dedicated Server from PowerDNN.com

To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs
You are not authorized to post a reply.
Forums >IowaComputerGurus Inc. Software >DNN Expandable Text/HTML > Script error when upgrading to 1.2.0



ActiveForums 3.7