parameter's type doesn't match cached parameters Help

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
4/30/2009 1:54:25 AM
shuiwuhen21
Gravatar
Total Posts 28
View Posts

parameter's type doesn't match cached parameters Help

hi joe

I meet a strange probelm.

recently  I downloaded the new version 2.3.0.1 ,and any some change . [ add a new column in my_users table]

on my develope computer ,all thing is right .no problem.no error.

then  I copy the  website and the database file to web server  machine.

deployment it.

when i register a new user ,   the error occur:

parameter's type doesn't match cached parameters

at SqlParameterHelper.DefineSqlParameter(string paramName,SqlDbType.type,
Int32 size,ParameterDirection dir,Object value,Boolean sizeProvided)
E:\mojoportal2301\mojoPortal.Data.MSSQL\SQLParameterHelper.cs(120)
at SqlParameterHelper.DefineSqlParameter(String paramName,SqlDbType type,
ParameterDirection dir,Object value)
E:\mojoportal2301\mojoPortal.Data.MSSQL\SqlParameterHelper.cs(91)
at DBSiteUser.UpdateUser(Int32 userID,string name,........)

the error message  picture :      http://web.rcjy.com.cn/01.jpg

I haven't change the UpdateUser method and relate procedure. (but I have changed the mp_users table:add a column).

to my surprise : the  E:\mojoportal2301  is the path in my develop computer. not the web server's.

joe, I need your help.  Thanks

when I turn CacheMSSQLParameters to false.   The error message also  occurs

 

develope computer: vista + sqlserver2000

web server computer: win2003+sqlserver2000

4/30/2009 2:12:03 AM
shuiwuhen21
Gravatar
Total Posts 28
View Posts

Re: parameter's type doesn't match cached parameters Help

 O ,I find the reason

when I turn CacheMSSQLParameters to true.  all the thing is right.

thanks

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