Mitchel's Forums

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:5607

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
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.

View Mitchel Sellers's profile on LinkedIn

3Essentials is my recommended Shared Hosting Provider

This site is hosted on a VPS from HostMySIte.com

Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!

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 
{objectQualifier}ICG_ETH_ExpandableTextHtml
WHERE 
  ModuleId = ' + CAST(@ModuleId AS VARCHAR) + ' '

when replaced {objectQualifier}.

Must be for example :

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

 

 

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

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
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.

View Mitchel Sellers's profile on LinkedIn

3Essentials is my recommended Shared Hosting Provider

This site is hosted on a VPS from HostMySIte.com

Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!

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