Items not appearing in order

05.09.2013 13:22
#1
Oldcrow
User Oldcrow
Name: Carl Potter
20.11.2012
Posts: 15
Quote
Items not appearing in order

When items are being selected for purchase and the order is processed it completes, but the email order does not show any items, but does show the value of the order.

In addition the order withing joomshopper does the same, shows the total value of order but no items.

Please help.


JoomShopping: 3.15.3
 
05.09.2013 15:02
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16487
Quote
Aw: Items not appearing in order

Enable debug mode joomla - see errors

 
05.09.2013 15:53
#3
Oldcrow
User Oldcrow
Name: Carl Potter
20.11.2012
Posts: 15
Quote
Aw: Items not appearing in order

JDatabaseMySQLi::query: 1054 - Unknown column 'extra_fields' in 'field list' SQL=INSERT INTO `zt4va_jshopping_order_item` (`order_id`,`product_id`,`product_ean`,`product_name`,`product_quantity`,`product_item_price`,`product_attributes`,`files`,`weight`,`thumb_image`,`vendor_id`,`product_freeattributes`,`attributes`,`freeattributes`,`delivery_times_id`,`extra_fields`) VALUES ('21','51','SLEE005','Sleeping Eye Mask','1','3.99','','a:0:{}','0.0000','thumb_53.jpg','1','','a:0:{}','a:0:{}','1','')

Call stack
# Function Location
1 JSite->dispatch() /var/www/vhosts/daisydesignsuk.co.uk/httpdocs/index.php:42
2 JComponentHelper::renderComponent() /var/www/vhosts/daisydesignsuk.co.uk/httpdocs/includes/application.php:197
3 JComponentHelper::executeComponent() /var/www/vhosts/daisydesignsuk.co.uk/httpdocs/libraries/joomla/application/component/helper.php:351
4 require_once() /var/www/vhosts/daisydesignsuk.co.uk/httpdocs/libraries/joomla/application/component/helper.php:383
5 JController->execute() /var/www/vhosts/daisydesignsuk.co.uk/httpdocs/components/com_jshopping/jshopping.php:27
6 JshoppingControllerCheckout->step5save() /var/www/vhosts/daisydesignsuk.co.uk/httpdocs/libraries/joomla/application/component/controller.php:761
7 jshopOrder->saveOrderItem() /var/www/vhosts/daisydesignsuk.co.uk/httpdocs/components/com_jshopping/controllers/checkout.php:941
8 JTable->store() /var/www/vhosts/daisydesignsuk.co.uk/httpdocs/components/com_jshopping/tables/order.php:272
9 JDatabase->insertObject() /var/www/vhosts/daisydesignsuk.co.uk/httpdocs/libraries/joomla/database/table.php:615
10 JDatabaseMySQLi->execute() /var/www/vhosts/daisydesignsuk.co.uk/httpdocs/libraries/joomla/database/database.php:841
11 JError::raiseError() /var/www/vhosts/daisydesignsuk.co.uk/httpdocs/libraries/joomla/database/database/mysqli.php:396
12 JError::raise() /var/www/vhosts/daisydesignsuk.co.uk/httpdocs/libraries/joomla/error/error.php:251

 
05.09.2013 21:10
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16487
Quote
Aw: Items not appearing in order

Problem update. Update step to step . or add field in table.

 
06.09.2013 10:37
#5
Oldcrow
User Oldcrow
Name: Carl Potter
20.11.2012
Posts: 15
Quote
Aw: Items not appearing in order

I installed all updates again and this has fixed the problem.

Thank you for your assistance.

 
Copyrights MAXXmarketing GmbH. All Rights Reserved