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

Where is the E-Commerce reports page?


Reply

8 Posts   1227 Views

Avatar
HansR

20 February 2009 at 8:34pm Community Member, 140 Posts

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.

Avatar
HansR

20 February 2009 at 8:51pm Community Member, 140 Posts

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.

Avatar
Uzenmi

9 March 2009 at 6:47am Community Member, 19 Posts

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?

Avatar
HansR

9 March 2009 at 9:53am Community Member, 140 Posts

@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 [url=http://silverstripe.org/e-commerce-module-2/]e-commerce[/url] 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

Avatar
Uzenmi

9 March 2009 at 3:29pm (Last edited: 9 March 2009 5:00pm), Community Member, 19 Posts

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

Avatar
HansR

9 March 2009 at 4:43pm Community Member, 140 Posts

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

Avatar
Uzenmi

9 March 2009 at 4:49pm Community Member, 19 Posts

I try rebuilding my database 2th but its still error :(

Avatar
Sam

9 March 2009 at 4:53pm Administrator, 685 Posts

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