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.

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

E-Commerce 0.6 beta 1 released


Go to End


108 Posts   32451 Views

Avatar
eskimo

Community Member, 30 Posts

17 March 2010 at 10:27am

Tried to re-install and when running /dev/build its gets as far as:

Creating database records
# TrackBackPing
# PageComment
# Order
Website Error
There has been an error

The website server has not been able to respond to your request.

Any ideas?

Avatar
eskimo

Community Member, 30 Posts

18 March 2010 at 12:15pm

I realised that error was useless - here is the actual error:

User Error] Couldn't run query: SELECT `hasShippingCost` FROM `Order` WHERE `ID` = '1' Unknown column 'hasShippingCost' in 'field list'
GET /dev/build

Line 401 in /home/wwdncouk/public_html/sapphire/core/model/MySQLDatabase.php

Anyone come accross this before ?

Avatar
eskimo

Community Member, 30 Posts

19 March 2010 at 2:44am

Here is the full error:

[User Error] Couldn't run query: SELECT `hasShippingCost` FROM `Order` WHERE `ID` = '1' Unknown column 'hasShippingCost' in 'field list'
GET /dev/build

Line 401 in /home/wwdncouk/public_html/sapphire/core/model/MySQLDatabase.php
Source

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

Trace

* Couldn't run query: SELECT `hasShippingCost` FROM `Order` WHERE `ID` = '1' Unknown column 'hasShippingCost' in 'field list'
Line 401 of MySQLDatabase.php
* MySQLDatabase->databaseError(Couldn't run query: SELECT `hasShippingCost` FROM `Order` WHERE `ID` = '1' | Unknown column 'hasShippingCost' in 'field list',256)
Line 102 of MySQLDatabase.php
* MySQLDatabase->query(SELECT `hasShippingCost` FROM `Order` WHERE `ID` = '1',256)
Line 120 of DB.php
* DB::query(SELECT `hasShippingCost` FROM `Order` WHERE `ID` = '1')
Line 694 of Order.php
* Order->requireDefaultRecords()
Line 212 of DatabaseAdmin.php
* DatabaseAdmin->doBuild(,1)
Line 98 of DatabaseAdmin.php
* DatabaseAdmin->build()
Line 136 of DevelopmentAdmin.php
* DevelopmentAdmin->build(HTTPRequest)
Line 129 of RequestHandler.php
* RequestHandler->handleRequest(HTTPRequest)
Line 119 of Controller.php
* Controller->handleRequest(HTTPRequest)
Line 280 of Director.php
* Director::handleRequest(HTTPRequest,Session)
Line 121 of Director.php
* Director::direct(/dev/build)
Line 118 of main.php

Avatar
jorrie

Community Member, 40 Posts

29 March 2010 at 7:33am

Is this project still under development ? latest version from last year several months back?
I would love a solid e-commerce module for silverstripe

Avatar
mew da vinci

Community Member, 2 Posts

7 April 2010 at 8:19am

Well...
I have more problem than that one..
here is the full code..

-----------------
[User Error] Uncaught Exception: Object->__call(): the method 'getecommercefields' does not exist on 'Member'
GET /silverstripe/checkout/

Line 576 in C:\wamp\www\silverstripe\sapphire\core\Object.php
Source

567 case isset($config['function']) :
568 return $config['function']($this, $arguments);
569
570 default :
571 throw new Exception (
572 "Object->__call(): extra method $method is invalid on $this->class:" . var_export($config, true)
573 );
574 }
575 } else {
576 throw new Exception("Object->__call(): the method '$method' does not exist on '$this->class'");
577 }
578 }
579
580 // -----------------------------------------------------------------------------------------------------------------
581
582 /**

Trace

* Object->__call(getEcommerceFields,Array)
* Member->getEcommerceFields()
Line 18 of OrderForm.php
* OrderForm->__construct(CheckoutPage_Controller,OrderForm)
Line 226 of CheckoutPage.php
* CheckoutPage_Controller->OrderForm()
* call_user_func_array(Array,Array)
Line 408 of ViewableData.php
* ViewableData->XML_val(OrderForm,,1)
Line 492 of .cacheC..wamp.www.silverstripe.cms.ecommerce.templates.Layout.CheckoutPage.ss
* include(C:\Windows\Temp\silverstripe-cacheC--wamp-www-silverstripe\.cacheC..wamp.www.silverstripe.cms.ecommerce.templates.Layout.CheckoutPage.ss)
Line 357 of SSViewer.php
* SSViewer->process(CheckoutPage_Controller)
Line 349 of SSViewer.php
* SSViewer->process(CheckoutPage_Controller)
Line 172 of Controller.php
* Controller->handleAction(HTTPRequest)
Line 129 of RequestHandler.php
* RequestHandler->handleRequest(HTTPRequest)
Line 119 of Controller.php
* Controller->handleRequest(HTTPRequest)
Line 29 of ModelAsController.php
* ModelAsController->handleRequest(HTTPRequest)
Line 280 of Director.php
* Director::handleRequest(HTTPRequest,Session)
Line 121 of Director.php
* Director::direct(/checkout/)
Line 118 of main.php
--------------------------------------

it's happened when I click the check out page..

please, anyone can help me?

Avatar
novaweb

Community Member, 116 Posts

14 May 2010 at 12:17pm

Hi Sean!

Do you know if there plans being made to run eCommerce on 2.4 and above?

Cheers,

Josh

Avatar
DsX

Community Member, 178 Posts

23 May 2010 at 1:33pm

I too would like to know if there have been any updates to the beta?? Or movement toward 2.4?

Avatar
Jedateach

Forum Moderator, 238 Posts

28 May 2010 at 3:51pm

Edited: 28/05/2010 3:51pm