Possible Web Store MySql schema problem.

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.
10/14/2008 5:36:59 PM
Richard Bourque
Gravatar
Total Posts 92
View Posts

Possible Web Store MySql schema problem.

On my Windows/Apache/MySql testbed I upgraded to version 2.2.7.6 and decided to take a look at the Web Store to see what it's like, and ran into some mysql schema problems.

I had to run the following commands to add some defaults to make it work.

ALTER TABLE `mojoportal`.`ws_product` MODIFY COLUMN `UnitCost` DECIMAL(15,4) NOT NULL DEFAULT 0;

ALTER TABLE `mojoportal`.`ws_product` MODIFY COLUMN `RetailPrice` DECIMAL(15,4) NOT NULL DEFAULT 0;

ALTER TABLE `mojoportal`.`ws_product` MODIFY COLUMN `IsDeleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;

ALTER TABLE `mojoportal`.`ws_offer` MODIFY COLUMN `IsDeleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;

ALTER TABLE `mojoportal`.`ws_offerproduct` MODIFY COLUMN `IsDeleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;

I haven't tested it with a fresh system, this is a system thats been upgraded over the last 3-4 versions.

10/15/2008 3:50:33 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Possible Web Store MySql schema problem.

Hi Richard,

Glad you were able to figure out how to get it fixed. That doesn't surprise me for an older version upgrade. The WebStore feature is still experimental and depending on when you first installed it something might have got left out of your upgrade. I think the current scripts are ok, they work with a clean install and will hopefully work with upgrades going forward. There are going to be a lot of changes in the web store data model as my current vision for it has evolved a lot from what I started out with. So there is a potential for bumpy upgrades for this feature until the schema has stabilized. Thats the main reason I call it experimental. I'm not sure I can promise a smooth upgrade path at this stage of the implementation. The good news is my efforts in the near term are going to be focused heavily on the WebStore feature and therefore it should mature quickly. I need improvements to it for my own store on this site and I think getting it in shape so it is suitable for a variety of ecommerce needs is going to be a key factor in increasing interest in mojoPortal as a whole.

Best,

Joe

10/17/2008 9:31:53 AM
Richard Bourque
Gravatar
Total Posts 92
View Posts

Re: Possible Web Store MySql schema problem.

I'm starting a business venture with a friend who owns a security company to setup an online web store very soon.   We were testing web store programs but would absolutely throw them all away if we can accomplish everything in mojoportal.

I'll be more than happy to be your betatest site your svn code, and help with the bug tracking.

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