ERROR - parameter's type doesn't match cached paramters

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
9/13/2007 10:46:29 PM
Gravatar
Total Posts 2

ERROR - parameter's type doesn't match cached paramters

I am getting following error while I am doing the clean installation (mojoportal-2-2-3-8-1). Please check the below linked screen shot to get more info on this.

http://www.yeschandana.com/image/Error_Setup.jpg

Here I am trying to do the instillation through VS2005 IDE. Please be good enough to  response me as soon as. Thx...

9/14/2007 7:32:00 AM
Gravatar
Total Posts 18439

Re: ERROR - parameter's type doesn't match cached paramters

Hi,

This appears to be another bug introduced by some refactoring in the ms sql data layer. It is missing the size for the parameter in dbPortal.cs at line 182

It should be like this:

sph.DefineSqlParameter("@ScriptFile", SqlDbType.NVarChar, 255, ParameterDirection.Input, scriptFile);

where currently its like this:

sph.DefineSqlParameter("@ScriptFile", SqlDbType.NVarChar, ParameterDirection.Input, scriptFile);

I will fix this now and upload new files, but you can fix it locally making the same change to add the param size of 255

Thanks,

Joe

9/14/2007 8:50:01 AM
Gravatar
Total Posts 2

Re: ERROR - parameter's type doesn't match cached paramters

Hi Joe, 
It worked well for one place as you mentioned. but same type of errors are coming (2 Times). I will check and let you know soon. Thx.. 

 

9/14/2007 9:30:54 AM
Gravatar
Total Posts 18439

Re: ERROR - parameter's type doesn't match cached paramters

Thanks, I have tracked down those additional errors. They only happen in debug mode because of debug asserts. In a few places param types were declared incorrectly as Text instead of NText. I have fixed these and will upload new files again shortly. These issues do not happen using the relase files because they are not in debug mode and no actual error occurs since the correct param type is assigned by getting the params directly from the database. The declared type would only be used if caching of sql params were disabled in which case the declared types would be used. However they should be fixed to have correct param tye declarations so I am fxing these now and will upload soon.

Thanks,

Joe

You must sign in to post in the forums. This thread is closed to new posts.