HIKASHOP ESSENTIAL 60€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
Topic Author
-- HikaShop version -- : HikaShop [1504301217]
-- Joomla version -- : 3.4.1
-- Error-message(debug-mod must be tuned on) -- :
Database Queries
27 Queries Logged 21.6 ms
14 duplicate found!
2 duplicates: #11 #18
2 duplicates: #12 #19
2 duplicates: #14 #20
2 duplicates: #15 #21
2 duplicates: #16 #22
2 duplicates: #17 #23
2 duplicates: #24 #25
Query Time: 0.16 ms Query memory: 0.013 MB Memory before query: 2.516 MB Rows returned: 1
SELECT `data`
FROM `j3_session`
WHERE `session_id` = 'bd80114189ccbbf84f300950750baa27'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_session const PRIMARY PRIMARY 602 const 1
Profile
Error
The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working SQL=SHOW PROFILES
Call Stack
JROOT/libraries/joomla/session/storage/database.php:44
JROOT/libraries/joomla/session/session.php:665
JROOT/libraries/joomla/session/session.php:603
JROOT/libraries/cms/application/cms.php:739
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/administrator.php:45
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/administrator/index.php:39
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.17 ms After last query: 2.00 ms Query memory: 0.008 MB Memory before query: 2.694 MB
DELETE
FROM `j3_session`
WHERE `time` '1430899767'
Explain
EXPLAIN not possible on query: DELETE FROM `j3_session` WHERE `time` '1430899767'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Cal Stack
JROOT/libraries/cms/application/cms.php:756
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/administrator.php:45
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/administrator/index.php:39
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.53 ms After last query: 10.58 ms Query memory: 0.011 MB Memory before query: 3.325 MB Rows returned: 88
SELECT folder AS type, element AS name, params
FROM j3_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1,2,3)
ORDER BY ordering
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_extensions ref extension extension 62 const 160 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:310
JROOT/libraries/cms/plugin/helper.php:86
JROOT/libraries/cms/plugin/helper.php:128
JROOT/libraries/cms/application/cms.php:640
JROOT/libraries/cms/application/administrator.php:294
JROOT/libraries/cms/applicationadministrator.php:116
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.51 ms After last query: 32.76 ms Query memory: 0.018 MB Memory before query: 5.620 MB Rows returned: 38
SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
WHERE `type` = 'component'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_extensions ref extension extension 62 const 38 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/component/helper.php:434
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:119
JROOT/plugins/system/k2/k2.php:435
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:654
JROOT/libraries/cms/application/administrator.php:294
JROOT/libraries/cms/application/administrator.php:116
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.36 ms After last query: 14.37 ms Query memory: 0.022 MB Memory before query: 6.294 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:177
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/sef/sef.php:28
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/administrator.php:457
JROOT/libraries/cms/application/administrator.php:137
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 9.13 ms After last query: 2.12 ms Query memory: 0.017 MB Memory before query: 6.402 MB
UPDATE `j3_extensions`
SET `params` = '{\"mediaversion\":\"6262967d85df0fcb2b9fa3a905fe000e\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Explain
EXPLAIN not possible on query: UPDATE `j3_extensions` SET `params` = '{\"mediaversion\":\"6262967d85df0fcb2b9fa3a905fe000e\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:228
JROOT/libraries/cms/version/version.php:187
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/sef/sef.php:28
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/administrator.php:457
JROOT/libraries/cms/application/administrator.php:137
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.35 ms After last query: 2.75 ms Query memory: 0.008 MB Memory before query: 6.621 MB Rows returned: 1
SELECT template, s.params
FROM j3_template_styles as s
LEFT JOIN j3_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = '1'
ORDER BY home
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s ref idx_home idx_home 21 const 1 Using where
1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 303 ssahota_lec3.s.template,const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/administrator.php:212
JROOT/libraries/cms/application/administrator.php:82
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.63 ms After last query: 36.56 ms Query memory: 0.015 MB Memory before query: 9.088 MB Rows returned: 367
SELECT *
FROM j3_hikashop_config
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_hikashop_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 367
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/classes/config.php:16
JROOT/administrator/components/com_hikashop/helpers/helper.php:973
JROOT/administrator/components/com_hikashop/helpers/helper.php:3287
JROOT/administrator/components/com_hikashop/hikashop.php:14
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.28 ms After last query: 20.75 ms Query memory: 0.017 MB Memory before query: 11.098 MB Rows returned: 1
SELECT a.id
FROM j3_user_usergroup_map AS map
LEFT JOIN j3_usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 630
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE map ref PRIMARY PRIMARY 4 const 1 Using index
1 SIMPLE a eq_ref PRIMARY PRIMARY 4 ssahota_lec3.map.group_id 1 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:332
JROOT/administrator/components/com_hikashop/helpers/helper.php:152
JROOT/administrator/components/com_hikashop/classes/field.php:109
JROOT/administrator/components/com_hikashop/helpers/import.php:68
JROOT/administrator/components/com_hikashop/helpers/helper.php:1065
JROOT/administrator/components/com_hikashop/controllers/import.php:25
JROOT/administrator/components/com_hikashop/hikashop.php:52
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.19 ms After last query: 0.17 ms Query memory: 0.015 MB Memory before query: 11.112 MB Rows returned: 0
SELECT *
FROM j3_hikashop_field as a
WHERE a.`field_published` = 1
AND a.field_table='product'
AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%')
ORDER BY a.`field_ordering` ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 15 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/classes/field.php:111
JROOT/administrator/components/com_hikashop/helpers/import.php:68
JROOT/administrator/components/com_hikashop/helpers/helper.php:1065
JROOT/administrator/components/com_hikashop/controllers/import.php:25
JROOT/administrator/components/com_hikashop/hikashop.php:52
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.41 ms After last query: 0.13 ms Query memory: 0.015 MB Memory before query: 11.131 MB Rows returned: 45
Duplicate queries: #18
SHOW FULL COLUMNS
FROM `j3_hikashop_product`
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `j3_hikashop_product`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/helpers/import.php:85
JROOT/administrator/components/com_hikashop/helpers/helper.php:1065
JROOT/administrator/components/com_hikashop/controllers/import.php:25
JROOT/administrator/components/com_hikashop/hikashop.php:52
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.19 ms After last query: 1.56 ms Query memory: 0.015 MB Memory before query: 11.209 MB Rows returned: 6
Duplicate queries: #19
SELECT *
FROM j3_hikashop_characteristic
ORDER BY characteristic_parent_id ASC, characteristic_ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_hikashop_characteristic ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/classes/characteristic.php:82
JROOT/administrator/components/com_hikashop/helpers/import.php:89
JROOT/administrator/components/com_hikashop/helpers/helper.php:1065
JROOT/administrator/components/com_hikashop/controllers/import.php:25
JROOT/administrator/components/com_hikashop/hikashop.php:52
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.19 ms After last query: 5.48 ms Query memory: 0.016 MB Memory before query: 11.631 MB Rows returned: 1
SELECT category_id
FROM j3_hikashop_category
WHERE category_type='root'
LIMIT 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/classes/category.php:397
JROOT/administrator/components/com_hikashop/classes/category.php:414
JROOT/administrator/components/com_hikashop/helpers/import.php:95
JROOT/administrator/components/com_hikashop/helpers/helper.php:1065
JROOT/administrator/components/com_hikashop/controllers/import.php:25
JROOT/administrator/components/com_hikashop/hikashop.php:52
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.09 ms After last query: 0.12 ms Query memory: 0.015 MB Memory before query: 11.647 MB Rows returned: 1
Duplicate queries: #20
SELECT category_id
FROM j3_hikashop_category
WHERE category_parent_id=1
AND category_type='product'
LIMIT 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/classes/category.php:416
JROOT/administrator/components/com_hikashop/helpers/import.php:95
JROOT/administrator/components/com_hikashop/helpers/helper.php:1065
JROOT/administrator/components/com_hikashop/controllers/import.php:25
JROOT/administrator/components/com_hikashop/hikashop.php:52
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.09 ms After last query: 0.10 ms Query memory: 0.015 MB Memory before query: 11.663 MB Rows returned: 1
Duplicate queries: #21
SELECT category_id
FROM j3_hikashop_category
WHERE category_parent_id=1
AND category_type='manufacturer'
LIMIT 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/classes/category.php:416
JROOT/administrator/components/com_hikashop/helpers/import.php:97
JROOT/administrator/components/com_hikashop/helpers/helper.php:1065
JROOT/administrator/components/com_hikashop/controllers/import.php:25
JROOT/administrator/components/com_hikashop/hikashop.php:52
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.08 ms After last query: 0.11 ms Query memory: 0.015 MB Memory before query: 11.678 MB Rows returned: 1
Duplicate queries: #22
SELECT category_id
FROM j3_hikashop_category
WHERE category_parent_id=1
AND category_type='tax'
LIMIT 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/classes/category.php:416
JROOT/administrator/components/com_hikashop/helpers/import.php:99
JROOT/administrator/components/com_hikashop/helpers/helper.php:1065
JROOT/administrator/components/com_hikashop/controllers/import.php:25
JROOT/administrator/components/com_hikashop/hikashop.php:52
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.19 ms After last query: 0.10 ms Query memory: 0.014 MB Memory before query: 11.694 MB Rows returned: 3
Duplicate queries: #23
SELECT category_id
FROM j3_hikashop_category
WHERE category_type='tax' && category_parent_id=3
ORDER BY category_ordering DESC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/helpers/import.php:101
JROOT/administrator/components/com_hikashop/helpers/helper.php:1065
JROOT/administrator/components/com_hikashop/controllers/import.php:25
JROOT/administrator/components/com_hikashop/hikashop.php:52
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.49 ms After last query: 8.09 ms Query memory: 0.018 MB Memory before query: 12.415 MB Rows returned: 45
Duplicate queries: #11
SHOW FULL COLUMNS
FROM `j3_hikashop_product`
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `j3_hikashop_product`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/helpers/import.php:85
JROOT/administrator/components/com_hikashop/helpers/importvm.php:24
JROOT/administrator/components/com_hikashop/helpers/helper.php:1062
JROOT/administrator/components/com_hikashop/controllers/import.php:50
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1489
JROOT/administrator/components/com_hikashop/hikashop.php:54
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.16 ms After last query: 0.73 ms Query memory: 0.018 MB Memory before query: 12.443 MB Rows returned: 6
Duplicate queries: #12
SELECT *
FROM j3_hikashop_characteristic
ORDER BY characteristic_parent_id ASC, characteristic_ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_hikashop_characteristic ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/classes/characteristic.php:82
JROOT/administrator/components/com_hikashop/helpers/import.php:89
JROOT/administrator/components/com_hikashop/helpers/importvm.php:24
JROOT/administrator/components/com_hikashop/helpers/helper.php:1062
JROOT/administrator/components/com_hikashop/controllers/import.php:50
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1489
JROOT/administrator/components/com_hikashop/hikashop.php:54
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.14 ms After last query: 0.47 ms Query memory: 0.018 MB Memory before query: 12.476 MB Rows returned: 1
Duplicate queries: #14
SELECT category_id
FROM j3_hikashop_category
WHERE category_parent_id=1
AND category_type='product'
LIMIT 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/classes/category.php:416
JROOT/administrator/components/com_hikashop/helpers/import.php:95
JROOT/administrator/components/com_hikashop/helpers/importvm.php:24
JROOT/administrator/components/com_hikashop/helpers/helper.php:1062
JROOT/administrator/components/com_hikashop/controllers/import.php:50
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1489
JROOT/administrator/components/com_hikashop/hikashop.php:54
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.09 ms After last query: 0.12 ms Query memory: 0.018 MB Memory before query: 12.495 MB Rows returned: 1
Duplicate queries: #15
SELECT category_id
FROM j3_hikashop_category
WHERE category_parent_id=1
AND category_type='manufacturer'
LIMIT 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/classes/category.php:416
JROOT/administrator/components/com_hikashop/helpers/import.php:97
JROOT/administrator/components/com_hikashop/helpers/importvm.php:24
JROOT/administrator/components/com_hikashop/helpers/helper.php:1062
JROOT/administrator/components/com_hikashop/controllers/import.php:50
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1489
JROOT/administrator/components/com_hikashop/hikashop.php:54
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.08 ms After last query: 0.10 ms Query memory: 0.018 MB Memory before query: 12.514 MB Rows returned: 1
Duplicate queries: #16
SELECT category_id
FROM j3_hikashop_category
WHERE category_parent_id=1
AND category_type='tax'
LIMIT 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/classes/category.php:416
JROOT/administrator/components/com_hikashop/helpers/import.php:99
JROOT/administrator/components/com_hikashop/helpers/importvm.php:24
JROOT/administrator/components/com_hikashop/helpers/helper.php:1062
JROOT/administrator/components/com_hikashop/controllers/import.php:50
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1489
JROOT/administrator/components/com_hikashop/hikashop.php:54
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.18 ms After last query: 0.10 ms Query memory: 0.017 MB Memory before query: 12.533 MB Rows returned: 3
Duplicate queries: #17
SELECT category_id
FROM j3_hikashop_category
WHERE category_type='tax' && category_parent_id=3
ORDER BY category_ordering DESC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE j3_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 109 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/helpers/import.php:101
JROOT/administrator/components/com_hikashop/helpers/importvm.php:24
JROOT/administrator/components/com_hikashop/helpers/helper.php:1062
JROOT/administrator/components/com_hikashop/controllers/import.php:50
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1489
JROOT/administrator/components/com_hikashop/hikashop.php:54
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.91 ms After last query: 0.15 ms Query memory: 0.014 MB Memory before query: 12.546 MB Rows returned: 1
Duplicate queries: #25
SHOW TABLES LIKE 'j3_virtuemart_products'
Explain
EXPLAIN not possible on query: SHOW TABLES LIKE 'j3_virtuemart_products'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/controllers/import.php:53
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1489
JROOT/administrator/components/com_hikashop/hikashop.php:54
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.88 ms After last query: 0.28 ms Query memory: 0.017 MB Memory before query: 12.563 MB Rows returned: 1
Duplicate queries: #24
SHOW TABLES LIKE 'j3_virtuemart_products'
Explain
EXPLAIN not possible on query: SHOW TABLES LIKE 'j3_virtuemart_products'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/helpers/importvm.php:101
JROOT/administrator/components/com_hikashop/helpers/importvm.php:63
JROOT/administrator/components/com_hikashop/controllers/import.php:120
JROOT/administrator/components/com_hikashop/controllers/import.php:73
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1489
JROOT/administrator/components/com_hikashop/hikashop.php:54
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.86 ms After last query: 0.14 ms Query memory: 0.017 MB Memory before query: 12.582 MB Rows returned: 1
SHOW TABLES LIKE 'j3_virtuemart_products_en_gb'
Explain
EXPLAIN not possible on query: SHOW TABLES LIKE 'j3_virtuemart_products_en_gb'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_hikashop/helpers/importvm.php:116
JROOT/administrator/components/com_hikashop/helpers/importvm.php:63
JROOT/administrator/components/com_hikashop/controllers/import.php:120
JROOT/administrator/components/com_hikashop/controllers/import.php:73
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1489
JROOT/administrator/components/com_hikashop/hikashop.php:54
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/administrator.php:98
JROOT/libraries/cms/application/administrator.php:152
JROOT/libraries/cms/application/cms.php:252
JROOT/administrator/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.29 ms After last query: 2.29 ms Query memory: 0.003 MB Memory before query: 12.741 MB
UPDATE `j3_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:13;s:19:\"session.timer.start\";i:1430900528;s:18:\"session.timer.last\";i:1430900662;s:17:\"session.timer.now\";i:1430900667;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:10:\"com_config\";O:8:\"stdClass\":1:{s:6:\"config\";O:8:\"stdClass\":1:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"data\";a:91:{s:7:\"offline\";s:1:\"0\";s:15:\"offline_message\";s:69:\"This site is down for maintenance.Please check back again soon.\";s:23:\"display_offline_message\";s:1:\"1\";s:13:\"offline_image\";s:0:\"\";s:8:\"sitename\";s:3:\"LEC\";s:6:\"editor\";s:7:\"tinymce\";s:7:\"captcha\";s:9:\"recaptcha\";s:10:\"list_limit\";s:2:\"20\";s:6:\"access\";s:1:\"1\";s:5:\"debug\";s:1:\"1\";s:10:\"debug_lang\";s:1:\"0\";s:6:\"dbtype\";s:6:\"mysqli\";s:4:\"host\";s:9:\"localhost\";s:4:\"user\";s:13:\"ssahota_d3m03\";s:8:\"password\";s:8:\"W33tab!X\";s:2:\"db\";s:12:\"ssahota_lec3\";s:8:\"dbprefix\";s:3:\"j3_\";s:9:\"live_site\";s:0:\"\";s:6:\"secret\";s:16:\"VNPXIAXQprnBBNMk\";s:4:\"gzip\";s:1:\"0\";s:15:\"error_reporting\";s:7:\"maximum\";s:7:\"helpurl\";s:90:\"https://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"ftp_host\";s:0:\"\";s:8:\"ftp_port\";s:0:\"\";s:8:\"ftp_user\";s:0:\"\";s:8:\"ftp_pass\";s:0:\"\";s:8:\"ftp_root\";s:0:\"\";s:10:\"ftp_enable\";s:1:\"0\";s:6:\"offset\";s:3:\"UTC\";s:10:\"mailonline\";s:1:\"1\";s:6:\"mailer\";s:4:\"mail\";s:8:\"mailfrom\";s:20:\"sales@leconcepts.com\";s:8:\"fromname\";s:21:\"Leading Edge Concepts\";s:8:\"sendmail\";s:18:\"/usr/sbin/sendmail\";s:8:\"smtpauth\";s:1:\"0\";s:8:\"smtpuser\";s:0:\"\";s:8:\"smtppass\";s:0:\"\";s:8:\"smtphost\";s:9:\"localhost\";s:10:\"smtpsecure\";s:4:\"none\";s:8:\"smtpport\";s:2:\"25\";s:7:\"caching\";s:1:\"0\";s:13:\"cache_handler\";s:4:\"file\";s:9:\"cachetime\";s:2:\"15\";s:8:\"MetaDesc\";s:0:\"\";s:8:\"MetaKeys\";s:0:\"\";s:9:\"MetaTitle\";s:1:\"1\";s:10:\"MetaAuthor\";s:1:\"0\";s:11:\"MetaVersion\";s:1:\"0\";s:6:\"robots\";s:0:\"\";s:3:\"sef\";s:1:\"1\";s:11:\"sef_rewrite\";s:1:\"1\";s:10:\"sef_suffix\";s:1:\"0\";s:12:\"unicodeslugs\";s:1:\"0\";s:10:\"feed_limit\";s:2:\"10\";s:8:\"log_path\";s:31:\"/home/demo3lec/public_html/logs\";s:8:\"tmp_path\";s:30:\"/home/demo3lec/public_html/tmp\";s:8:\"lifetime\";s:2:\"15\";s:15:\"session_handler\";s:8:\"database\";s:16:\"memcache_persist\";s:1:\"1\";s:17:\"memcache_compress\";s:1:\"0\";s:20:\"memcache_server_host\";s:9:\"localhost\";s:20:\"memcache_server_port\";s:5:\"11211\";s:17:\"memcached_persist\";s:1:\"1\";s:18:\"memcached_compress\";s:1:\"0\";s:21:\"memcached_server_host\";s:9:\"localhost\";s:21:\"memcached_server_port\";s:5:\"11211\";s:13:\"redis_persist\";s:1:\"1\";s:17:\"redis_server_host\";s:9:\"localhost\";s:17:\"redis_server_port\";s:4:\"6379\";s:17:\"redis_server_auth\";s:0:\"\";s:15:\"redis_server_db\";s:1:\"0\";s:12:\"proxy_enable\";s:1:\"0\";s:10:\"proxy_host\";s:0:\"\";s:10:\"proxy_port\";s:0:\"\";s:10:\"proxy_user\";s:0:\"\";s:10:\"proxy_pass\";s:0:\"\";s:11:\"massmailoff\";s:1:\"1\";s:10:\"MetaRights\";s:0:\"\";s:19:\"sitename_pagetitles\";s:1:\"1\";s:9:\"force_ssl\";s:1:\"0\";s:28:\"session_memcache_server_host\";s:9:\"localhost\";s:28:\"session_memcache_server_port\";s:5:\"11211\";s:29:\"session_memcached_server_host\";s:9:\"localhost\";s:29:\"session_memcached_server_port\";s:5:\"11211\";s:12:\"frontediting\";s:1:\"1\";s:10:\"feed_email\";s:6:\"author\";s:13:\"cookie_domain\";s:0:\"\";s:11:\"cookie_path\";s:0:\"\";s:8:\"asset_id\";i:1;s:7:\"filters\";a:8:{i:1;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:6;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:7;a:3:{s:11:\"filter_type\";s:4:\"NONE\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:2;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:3;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:4;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:5;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:8;a:3:{s:11:\"filter_type\";s:4:\"NONE\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}}s:5:\"rules\";a:10:{s:15:\"core.login.site\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:1:\"1\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:16:\"core.login.admin\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:18:\"core.login.offline\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:10:\"core.admin\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:1:\"1\";}s:11:\"core.manage\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:1:\"1\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:11:\"core.create\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:1:\"1\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:11:\"core.delete\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:9:\"core.edit\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:1:\"1\";i:5;s:0:\"\";i:8;s:0:\"\";}s:15:\"core.edit.state\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:1:\"1\";i:8;s:0:\"\";}s:13:\"core.edit.own\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:1:\"1\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}}}}}}s:22:\"com_hikashopvmvmPrefix\";s:3:\"j3_\";s:22:\"com_hikashopvmlanguage\";s:5:\"en_gb\";}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":28:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"630\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:22:\"nigel.lettin@gmail.com\";s:8:\"password\";s:60:\"$2y$10$NQW5I.ii0tULz4uDI7iz8OO8sN4OBq/DZXyil.OxYx131njqiIk5K\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2015-04-22 14:56:27\";s:13:\"lastvisitDate\";s:19:\"2015-05-05 16:37:17\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"8b783d67e9b33ef3d3e0c37c8c692d80\";}check_anticopy_framing|N;check_contentprotect_framing|N;'
, `time` = '1430900668'
WHERE `session_id` = 'bd80114189ccbbf84f300950750baa27'
Explain
EXPLAIN not possible on query: UPDATE `j3_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:13;s:19:\"session.timer.start\";i:1430900528;s:18:\"session.timer.last\";i:1430900662;s:17:\"session.timer.now\";i:1430900667;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:10:\"com_config\";O:8:\"stdClass\":1:{s:6:\"config\";O:8:\"stdClass\":1:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"data\";a:91:{s:7:\"offline\";s:1:\"0\";s:15:\"offline_message\";s:69:\"This site is down for maintenance.Please check back again soon.\";s:23:\"display_offline_message\";s:1:\"1\";s:13:\"offline_image\";s:0:\"\";s:8:\"sitename\";s:3:\"LEC\";s:6:\"editor\";s:7:\"tinymce\";s:7:\"captcha\";s:9:\"recaptcha\";s:10:\"list_limit\";s:2:\"20\";s:6:\"access\";s:1:\"1\";s:5:\"debug\";s:1:\"1\";s:10:\"debug_lang\";s:1:\"0\";s:6:\"dbtype\";s:6:\"mysqli\";s:4:\"host\";s:9:\"localhost\";s:4:\"user\";s:13:\"ssahota_d3m03\";s:8:\"password\";s:8:\"W33tab!X\";s:2:\"db\";s:12:\"ssahota_lec3\";s:8:\"dbprefix\";s:3:\"j3_\";s:9:\"live_site\";s:0:\"\";s:6:\"secret\";s:16:\"VNPXIAXQprnBBNMk\";s:4:\"gzip\";s:1:\"0\";s:15:\"error_reporting\";s:7:\"maximum\";s:7:\"helpurl\";s:90:\"https://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"ftp_host\";s:0:\"\";s:8:\"ftp_port\";s:0:\"\";s:8:\"ftp_user\";s:0:\"\";s:8:\"ftp_pass\";s:0:\"\";s:8:\"ftp_root\";s:0:\"\";s:10:\"ftp_enable\";s:1:\"0\";s:6:\"offset\";s:3:\"UTC\";s:10:\"mailonline\";s:1:\"1\";s:6:\"mailer\";s:4:\"mail\";s:8:\"mailfrom\";s:20:\"sales@leconcepts.com\";s:8:\"fromname\";s:21:\"Leading Edge Concepts\";s:8:\"sendmail\";s:18:\"/usr/sbin/sendmail\";s:8:\"smtpauth\";s:1:\"0\";s:8:\"smtpuser\";s:0:\"\";s:8:\"smtppass\";s:0:\"\";s:8:\"smtphost\";s:9:\"localhost\";s:10:\"smtpsecure\";s:4:\"none\";s:8:\"smtpport\";s:2:\"25\";s:7:\"caching\";s:1:\"0\";s:13:\"cache_handler\";s:4:\"file\";s:9:\"cachetime\";s:2:\"15\";s:8:\"MetaDesc\";s:0:\"\";s:8:\"MetaKeys\";s:0:\"\";s:9:\"MetaTitle\";s:1:\"1\";s:10:\"MetaAuthor\";s:1:\"0\";s:11:\"MetaVersion\";s:1:\"0\";s:6:\"robots\";s:0:\"\";s:3:\"sef\";s:1:\"1\";s:11:\"sef_rewrite\";s:1:\"1\";s:10:\"sef_suffix\";s:1:\"0\";s:12:\"unicodeslugs\";s:1:\"0\";s:10:\"feed_limit\";s:2:\"10\";s:8:\"log_path\";s:31:\"/home/demo3lec/public_html/logs\";s:8:\"tmp_path\";s:30:\"/home/demo3lec/public_html/tmp\";s:8:\"lifetime\";s:2:\"15\";s:15:\"session_handler\";s:8:\"database\";s:16:\"memcache_persist\";s:1:\"1\";s:17:\"memcache_compress\";s:1:\"0\";s:20:\"memcache_server_host\";s:9:\"localhost\";s:20:\"memcache_server_port\";s:5:\"11211\";s:17:\"memcached_persist\";s:1:\"1\";s:18:\"memcached_compress\";s:1:\"0\";s:21:\"memcached_server_host\";s:9:\"localhost\";s:21:\"memcached_server_port\";s:5:\"11211\";s:13:\"redis_persist\";s:1:\"1\";s:17:\"redis_server_host\";s:9:\"localhost\";s:17:\"redis_server_port\";s:4:\"6379\";s:17:\"redis_server_auth\";s:0:\"\";s:15:\"redis_server_db\";s:1:\"0\";s:12:\"proxy_enable\";s:1:\"0\";s:10:\"proxy_host\";s:0:\"\";s:10:\"proxy_port\";s:0:\"\";s:10:\"proxy_user\";s:0:\"\";s:10:\"proxy_pass\";s:0:\"\";s:11:\"massmailoff\";s:1:\"1\";s:10:\"MetaRights\";s:0:\"\";s:19:\"sitename_pagetitles\";s:1:\"1\";s:9:\"force_ssl\";s:1:\"0\";s:28:\"session_memcache_server_host\";s:9:\"localhost\";s:28:\"session_memcache_server_port\";s:5:\"11211\";s:29:\"session_memcached_server_host\";s:9:\"localhost\";s:29:\"session_memcached_server_port\";s:5:\"11211\";s:12:\"frontediting\";s:1:\"1\";s:10:\"feed_email\";s:6:\"author\";s:13:\"cookie_domain\";s:0:\"\";s:11:\"cookie_path\";s:0:\"\";s:8:\"asset_id\";i:1;s:7:\"filters\";a:8:{i:1;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:6;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:7;a:3:{s:11:\"filter_type\";s:4:\"NONE\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:2;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:3;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:4;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:5;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:8;a:3:{s:11:\"filter_type\";s:4:\"NONE\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}}s:5:\"rules\";a:10:{s:15:\"core.login.site\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:1:\"1\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:16:\"core.login.admin\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:18:\"core.login.offline\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:10:\"core.admin\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:1:\"1\";}s:11:\"core.manage\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:1:\"1\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:11:\"core.create\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:1:\"1\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:11:\"core.delete\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:9:\"core.edit\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:1:\"1\";i:5;s:0:\"\";i:8;s:0:\"\";}s:15:\"core.edit.state\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:1:\"1\";i:8;s:0:\"\";}s:13:\"core.edit.own\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:1:\"1\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}}}}}}s:22:\"com_hikashopvmvmPrefix\";s:3:\"j3_\";s:22:\"com_hikashopvmlanguage\";s:5:\"en_gb\";}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":28:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"630\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:22:\"nigel.lettin@gmail.com\";s:8:\"password\";s:60:\"$2y$10$NQW5I.ii0tULz4uDI7iz8OO8sN4OBq/DZXyil.OxYx131njqiIk5K\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2015-04-22 14:56:27\";s:13:\"lastvisitDate\";s:19:\"2015-05-05 16:37:17\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"8b783d67e9b33ef3d3e0c37c8c692d80\";}check_anticopy_framing|N;check_contentprotect_framing|N;' , `time` = '1430900668' WHERE `session_id` = 'bd80114189ccbbf84f300950750baa27'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:84
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
15 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
9 × SELECT category_id
FROM j3_hikashop_category
2 × SELECT *
FROM j3_hikashop_characteristic
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
1 × SELECT *
FROM j3_hikashop_field as a
1 × SELECT a.id
FROM j3_user_usergroup_map AS map
LEFT JOIN j3_usergroups AS a
ON a.id = map.group_id
1 × SELECT *
FROM j3_hikashop_confi
1 × SELECT folder AS type, element AS name, params
FROM j3_extensions
1 × SELECT template, s.params
FROM j3_template_styles as s
LEFT JOIN j3_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
1 × SELECT `data`
FROM `j3_session`
OTHER Tables:
2 × SHOW TABLES LIKE 'j3_virtuemart_products
2 × SHOW FULL COLUMNS
FROM `j3_hikashop_product
1 × UPDATE `j3_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:13;s:19:\"session.timer.start\";i:1430900528;s:18:\"session.timer.last\";i:1430900662;s:17:\"session.timer.now\";i:1430900667;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:10:\"com_config\";O:8:\"stdClass\":1:{s:6:\"config\";O:8:\"stdClass\":1:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"data\";a:91:{s:7:\"offline\";s:1:\"0\";s:15:\"offline_message\";s:69:\"This site is down for maintenance.Please check back again soon.\";s:23:\"display_offline_message\";s:1:\"1\";s:13:\"offline_image\";s:0:\"\";s:8:\"sitename\";s:3:\"LEC\";s:6:\"editor\";s:7:\"tinymce\";s:7:\"captcha\";s:9:\"recaptcha\";s:10:\"list_limit\";s:2:\"20\";s:6:\"access\";s:1:\"1\";s:5:\"debug\";s:1:\"1\";s:10:\"debug_lang\";s:1:\"0\";s:6:\"dbtype\";s:6:\"mysqli\";s:4:\"host\";s:9:\"localhost\";s:4:\"user\";s:13:\"ssahota_d3m03\";s:8:\"password\";s:8:\"W33tab!X\";s:2:\"db\";s:12:\"ssahota_lec3\";s:8:\"dbprefix\";s:3:\"j3_\";s:9:\"live_site\";s:0:\"\";s:6:\"secret\";s:16:\"VNPXIAXQprnBBNMk\";s:4:\"gzip\";s:1:\"0\";s:15:\"error_reporting\";s:7:\"maximum\";s:7:\"helpurl\";s:90:\"https://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"ftp_host\";s:0:\"\";s:8:\"ftp_port\";s:0:\"\";s:8:\"ftp_user\";s:0:\"\";s:8:\"ftp_pass\";s:0:\"\";s:8:\"ftp_root\";s:0:\"\";s:10:\"ftp_enable\";s:1:\"0\";s:6:\"offset\";s:3:\"UTC\";s:10:\"mailonline\";s:1:\"1\";s:6:\"mailer\";s:4:\"mail\";s:8:\"mailfrom\";s:20:\"sales@leconcepts.com\";s:8:\"fromname\";s:21:\"Leading Edge Concepts\";s:8:\"sendmail\";s:18:\"/usr/sbin/sendmail\";s:8:\"smtpauth\";s:1:\"0\";s:8:\"smtpuser\";s:0:\"\";s:8:\"smtppass\";s:0:\"\";s:8:\"smtphost\";s:9:\"localhost\";s:10:\"smtpsecure\";s:4:\"none\";s:8:\"smtpport\";s:2:\"25\";s:7:\"caching\";s:1:\"0\";s:13:\"cache_handler\";s:4:\"file\";s:9:\"cachetime\";s:2:\"15\";s:8:\"MetaDesc\";s:0:\"\";s:8:\"MetaKeys\";s:0:\"\";s:9:\"MetaTitle\";s:1:\"1\";s:10:\"MetaAuthor\";s:1:\"0\";s:11:\"MetaVersion\";s:1:\"0\";s:6:\"robots\";s:0:\"\";s:3:\"sef\";s:1:\"1\";s:11:\"sef_rewrite\";s:1:\"1\";s:10:\"sef_suffix\";s:1:\"0\";s:12:\"unicodeslugs\";s:1:\"0\";s:10:\"feed_limit\";s:2:\"10\";s:8:\"log_path\";s:31:\"/home/demo3lec/public_html/logs\";s:8:\"tmp_path\";s:30:\"/home/demo3lec/public_html/tmp\";s:8:\"lifetime\";s:2:\"15\";s:15:\"session_handler\";s:8:\"database\";s:16:\"memcache_persist\";s:1:\"1\";s:17:\"memcache_compress\";s:1:\"0\";s:20:\"memcache_server_host\";s:9:\"localhost\";s:20:\"memcache_server_port\";s:5:\"11211\";s:17:\"memcached_persist\";s:1:\"1\";s:18:\"memcached_compress\";s:1:\"0\";s:21:\"memcached_server_host\";s:9:\"localhost\";s:21:\"memcached_server_port\";s:5:\"11211\";s:13:\"redis_persist\";s:1:\"1\";s:17:\"redis_server_host\";s:9:\"localhost\";s:17:\"redis_server_port\";s:4:\"6379\";s:17:\"redis_server_auth\";s:0:\"\";s:15:\"redis_server_db\";s:1:\"0\";s:12:\"proxy_enable\";s:1:\"0\";s:10:\"proxy_host\";s:0:\"\";s:10:\"proxy_port\";s:0:\"\";s:10:\"proxy_user\";s:0:\"\";s:10:\"proxy_pass\";s:0:\"\";s:11:\"massmailoff\";s:1:\"1\";s:10:\"MetaRights\";s:0:\"\";s:19:\"sitename_pagetitles\";s:1:\"1\";s:9:\"force_ssl\";s:1:\"0\";s:28:\"session_memcache_server_host\";s:9:\"localhost\";s:28:\"session_memcache_server_port\";s:5:\"11211\";s:29:\"session_memcached_server_host\";s:9:\"localhost\";s:29:\"session_memcached_server_port\";s:5:\"11211\";s:12:\"frontediting\";s:1:\"1\";s:10:\"feed_email\";s:6:\"author\";s:13:\"cookie_domain\";s:0:\"\";s:11:\"cookie_path\";s:0:\"\";s:8:\"asset_id\";i:1;s:7:\"filters\";a:8:{i:1;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:6;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:7;a:3:{s:11:\"filter_type\";s:4:\"NONE\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:2;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:3;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:4;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:5;a:3:{s:11:\"filter_type\";s:2:\"BL\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:8;a:3:{s:11:\"filter_type\";s:4:\"NONE\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}}s:5:\"rules\";a:10:{s:15:\"core.login.site\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:1:\"1\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:16:\"core.login.admin\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:18:\"core.login.offline\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:10:\"core.admin\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:1:\"1\";}s:11:\"core.manage\";a:8:{i:1;s:0:\"\";i:6;s:0:\"\";i:7;s:1:\"1\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:11:\"core.create\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:1:\"1\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:11:\"core.delete\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}s:9:\"core.edit\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:1:\"1\";i:5;s:0:\"\";i:8;s:0:\"\";}s:15:\"core.edit.state\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:0:\"\";i:4;s:0:\"\";i:5;s:1:\"1\";i:8;s:0:\"\";}s:13:\"core.edit.own\";a:8:{i:1;s:0:\"\";i:6;s:1:\"1\";i:7;s:0:\"\";i:2;s:0:\"\";i:3;s:1:\"1\";i:4;s:0:\"\";i:5;s:0:\"\";i:8;s:0:\"\";}}}}}}s:22:\"com_hikashopvmvmPrefix\";s:3:\"j3_\";s:22:\"com_hikashopvmlanguage\";s:5:\"en_gb\";}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":28:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"630\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:22:\"nigel.lettin@gmail.com\";s:8:\"password\";s:60:\"$2y$10$NQW5I.ii0tULz4uDI7iz8OO8sN4OBq/DZXyil.OxYx131njqiIk5K\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2015-04-22 14:56:27\";s:13:\"lastvisitDate\";s:19:\"2015-05-05 16:37:17\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"8b783d67e9b33ef3d3e0c37c8c692d80\";}check_anticopy_framing|N;check_contentprotect_framing|N;' , `time` = '1430900668'
1 × SHOW TABLES LIKE 'j3_virtuemart_products_en_gb
1 × UPDATE `j3_extensions`
SET `params` = '{\"mediaversion\":\"6262967d85df0fcb2b9fa3a905fe000e\"}'
1 × DELETE
FROM `j3_session`Please Log in or Create an account to join the conversation.
Hi,
Delete all the hikashop_ tables from your database via your phpmyadmin, install HikaShop again so that it can add all the tables again with the default data and then you can run the import again.
Please Log in or Create an account to join the conversation.
Topic Author
OK, so I've spent quite a few hours configuring HikaShop ... payment types, currencies, categories etc.. so I'm a bit reluctant to delete all the tables. Is there another way around this? Maybe just delete the product information and / or reset the history.
Please Log in or Create an account to join the conversation.
Well, then you can just delete the tables you don't want instead of deleting them all. HikaShop will then recreate only the missing tables when you install it.
But it's more complex because you might get stuff twice in the database for some type of elements, you also need to clear the hikashop_vm_prod table and you want to remove the entries vm_import_last_vm_prod and vm_import_max_hk_prod from the hikashop_config table.
I highly recommend to backup before such manipulations as you might end up screwing your data.
Please Log in or Create an account to join the conversation.
Topic Author
OK, so I managed to get all the products, users and orders migrated in but the images failed.
I've now ended up with around 10 blank images per product - is there a way to delete these and try re-importing them? What file(s) do I need to delete or can I copy over the files using FTP and put them into the correct HikaShop product images folder?
Please Log in or Create an account to join the conversation.
Hi,
Did the original product also had 10 images ?
In that case, that would mean that the links between the products and the images are correct in the database, and all you need to do is to copy all the images from VirtueMart in the images/com_hikashop/upload folder of your website and the system will be able to use them automatically.
Please Log in or Create an account to join the conversation.
Topic Author
No, this is happening for all products where there was a problem with the image in virtuemart. Is there a way to easily delete all these using phpmyadmin?
Please Log in or Create an account to join the conversation.
It's gonna be complex if you don't want to remove all the images of all the products as there is no way of knowing if the image entry in the database it wrong or not.
Please Log in or Create an account to join the conversation.
Topic Author
[quote="nicolas" post=201192all you need to do is to copy all the images from VirtueMart in the images/com_hikashop/upload folder of your website and the system will be able to use them automatically.[/quote]
All the images are in the correct folder for Hikashop but NONE of them are showing?? They are correct in Virtuemart but didn't seem to import across. Are there supposed to be product thumbnails in the Hikashop image folders?
This is a serious issue as I have nearly 1500 products and I have other major issues importing from virtuemart too;
1) It is not importing the correct prices with tax so I now have to assign a tax cagtegory to each product.
2) It seems to be adding a downloadable file to each product (that is a different product)
3) Related products are not being imported so this is another huge piece of work
Please Log in or Create an account to join the conversation.
Hi,
Ok, clear the HikaShop product tables and try differently. Instead of using the virtuemart import, export your products from VirtueMart with CSVimproved and import them back to HikaShop with the same tool. That should circumvent the issues you have.
Please Log in or Create an account to join the conversation.
Topic Author
I'm not sure that using CSVI in an option anymore as I have spent quite a while cleaning up the products within HikaShop. At this stage I would just like to delete all the hikashop product images in the database and re-upload them but I can't find any reference to product images anywhere in the hikashop database tables? Can you tell me how they are referenced please and I will sort it directly on the database.
UPDATE - OK, I've found it - xxx_hikashop_file contained all the images links. I am uploading all the images by hand to ensure that they get embedded into the Db correctly this time.
The Hikashop import tool needs some work - I was importing the products OK into J3 from J1.5 using the VM migrator tool (from daycounts) so there is a problem with your import tool.
The only thing I'm missing now are discounted prices which don't seem to have been imported either.
Please Log in or Create an account to join the conversation.
Hi,
From what you're saying, it seems that you were importing from VirtueMart 3. The import tool has only been tested with VirtueMart 1 and 2 for now. So that would explain why you had these issues.
The import should also handle the import of discounts. But I'm not sure that you're talking about standard discounts ?
Again it could come from the same cause as your other problems with the import.
Please Log in or Create an account to join the conversation.
Topic Author
Hello, is there any change on importing orders and users from VM3 as I now need to import over a years worth of orders and users?
I have bought CVSI Pro (no free version available for J3) but it is not clear what columns I need to use from both VM and HikaShop.
I exported a VM order and there are 28 columns which will need transposing to the correct HikaShop tables - this is proving to be a real headache - is there a ready made template available for me to use in CVSI Pro?
This is a big deal for anyone wanting to 'upgrade' to HikaShop from VM3.
Please Log in or Create an account to join the conversation.
Hi,
We've had several users of HikaShop migrating from VM3 to HikaShop with the import tool, so as far as I know the import from VM3 works fine.
You can do that via the menu Products>Import in HikaShop.
It will be way easier than trying to import data via CSV files.
Please Log in or Create an account to join the conversation.
Topic Author
Thanks Nicolas, I'm having issues with users and orders (products seem to work OK apart from the images are not showing).
I need to update HikaShop today and will re-try the import - do I need to reset anything so that it can try and re-import the new data?
UPDATE - I updated Hikashop and re-ran the HikaShop Import tool and it picked up 11 new orders (which it missed when I tried last time). However, I need to go back further than the last 11 orders (last Month) - how can I do this without messing my data up? As mentioned above, I primarily interested in orders and users (the products imported OK).
Thanks
Please Log in or Create an account to join the conversation.
Hi,
Mmm. It would be better to revert the database if that's possible. Otherwise, you might have to update the pointers in hikashop_config (at the end of the entries) or clear some of the HikaShop tables to get the system to try importing the data again if the data wasn't completely imported.
Please Log in or Create an account to join the conversation.
