No order possible anymore

  • Posts: 137
  • Thank you received: 2
12 years 5 months ago #27608

Hi, I migrated recently to the latest version. Today a customer called an said he was not able to order. Following happens: when he wants to delete an item frm the cart is is coming back again. Also, if he completes the checkout and presses the final button, the process does not complete, but instead the cart content is duplicated. I verified from my admin user-id and experience the same issue. My website address is: www.die-besten-weine-der-welt.de

So basically no customer can order in the moment!!! I would need some urgent help.

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13035
  • MODERATOR
12 years 5 months ago #27622

Could you try to download again the install package from our server and install it on your website again ?
Does that solve the problem ?
If not, could you activate the debug mode in the joomla configuration and try again ? Do you get any error message in that case ?

Please Log in or Create an account to join the conversation.

  • Posts: 137
  • Thank you received: 2
12 years 5 months ago #27644

this happens when I try to delete an element of the cart:
Speichernutzung
8931100
17 Abfragen protokolliert

SELECT *
FROM jos_session
WHERE session_id = 'd2acf491502d0941b51e270eb34d1a23'
DELETE
FROM jos_session
WHERE ( time < '1319018908' )
SELECT *
FROM jos_session
WHERE session_id = 'd2acf491502d0941b51e270eb34d1a23'
UPDATE `jos_session`
SET `time`='1319090908',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='1',`data`='__default|a:9:{s:15:\"session.counter\";i:41;s:19:\"session.timer.start\";i:1319049586;s:18:\"session.timer.last\";i:1319090902;s:17:\"session.timer.now\";i:1319090908;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:6:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:11:\"application\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}s:10:\"com_cpanel\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:9:\"mtupgrade\";O:8:\"stdClass\":1:{s:7:\"checked\";b:1;}}}s:6:\"global\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"limit\";s:2:\"20\";}}}s:13:\"com_installer\";a:1:{s:4:\"data\";O:8:\"stdClass\":2:{s:10:\"limitstart\";O:8:\"stdClass\":4:{s:6:\"module\";i:0;s:6:\"plugin\";i:0;s:8:\"language\";i:0;s:8:\"template\";i:0;}s:9:\"templates\";O:8:\"stdClass\":1:{s:6:\"client\";s:2:\"-1\";}}}s:12:\"com_hikashop\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:8:\"category\";O:8:\"stdClass\":7:{s:9:\"filter_id\";s:2:\"30\";s:12:\"filter_order\";s:19:\"a.category_ordering\";s:16:\"filter_order_Dir\";s:3:\"asc\";s:10:\"limitstart\";i:0;s:6:\"search\";s:0:\"\";s:10:\"list_limit\";s:2:\"20\";s:11:\"filter_type\";i:0;}}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:23:\"erleseneweine@gmail.com\";s:8:\"password\";s:65:\"2b969b0fd2de2549592102a319821522:Weg6dbYBD3WvnmK82aoFHZwW1yWZXs7h\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2010-11-17 10:37:34\";s:13:\"lastvisitDate\";s:19:\"2011-10-19 18:46:30\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:56:\"admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=0\n\n\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:81:\"/home/die-besten-weine-der-welt-de/htdocs/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":5:{s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:1:\"0\";}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"595a055a2237f09c74a9e02701f223ae\";s:17:\"application.queue\";a:1:{i:0;a:2:{s:7:\"message\";s:48:\"Die Konfiguration wurde erfolgreich gespeichert!\";s:4:\"type\";s:7:\"message\";}}}'
WHERE session_id='d2acf491502d0941b51e270eb34d1a23'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id = 1
ORDER BY position, ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 1
AND menuid = 0
SELECT COUNT(*)
FROM jos_session
WHERE userid != 0
ORDER BY usertype, username
SELECT username, time, userid, usertype, client_id
FROM jos_session
WHERE userid != 0
ORDER BY usertype, username
SELECT a.hits, a.id, a.sectionid, a.title, a.created, u.name
FROM jos_content AS a
LEFT JOIN jos_users AS u
ON u.id=a.created_by
WHERE a.state <> -2
ORDER BY hits DESC
LIMIT 0, 10
SELECT a.id, a.sectionid, a.title, a.created, a.modified, u.name, a.created_by_alias, a.created_by
FROM jos_content AS a
LEFT JOIN jos_users AS u
ON u.id = a.created_by
WHERE a.state <> -2
ORDER BY created DESC
LIMIT 0, 10
SELECT menutype, COUNT(id) AS numitems
FROM jos_menu
WHERE published = 1
GROUP BY menutype
SELECT a.*, SUM(b.home) AS home
FROM jos_menu_types AS a
LEFT JOIN jos_menu AS b
ON b.menutype = a.menutype
GROUP BY a.id
SELECT *
FROM jos_components
WHERE `option` <> "com_frontpage"
AND `option` <> "com_media"
AND enabled = 1
ORDER BY ordering, name
SELECT COUNT(*)
FROM jos_messages
WHERE state = 0
AND user_id_to = 62
SELECT COUNT( session_id )
FROM jos_session
WHERE guest <> 1

