After a lot of testing i can't seem to get the Order notification email or in other words the email that goes to the administrator every time an order is entered. this email contains all the information of the customer and order along with the extra fields. I am getting all the other emails the invoice to the customer, the payment notification email from hikashop with the subject "Authorize.net payment notification : payment Accepted". Joomla's phpmail is working. i just can't seem to get this email to get to me. please me let me know the issue. i will be sending you an email with backend access so you can look around if you choose.
here is the debug information at the end of cart stage
**Profile Information**
Application 0.000 seconds (+0.000); 0.88 MB (+0.88) - afterLoad
Application 0.062 seconds (+0.062); 8.26 MB (+7.38) - afterInitialise
Application 0.118 seconds (+0.056); 13.09 MB (+4.83) - afterRoute
Application 1.254 seconds (+1.136); 20.43 MB (+7.34) - afterDispatch
Application 1.297 seconds (+0.042); 21.43 MB (+1.00) - afterRender
**Memory Usage**
21.45 MB (22,487,312 Bytes)
**78 Queries Logged**
DELETE
FROM `jos_session`
WHERE `time` < 1318446347
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = 'c6ffe9926b1ca1baea282064dec5c5d1'
LIMIT 0, 1
INSERT INTO `jos_session` (`session_id`, `client_id`, `guest`, `time`, `userid`, `username`)
VALUES ('c6ffe9926b1ca1baea282064dec5c5d1', 0, 0, 1318443677, 42, 'admin')
SELECT folder AS type, element AS name, params
FROM jos_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT *
FROM jos_hikashop_config
SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component
FROM jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
AND m.access IN (1,1,2,3)
ORDER BY m.lft
SELECT id, home, template, params
FROM jos_template_styles
WHERE client_id = 0
SELECT id, title, module, position, content, showtitle, params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-10-12 20:05:47')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-10-12 20:05:47')
AND m.client_id = 0
AND (mm.menuid = 195 OR mm.menuid <= 0)
ORDER BY position, ordering
SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_hikashop'
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY lang_id ASC
SELECT a.*
FROM jos_hikashop_cart AS a
WHERE a.cart_id = 311
ORDER BY a.cart_modified DESC
LIMIT 1
SELECT b.id
FROM jos_user_usergroup_map AS map
LEFT JOIN jos_usergroups AS a
ON a.id = map.group_id
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE map.user_id = 42
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 = 311
AND b.product_id > 0
AND (c.product_access = 'all' OR c.product_access LIKE '%,1,%' OR c.product_access LIKE '%,8,%')
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 = 311
AND b.product_id > 0
AND (c.product_access = 'all' OR c.product_access LIKE '%,1,%' OR c.product_access LIKE '%,8,%')
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
UPDATE `jos_hikashop_cart`
SET `user_id`='42',`session_id`='c6ffe9926b1ca1baea282064dec5c5d1',`cart_modified`='1318449947'
WHERE cart_id='311'
SELECT currency_id
FROM jos_hikashop_currency
WHERE currency_published=1 OR currency_id = 2
SELECT *
FROM jos_hikashop_address
WHERE address_id = '159'
LIMIT 1
SELECT *
FROM jos_hikashop_zone
WHERE zone_namekey = 'state_Florida_4270'
LIMIT 1
SELECT *
FROM jos_hikashop_address
WHERE address_id = '159'
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 = 311
AND b.product_id > 0
AND (c.product_access = 'all' OR c.product_access LIKE '%,1,%' OR c.product_access LIKE '%,8,%')
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (86,8,18,87)
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 (86,8,18,87)
ORDER BY a.ordering,b.characteristic_value
SELECT *
FROM jos_hikashop_price
WHERE price_currency_id IN (1,2)
AND price_product_id IN (86,8,18,87)
AND (price_access = 'all' OR price_access LIKE '%,1,%' OR price_access LIKE '%,8,%')
ORDER BY price_value DESC
SELECT *
FROM jos_hikashop_currency
WHERE currency_id IN (2)
SELECT *
FROM jos_hikashop_address
WHERE address_id = '159'
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 = 24
AND b.taxation_published=1
AND ( taxation_type = '' OR taxation_type = 'individual' )
AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,1,%' OR b.taxation_access LIKE '%,8,%')
SELECT *
FROM jos_hikashop_zone
WHERE zone_id = 4270
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 < 1318449947
AND ( discount_end > 1318449947 OR discount_end = 0 )
AND ( discount_product_id IN (86,8,18,87) OR discount_product_id=0 )
AND discount_zone_id IN (0,4270)
AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
AND (discount_access = 'all' OR discount_access LIKE '%,1,%' OR discount_access LIKE '%,8,%')
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (86,8,18,87)
AND file_type='product'
ORDER BY file_id ASC
SELECT category_id
FROM jos_hikashop_product_category
WHERE product_id=86
ORDER BY ordering ASC
SELECT DISTINCT b.*
FROM jos_hikashop_category AS a
LEFT JOIN jos_hikashop_category AS b
ON a.category_left >= b.category_left
WHERE b.category_right >= a.category_right
AND a.category_id IN (25)
ORDER BY b.category_left
SELECT *
FROM jos_hikashop_field as a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_table='product'
AND (a.field_access = 'all' OR a.field_access LIKE '%,1,%' OR a.field_access LIKE '%,8,%')
AND ((field_with_sub_categories=0
AND (field_categories="all" OR field_categories LIKE '%,25,%'))OR (field_with_sub_categories=1
AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,10,%' OR field_categories LIKE '%,12,%' OR field_categories LIKE '%,25,%')))
ORDER BY a.`field_ordering` ASC
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 '%,1,%' OR discount_access LIKE '%,8,%')
ORDER BY discount_minimum_order DESC, discount_minimum_products DESC
SELECT *
FROM jos_hikashop_address
WHERE address_id = '159'
LIMIT 1
SELECT *
FROM jos_hikashop_field as a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_table='address'
AND (a.field_access = 'all' OR a.field_access LIKE '%,1,%' OR a.field_access LIKE '%,8,%')
ORDER BY a.`field_ordering` ASC
SELECT a.*
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('state_Florida_4270','country_United_States_of_America_223');
SELECT a.*
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('country_United_States_of_America_223');
SELECT *
FROM jos_hikashop_shipping
WHERE (shipping_access = 'all' OR shipping_access LIKE '%,1,%' OR shipping_access LIKE '%,8,%')
ORDER BY shipping_ordering ASC
SELECT *
FROM jos_hikashop_payment
WHERE (payment_access = 'all' OR payment_access LIKE '%,1,%' OR payment_access LIKE '%,8,%')
SELECT *
FROM jos_extensions
WHERE element IN ('collectondelivery','creditcard','authorize')
AND folder='hikashoppayment'
AND type='plugin'
ORDER BY ordering ASC
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_cms_id=42
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=53
SELECT a.variant_product_id as product_id,b.characteristic_id as value_id,b.characteristic_value as value,c.characteristic_id as name_id,c.characteristic_value as name
FROM jos_hikashop_variant AS a
LEFT JOIN jos_hikashop_characteristic AS b
ON a.variant_characteristic_id=b.characteristic_id
LEFT JOIN jos_hikashop_characteristic AS c
ON b.characteristic_parent_id = c.characteristic_id
WHERE a.variant_product_id IN (87)
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 '%,1,%' OR a.field_access LIKE '%,8,%')
ORDER BY a.`field_ordering` ASC
SELECT *
FROM jos_hikashop_payment
WHERE payment_type='authorize'
SELECT *
FROM jos_hikashop_address
WHERE address_id = '159'
LIMIT 1
SELECT *
FROM jos_hikashop_zone
WHERE zone_namekey IN ('state_Florida_4270','country_United_States_of_America_223');
SELECT *
FROM jos_hikashop_address
WHERE address_id = '159'
LIMIT 1
SELECT *
FROM jos_hikashop_zone
WHERE zone_namekey IN ('state_Florida_4270','country_United_States_of_America_223');
INSERT IGNORE INTO `jos_hikashop_order` ( `order_user_id`,`order_status`,`order_shipping_address_id`,`order_billing_address_id`,`order_currency_id`,`order_type`,`order_full_price`,`order_shipping_tax`,`order_discount_tax`,`order_discount_price`,`order_payment_id`,`order_payment_method`,`numberchoice`,`mobile_serial_lock_code`,`esnnumber`,`phone_number`,`carrier`,`account_number`,`pin`,`ssn`,`accountname`,`billingaddress`,`iqaccount`,`user_choice`,`order_created`,`order_ip`,`order_modified` )
VALUES ( '53','confirmed','159','159','2','sale','1.5','0','0','0','3','authorize','newnumber','111','111','','','','','','','Address, City, State, Zip','239-252-1234','','1318449948','75.147.150.110','1318449948' )
UPDATE `jos_hikashop_order`
SET `order_user_id`='53',`order_status`='confirmed',`order_shipping_address_id`='159',`order_billing_address_id`='159',`order_currency_id`='2',`order_type`='sale',`order_full_price`='1.5',`order_shipping_tax`='0',`order_discount_tax`='0',`order_discount_price`='0',`order_payment_id`='3',`order_payment_method`='authorize',`numberchoice`='newnumber',`mobile_serial_lock_code`='111',`esnnumber`='111',`phone_number`='',`carrier`='',`account_number`='',`pin`='',`ssn`='',`accountname`='',`billingaddress`='Address, City, State, Zip',`iqaccount`='239-252-1234',`user_choice`='',`order_created`='1318449948',`order_ip`='75.147.150.110',`order_modified`='1318449948',`order_number`='C6W5'
WHERE order_id='65'
UPDATE jos_hikashop_product
SET product_quantity = product_quantity - 1
WHERE product_id IN (8,18)
AND product_quantity > -1
UPDATE jos_hikashop_product
SET product_sales = product_sales + 1
WHERE product_id IN (8,18)
UPDATE jos_hikashop_product
SET product_quantity = product_quantity - 2
WHERE product_id IN (87)
AND product_quantity > -1
UPDATE jos_hikashop_product
SET product_sales = product_sales + 2
WHERE product_id IN (87)
INSERT IGNORE INTO jos_hikashop_order_product (order_id,product_id,order_product_quantity,order_product_name,order_product_code,order_product_price,order_product_tax,order_product_options,order_product_option_parent_id)
VALUES (65,8,1,'One time Activation Fee','One_time_Activation_Fee','1','0','',1044),(65,18,1,'iQ Unlimited Blackberry Talk, Text & Web',' iQ_Unlimited_Talk__Text___Web','0.5','0','',1041),(65,87,2,'Secure Pay: <span class=\"hikashop_product_variant_subname\"> Not selected</span>','Secure_Pay_46','','0','a:2:{i:1;O:8:\"stdClass\":6:{s:25:\"variant_characteristic_id\";s:2:\"46\";s:18:\"variant_product_id\";s:2:\"87\";s:8:\"ordering\";s:1:\"0\";s:17:\"characteristic_id\";s:2:\"46\";s:24:\"characteristic_parent_id\";s:2:\"48\";s:20:\"characteristic_value\";s:12:\"Not selected\";}s:10:\"Secure Pay\";s:12:\"Not selected\";}',1043)
SELECT *
FROM jos_hikashop_order_product
WHERE order_id=65
UPDATE jos_hikashop_order_product
SET order_product_option_parent_id=152
WHERE order_product_option_parent_id IN (1043)
AND order_id=65
UPDATE jos_hikashop_order_product
SET order_product_option_parent_id=0
WHERE order_id=65
AND order_product_option_parent_id NOT IN (152)
SELECT *
FROM jos_hikashop_payment
WHERE payment_type='authorize'
INSERT IGNORE INTO `jos_hikashop_history` ( `history_order_id`,`history_created`,`history_ip`,`history_user_id`,`history_new_status`,`history_reason`,`history_notified`,`history_type`,`history_amount`,`history_payment_id`,`history_payment_method`,`history_data` )
VALUES ( '65','1318449949','75.147.150.110','53','confirmed','**automatic payment notification received**','0','payment','1.5USD','3','authorize','' )
SELECT *
FROM jos_hikashop_address
WHERE address_id IN (159,159)
SELECT *
FROM jos_hikashop_zone
WHERE zone_namekey IN ('state_Florida_4270','country_United_States_of_America_223');
SELECT *
FROM jos_hikashop_category
WHERE category_type='status'
AND category_name='confirmed'
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 '%,1,%' OR a.field_access LIKE '%,8,%')
ORDER BY a.`field_ordering` ASC
SELECT *
FROM jos_hikashop_order
WHERE order_id = '65'
LIMIT 1
SELECT *
FROM jos_hikashop_address
WHERE address_id = '159'
LIMIT 1
SELECT *
FROM jos_hikashop_zone
WHERE zone_namekey IN ('state_Florida_4270','country_United_States_of_America_223');
SELECT *
FROM jos_hikashop_address
WHERE address_id = '159'
LIMIT 1
SELECT *
FROM jos_hikashop_zone
WHERE zone_namekey IN ('state_Florida_4270','country_United_States_of_America_223');
SELECT a.*
FROM jos_hikashop_order_product AS a
WHERE a.order_id = 65
SELECT *
FROM jos_hikashop_entry
WHERE order_id=65
SELECT *
FROM jos_hikashop_product
WHERE product_id IN (8,18,87)
AND product_type='variant'
SELECT b.*,a.*
FROM jos_hikashop_file AS a
LEFT JOIN jos_hikashop_download AS b
ON b.order_id=65
AND a.file_id = b.file_id
WHERE a.file_ref_id IN (8,18,87,86)
AND a.file_type='file'
SELECT *
FROM jos_hikashop_payment
WHERE payment_type='authorize'
DELETE
FROM jos_hikashop_cart_product
WHERE cart_id IN ('311')
DELETE
FROM jos_hikashop_cart
WHERE cart_id IN ('311')
**51 Query Types Logged, Sorted by Occurrences.**
**SELECT Tables:**
**9 × SELECT * FROM jos_hikashop_address**
**7 × SELECT * FROM jos_hikashop_zone**
**4 × SELECT * FROM jos_hikashop_field as a**
**4 × SELECT * FROM jos_hikashop_payment**
**3 × SELECT b.*,c.* FROM jos_hikashop_cart_product AS b LEFT JOIN jos_hikashop_product AS c ON b.product_id=c.product_id**
**2 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jos_extensions**
**2 × SELECT a.*,b.* FROM jos_hikashop_user AS a LEFT JOIN jos_users AS b ON a.user_cms_id=b.id**
**2 × SELECT * FROM jos_hikashop_file**
**2 × SELECT a.* FROM jos_hikashop_zone_link AS a**
**2 × SELECT * FROM jos_hikashop_discount**
**1 × SELECT * FROM jos_extensions**
**1 × SELECT b.*,a.* FROM jos_hikashop_file AS a LEFT JOIN jos_hikashop_download AS b ON b.order_id=65 AND a.file_id = b.file_id**
**1 × SELECT * FROM jos_hikashop_shipping**
**1 × SELECT * FROM jos_hikashop_entry**
**1 × SELECT * FROM jos_hikashop_category**
**1 × SELECT * FROM jos_hikashop_order**
**1 × SELECT * FROM jos_hikashop_order_product**
**1 × SELECT a.variant_product_id as product_id,b.characteristic_id as value_id,b.characteristic_value as value,c.characteristic_id as name_id,c.characteristic_value as name FROM jos_hikashop_variant AS a LEFT JOIN jos_hikashop_characteristic AS b ON a.variant_characteristic_id=b.characteristic_id LEFT JOIN jos_hikashop_characteristic AS c ON b.characteristic_parent_id = c.characteristic_id**
**1 × SELECT a.* FROM jos_hikashop_order_product AS a**
**1 × SELECT DISTINCT b.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_category AS b ON a.category_left >= b.category_left**
**1 × SELECT * FROM jos_hikashop_product**
**1 × SELECT * FROM jos_hikashop_currency**
**1 × SELECT id, title, module, position, content, showtitle, params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id**
**1 × SELECT * FROM jos_languages**
**1 × SELECT id, home, template, params FROM jos_template_styles**
**1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id**
**1 × SELECT folder AS type, element AS name, params FROM jos_extensions**
**1 × SELECT * FROM jos_hikashop_confi**
**1 × SELECT a.* FROM jos_hikashop_cart AS a**
**1 × SELECT b.id FROM jos_user_usergroup_map AS map LEFT JOIN jos_usergroups AS a ON a.id = map.group_id LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt**
**1 × SELECT `session_id` FROM `jos_session`**
**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**
**1 × SELECT * FROM jos_hikashop_price**
**1 × SELECT a.*,b.* FROM jos_hikashop_variant AS a LEFT JOIN jos_hikashop_characteristic AS b ON a.variant_characteristic_id=b.characteristic_id**
**1 × SELECT currency_id FROM jos_hikashop_currency**
**1 × SELECT category_id FROM jos_hikashop_product_category**
**OTHER Tables:**
**1 × UPDATE jos_hikashop_order_product SET order_product_option_parent_id=152**
**1 × INSERT IGNORE INTO jos_hikashop_order_product (order_id,product_id,order_product_quantity,order_product_name,order_product_code,order_product_price,order_product_tax,order_product_options,order_product_option_parent_id) VALUES (65,8,1,'One time Activation Fee','One_time_Activation_Fee','1','0','',1044),(65,18,1,'iQ Unlimited Blackberry Talk, Text & Web',' iQ_Unlimited_Talk__Text___Web','0.5','0','',1041),(65,87,2,'Secure Pay: Not selected','Secure_Pay_46','','0','a:2:{i:1;O:8:\"stdClass\":6:{s:25:\"variant_characteristic_id\";s:2:\"46\";s:18:\"variant_product_id\";s:2:\"87\";s:8:\"ordering\";s:1:\"0\";s:17:\"characteristic_id\";s:2:\"46\";s:24:\"characteristic_parent_id\";s:2:\"48\";s:20:\"characteristic_value\";s:12:\"Not selected\";}s:10:\"Secure Pay\";s:12:\"Not selected\";}',1043**
**1 × UPDATE jos_hikashop_order_product SET order_product_option_parent_id=0**
**1 × INSERT IGNORE INTO `jos_hikashop_history` ( `history_order_id`,`history_created`,`history_ip`,`history_user_id`,`history_new_status`,`history_reason`,`history_notified`,`history_type`,`history_amount`,`history_payment_id`,`history_payment_method`,`history_data` ) VALUES ( '65','1318449949','75.147.150.110','53','confirmed','**automatic payment notification received**','0','payment','1.5USD','3','authorize',''**
**1 × DELETE FROM jos_hikashop_cart**
**1 × DELETE FROM jos_hikashop_cart_product**
**1 × UPDATE jos_hikashop_product SET product_sales = product_sales + 2**
**1 × UPDATE jos_hikashop_product SET product_quantity = product_quantity - 2**
**1 × UPDATE `jos_hikashop_cart` SET `user_id`='42',`session_id`='c6ffe9926b1ca1baea282064dec5c5d1',`cart_modified`='1318449947'**
**1 × INSERT INTO `jos_session` (`session_id`, `client_id`, `guest`, `time`, `userid`, `username`) VALUES ('c6ffe9926b1ca1baea282064dec5c5d1', 0, 0, 1318443677, 42, 'admin'**
**1 × INSERT IGNORE INTO `jos_hikashop_order` ( `order_user_id`,`order_status`,`order_shipping_address_id`,`order_billing_address_id`,`order_currency_id`,`order_type`,`order_full_price`,`order_shipping_tax`,`order_discount_tax`,`order_discount_price`,`order_payment_id`,`order_payment_method`,`numberchoice`,`mobile_serial_lock_code`,`esnnumber`,`phone_number`,`carrier`,`account_number`,`pin`,`ssn`,`accountname`,`billingaddress`,`iqaccount`,`user_choice`,`order_created`,`order_ip`,`order_modified` ) VALUES ( '53','confirmed','159','159','2','sale','1.5','0','0','0','3','authorize','newnumber','111','111','','','','','','','Address, City, State, Zip','239-252-1234','','1318449948','75.147.150.110','1318449948'**
**1 × UPDATE `jos_hikashop_order` SET `order_user_id`='53',`order_status`='confirmed',`order_shipping_address_id`='159',`order_billing_address_id`='159',`order_currency_id`='2',`order_type`='sale',`order_full_price`='1.5',`order_shipping_tax`='0',`order_discount_tax`='0',`order_discount_price`='0',`order_payment_id`='3',`order_payment_method`='authorize',`numberchoice`='newnumber',`mobile_serial_lock_code`='111',`esnnumber`='111',`phone_number`='',`carrier`='',`account_number`='',`pin`='',`ssn`='',`accountname`='',`billingaddress`='Address, City, State, Zip',`iqaccount`='239-252-1234',`user_choice`='',`order_created`='1318449948',`order_ip`='75.147.150.110',`order_modified`='1318449948',`order_number`='C6W5'**
**1 × UPDATE jos_hikashop_product SET product_sales = product_sales + 1**
**1 × UPDATE jos_hikashop_product SET product_quantity = product_quantity - 1**
**1 × DELETE FROM `jos_session`**
**Parsing errors in language files**
/home/iqcellul/public_html/language/en-GB/en-GB.com_hikashop.ini : error(s) in line(s) 1
/home/iqcellul/public_html/administrator/language/en-GB/en-GB.plg_system_jat3.ini : error(s) in line(s) 87, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 347, 348, 349, 350, 351, 352, 353, 354
/home/iqcellul/public_html/language/en-GB/en-GB.tpl_ja_anion.ini : error(s) in line(s) 9, 10
**Language Files Loaded**
/home/iqcellul/public_html/language/en-GB/en-GB.ini 1
/home/iqcellul/public_html/language/en-GB/en-GB.com_hikashop.ini 1
/home/iqcellul/public_html/language/en-GB/en-GB.lib_joomla.ini 1
/home/iqcellul/public_html/administrator/language/en-GB/en-GB.plg_system_jat3.ini 1
/home/iqcellul/public_html/language/en-GB/en-GB.tpl_ja_anion.ini
/home/iqcellul/public_html/plugins/system/jat3/language/en-GB/en-GB.tpl_ja_anion.ini
/home/iqcellul/public_html/administrator/language/en-GB/en-GB.plg_system_cachecleaner.ini 1
/home/iqcellul/public_html/administrator/language/en-GB/en-GB.plg_system_sourcerer.ini 1
/home/iqcellul/public_html/language/en-GB/en-GB.plg_system_sourcerer.ini 1
/home/iqcellul/public_html/language/en-GB/en-GB.mod_menu.ini 1
/home/iqcellul/public_html/language/en-GB/en-GB.mod_breadcrumbs.ini 1
/home/iqcellul/public_html/language/en-GB/en-GB.mod_custom.ini 1
/home/iqcellul/public_html/administrator/language/en-GB/en-GB.plg_content_pagebreak.ini 1
/home/iqcellul/public_html/administrator/language/en-GB/en-GB.plg_content_vote.ini 1
/home/iqcellul/public_html/administrator/language/en-GB/en-GB.plg_system_debug.ini 1
**Untranslated Strings**
# /home/iqcellul/public_html/administrator/components/com_hikashop/classes/field.php
# /home/iqcellul/public_html/administrator/components/com_hikashop/classes/order.php
=""
# /home/iqcellul/public_html/media/com_hikashop/mail/order_creation_notification.text.modified.php
ACCOUNT_NAME="NAME"
ACCOUNT__=""
BILLING_ADDRESS="ADDRESS"
CARRIER="CARRIER"
ESN="ESN"
IQ_ACCOUNT__PHONE_NUMBER_="ACCOUNT PHONE NUMBER"
I_WANT_TO="WANT TO"
I_WOULD_LIKE="WOULD LIKE"
KEEP_YOUR_NUMBER="YOUR NUMBER"
MSL="MSL"
PHONE__=""
PIN__=""
SSN__=""
# /home/iqcellul/public_html/plugins/system/jat3/jat3/core/template.php
SKIP_TO_CONTENT="to content"
TOP="TOP"
HIKASHOP ESSENTIAL 49,95€The basic version. With the main features for a little shop.
HIKAMARKETAdd-on Create a multivendor platform. Enable many vendors on your website.
HIKASERIALAdd-on Sale e-tickets, vouchers, gift certificates, serial numbers and more!
MARKETPLACEPlugins, modules and other kinds of integrations for HikaShop
HIKAAUCTION 40€Add-on Create auctions and let your customers bid for products.
ACCESS THE CHECKOUTClick here to access the payment area
