Jump to:

2084 Posts in 1005 Topics by 453 members

E-Commerce Modules

SilverStripe Forums » E-Commerce Modules » Where is the E-Commerce reports page?

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: 1212 Views
  • HansR
    Avatar
    Community Member
    140 Posts

    Where is the E-Commerce reports page? Link to this post

    I just installed the latest e-commerce module into a Silverstripe 2.3.0 site, and I don't see the reports page. Did I do something wrong? Or is there a problem with the e-commerce module? This module is useless if you can't review orders that people have made.

  • HansR
    Avatar
    Community Member
    140 Posts

    Re: Where is the E-Commerce reports page? Link to this post

    Answering my own question, the Current release (0.5.2) is incompatible with Silverstripe 2.3.0. I just upgraded to the latest trunk build, and the reports page appeared.

  • Uzenmi
    Avatar
    Community Member
    19 Posts

    Re: Where is the E-Commerce reports page? Link to this post

    Hi,

    I do not see Reports tab in CMS v2.3.0 after E-commerce module installed too. So where I can add this pls?

  • HansR
    Avatar
    Community Member
    140 Posts

    Re: Where is the E-Commerce reports page? Link to this post

    @ngoclam

    As I said above, the latest release is incompatible with SIlverstripe 2.3.0. You will need to download the latest trunk build. You will find it in the right-hand column on the e-commerce module page. Please heed the warnings about it being a preview, not a release, and therefore more buggy. If that is too much, then you may wish to undo your upgrade back to Silverstripe 2.2.2 until an updated release is made.

    Hans

  • Uzenmi
    Avatar
    Community Member
    19 Posts

    Re: Where is the E-Commerce reports page? Link to this post

    Thank you very much, HansR.

    However, this trunk build has an error when I try to process an order, I do not know did you have like that?
    Error info below:


    [User Error] Couldn't run query: INSERT INTO `Payment` SET Created = NOW() Field 'Amount' doesn't have a default value
    POST /sv23/checkout/OrderForm

    Line 394 in C:\EasyPHP3\www\sv23\sapphire\core\model\MySQLDatabase.php
    Source

    385    }
    386    
    387    function databaseError($msg, $errorLevel = E_USER_ERROR) {
    388       // try to extract and format query
    389       if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
    390          $formatter = new SQLFormatter();
    391          $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
    392       }
    393       
    394       user_error($msg, $errorLevel);
    395    }
    396 }
    397
    398 /**
    399 * A result-set from a MySQL database.
    400 * @package sapphire


    Trace

    * Couldn't run query: INSERT INTO `Payment` SET Created = NOW() Field 'Amount' doesn't have a default value
    Line 394 of MySQLDatabase.php
    * MySQLDatabase->databaseError(Couldn't run query: INSERT INTO `Payment` SET Created = NOW() | Field 'Amount' doesn't have a default value,256)
    Line 102 of MySQLDatabase.php
    * MySQLDatabase->query(INSERT INTO `Payment` SET Created = NOW(),256)
    Line 104 of DB.php
    * DB::query(INSERT INTO `Payment` SET Created = NOW())
    Line 770 of DataObject.php
    * DataObject->write()
    Line 172 of OrderForm.php
    * OrderForm->processOrder(Array,OrderForm,HTTPRequest)
    Line 232 of Form.php
    * Form->httpSubmission(HTTPRequest)
    Line 107 of RequestHandler.php
    * RequestHandler->handleRequest(HTTPRequest)
    Line 121 of RequestHandler.php
    * RequestHandler->handleRequest(HTTPRequest)
    Line 122 of Controller.php
    * Controller->handleRequest(HTTPRequest)
    Line 19 of ModelAsController.php
    * ModelAsController->handleRequest(HTTPRequest)
    Line 262 of Director.php
    * Director::handleRequest(HTTPRequest,Session)
    Line 106 of Director.php
    * Director::direct(/checkout/OrderForm)
    Line 115 of main.php

  • HansR
    Avatar
    Community Member
    140 Posts

    Re: Where is the E-Commerce reports page? Link to this post

    I don't remember having that problem. Try rebuilding your database by visiting dev/build/?flush=1

  • Uzenmi
    Avatar
    Community Member
    19 Posts

    Re: Where is the E-Commerce reports page? Link to this post

    I try rebuilding my database 2th but its still error

  • Sam
    Avatar
    Administrator
    679 Posts

    Re: Where is the E-Commerce reports page? Link to this post

    You might need to edit the Amount column in phpmyadmin and add a default value.

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