I have the same problem with e-commerce module v.052.. in the first time I used v.06 in SS v.2-3-6..
yes, it works although I found some problem like: can't add more product in customer's page, can't do payments (problem in order form), and other.
then the module was downgraded to 0.52.. but I've got so many problems..
here is the complete error..:
---------------------------------------------------------------------
[User Error] Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `CheckoutPage`.*, `Product`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `CheckoutPage` ON `CheckoutPage`.ID = `SiteTree`.ID LEFT JOIN `Product` ON `Product`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1 Table 'db_leiluv.checkoutpage' doesn't exist
GET /leiluv/admin/
Line 401 in C:\wamp\www\leiluv\sapphire\core\model\MySQLDatabase.php
Source
392 }
393
394 function databaseError($msg, $errorLevel = E_USER_ERROR) {
395 // try to extract and format query
396 if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
397 $formatter = new SQLFormatter();
398 $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
399 }
400
401 user_error($msg, $errorLevel);
402 }
403 }
404
405 /**
406 * A result-set from a MySQL database.
407 * @package sapphire
Trace
* Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `CheckoutPage`.*, `Product`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `CheckoutPage` ON `CheckoutPage`.ID = `SiteTree`.ID LEFT JOIN `Product` ON `Product`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1 Table 'db_leiluv.checkoutpage' doesn't exist
Line 401 of MySQLDatabase.php
* MySQLDatabase->databaseError(Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `CheckoutPage`.*, `Product`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `CheckoutPage` ON `CheckoutPage`.ID = `SiteTree`.ID LEFT JOIN `Product` ON `Product`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1 | Table 'db_leiluv.checkoutpage' doesn't exist,256)
Line 102 of MySQLDatabase.php
* MySQLDatabase->query(SELECT `SiteTree`.*, `GhostPage`.*, `CheckoutPage`.*, `Product`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `CheckoutPage` ON `CheckoutPage`.ID = `SiteTree`.ID LEFT JOIN `Product` ON `Product`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1,256)
Line 120 of DB.php
* DB::query(SELECT `SiteTree`.*, `GhostPage`.*, `CheckoutPage`.*, `Product`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `CheckoutPage` ON `CheckoutPage`.ID = `SiteTree`.ID LEFT JOIN `Product` ON `Product`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1)
Line 426 of SQLQuery.php
* SQLQuery->execute()
Line 2531 of DataObject.php
* DataObject->instance_get_one(`SiteTree`.URLSegment = '',)
Line 2468 of DataObject.php
* DataObject::get_one(SiteTree,`SiteTree`.URLSegment = '',1,)
Line 1094 of SiteTree.php
* SiteTree::get_by_url()
Line 215 of CMSMain.php
* CMSMain->generateDataTreeHints()
Line 143 of CMSMain.php
* CMSMain->SiteTreeAsUL()
* call_user_func_array(Array,Array)
Line 408 of ViewableData.php
* ViewableData->XML_val(SiteTreeAsUL,,1)
Line 294 of .cacheC..wamp.www.leiluv.cms.templates.Includes.CMSMain_left.ss
* include(C:\Windows\Temp\silverstripe-cacheC--wamp-www-leiluv\.cacheC..wamp.www.leiluv.cms.templates.Includes.CMSMain_left.ss)
Line 357 of SSViewer.php
* SSViewer->process(CMSMain)
Line 773 of ViewableData.php
* ViewableData->renderWith(Array)
Line 448 of LeftAndMain.php
* LeftAndMain->Left()
* call_user_func_array(Array,Array)
Line 408 of ViewableData.php
* ViewableData->XML_val(Left,,1)
Line 59 of .cacheC..wamp.www.leiluv.cms.templates.LeftAndMain.ss
* include(C:\Windows\Temp\silverstripe-cacheC--wamp-www-leiluv\.cacheC..wamp.www.leiluv.cms.templates.LeftAndMain.ss)
Line 357 of SSViewer.php
* SSViewer->process(CMSMain)
Line 172 of Controller.php
* Controller->handleAction(HTTPRequest)
Line 129 of RequestHandler.php
* RequestHandler->handleRequest(HTTPRequest)
Line 119 of Controller.php
* Controller->handleRequest(HTTPRequest)
Line 280 of Director.php
* Director::handleRequest(HTTPRequest,Session)
Line 121 of Director.php
* Director::direct(/admin/)
Line 118 of main.php
---------------------------------------------------------------------
please help me..
which one better? v.06 or v.052 when using SS v.2-3-6?
Thank you..
