ExperSHOP - ChangesHome Contents Please email any bug reports, comments or suggestions to ExperLog's Online Support Warning : Migration from version 3.0- to 3.5+ (database schema change)The database schema of the EProdOrder table has changed : - 3 new columns were added (ItemId, Rank, Superior). - The primary key has changed : it is now (OrdId, ItemId) instead of (OrdId, ProdId). To migrate you can use the following procedure (tested on MySQL and PostgreSQL): 1) Save the EPordOrder table in a temporary one: create table eprodordersvg as select * from EProdOrder; 2) Delete the EPordOrder table, and create the new one that corresponds to the new schema: drop table EProdOrder; create table EProdOrder ( ... ); 3) Fill the new table with the saved values (the old ProdId is inserted in both ProdId and ItemId columns): insert into EProdOrder(OrdId,ItemId,ProdId,Name,Price,Qty,Options,Superior) select Ordid,Prodid,Prodid,Name,Price,Qty,Options,'' from eprodordersvg; 4) Delete the temporary table (after checking that everything works !): drop table eprodordersvg; ExperShop version: 3.5 Version date: September 19, 2003. List of changes- Replaced InstantDB with Hsql DB in the demo shop. - Changed the database schema for EProdOrder (added ItemId, Rank and Superior, and changed the primary key from OrdId/ProdId to OrdId/ItemId). List of new functionalities- Now ExperShop supports configurable products, like assembled computers, etc... ExperShop version: 3.5 beta Version date: May 1, 2003. List of changes- Bug fix in the management console (to the end of the client) - Bug fix in multiplexing of JDBC connections - Bug fix in $AppendSQL when used with $LoopOnEnum - Validated PayBox online payment List of new functionalities- Added stored procedure management for Oracle system. You can find here a complete description of the new mechanism, how it works, and how you have to use it. - Integration of the XAPool project to use pooled connections. With this new version, the Enhydra pool is used as is, and is became a maintained product. See the XAPool project. - Cookie support to maintain sessions. - Now the cart can have options. Items are bind to product (only one level). - Added a new action, to send e-mail with multiple attachment files. ExperShop version: 3.0 Version date: September 4, 2002. List of changes- Changed the administration console. The look has changed with some functionnalities. Now you can sort by date the clients which enter in your application. - Modified the debug level, now we used the log4j level: DEBUG, INFO, WARN, ERROR, FATAL. List of new functionalities- Added multiple datasources in a single application, and these datasources are manageable with the administration console. ExperShop version: 2.0.1 . Version date: November 16, 2001. List of changes- Bug fix in the endswitch element. List of new functionalities- Added a "Save configuration" button in the administration console, to save to a file the current configuration. ExperShop version: 2.0 (beta 2). Version date: June 30, 2001. List of changes- Bug fix in the connection pooling - Fixed some locks in the trace configuration - Added jar files from Sun. It's no need to download these packages from the web site from Sun. List of new functionalities- Added multiplexing in the connection pooling. - Added the administration console to administrate the ExperSHOP applications. Now, no need to restart your server when you change the configuration of an application. The administration console help you to manage properties dynamically. Just a simple example, you want to increase the number of jdbc connections, now with the console, you have two ways to do the work. You can increase the number of physical connections, or increase the multiplex property, in this case, many connections to the clients will be managed by the same physical connection. - Added an upload servlet. You give the source file, the destination directory, and the return URL. - Added new payment modules: Lebonkado, PayBox,and new version of SIPS payment. - Added a Switch/Case element for the DynHtml language. ExperShop version: 2.0 (beta 1). Version date: Mars 1, 2001. List of new functionalities- ExperSHOP uses now the new JDBC service from Enhydra to manage the JDBC connections to the database. Now, the administrator can manage the pool of connections. - A new tracing system is now in place, more precise (see the documentation). - This new version integrates some bugs fixing. - Added a new DynHtml tag : $EXITLOOP, to exit from a loop - Added new behavior for $LOOPONRESULTS tag, you can now loop on a tuple and indicate the begin index and the end index: $LoopOnResults nomRequete nomTuple[(i,j)] ExperShop version: 1.1. Version date: November 27, 2000.
List of changesYou are concerned by these changes if you are using an old ExperSHOP version (download before November 27, 2000).Some bugs were fixed, mainly concerning high-traffic sites: - A memory leak when releasing user sessions. - A file descriptor that was sometimes not closed. These bugs had little impact on low and medium-traffic sites, but it is recommended to migrate to the new version. If you have an old expershop, you may have some minor problems to migrate: In case of trouble during the migration phase, e-mail us. List of new functionalitiesFor the french and european users, the ATOS sips secure payment is now supported (but not yet documented! this will be done soon, contact us if you don't find the doc on our site). And also, the DynHtml syntax improvements I described above can be helpful... |