1999 Posts in 530 Topics by 433 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, Howard, Sean, Ryan M., biapar, Willr, Ingo, Jedateach, swaiba, simon_w
|
Page:
1
|
Go to End | |
| Author | Topic: | 1068 Views |
-
Where is the E-Commerce reports page?
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.
-
Re: Where is the E-Commerce reports page?
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.
-
Re: Where is the E-Commerce reports page?
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?
-
Re: Where is the E-Commerce reports page?
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 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
-
Re: Where is the E-Commerce reports page?
9 March 2009 at 3:29pm Last edited: 9 March 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/OrderFormLine 394 in C:\EasyPHP3\www\sv23\sapphire\core\model\MySQLDatabase.php
Source385 }
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 -
Re: Where is the E-Commerce reports page?
9 March 2009 at 4:43pm
I don't remember having that problem. Try rebuilding your database by visiting dev/build/?flush=1
-
Re: Where is the E-Commerce reports page?
9 March 2009 at 4:49pm
I try rebuilding my database 2th but its still error
-
Re: Where is the E-Commerce reports page?
9 March 2009 at 4:53pm
You might need to edit the Amount column in phpmyadmin and add a default value.
| 1068 Views | ||
|
Page:
1
|
Go to Top |
