Possible Bug in WebStore Feature MojoPortal Release 2.2.6.6b

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.
7/31/2008 12:07:38 PM
Gravatar
Total Posts 10

Possible Bug in WebStore Feature MojoPortal Release 2.2.6.6b

Possible Bug in WebStore Feature MojoPortal Release 2.2.6.6b

I was publishing a WebStore Feature in the sourcecode version while in DEBUG when I found two possible bugs.

1.  In DBOffers.cs Line #273 parameter count should be 5 not 4 (throws and error "Parameter Count Does not match DB definition" when GetSPParameterSet Line#65).  The SP ws_OfferSelectPageforProductList has 5 parameters.

2.  When the above is recompiled into the complete solution the debugger catches another error in DBOfferProduct.cs Line #355 when trying to execute the DB Stored Procedure "ws_OfferProduct_CountByOffer" the SP does not exist in the DB

 

7/31/2008 12:16:30 PM
Gravatar
Total Posts 18439

Re: Possible Bug in WebStore Feature MojoPortal Release 2.2.6.6b

Hi,

If you want to play with WebStore and you are working with source code, I recommend get the code from svn trunk. Bugs get fixed quickly and then you can do svn update to get the fix. WebStore is not a mature feature yet, its undergoing very active development and currently it is being tested more fully using MySql because thats what this site is using. I do test on my local machine with MS SQL but its only being used on production with MySql at least by me. So far 5 people have bought me a beer ;-), thats not a huge amount of real world use but its a start.

I'm pretty sure these 2 bugs are already fixed if you get the code from svn trunk. If you find otherwise after getting the latest code please let me know and I will fix it quickly.

Best,

Joe

8/2/2008 8:37:38 AM
Gravatar
Total Posts 10

Re: Possible Bug in WebStore Feature MojoPortal Release 2.2.6.6b

Hi Joe,

I did sign up for SVN updates and I reviewed the bugs below in the latest checkout.  The bugs are still there. 

Thanks,

Bill

 

 

8/2/2008 9:05:17 AM
Gravatar
Total Posts 18439

Re: Possible Bug in WebStore Feature MojoPortal Release 2.2.6.6b

Hi Bill,

Thanks for following up. I've corrected the param count and added the missing procedure. If you do svn update, rebuild, then visit the /Setup/Default.aspx page it should fix it for you.

Best,

Joe

8/2/2008 9:19:40 AM
Gravatar
Total Posts 10

Re: Possible Bug in WebStore Feature MojoPortal Release 2.2.6.6b

Cool Thanks Joe!  BTW, the mp_Language_SelectAll returns and empty set.  The [dbo].[mp_Language] table is empty.  Is there something I should set to get the language values to populate the tables>

8/2/2008 9:35:47 AM
Gravatar
Total Posts 18439

Re: Possible Bug in WebStore Feature MojoPortal Release 2.2.6.6b

Oops, that was a mistake I made this morning. It used to be the for MS SQL the install started at version 2.2.4.8 then ran upgrade scripts up to 2.2.6.7, but this morning I consolidated it so that it could start at 2.2.6.7 and not have to run any upgrade scripts for a new installation. Unforutnately I forgot to add the data creation into the new install script. I've just corrected it. If you do svn update the script is now correct, but you will either need to start with a new db or grab the new insert statements from the bottom of /Setup/applications/mojoportal-core/SchemaInstalScripts/2.2.6.7.config and run the from query analyzer. This will populate the languages, currency, countries, states with some default content that is needed.

Thanks for helping me catch this quickly.

Best,

Joe

8/3/2008 10:35:16 PM
Gravatar
Total Posts 11

Re: Possible Bug in WebStore Feature MojoPortal Release 2.2.6.6b

Hi,

I am still not find 'ws_OfferProduct_CountByOffer' from latest update, for mssql schema. Am I missing something here?

Thanks,

An

8/4/2008 6:54:42 AM
Gravatar
Total Posts 18439

Re: Possible Bug in WebStore Feature MojoPortal Release 2.2.6.6b

Hi An,

Are you working with mojoPortal from svn trunk? It is fixed there. WebStore is undergoing a lot of development things get fixed/improved every day, but I can't be making releases every day so its really only good for developers who are working with the code from svn trunk. After doing svn update, rebuild solution then visit /Setup/Default.aspx and it will run any upgrade scripts added since the last svn update.

Best,

Joe

8/5/2008 8:14:06 AM
Gravatar
Total Posts 18439

Re: Possible Bug in WebStore Feature MojoPortal Release 2.2.6.6b

Last night I uploaded release version 2.2.6.7 which should fix this error.

Best,

Joe

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