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

E-Commerce 0.6 beta 1 released


Reply

108 Posts   19743 Views

Avatar
eskimo

17 March 2010 at 10:27am Community Member, 30 Posts

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

18 March 2010 at 12:15pm Community Member, 30 Posts

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

19 March 2010 at 2:44am Community Member, 30 Posts

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

29 March 2010 at 7:33am Community Member, 40 Posts

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

7 April 2010 at 8:19am Community Member, 2 Posts

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

14 May 2010 at 12:17pm Community Member, 115 Posts

Hi Sean!

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

Cheers,

Josh

Avatar
DsX

23 May 2010 at 1:33pm Community Member, 178 Posts

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

Avatar
Jedateach

28 May 2010 at 3:51pm (Last edited: 28 May 2010 3:51pm), Forum Moderator, 227 Posts

I'm working on 2.4 compatibility
[url]http://www.silverstripe.org/e-commerce-module-forum/show/285221[/url]