the following happens, when I try to hit the next button in the cart/checkout process:
SELECT *
FROM jos_session
WHERE session_id = '0f8e60921b7bf819ed5692237a750620'
DELETE
FROM jos_session
WHERE ( time < '1319019109' )
SELECT *
FROM jos_session
WHERE session_id = '0f8e60921b7bf819ed5692237a750620'
UPDATE `jos_session`
SET `time`='1319091109',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:58;s:19:\"session.timer.start\";i:1319027777;s:18:\"session.timer.last\";i:1319090859;s:17:\"session.timer.now\";i:1319090917;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:12:\"com_hikashop\";a:1:{s:4:\"data\";O:8:\"stdClass\":13:{s:7:\"cart_id\";i:245;s:11:\"currency_id\";i:1;s:7:\"user_id\";i:1;s:16:\"shipping_address\";s:1:\"6\";s:15:\"billing_address\";s:1:\"6\";s:15:\"shipping_method\";s:6:\"manual\";s:11:\"shipping_id\";s:1:\"1\";s:13:\"shipping_data\";O:8:\"stdClass\":17:{s:11:\"shipping_id\";s:1:\"1\";s:13:\"shipping_type\";s:6:\"manual\";s:21:\"shipping_zone_namekey\";s:18:\"country_Germany_81\";s:15:\"shipping_tax_id\";s:2:\"12\";s:14:\"shipping_price\";s:7:\"5.88000\";s:20:\"shipping_currency_id\";s:1:\"1\";s:13:\"shipping_name\";s:18:\"DHL Paket National\";s:20:\"shipping_description\";s:0:\"\";s:18:\"shipping_published\";s:1:\"1\";s:17:\"shipping_ordering\";s:1:\"1\";s:15:\"shipping_params\";O:8:\"stdClass\":8:{s:18:\"shipping_min_price\";s:0:\"\";s:18:\"shipping_max_price\";s:0:\"\";s:19:\"shipping_min_weight\";s:0:\"\";s:19:\"shipping_max_weight\";s:0:\"\";s:20:\"shipping_weight_unit\";s:2:\"kg\";s:19:\"shipping_min_volume\";s:0:\"\";s:19:\"shipping_max_volume\";s:0:\"\";s:18:\"shipping_size_unit\";s:1:\"m\";}s:15:\"shipping_images\";s:0:\"\";s:15:\"shipping_access\";s:3:\"all\";s:23:\"shipping_price_with_tax\";d:7;s:19:\"shipping_price_orig\";d:0;s:28:\"shipping_price_orig_with_tax\";d:0;s:5:\"total\";O:8:\"stdClass\":1:{s:6:\"prices\";a:1:{i:0;O:8:\"stdClass\":7:{s:28:\"price_value_without_discount\";d:0;s:11:\"price_value\";d:6536.8799999999964711605571210384368896484375;s:37:\"price_value_without_discount_with_tax\";d:0;s:20:\"price_value_with_tax\";d:7777.0000000000027284841053187847137451171875;s:17:\"price_currency_id\";i:1;s:37:\"price_value_without_shipping_with_tax\";d:7770.0000000000027284841053187847137451171875;s:28:\"price_value_without_shipping\";d:6530.99999999999636202119290828704833984375;}}}}s:14:\"payment_method\";s:6:\"paypal\";s:10:\"payment_id\";i:1;s:12:\"payment_data\";O:8:\"stdClass\":23:{s:10:\"payment_id\";s:1:\"1\";s:12:\"payment_name\";s:6:\"PayPal\";s:19:\"payment_description\";s:58:\"<p>Hier klicken, falls Sie per Paypal zahlen möchten.</p>\";s:14:\"payment_images\";s:0:\"\";s:14:\"payment_params\";O:8:\"stdClass\":12:{s:3:\"url\";s:37:\"https://www.paypal.com/cgi-bin/webscr\";s:5:\"email\";s:33:\"info@die-besten-weine-der-welt.de\";s:12:\"address_type\";s:8:\"shipping\";s:12:\"notification\";s:1:\"1\";s:5:\"debug\";s:1:\"1\";s:10:\"cancel_url\";s:0:\"\";s:10:\"return_url\";s:0:\"\";s:16:\"cpp_header_image\";s:0:\"\";s:3:\"ips\";a:4:{i:0;s:10:\"64.4.241.*\";i:1;s:12:\"66.211.169.*\";i:2;s:12:\"66.211.170.*\";i:3;s:13:\"216.113.191.*\";}s:14:\"invalid_status\";s:9:\"cancelled\";s:14:\"pending_status\";s:7:\"created\";s:15:\"verified_status\";s:9:\"confirmed\";}s:12:\"payment_type\";s:6:\"paypal\";s:20:\"payment_zone_namekey\";s:0:\"\";s:14:\"payment_access\";s:3:\"all\";s:24:\"payment_shipping_methods\";s:0:\"\";s:16:\"payment_currency\";s:0:\"\";s:2:\"id\";s:2:\"45\";s:4:\"name\";s:30:\"HikaShop Paypal payment plugin\";s:7:\"element\";s:6:\"paypal\";s:6:\"folder\";s:15:\"hikashoppayment\";s:6:\"access\";s:1:\"0\";s:8:\"ordering\";s:1:\"0\";s:9:\"published\";s:1:\"1\";s:6:\"iscore\";s:1:\"0\";s:9:\"client_id\";s:1:\"0\";s:11:\"checked_out\";s:1:\"0\";s:16:\"checked_out_time\";s:19:\"0000-00-00 00:00:00\";s:6:\"params\";s:0:\"\";s:7:\"enabled\";s:1:\"1\";}s:14:\"checkout_terms\";s:1:\"1\";s:12:\"ssl_redirect\";i:0;}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:23:\"erleseneweine@gmail.com\";s:8:\"password\";s:65:\"2b969b0fd2de2549592102a319821522:Weg6dbYBD3WvnmK82aoFHZwW1yWZXs7h\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2010-11-17 10:37:34\";s:13:\"lastvisitDate\";s:19:\"2011-10-16 08:31:06\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:56:\"admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=0\n\n\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:81:\"/home/die-besten-weine-der-welt-de/htdocs/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":5:{s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:1:\"0\";}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"c7e9560ed204b11843e25567259ca0a4\";}'
WHERE session_id='0f8e60921b7bf819ed5692237a750620'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT *
FROM jos_hikashop_config
SELECT a.*
FROM jos_hikashop_cart AS a
WHERE a.cart_id = 245
ORDER BY a.cart_modified DESC
LIMIT 1
SELECT b.*,c.*
FROM jos_hikashop_cart_product AS b
LEFT JOIN jos_hikashop_product AS c
ON b.product_id=c.product_id
WHERE b.cart_id = 245
AND b.product_id > 0
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT b.*,c.*
FROM jos_hikashop_cart_product AS b
LEFT JOIN jos_hikashop_product AS c
ON b.product_id=c.product_id
WHERE b.cart_id = 245
AND b.product_id > 0
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
UPDATE `jos_hikashop_cart`
SET `user_id`='62',`session_id`='0f8e60921b7bf819ed5692237a750620',`cart_modified`='1319091110'
WHERE cart_id='245'
SELECT *
FROM jos_hikashop_product
WHERE product_id = '33'
LIMIT 1
INSERT INTO jos_hikashop_cart_product (cart_id,cart_product_modified,product_id,cart_product_parent_id,cart_product_quantity,cart_product_option_parent_id)
VALUES (245,1319091110,33,0,12,0)
SELECT a.*
FROM jos_hikashop_cart AS a
WHERE a.cart_id = 245
ORDER BY a.cart_modified DESC
LIMIT 1
SELECT b.*,c.*
FROM jos_hikashop_cart_product AS b
LEFT JOIN jos_hikashop_product AS c
ON b.product_id=c.product_id
WHERE b.cart_id = 245
AND b.product_id > 0
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT currency_id
FROM jos_hikashop_currency
WHERE currency_published=1 OR currency_id = 1
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT *
FROM jos_hikashop_zone
WHERE zone_namekey = 'country_Germany_81'
LIMIT 1
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT b.*,c.*
FROM jos_hikashop_cart_product AS b
LEFT JOIN jos_hikashop_product AS c
ON b.product_id=c.product_id
WHERE b.cart_id = 245
AND b.product_id > 0
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
AND file_type = 'product'
SELECT a.*,b.*
FROM jos_hikashop_variant AS a
LEFT JOIN jos_hikashop_characteristic AS b
ON a.variant_characteristic_id=b.characteristic_id
WHERE a.variant_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
ORDER BY a.ordering,b.characteristic_value
SELECT *
FROM jos_hikashop_price
WHERE price_currency_id IN (1,2)
AND price_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
ORDER BY price_value DESC
SELECT *
FROM jos_hikashop_currency
WHERE currency_id IN (1)
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT b.*,c.*
FROM jos_hikashop_category AS a
LEFT JOIN jos_hikashop_taxation AS b
ON a.category_namekey=b.category_namekey
LEFT JOIN jos_hikashop_tax AS c
ON b.tax_namekey=c.tax_namekey
WHERE a.category_id = 12
AND b.taxation_published=1
AND ( taxation_type = '' OR taxation_type = 'individual' )
SELECT *
FROM jos_hikashop_zone
WHERE zone_id = 81
SELECT *
FROM jos_hikashop_discount
WHERE discount_type='discount'
AND discount_published=1
AND ( discount_quota>discount_used_times OR discount_quota=0 )
AND discount_start < 1319091110
AND ( discount_end > 1319091110 OR discount_end = 0 )
AND ( discount_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33) OR discount_product_id=0 )
AND discount_zone_id IN (0,81)
AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
AND file_type='product'
ORDER BY file_id ASC
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT *
FROM jos_hikashop_field AS a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_table='address'
ORDER BY a.`field_ordering` ASC
SELECT a.*
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('country_Germany_81');
SELECT a.*
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('country_Ger_203338886','payment_EU_1779881374','payment_WW_906302993','tax_europe_9728');
SELECT a.*
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('payment_EU_1352161813');
SELECT *
FROM jos_hikashop_shipping
ORDER BY shipping_ordering ASC
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT b.*,c.*
FROM jos_hikashop_cart_product AS b
LEFT JOIN jos_hikashop_product AS c
ON b.product_id=c.product_id
WHERE b.cart_id = 245
AND b.product_id > 0
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
AND file_type = 'product'
SELECT a.*,b.*
FROM jos_hikashop_variant AS a
LEFT JOIN jos_hikashop_characteristic AS b
ON a.variant_characteristic_id=b.characteristic_id
WHERE a.variant_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
ORDER BY a.ordering,b.characteristic_value
SELECT *
FROM jos_hikashop_price
WHERE price_currency_id IN (1,2)
AND price_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
ORDER BY price_value DESC
SELECT *
FROM jos_hikashop_discount
WHERE discount_type='discount'
AND discount_published=1
AND ( discount_quota>discount_used_times OR discount_quota=0 )
AND discount_start < 1319091110
AND ( discount_end > 1319091110 OR discount_end = 0 )
AND ( discount_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33) OR discount_product_id=0 )
AND discount_zone_id IN (0,81)
AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
AND file_type='product'
ORDER BY file_id ASC
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT a.*
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('country_Germany_81');
SELECT a.*
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('country_Ger_203338886','payment_EU_1779881374','payment_WW_906302993','tax_europe_9728');
SELECT a.*
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('payment_EU_1352161813');
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT *
FROM jos_hikashop_payment
WHERE (payment_shipping_methods IN ('','_') OR payment_shipping_methods LIKE '%manual_1%')
AND (payment_currency IN ('','_','all') OR payment_currency LIKE '%,1,%')
SELECT *,published AS enabled
FROM jos_plugins
WHERE element IN ('paypal','collectondelivery','banktransfer')
AND folder='hikashoppayment'
ORDER BY ordering ASC
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id = 0
AND ( mm.menuid = 0 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT b.*,c.*
FROM jos_hikashop_cart_product AS b
LEFT JOIN jos_hikashop_product AS c
ON b.product_id=c.product_id
WHERE b.cart_id = 245
AND b.product_id > 0
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT *
FROM jos_hikashop_price
WHERE price_currency_id IN (1,2)
AND price_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
ORDER BY price_value DESC
SELECT *
FROM jos_hikashop_discount
WHERE discount_type='discount'
AND discount_published=1
AND ( discount_quota>discount_used_times OR discount_quota=0 )
AND discount_start < 1319091110
AND ( discount_end > 1319091110 OR discount_end = 0 )
AND ( discount_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33) OR discount_product_id=0 )
AND discount_zone_id IN (0,81)
AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13035
  • MODERATOR
12 years 5 months ago #27659

We are not able to reproduce the problem on our end. Would it be possible to get an FTP access to your website in order to debug the problem ?

Please Log in or Create an account to join the conversation.

  • Posts: 137
  • Thank you received: 2
12 years 5 months ago #27662

Nicolas, sure! I have sent you the user-id and pw per Personal Message. The website is: www.die-besten-weine-der-welt.de

Problems are identical on FF and IE.

Please Log in or Create an account to join the conversation.

  • Posts: 81361
  • Thank you received: 13035
  • MODERATOR
12 years 5 months ago #27682

The problem came from the fact that we had changed some things in the latest version in order to handle the cart operations differently, but since you had edited the cart file of the view checkout it didn't work anymore because you didn't get the modifications of that view file. I've changed the name of the file templates/YOUR_TEMPLATE/html/com_hikashop/checkout/cart.php to cart_.php in order the deactivate the override and it's working again.
Now you might want to reapply your modifications on the cart view.

Please Log in or Create an account to join the conversation.

Time to create page: 0.073 seconds
Powered by Kunena Forum