Checkout hanging.. HTTP Error 500 (Internal Server

Hi we've noticed that we're suddenly experiencing issues with hikashop hanging on payment (redirection to a normal paypal account) Has anyone else seen the error code:

HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request.

Ive reinstalled the site from a few days back when everything was working but we're still getting hangs at the payment stage of checkout.

Absolutely any thoughts very welcome because we're running dry of ideas after battling / restoring the website etc

Has anyone else seen this before?

(In my instance of hikashop Ive renamed coupons (Warren Miller discount code)

Any assistance very much welcome, I just turned on debug mode but all we get is a blank screen.

Will check out the thread and post whatever I find from the error log *hoping I can get to that via ftp*

Be back in a sec

I just got to warrenmiller.co.uk/component/hikashop/checkout/step/step-1 and it said:


The website cannot display the page

HTTP 500

Is there anyway I could ask you to check the site. Tonight was our opening night for the tour :/

I'll look for the error log.

I turned on debug,I dont know if this is *any* use. Its comes from the checkout screen (just before I press checkout to proceed to paypal)

Apologies if this isnt any use (below is a list of what joomla debug shows prior to press of "checkout")

Profile Information

Application afterLoad: 0.000 seconds, 0.23 MB

Application afterInitialise: 0.121 seconds, 4.36 MB

Application afterRoute: 0.211 seconds, 7.77 MB

Application afterDispatch: 0.305 seconds, 10.45 MB

Application afterRender: 0.414 seconds, 12.26 MB

Memory Usage
12948880
41 queries logged
1.
SELECT *
FROM jos_session
WHERE session_id = '3de0a736e209787d2384fec958ccdbaf'

2.
DELETE
FROM jos_session
WHERE ( TIME < '1320694825' )

3.
SELECT *
FROM jos_session
WHERE session_id = '3de0a736e209787d2384fec958ccdbaf'

4.
UPDATE `jos_session`
SET `time`='1320702025',`userid`='118',`usertype`='Registered',`username`='BOB',`gid`='18',`guest`='0',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:15;s:19:\"session.timer.start\";i:1320701495;s:18:\"session.timer.last\";i:1320701946;s:17:\"session.timer.now\";i:1320702009;s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)\";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\":15:{s:7:\"cart_id\";i:3224;s:11:\"currency_id\";i:4;s:7:\"user_id\";i:1;s:16:\"shipping_address\";s:2:\"55\";s:15:\"billing_address\";s:2:\"55\";s:7:\"zone_id\";s:3:\"222\";s:14:\"payment_method\";s:6:\"paypal\";s:10:\"payment_id\";i:2;s:12:\"payment_data\";O:8:\"stdClass\":22:{s:10:\"payment_id\";s:1:\"2\";s:12:\"payment_name\";s:6:\"PayPal\";s:19:\"payment_description\";s:62:\"You can pay by credit card or paypal using this payment method\";s:14:\"payment_images\";s:0:\"\";s:14:\"payment_params\";O:8:\"stdClass\":16:{s:3:\"url\";s:37:\" www.paypal.com/cgi-bin/webscr\";s:5:\"em...me\";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:18:\"checkout_fields_ok\";i:0;s:15:\"checkout_fields\";N;s:12:\"ssl_redirect\";i:0;s:15:\"shipping_method\";i:0;s:11:\"shipping_id\";i:0;s:13:\"shipping_data\";i:0;}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:3:\"118\";s:4:\"name\";s:3:\"BOB\";s:8:\"username\";s:3:\"BOB\";s:5:\"email\";s:25:\"eshots@blackdiamond.co.uk\";s:8:\"password\";s:65:\"6da9e013a84c9b418a38e1a954dcac18:y0UcHKoUlNRpFtUGZ6PBYdPlAuAFwl92\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"Registered\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:3:\"gid\";s:2:\"18\";s:12:\"registerDate\";s:19:\"2011-10-05 09:30:59\";s:13:\"lastvisitDate\";s:19:\"2011-11-07 18:57:51\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:1:\"\n\";s:3:\"aid\";i:1;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:84:\"/homepages/33/d345251787/htdocs/warrenMiller/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\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"696752c387ddeacce9025c107b6eb3d7\";}hikashop_order_data|N;'
WHERE session_id='3de0a736e209787d2384fec958ccdbaf'

5.
SELECT *
FROM jos_components
WHERE parent = 0

6.
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 1
ORDER BY ordering

7.
SELECT `query`
FROM `jos_admintools_wafexceptions`
WHERE (`option` IS NULL)
AND (`view` IS NULL)
GROUP BY `query`
ORDER BY `query` ASC

8.
SELECT `configuration`
FROM `jos_ak_profiles`
WHERE `id` = '1'

9.
SELECT *
FROM `jos_admintools_ipautoban`
WHERE `ip` = '109.154.16.87'

10.
SELECT `source`
FROM `jos_admintools_redirects`
WHERE (`dest` = 'component/hikashop/checkout/step/step-1' OR `dest` = 'component/hikashop/checkout/step/step-1')
AND `published` = 1
ORDER BY `ordering` DESC
LIMIT 0,1

11.
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

12.
SELECT r.*
FROM jos_chameleonrule AS r
WHERE r.published = 1
ORDER BY r.ordering

13.
SELECT *
FROM jos_hikashop_config

14.
SELECT a.*
FROM jos_hikashop_cart AS a
WHERE a.cart_id = 3224
ORDER BY a.cart_modified DESC
LIMIT 1

15.
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 = 3224
AND b.product_id > 0
AND (c.product_access = 'all' OR c.product_access LIKE '%,18,%')
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC

16.
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1

17.
SELECT a.*,b.*
FROM jos_hikashop_user AS a
LEFT JOIN jos_users AS b
ON a.user_cms_id=b.id
WHERE a.user_id=1

18.
SELECT *
FROM jos_hikashop_field AS a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_namekey!='address_name'
AND a.field_table='user'
AND (a.field_access = 'all' OR a.field_access LIKE '%,18,%')
ORDER BY a.`field_ordering` ASC

19.
SELECT *
FROM jos_hikashop_field AS a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_namekey!='address_name'
AND a.field_table='address'
AND (a.field_access = 'all' OR a.field_access LIKE '%,18,%')
ORDER BY a.`field_ordering` ASC

20.
SELECT currency_id
FROM jos_hikashop_currency
WHERE currency_published=1 OR currency_id = 4

21.
SELECT *
FROM jos_hikashop_address
WHERE address_id = '55'
LIMIT 1

22.
SELECT *
FROM jos_hikashop_address
WHERE address_id = '55'
LIMIT 1

23.
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 = 3224
AND b.product_id > 0
AND (c.product_access = 'all' OR c.product_access LIKE '%,18,%')
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC

24.
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (26)
AND file_type = 'product'

25.
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 (26)
ORDER BY a.ordering,b.characteristic_value

26.
SELECT *
FROM jos_hikashop_price
WHERE price_currency_id IN (4)
AND price_product_id IN (26)
AND (price_access = 'all' OR price_access LIKE '%,18,%')
ORDER BY price_value DESC

27.
SELECT *
FROM jos_hikashop_currency
WHERE currency_id IN (4)

28.
SELECT *
FROM jos_hikashop_address
WHERE address_id = '55'
LIMIT 1

29.
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 = 11
AND b.taxation_published=1
AND ( taxation_type = '' OR taxation_type = 'individual' )
AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,18,%')

30.
SELECT *
FROM jos_hikashop_zone
WHERE zone_id = 222

31.
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 < 1320702025
AND ( discount_end > 1320702025 OR discount_end = 0 )
AND ( discount_product_id IN (26) OR discount_product_id=0 )
AND discount_zone_id IN (0,222)
AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
AND (discount_access = 'all' OR discount_access LIKE '%,18,%')

32.
SELECT *
FROM jos_hikashop_discount
WHERE discount_type='coupon'
AND discount_published=1
AND discount_auto_load=1
AND (discount_access = 'all' OR discount_access LIKE '%,18,%')
ORDER BY discount_minimum_order DESC, discount_minimum_products DESC

33.
SELECT *
FROM jos_hikashop_address
WHERE address_id = '55'
LIMIT 1

34.
SELECT *
FROM jos_hikashop_shipping
WHERE (shipping_access = 'all' OR shipping_access LIKE '%,18,%')
ORDER BY shipping_ordering ASC

35.
SELECT *
FROM jos_hikashop_field AS a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_table='item'
AND (a.field_access = 'all' OR a.field_access LIKE '%,18,%')
ORDER BY a.`field_ordering` ASC

36.
SELECT *
FROM jos_hikashop_payment
WHERE (payment_access = 'all' OR payment_access LIKE '%,18,%')

37.
SELECT *,published AS enabled
FROM jos_plugins
WHERE element IN ('sagepay','paypal','paypalpro')
AND folder='hikashoppayment'
ORDER BY ordering ASC

38.
SELECT *
FROM jos_hikashop_field AS a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_table='order'
AND (a.field_access = 'all' OR a.field_access LIKE '%,18,%')
ORDER BY a.`field_ordering` ASC

39.
SELECT params
FROM jos_components AS c
WHERE c.OPTION='com_widgetkit'

40.
SELECT m.*, am.params AS adv_params
FROM jos_modules AS m
LEFT JOIN jos_advancedmodules AS am
ON am.moduleid = m.id
WHERE m.published = 1
AND m.access <= 1
AND m.client_id = 0
ORDER BY m.ordering, m.id

41.
SELECT `backupstart`
FROM `jos_ak_stats`
WHERE `origin` = "lazy"
AND NOT(`status` = "failed")
ORDER BY `backupstart` DESC
LIMIT 0,1


Language Files Loaded
•/homepages/33/d345251787/htdocs/warrenMiller/language/en-GB/en-GB.ini 1
•/homepages/33/d345251787/htdocs/warrenMiller/language/en-GB/en-GB.plg_system_debug.ini 1
•/homepages/33/d345251787/htdocs/warrenMiller/language/en-GB/en-GB.com_hikashop.ini 1
•/homepages/33/d345251787/htdocs/warrenMiller/language/en-GB/en-GB.com_user.ini 1
•/homepages/33/d345251787/htdocs/warrenMiller/administrator/components/com_widgetkit/language/en-GB/en-GB.widgetkit.ini 1
•/homepages/33/d345251787/htdocs/warrenMiller/language/en-GB/en-GB.tpl_yoo_downtown_white.ini
•/homepages/33/d345251787/htdocs/warrenMiller/templates/yoo_downtown_white/warp/systems/joomla.1.5/language/en-GB/en-GB.tpl_warp.ini 1
•/homepages/33/d345251787/htdocs/warrenMiller/language/en-GB/en-GB.mod_mainmenu.ini 1

Untranslated Strings Diagnostic
None
Untranslated Strings Designer
None

Nicholas is it possible to allow us to run two instances of hikashop to run on the registered domain? I only ask as I had to use an earlier backup of the website to get the site up an running. But we need to use the other instance just to see orders which continued to be created when the store wasnt processing payments. Is that possible?

We were pretty much up a creek without a paddle last night when joomla debug etc. still didnt shed any light on why hikashop wasnt processing payments via paypal.