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   1230 Views

Avatar
HansR

Community Member, 140 Posts

20 February 2009 at 8:34pm

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

Community Member, 140 Posts

20 February 2009 at 8:51pm

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

Community Member, 19 Posts

9 March 2009 at 6:47am

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

Community Member, 140 Posts

9 March 2009 at 9:53am

@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

Community Member, 19 Posts

9 March 2009 at 3:29pm

Edited: 09/03/2009 5:00pm

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

Community Member, 140 Posts

9 March 2009 at 4:43pm

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

Avatar
Uzenmi

Community Member, 19 Posts

9 March 2009 at 4:49pm

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

Avatar
Sam

Administrator, 685 Posts

9 March 2009 at 4:53pm

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