1999 Posts in 530 Topics by 433 members
E-Commerce Modules
SilverStripe Forums » E-Commerce Modules » problem with e-commerce
Discuss about the various e-commerce modules available:
Ecommerce, SS Shop, SilverCart and SwipeStripe
Alternatively, have a look the shared mailinglist.
Moderators: martimiz, Nicolaas, Howard, Sean, Ryan M., biapar, Willr, Ingo, Jedateach, swaiba, simon_w
|
Page:
1
|
Go to End | |
| Author | Topic: | 730 Views |
-
problem with e-commerce

8 April 2010 at 7:32pm
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
Source392 }
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 sapphireTrace
* 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..
-
Re: problem with e-commerce

23 April 2010 at 7:45am Last edited: 23 April 2010 7:46am
May I respectfully suggest that cronyoo's account is locked ... it's clear to me that it's only spam to promote the links in the signature! A "Report this post" link could be a handy feature for the forums module ;)
Sorry Mew to interrupt your question.
E-commerce 0.5.2 does not work on SS2.3+ full stop and I'm having trouble with 0.6 with SS2.3.6 so sticking to SS2.3.4 and e-commerce trunk code for now but will be taking a look at SS2.4 in the next couple of weeks.
All I can suggest right now is try SS2.3.7 + the latest e-commerce trunk (and the payment module of course).
Hope that helps
Rich
| 730 Views | ||
|
Page:
1
|
Go to Top |
