Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

E-Commerce Modules /

Discuss about the various e-commerce modules available:
Ecommerce, SS Shop, SilverCart and SwipeStripe
Alternatively, have a look the shared mailinglist.

Moderators: martimiz, Nicolaas, Sean, frankmullenger, biapar, Willr, Ingo, Jedateach, swaiba, simon_w

problem with e-commerce


Reply


2 Posts   936 Views

Avatar
mew da vinci

Community Member, 2 Posts

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
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..

Avatar
TotalNet

Community Member, 181 Posts

23 April 2010 at 7:45am

Edited: 23/04/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