Error session time finishing order

«StartZurück12WeiterEnde»
23.04.2013 11:57
#1
maxxrik
Joomshopping forum user no avatar
Name: Rik
24.08.2012
Posts: 16
Quote
Error session time finishing order

I've recently updated to joomshopping 3.13 but now when I make an order at the end I get the error:
"Error session time finish" (_JSHOP_SESSION_FINISH) and depending on my payment method I sometimes get the error "U should enter at least 1 receiving e-mailaddress". In my language dutch it's: "U dient minstens één ontvangers e-mailadres op te geven".

The orders also don't appear in Joomla. I've deleted al my old orders to check if maybe there was a problem with order numbers but I still get the error.

I've updated manually with FTP, could this be the problem? When I check my extensions it says that I still have version 3.7.2 installed.

Can someone please help me with this?


Letzte Änderung: 23.04.2013 12:45
 
23.04.2013 13:23
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16504
Quote
Aw: Error session time finishing order

Enable debug mode joomla - see errors.

Try update step to step again.

 
23.04.2013 13:59
#3
maxxrik
Joomshopping forum user no avatar
Name: Rik
24.08.2012
Posts: 16
Quote
Aw: Error session time finishing order

Alright I just did that. Debug mode is on and I've updated step by step. Now when I visit a shop category I get this error:

JDatabaseMySQL::query: 1054 - Unknown column 'F.description_nl-NL' in 'field list' SQL=SELECT F.id, F.`name_nl-NL` as name, F.`description_nl-NL` as description, F.allcats, F.type, F.cats, F.ordering, F.`group`, G.`name_nl-NL` as groupname, multilist FROM `hwy7c_jshopping_products_extra_fields` as F left join `hwy7c_jshopping_products_extra_field_groups` as G on G.id=F.group order by G.ordering, F.ordering
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:27
6 JshoppingControllerCategory->view() JROOT/libraries/joomla/application/component/controller.php:754
7 jshopCategory->getCountProducts() JROOT/components/com_jshopping/controllers/category.php:113
8 JTableAvto->getBuildQueryListProduct() JROOT/components/com_jshopping/tables/category.php:170
9 getQueryListProductsExtraFields() JROOT/components/com_jshopping/lib/jtableauto.php:35
10 JSFactory::getAllProductExtraField() JROOT/components/com_jshopping/lib/functions.php:1030
11 jshopProductField->getList() JROOT/components/com_jshopping/lib/factory.php:535
12 JDatabase->loadObjectList() JROOT/components/com_jshopping/tables/productfield.php:50
13 JDatabaseMySQL->query() JROOT/libraries/joomla/database/database.php:1071
14 JError::raiseError() JROOT/libraries/joomla/database/database/mysql.php:542
15 JError::raise() JROOT/libraries/joomla/error/error.php:251


Letzte Änderung: 23.04.2013 13:59
 
23.04.2013 14:55
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16504
Quote
Aw: Error session time finishing order

update step to step again.

 
23.04.2013 15:23
#5
maxxrik
Joomshopping forum user no avatar
Name: Rik
24.08.2012
Posts: 16
Quote
Aw: Error session time finishing order

I already updated to 3.14.3 and I have Joomla 2.5.

 
23.04.2013 16:06
#6
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16504
Quote
Aw: Error session time finishing order

start version?

 
23.04.2013 16:32
#7
maxxrik
Joomshopping forum user no avatar
Name: Rik
24.08.2012
Posts: 16
Quote
Aw: Error session time finishing order

Ok I removed 3.14.3 and installed 3.7.2 and it's strange because if I click on 'orders' in the backend I get a server error. It looks like there is something wrong with the orders section.

After that I decided to run a backup I made last month, both database and ftp data but in the backend I still get the error if I click 'orders'.

Does this have something to do with writing permissions?

After this I tried to update from the old installation but the problem with the orders page remain and in the frontend I get the message **Unvalid Token**. And the product page now has the same problem as the orders page.


Letzte Änderung: 23.04.2013 17:06
 
23.04.2013 20:26
#8
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16504
Quote
Aw: Error session time finishing order

Careful!
Update database need only.

 
23.04.2013 20:51
#9
maxxrik
Joomshopping forum user no avatar
Name: Rik
24.08.2012
Posts: 16
Quote
Aw: Error session time finishing order

