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.
We've moved the forum!
Please use forum.silverstripe.org for any new questions
(announcement).
The forum archive will stick around, but will be read only.
You can also use our Slack channel
or StackOverflow to ask for help.
Check out our community overview for more options to contribute.
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, Ed, frankmullenger, biapar, Willr, Ingo, Jedateach, swaiba
Where is the E-Commerce reports page?
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.
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?
@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
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
I don't remember having that problem. Try rebuilding your database by visiting dev/build/?flush=1
I try rebuilding my database 2th but its still error :(
You might need to edit the Amount column in phpmyadmin and add a default value.