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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 19415
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 19415
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 19415
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. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.