What do you mean by that?

 
23.04.2013 21:37
#10
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16504
Quote
Aw: Error session time finishing order

NEED update step to step.
Start 3.7.0

Component Update 3.7.0 -> 3.7.1
Component Update 3.7.1 -> 3.7.2
....

 
12.09.2013 09:34
#11
azam_a
Joomshopping forum user no avatar
Name: azam
21.10.2012
Posts: 2
Quote
Aw: Error session time finishing order

hi
i have installedd joomla 2.5 and when i want to connect to the payment section i recieve the same error : " Error session time finishing order "
i've installed the same component on another Joomla 2.5 and i had no problem connecting to the bank but now this one doesn't work.
plz help me with the error
thans


Letzte Änderung: 12.09.2013 09:36
 
12.09.2013 10:00
#12
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16504
Quote
Aw: Error session time finishing order

Enable debug mode joomla - see errors.

 
12.09.2013 22:48
#13
serafina123
Joomshopping forum user no avatar
Name: Maja Berger
17.03.2012
Posts: 6
Quote
Aw: Error session time finishing order

I got the same problem after updating from 3.9.0 to 3.15.3. . Joomla version 2.5.14. I tried to upadte again and got this errors:

JoomShopping-update-3.9.0-3.10.0
DB-Funktion mit Fehlercode 1060 fehlgeschlagen!
Duplicate column name 'manufacturer' SQL=alter table `kyz3a_jshopping_order_item` ADD COLUMN `manufacturer` varchar(255) NOT NULL, ADD COLUMN `params` text NOT NULL;

JoomShopping-update-3.10.0-3.11.0
DB-Funktion mit Fehlercode 1060 fehlgeschlagen!
Duplicate column name 'multilist' SQL=alter table `kyz3a_jshopping_products_extra_fields` ADD COLUMN `multilist` tinyint(1) NOT NULL;

After trying to repeat the updates the whole shop chrashed and I had to switch it off!

JDatabaseMySQLi::query: 1054 - Unknown column 'description_de-DE' in 'field list' SQL=SELECT attr_id, `name_de-DE` as name, `description_de-DE` as description, attr_type, independent, allcats, cats, attr_ordering FROM `kyz3a_jshopping_attr` ORDER BY attr_ordering
Call stack
# Function Location
1 JSite->dispatch() JROOT/index.php:42
2 JComponentHelper::renderComponent() JROOT/includes/application.php:197
3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351
4 require_once() JROOT/libraries/joomla/application/component/helper.php:383
5 JController->execute() JROOT/components/com_jshopping/jshopping.php:27
6 JshoppingControllerCart->add() JROOT/libraries/joomla/application/component/controller.php:761
7 jshopCart->add() JROOT/components/com_jshopping/controllers/cart.php:45
8 jshopProduct->getRequireAttribute() JROOT/components/com_jshopping/models/cart.php:446
9 JSFactory::getAllAttributes() JROOT/components/com_jshopping/tables/product.php:90
10 jshopAttribut->getAllAttributes() JROOT/components/com_jshopping/lib/factory.php:324
11 JDatabase->loadObjectList() JROOT/components/com_jshopping/tables/attribut.php:32
12 JDatabaseMySQLi->execute() JROOT/libraries/joomla/database/database.php:1100
13 JError::raiseError() JROOT/libraries/joomla/database/database/mysqli.php:396
14 JError::raise() JROOT/libraries/joomla/error/error.php:251


Joomla: 2.5.14
JoomShopping: 3.15.4
PHP: 5.3.27
MySQL: 5.0.51a-24+lenny5
Website Url: www.torqeedo.com
 
13.09.2013 08:08
#14
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16504
Quote
Aw: Error session time finishing order

folder language/de-DE exist?

 
13.09.2013 19:21
#15
serafina123
Joomshopping forum user no avatar
Name: Maja Berger
17.03.2012
Posts: 6
Quote
Aw: Error session time finishing order

Yes.

 
13.09.2013 19:25
#16
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16504
Quote
Aw: Error session time finishing order

send me
admin login
ftp
(privat)

 
30.09.2013 04:54
#17
nazarkin659
Joomshopping forum user no avatar
Name: Nazar
28.09.2013
Posts: 6
Quote
Aw: Error session time finishing order

Hi there

I recently updated to the last version

And after that I got this error while trying confirm my purchase.



