Orders don't get transmitted into database

24.08.2012 12:11
#1
LenaS7
Joomshopping forum user no avatar
Name: Lena
05.04.2012
Posts: 8
Quote
Orders don't get transmitted into database

Hello,

since the Update from 3.5.1 to 3.9 (done all at once step by step) I discovered that the "dummy" orders don't get transmitted into the database (#__jshopping_order_item). Therefore the customer gets an empty orderemail and PDF file (only the price is correct, but no products are listed). Same thing for the backend listing. I can't find the error...

Please help.


Joomla: 2.5
JoomShopping: 3.9
Website Url: www.heiderelax.de/cms
 
24.08.2012 14:44
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16480
Quote
Aw: Orders don't get transmitted into database

Enable debug mode in joomla

 
24.08.2012 14:49
#3
LenaS7
Joomshopping forum user no avatar
Name: Lena
05.04.2012
Posts: 8
Quote
Aw: Orders don't get transmitted into database

The following was shown:

JDatabaseMySQLi::query: 1054 - Unknown column 'extra_fields' in 'field list' SQL=INSERT INTO `p5wro_jshopping_order_item` (`order_id`,`product_id`,`product_ean`,`product_name`,`product_quantity`,`product_item_price`,`product_tax`,`product_attributes`,`files`,`weight`,`thumb_image`,`vendor_id`,`product_freeattributes`,`attributes`,`freeattributes`,`delivery_times_id`,`extra_fields`) VALUES ('35','4','hrKS9-Kb','Die \"bauchige Kopfschale\"','1','46','19.00','','a:0:{}','0.3200','thumb_24b6f06995c261791a9e8ae4f51a8460.jpg','1','','a:0:{}','a:0:{}','2','')

Call stack
# Function Location
1 JSite->dispatch() JROOT/index.php:42
2 JComponentHelper::renderComponent() JROOT/includes/application.php:198
3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:357
4 require_once() JROOT/libraries/joomla/application/component/helper.php:388
5 JController->execute() JROOT/components/com_jshopping/jshopping.php:29
6 JshoppingControllerCheckout->step5save() JROOT/libraries/joomla/application/component/controller.php:754
7 jshopOrder->saveOrderItem() JROOT/components/com_jshopping/controllers/checkout.php:850
8 JTable->store() JROOT/components/com_jshopping/tables/order.php:204
9 JDatabase->insertObject() JROOT/libraries/joomla/database/table.php:608
10 JDatabaseMySQLi->query() JROOT/libraries/joomla/database/database.php:824
11 JError::raiseError() JROOT/libraries/joomla/database/database/mysqli.php:396
12 JError::raise() JROOT/libraries/joomla/error/error.php:251

 
24.08.2012 14:57
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16480
Quote
Aw: Orders don't get transmitted into database

Udate need Step to step.
Very important not to skip the update.

 
24.08.2012 14:59
#5
LenaS7
Joomshopping forum user no avatar
Name: Lena
05.04.2012
Posts: 8
Quote
Aw: Orders don't get transmitted into database

I did the updates step by step. Is there one I have to do again?

 
24.08.2012 15:03
#6
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16480
Quote
Aw: Orders don't get transmitted into database

You skip "Component Update 3.7.0 -> 3.7.1"

1.disable debug mode
2.Start update Component Update 3.7.0 -> 3.7.1

...

3.9.0

 
24.08.2012 15:12
#7
LenaS7
Joomshopping forum user no avatar
Name: Lena
05.04.2012
Posts: 8
Quote
Aw: Orders don't get transmitted into database

It worked!
I could have sworn I did the updates step by step...

Nevertheless, thank you!

 
Copyrights MAXXmarketing GmbH. All Rights Reserved