Jump to:

2088 Posts in 1008 Topics by 455 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, Sean, frankmullenger, biapar, Willr, Ingo, Jedateach, swaiba, simon_w

Page: 1
Go to End
Author Topic: 880 Views
  • mew da vinci
    Avatar
    Community Member
    2 Posts

    problem with e-commerce Link to this post

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

  • TotalNet
    Avatar
    Community Member
    181 Posts

    Re: problem with e-commerce Link to this post

    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

    880 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.