mojoPortal Version 2.3.7.7 - Error Adding New User/Updating Existing User

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

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.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
1/4/2012 12:43:03 PM
Gravatar
Total Posts 28
~Leslie

mojoPortal Version 2.3.7.7 - Error Adding New User/Updating Existing User

Hi Joe,

I'm getting errors on my development website when trying to register as a new user, add a new user as administrator, or update an existing user account as a user.  I get an Assertion Failed error window with the message 'parameters count doesn't match DB definition.' The error message references the mojoPortal.Data.MSSQL\SQLParameterHelper.cs file.

Could this page have been broken due to the recent password hashing changes?  If you need more details on the error, let me know.

Thanks!

Leslie

1/4/2012 1:01:32 PM
Gravatar
Total Posts 18439

Re: mojoPortal Version 2.3.7.7 - Error Adding New User/Updating Existing User

Hi Leslie,

Did you visit the /Setup/Default.aspx page?

I hope you got the code from the default branch not from my joedev branch.

That assertion error only happens in debug builds and it only happens if the stored procedure has a different number of parameters than expected by the code that executes it.

I know that the 2.3.7.7 upgrade script updated both the mp_Users_Insert and mp_Users_Update procedures but they do match the correct number of params an no errors happen for me. Parameters do get cached so its possible they were cached before you ran the update script and then it did not match. Touching Web.config should clear the cache and solve that.

But if you got the code from my branch before I merged the changes into the default branch then its possible you got an unfinished version of the 2.3.7.7 upgrade script that was missing the changes to those stored procs. Once it runs an upgrade script it will not run it again even if you later got the changes. But I know I did not change it after I pushed it to the default branch, I did commit it to my own branch before I was finished editing it though.

If all else fails you can copy the alter procedure statements from the 2.3.7.7 upgrade script and run it manually against your db.

located at /Setup/applications/mojoportal-core/SchemaUpgradeScripts/mssql/2.3.7.7.config

Hope that helps,

Joe

 

1/4/2012 11:09:43 PM
Gravatar
Total Posts 1

Re: mojoPortal Version 2.3.7.7 - Error Adding New User/Updating Existing User

Hi Joe,

I also experienced the same problem. I was able to resolve it by changing the value of the paramCnt parameter from 37 to 39 in the SQLParamterHelper constructor on line 425 of dbSiteUser.cs in the mojoPortal.Data.MSSQL project.

Love the software by the way. I purchased hosting from Arvixe and bought Artisteer, but missed your notes about linking thru to get you credit. Any suggestions for getting you credit after the fact?

Thanks again for a great product!

Chuck

1/5/2012 6:15:40 AM
Gravatar
Total Posts 18439

Re: mojoPortal Version 2.3.7.7 - Error Adding New User/Updating Existing User

Hi Chuck,

Thanks! I could have sworn I already set that to 39 but you were right. Not sure why it didn't throw any error for me. This is now fixed in the repository.

Unfortunately there isn't any way to get affiliate credit afterwards if it didn't go through the links.

If you want to support my work you could always purchase my add on products or make a donation. The primary way I make my living is through the sales of my add on products.

Best,

Joe

1/5/2012 6:43:41 AM
Gravatar
Total Posts 28
~Leslie

Re: mojoPortal Version 2.3.7.7 - Error Adding New User/Updating Existing User

Joe, late yesterday afternoon a coworker also found the paramCnt on dbSiteUser.cs to be 37 instead of 39.  Changing the value fixed the problem.  I had an appointment and had to rush off before I was able to respond.  Thanks Chuck for the update.

~Leslie

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