Error session time finishing order

StartPrev 1 2 NextEnd
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?


Last change: 23.04.2013 12:45
 
23.04.2013 13:23
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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


Last change: 23.04.2013 13:59
 
23.04.2013 14:55
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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.


Last change: 23.04.2013 17:06
 
23.04.2013 20:26
#8
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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


Last change: 12.09.2013 09:36
 
12.09.2013 10:00
#12
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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: 12
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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: 12
Quote
Aw: Error session time finishing order

Yes.

 
13.09.2013 19:25
#16
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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?


Last change: 30.09.2013 16:02
 
30.09.2013 21:31
#20
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
Quote
Aw: Error session time finishing order

try again.

 
StartPrev 1 2 NextEnd


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.