• Forums
  • Developer Forum
  • ws_Order_EnsureReportOrderData procedure not create during WebStore setup process, but ALTER during

ws_Order_EnsureReportOrderData procedure not create during WebStore setup process, but ALTER during

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.
7/11/2009 5:19:18 PM
Asad Samarian
Gravatar
Total Posts 550
View Posts

ws_Order_EnsureReportOrderData procedure not create during WebStore setup process,...

Hi Joe,

I find that the ws_Order_EnsureReportOrderData proecede not create during WebStore setup process, it create during core setup in version 2.2.9.0 and it defect self consistency of the Web store , because a developer expect all procedures with "ws_" prefix created during WebStore setup process. If we delete all "ws_" prefixed procedures and schema vesrion history of web store , the WebStore setup process stop at verion 0.0.4.6 because this version want to ALTER a procedure that was deleted.

Best,

Asad
 

7/12/2009 9:20:50 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: ws_Order_EnsureReportOrderData procedure not create during WebStore setup process, but ALTER dur

Hi Asad,

You are right, that procedure script should never have been in the mojoportal-core scripts, I must have made a mistake putting it there. It seems strange because version 2.2.9.0 is a long time ago and I would have expected it to cause an error during new installation when it creates that procedure because the webstore tables don't even exist yet. I guess somehow it did not cause an error since I've never seen one and no-one has reported any error about that.

I will move that out of the core 2.2.9.0 and into the Webstore 0.0.4.5 script.

Thanks,

Joe 

7/12/2009 10:24:08 AM
Asad Samarian
Gravatar
Total Posts 550
View Posts

Re: ws_Order_EnsureReportOrderData procedure not create during WebStore setup process, but ALTER during

Hi Joe,

the ws_Order_EnsureReportOrderData procedure not use of any tables of the WebStore , so no error happens during new installation.

Best,

Asad

7/12/2009 10:28:29 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: ws_Order_EnsureReportOrderData procedure not create during WebStore setup process, but ALTER dur

It does reference ws_Store and ws_Order which are WebStore tables.

Best,

Joe 

7/12/2009 10:52:46 AM
Asad Samarian
Gravatar
Total Posts 550
View Posts

Re: ws_Order_EnsureReportOrderData procedure not create during WebStore setup process, but ALTER during

I Create a new Installation without error.

Best,

Asad

 

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