"
JDatabaseMySQLi::query: 1054 - Unknown column 'shipping_tax' in 'field list' SQL=INSERT INTO `c701w_jshopping_orders` (`order_number`,`user_id`,`order_total`,`order_subtotal`,`order_tax`,`order_tax_ext`,`order_shipping`,`order_payment`,`order_discount`,`currency_code`,`currency_code_iso`,`currency_exchange`,`order_status`,`order_created`,`order_date`,`order_m_date`,`shipping_method_id`,`payment_method_id`,`ip_address`,`order_add_info`,`title`,`f_name`,`l_name`,`firma_name`,`client_type`,`client_type_name`,`firma_code`,`tax_number`,`email`,`street`,`zip`,`city`,`state`,`country`,`phone`,`mobil_phone`,`fax`,`ext_field_1`,`ext_field_2`,`ext_field_3`,`d_title`,`d_f_name`,`d_l_name`,`d_firma_name`,`d_email`,`d_street`,`d_zip`,`d_city`,`d_state`,`d_country`,`d_phone`,`d_mobil_phone`,`d_fax`,`d_ext_field_1`,`d_ext_field_2`,`d_ext_field_3`,`order_hash`,`file_hash`,`display_price`,`vendor_type`,`vendor_id`,`lang`,`home`,`apartment`,`d_home`,`d_apartment`,`shipping_tax_ext`,`payment_tax_ext`,`order_package`,`package_tax_ext`,`m_name`,`birthday`,`d_m_name`,`d_birthday`,`shipping_tax`,`payment_tax`,`coupon_id`) VALUES ('00000038','42','248','195','0','a:0:{}','53','0','0','$','USD','1.000000','1','0','2013-09-30 02:43:42','2013-09-30 02:43:42','1','5','108.253.232.157','','1','Alvin','Konda','','0','','','','tan-ka1@yandex.ru','Test','test','Moscow','Moscow','176','003555692022008','','','','','','1','Alvin','Konda','','tan-ka1@yandex.ru','Test','test','Moscow','Moscow','176','003555692022008','','','','','','837493ef346ac11e1082a8206f2bf027','e1a6a08a82ca17725936a8d2b29e8434','1','0','1','ru-RU','','12','','12','a:1:{s:4:\"0.00\";d:0;}','a:1:{s:4:\"0.00\";d:0;}','0','a:1:{s:0:\"\";d:0;}','','0000-00-00','','0000-00-00','0.00','0.00','0')


And php :


Call stack
# Function Location
1 JSite->dispatch() /home/best4fis/public_html/index.php:42
2 JComponentHelper::renderComponent() /home/best4fis/public_html/includes/application.php:197
3 JComponentHelper::executeComponent() /home/best4fis/public_html/libraries/joomla/application/component/helper.php:351
4 require_once() /home/best4fis/public_html/libraries/joomla/application/component/helper.php:383
5 JController->execute() /home/best4fis/public_html/components/com_jshopping/jshopping.php:27
6 JshoppingControllerCheckout->step5save() /home/best4fis/public_html/libraries/joomla/application/component/controller.php:761
7 JTable->store() /home/best4fis/public_html/components/com_jshopping/controllers/checkout.php:923
8 JDatabase->insertObject() /home/best4fis/public_html/libraries/joomla/database/table.php:615
9 JDatabaseMySQLi->execute() /home/best4fis/public_html/libraries/joomla/database/database.php:841
10 JError::raiseError() /home/best4fis/public_html/libraries/joomla/database/database/mysqli.php:396
11 JError::raise() /home/best4fis/public_html/libraries/joomla/error/error.php:251

"



What I suppose to do?


Thank you


Joomla: 2.5.8
JoomShopping: 3.15.3
 
30.09.2013 08:17
#18
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16504
Quote
Aw: Error session time finishing order

update need step to step

 
30.09.2013 15:59
#19
nazarkin659
Joomshopping forum user no avatar
Name: Nazar
28.09.2013
Posts: 6
Quote
Aw: Error session time finishing order

Thats exactly what I did.

How can I fix that?


Letzte Änderung: 30.09.2013 16:02
 
30.09.2013 21:31
#20
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16504
Quote
Aw: Error session time finishing order

try again.

 
«StartZurück12WeiterEnde»
Copyrights MAXXmarketing GmbH. All Rights Reserved