Error after Joomla Update 3.2.3 / 3.3.0

  • Posts: 33
  • Thank you received: 0
11 years 2 months ago #155059

:( -- url of the page with the problem -- : mywebsite.com/mypage
-- HikaShop version -- : 2.3.0
-- Joomla version -- : 3.2.3
-- PHP version -- : 5
-- Browser(s) name and version -- : Firefox 28.0
-- Error-message(debug-mod must be tuned on) -- : Error_message
-- Protostar template

An error has occurred.
0 SQL=SELECT category_id FROM syi7r_hikashop_category WHERE category_parent_id= AND category_type='product' LIMIT 1

Hello Everyone,

I stupidly upgraded Joomla 3.2.3 to 3.3.0 and quickly found the hikashop link in the component menu in the backend to give a 1064 error. Googling the error did not return much hope so I chose to restore a backup.
My last Akeeba backup is 8 days ago so that was too long ago, I turned to my ISP backup of yesterday which was still based on the J3.2.3 version.

I restored the files and there were two databases also, restored everything successfully, now when I click on the hikashop link in the components menu in the backend, I get the error listed above.

I have no idea what this means or how to fix it. The front end looks fine.
www.madman.co.za
Anyone got any ideas ?

Thanks,
Brian

Engine Monitoring and Performance Systems

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

  • Posts: 26260
  • Thank you received: 4042
  • MODERATOR
11 years 2 months ago #155061

Hi,

First, please use the joomla driver "mysqli" and not the "mysql" one.
The Joomla patchs I made were included in the "mysqli" and not yet in the "mysql" one, so the real error message are not displayed correctly if you are not using the "mysqli" driver.

The error in your query is that there is no id for the "category_parent_id".
We have to know the exact context you got this error, so we can know when this query is execute and why there is no id in the SQL query.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 33
  • Thank you received: 0
11 years 2 months ago #155107

Hi Jerome,
Thank you for your response,
I changed the database from Mysql to mysqli in the global system setup in Joomla backend ?
Now the error code has changed back to what it was after I did the J3.3.0 upgrade:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND category_type='status' LIMIT 1' at line 1 SQL=SELECT category_id FROM syi7r_hikashop_category WHERE category_parent_id= AND category_type='status' LIMIT 1

Clearly the J3.3.0 upgrade and subsequent restore back to J2.3.2 has left something un-restored.

I get this error when clicking on the HikaShop link under the Components tab in Joomla 3.2.3 backend.
The same error happens when I click on :
Products
Catalog
Configuration

The other menu items go to the menu correctly.

Where do you suggest I look now ?
Regards
Brian

Engine Monitoring and Performance Systems
Last edit: 11 years 2 months ago by MadMan. Reason: more info added regarding the error

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

  • Posts: 26260
  • Thank you received: 4042
  • MODERATOR
11 years 2 months ago #155155

Hi,

Could you please activate the debug mode in the Joomla global configuration ?
In the printed debug, you will see a "Database Queries". By clicking on it you will see all queries made in the page.
You will be able to see the query with the error and you will click on the "Call Stack" just below.
At this moment, you will have the call stack which will help us to understand which element, which part of code, has made this wrong query.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 33
  • Thank you received: 0
11 years 2 months ago #155180

Jerome,

Here is a cut and paste of the listing with all **explain** and **call stack** info

I will be away this week end - leaving in about 6 hours time, be back Sunday, so I don't stress if I do not respond then .

Regards (and thanks)
Brian

**Joomla! Debug Console**
**Session**
**Profile Information**
**Memory Usage**
**Database Queries**
**16 Queries Logged** 42.3 ms

    1. **Query Time: 0.50 ms** **Query memory: 0.007 MB Memory before query: 1.400 MB** **Rows returned: 1**

    SELECT `data`

      FROM `syi7r_session`

      WHERE `session_id` = '8mir0njs32lk4smhtj8g156ks1'

    **Explain**
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	syi7r_session	const	PRIMARY	PRIMARY	602	const	1	
    **Profile**
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking privileges on cached 	0.0 ms
    checking permissions	0.0 ms
    sending cached result to clien	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/libraries/joomla/session/storage/database.php:46
    JROOT/libraries/joomla/session/session.php:658
    JROOT/libraries/joomla/session/session.php:596
    JROOT/libraries/cms/application/cms.php:672
    JROOT/libraries/cms/application/cms.php:131
    JROOT/libraries/cms/application/administrator.php:45
    JROOT/libraries/cms/application/cms.php:332
    JROOT/libraries/joomla/factory.php:124
    JROOT/administrator/index.php:39
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]
    
2. **Query Time: 7.13 ms** **After last query: 1.23 ms** **Query memory: 0.004 MB Memory before query: 1.464 MB**

    DELETE 

      FROM `syi7r_session`

      WHERE `time` < '1399644531'

    **Explain**
    **EXPLAIN not possible on query: DELETE FROM `syi7r_session` WHERE `time` < '1399644531'**
    **Profile**
    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    init	0.1 ms
    updating	0.1 ms
    end	0.0 ms
    Waiting for query cache lock	0.0 ms
    end	0.1 ms
    query end	6.3 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/libraries/cms/application/cms.php:689
    JROOT/libraries/cms/application/cms.php:131
    JROOT/libraries/cms/application/administrator.php:45
    JROOT/libraries/cms/application/cms.php:332
    JROOT/libraries/joomla/factory.php:124
    JROOT/administrator/index.php:39
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]
    
3. **Query Time: 3.86 ms** **After last query: 18.92 ms** **Query memory: 0.007 MB Memory before query: 1.846 MB** **Rows returned: 73**

    SELECT folder AS type, element AS name, params

      FROM syi7r_extensions

      WHERE enabled >= 1 
      AND type ='plugin' 
      AND state >= 0 
      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	syi7r_extensions	ALL	extension	**NO INDEX KEY COULD BE USED**	NULL	NULL	190	Using where; **Using filesort**
    **Profile**
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.1 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sorting result	0.3 ms
    Sending data	0.1 ms
    Waiting for query cache lock	0.0 ms
    Sending data	0.5 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.1 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/libraries/cms/plugin/helper.php:312
    JROOT/libraries/cms/plugin/helper.php:88
    JROOT/libraries/cms/plugin/helper.php:130
    JROOT/libraries/cms/application/cms.php:573
    JROOT/libraries/cms/application/administrator.php:285
    JROOT/libraries/cms/application/administrator.php:116
    JROOT/libraries/cms/application/cms.php:255
    JROOT/administrator/index.php:42
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]
    
4.**Query Time: 1.02 ms** **After last query: 44.78 ms** **Query memory: 0.012 MB Memory before query: 3.073 MB** **Rows returned: 1**

    SELECT extension_id AS id, element AS "option", params, enabled

      FROM syi7r_extensions

      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    **Explain**
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	syi7r_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where
    **Profile**
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/libraries/joomla/cache/controller/callback.php:158
    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:179
    JROOT/libraries/joomla/factory.php:734
    JROOT/libraries/joomla/factory.php:215
    JROOT/plugins/system/sef/sef.php:30
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/libraries/cms/application/administrator.php:448
    JROOT/libraries/cms/application/administrator.php:137
    JROOT/libraries/cms/application/cms.php:255
    JROOT/administrator/index.php:42
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]
   
5. **Query Time: 6.04 ms** **After last query: 0.35 ms** **Query memory: 0.010 MB Memory before query: 3.070 MB**

    UPDATE `syi7r_extensions`

      SET `params` = '{\"mediaversion\":\"81dad8ef00070c1ce3af1766a062e698\"}'

      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    **Explain**
    **EXPLAIN not possible on query: UPDATE `syi7r_extensions` SET `params` = '{\"mediaversion\":\"81dad8ef00070c1ce3af1766a062e698\"}' WHERE `type` = 'library' AND `element` = 'joomla'**
    **Profile**
    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    init	0.1 ms
    Updating	0.1 ms
    end	0.0 ms
    Waiting for query cache lock	0.0 ms
    end	2.6 ms
    query end	2.9 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/libraries/cms/library/helper.php:119
    JROOT/libraries/cms/version/version.php:230
    JROOT/libraries/cms/version/version.php:189
    JROOT/libraries/joomla/factory.php:734
    JROOT/libraries/joomla/factory.php:215
    JROOT/plugins/system/sef/sef.php:30
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/libraries/cms/application/administrator.php:448
    JROOT/libraries/cms/application/administrator.php:137
    JROOT/libraries/cms/application/cms.php:255
    JROOT/administrator/index.php:42
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]

6.    **Query Time: 1.12 ms** **After last query: 2.65 ms** **Query memory: 0.004 MB Memory before query: 3.201 MB** **Rows returned: 1**

    SELECT template, s.params

      FROM syi7r_template_styles as s

      LEFT JOIN syi7r_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	2	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	madman_db2.s.template,const	1	
    **Profile**
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache lock	0.1 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.2 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/libraries/cms/application/administrator.php:203
    JROOT/libraries/cms/application/administrator.php:82
    JROOT/libraries/cms/application/administrator.php:143
    JROOT/libraries/cms/application/cms.php:255
    JROOT/administrator/index.php:42
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]

7.    **Query Time: 0.95 ms** **After last query: 4.62 ms** **Query memory: 0.008 MB Memory before query: 3.284 MB** **Rows returned: 1**

    SELECT extension_id AS id, element AS "option", params, enabled

      FROM syi7r_extensions

      WHERE `type` = 'component' 
      AND `element` = 'com_hikashop'

    **Explain**
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	syi7r_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where
    **Profile**
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:73
    JROOT/libraries/cms/component/helper.php:320
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:143
    JROOT/libraries/cms/application/cms.php:255
    JROOT/administrator/index.php:42
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]

8.    **Query Time: 4.46 ms** **After last query: 21.96 ms** **Query memory: 0.008 MB Memory before query: 4.114 MB** **Rows returned: 263**

    SELECT * 
      FROM syi7r_hikashop_config

    **Explain**
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	syi7r_hikashop_config	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	263	
    **Profile**
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking privileges on cached 	0.0 ms
    checking permissions	0.0 ms
    sending cached result to clien	0.6 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/administrator/components/com_hikashop/classes/config.php:16
    JROOT/administrator/components/com_hikashop/helpers/helper.php:837
    JROOT/administrator/components/com_hikashop/helpers/helper.php:2578
    JROOT/administrator/components/com_hikashop/hikashop.php:14
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:143
    JROOT/libraries/cms/application/cms.php:255
    JROOT/administrator/index.php:42
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]
 
 9.  **Query Time: 0.82 ms** **After last query: 84.55 ms** **Query memory: 0.012 MB Memory before query: 6.877 MB** **Rows returned: 3**

    SELECT * 
      FROM syi7r_hikashop_widget 
      WHERE widget_published=1 
      ORDER BY widget_ordering ASC

    **Explain**
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	syi7r_hikashop_widget	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	11	Using where; **Using filesort**
    **Profile**
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking privileges on cached 	0.0 ms
    checking permissions	0.0 ms
    sending cached result to clien	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/administrator/components/com_hikashop/classes/widget.php:35
    JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:73
    JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22
    JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/administrator/components/com_hikashop/helpers/helper.php:1323
    JROOT/administrator/components/com_hikashop/helpers/helper.php:1072
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_hikashop/helpers/helper.php:1311
    JROOT/administrator/components/com_hikashop/hikashop.php:54
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:143
    JROOT/libraries/cms/application/cms.php:255
    JROOT/administrator/index.php:42
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]

10.    **Query Time: 1.69 ms** **After last query: 0.41 ms** **Query memory: 0.012 MB Memory before query: 6.919 MB** **Rows returned: 0**

    SELECT b.*,a.* 
      FROM syi7r_hikashop_order AS a 
      LEFT JOIN syi7r_hikashop_user AS b 
      ON a.order_user_id=b.user_id  
      WHERE a.order_type='sale' 
      AND a.order_created > 1398895200 
      AND a.order_created < 1399645731 
      ORDER BY a.order_created DESC 
      LIMIT 7

    **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	2	Using where; **Using filesort**
    1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	madman_db2.a.order_user_id	1	
    **Profile**
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.5 ms
    System lock	0.1 ms
    Waiting for query cache lock	0.0 ms
    init	0.1 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sorting result	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.1 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/administrator/components/com_hikashop/classes/widget.php:1195
    JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83
    JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22
    JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/administrator/components/com_hikashop/helpers/helper.php:1323
    JROOT/administrator/components/com_hikashop/helpers/helper.php:1072
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_hikashop/helpers/helper.php:1311
    JROOT/administrator/components/com_hikashop/hikashop.php:54
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:143
    JROOT/libraries/cms/application/cms.php:255
    JROOT/administrator/index.php:42
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]

11.    **Query Time: 0.32 ms** **After last query: 0.16 ms** **Query memory: 0.016 MB Memory before query: 6.934 MB** **Rows returned: 0**

    SELECT category_id 
      FROM syi7r_hikashop_category 
      WHERE category_type='root' 
      LIMIT 1

    **Explain**
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	syi7r_hikashop_category	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	45	Using where
    **Profile**
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking privileges on cached 	0.0 ms
    checking permissions	0.0 ms
    sending cached result to clien	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/administrator/components/com_hikashop/classes/category.php:374
    JROOT/administrator/components/com_hikashop/classes/category.php:380
    JROOT/administrator/components/com_hikashop/classes/category.php:421
    JROOT/administrator/components/com_hikashop/classes/category.php:386
    JROOT/administrator/components/com_hikashop/classes/category.php:511
    JROOT/administrator/components/com_hikashop/classes/widget.php:1460
    JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83
    JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22
    JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/administrator/components/com_hikashop/helpers/helper.php:1323
    JROOT/administrator/components/com_hikashop/helpers/helper.php:1072
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_hikashop/helpers/helper.php:1311
    JROOT/administrator/components/com_hikashop/hikashop.php:54
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:143
    JROOT/libraries/cms/application/cms.php:255
    JROOT/administrator/index.php:42
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]
  
12.  **Query Time: 0.34 ms** **After last query: 0.15 ms** **Query memory: 0.015 MB Memory before query: 6.950 MB**

    SELECT category_id 
      FROM syi7r_hikashop_category 
      WHERE category_parent_id= 
      AND category_type='status' 
      LIMIT 1

    **Explain**
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND category_type='status' LIMIT 1' at line 1 SQL=EXPLAIN SELECT category_id FROM syi7r_hikashop_category WHERE category_parent_id= AND category_type='status' LIMIT 1
    **Profile**
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/administrator/components/com_hikashop/classes/category.php:382
    JROOT/administrator/components/com_hikashop/classes/category.php:421
    JROOT/administrator/components/com_hikashop/classes/category.php:386
    JROOT/administrator/components/com_hikashop/classes/category.php:511
    JROOT/administrator/components/com_hikashop/classes/widget.php:1460
    JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83
    JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22
    JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/administrator/components/com_hikashop/helpers/helper.php:1323
    JROOT/administrator/components/com_hikashop/helpers/helper.php:1072
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_hikashop/helpers/helper.php:1311
    JROOT/administrator/components/com_hikashop/hikashop.php:54
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:143
    JROOT/libraries/cms/application/cms.php:255
    JROOT/administrator/index.php:42
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]
  
13.  **Query Time: 1.64 ms** **After last query: 3.46 ms** **Query memory: 0.006 MB Memory before query: 7.054 MB** **Rows returned: 10**

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

      FROM syi7r_modules AS m

      LEFT JOIN syi7r_modules_menu AS mm 
      ON mm.moduleid = m.id

      LEFT JOIN syi7r_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2014-05-09 14:28:51') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-05-09 14:28:51') 
      AND m.access IN (1,1,2,3) 
      AND m.client_id = 1 
      AND (mm.menuid = 0 OR mm.menuid <= 0)

      ORDER BY m.position, m.ordering

    **Explain**
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	35	Using where; **Using filesort**
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	madman_db2.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	madman_db2.m.module,const	1	Using where
    **Profile**
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache lock	0.0 ms
    init	0.1 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.1 ms
    executing	0.0 ms
    Sorting result	0.2 ms
    Sending data	0.3 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.1 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/libraries/cms/module/helper.php:376
    JROOT/libraries/cms/module/helper.php:84
    JROOT/administrator/templates/isis/error.php:34
    JROOT/libraries/joomla/document/error/error.php:135
    JROOT/libraries/joomla/document/error/error.php:107
    JROOT/libraries/legacy/error/error.php:791
    JROOT/plugins/system/redirect/redirect.php:134
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]

14.    **Query Time: 0.55 ms** **After last query: 16.27 ms** **Query memory: 0.009 MB Memory before query: 7.316 MB** **Rows returned: 5**

    SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native

      FROM syi7r_menu_types AS a

      LEFT JOIN syi7r_menu AS b 
      ON b.menutype = a.menutype 
      AND b.home != 0

      LEFT JOIN syi7r_languages AS l 
      ON l.lang_code = language

      WHERE (b.client_id = 0 OR b.client_id IS NULL)

      GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native

    **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	5	Using temporary; **Using filesort**
    1	SIMPLE	b	ref	idx_menutype	idx_menutype	74	madman_db2.a.menutype	3	Using where
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	madman_db2.b.language	1	
    **Profile**
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking privileges on cached 	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    sending cached result to clien	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/administrator/modules/mod_menu/helper.php:47
    JROOT/administrator/modules/mod_menu/tmpl/default_enabled.php:139
    JROOT/administrator/modules/mod_menu/tmpl/default.php:14
    JROOT/administrator/modules/mod_menu/mod_menu.php:30
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/templates/isis/error.php:170
    JROOT/libraries/joomla/document/error/error.php:135
    JROOT/libraries/joomla/document/error/error.php:107
    JROOT/libraries/legacy/error/error.php:791
    JROOT/plugins/system/redirect/redirect.php:134
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]
   
15. **Query Time: 1.52 ms** **After last query: 1.84 ms** **Query memory: 0.009 MB Memory before query: 7.354 MB** **Rows returned: 33**

    SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element

      FROM syi7r_menu AS m

      LEFT JOIN syi7r_extensions AS e 
      ON m.component_id = e.extension_id

      WHERE m.client_id = 1 
      AND e.enabled = 1 
      AND m.id > 1

      ORDER BY m.lft

    **Explain**
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,idx_client_id_parent_id_alias_language,idx_componentid	idx_client_id_parent_id_alias_language	1	const	33	Using where; **Using filesort**
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	madman_db2.m.component_id	1	Using where
    **Profile**
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sorting result	0.2 ms
    Sending data	0.3 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/administrator/modules/mod_menu/helper.php:85
    JROOT/administrator/modules/mod_menu/tmpl/default_enabled.php:241
    JROOT/administrator/modules/mod_menu/tmpl/default.php:14
    JROOT/administrator/modules/mod_menu/mod_menu.php:30
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/templates/isis/error.php:170
    JROOT/libraries/joomla/document/error/error.php:135
    JROOT/libraries/joomla/document/error/error.php:107
    JROOT/libraries/legacy/error/error.php:791
    JROOT/plugins/system/redirect/redirect.php:134
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]
  
16.  **Query Time: 10.31 ms** **After last query: 50.02 ms** **Query memory: 0.002 MB Memory before query: 7.491 MB**

    UPDATE `syi7r_session`

      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:11;s:19:\"session.timer.start\";i:1399645351;s:18:\"session.timer.last\";i:1399645722;s:17:\"session.timer.now\";i:1399645731;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"863\";s:4:\"name\";s:5:\"Brian\";s:8:\"username\";s:7:\"Madness\";s:5:\"email\";s:18:\"brian@madman.co.za\";s:8:\"password\";s:34:\"$P$Due7Ce.k9g071gzUUFp415T1CXSsil0\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-04-03 12:26:19\";s:13:\"lastvisitDate\";s:19:\"2014-05-09 04:28:33\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:247:\"{\"admin_style\":\"\",\"admin_language\":\"en-GB\",\"language\":\"en-GB\",\"editor\":\"jckeditor\",\"helpsite\":\"http:\\/\\/help.joomla.org\\/proxy\\/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\",\"timezone\":\"Africa\\/Johannesburg\",\"jckuicolor\":\"#E6E6E6\"}\";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:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":7:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:5:\"en-GB\";s:8:\"language\";s:5:\"en-GB\";s:6:\"editor\";s:9:\"jckeditor\";s:8:\"helpsite\";s:89:\"http://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"timezone\";s:19:\"Africa/Johannesburg\";s:10:\"jckuicolor\";s:7:\"#E6E6E6\";}}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: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:\"12490d9f77632bc4b172681cef0d89a7\";}'
    	, `time` = '1399645731'

      WHERE `session_id` = '8mir0njs32lk4smhtj8g156ks1'

    **Explain**
    **EXPLAIN not possible on query: UPDATE `syi7r_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:11;s:19:\"session.timer.start\";i:1399645351;s:18:\"session.timer.last\";i:1399645722;s:17:\"session.timer.now\";i:1399645731;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"863\";s:4:\"name\";s:5:\"Brian\";s:8:\"username\";s:7:\"Madness\";s:5:\"email\";s:18:\"brian@madman.co.za\";s:8:\"password\";s:34:\"$P$Due7Ce.k9g071gzUUFp415T1CXSsil0\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-04-03 12:26:19\";s:13:\"lastvisitDate\";s:19:\"2014-05-09 04:28:33\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:247:\"{\"admin_style\":\"\",\"admin_language\":\"en-GB\",\"language\":\"en-GB\",\"editor\":\"jckeditor\",\"helpsite\":\"http:\\/\\/help.joomla.org\\/proxy\\/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\",\"timezone\":\"Africa\\/Johannesburg\",\"jckuicolor\":\"#E6E6E6\"}\";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:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":7:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:5:\"en-GB\";s:8:\"language\";s:5:\"en-GB\";s:6:\"editor\";s:9:\"jckeditor\";s:8:\"helpsite\";s:89:\"http://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"timezone\";s:19:\"Africa/Johannesburg\";s:10:\"jckuicolor\";s:7:\"#E6E6E6\";}}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: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:\"12490d9f77632bc4b172681cef0d89a7\";}' , `time` = '1399645731' WHERE `session_id` = '8mir0njs32lk4smhtj8g156ks1'**
    **Profile**
    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    init	0.0 ms
    Updating	0.1 ms
    end	0.0 ms
    Waiting for query cache lock	0.0 ms
    end	0.0 ms
    query end	9.5 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    **Call Stack**
    JROOT/libraries/joomla/session/storage/database.php:85
    [**Add xdebug.file_link_format directive to your php.ini file to have links for files**]

**14 Query Types Logged, Sorted by Occurrences.**
**SELECT Tables:**

    **2 × SELECT category_id 
      FROM syi7r_hikashop_category**

    **2 × SELECT extension_id AS id, element AS "option", params, enabled 
      FROM syi7r_extensions**

    **1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element 
      FROM syi7r_menu AS m 
      LEFT JOIN syi7r_extensions AS e 
      ON m.component_id = e.extension_id**

    **1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM syi7r_modules AS m 
      LEFT JOIN syi7r_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN syi7r_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id**

    **1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native 
      FROM syi7r_menu_types AS a 
      LEFT JOIN syi7r_menu AS b 
      ON b.menutype = a.menutype 
      AND b.home != 0 
      LEFT JOIN syi7r_languages AS l 
      ON l.lang_code = language**

    **1 × SELECT b.*,a.* 
      FROM syi7r_hikashop_order AS a 
      LEFT JOIN syi7r_hikashop_user AS b 
      ON a.order_user_id=b.user_id**

    **1 × SELECT * 
      FROM syi7r_hikashop_widget**

    **1 × SELECT folder AS type, element AS name, params 
      FROM syi7r_extensions**

    **1 × SELECT template, s.params 
      FROM syi7r_template_styles as s 
      LEFT JOIN syi7r_extensions as e 
      ON e.type='template' 
      AND e.element=s.template 
      AND e.client_id=s.client_id**

    **1 × SELECT * 
      FROM syi7r_hikashop_confi**

    **1 × SELECT `data` 
      FROM `syi7r_session`**

**OTHER Tables:**

    **1 × UPDATE `syi7r_session` 
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:11;s:19:\"session.timer.start\";i:1399645351;s:18:\"session.timer.last\";i:1399645722;s:17:\"session.timer.now\";i:1399645731;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"863\";s:4:\"name\";s:5:\"Brian\";s:8:\"username\";s:7:\"Madness\";s:5:\"email\";s:18:\"brian@madman.co.za\";s:8:\"password\";s:34:\"$P$Due7Ce.k9g071gzUUFp415T1CXSsil0\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-04-03 12:26:19\";s:13:\"lastvisitDate\";s:19:\"2014-05-09 04:28:33\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:247:\"{\"admin_style\":\"\",\"admin_language\":\"en-GB\",\"language\":\"en-GB\",\"editor\":\"jckeditor\",\"helpsite\":\"http:\\/\\/help.joomla.org\\/proxy\\/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\",\"timezone\":\"Africa\\/Johannesburg\",\"jckuicolor\":\"#E6E6E6\"}\";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:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":7:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:5:\"en-GB\";s:8:\"language\";s:5:\"en-GB\";s:6:\"editor\";s:9:\"jckeditor\";s:8:\"helpsite\";s:89:\"http://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"timezone\";s:19:\"Africa/Johannesburg\";s:10:\"jckuicolor\";s:7:\"#E6E6E6\";}}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: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:\"12490d9f77632bc4b172681cef0d89a7\";}'  , `time` = '1399645731'**

    **1 × UPDATE `syi7r_extensions` 
      SET `params` = '{\"mediaversion\":\"81dad8ef00070c1ce3af1766a062e698\"}'**

    **1 × DELETE  
      FROM `syi7r_session`**

Engine Monitoring and Performance Systems
Last edit: 11 years 2 months ago by Jerome. Reason: [code] is nice !!

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

  • Posts: 26260
  • Thank you received: 4042
  • MODERATOR
11 years 2 months ago #155181

Hi,

Thanks for the traces !

It looks like your Root category is broken.
In the file "administrator/components/com_hikashop/classes/category.php" please replace

$query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE category_parent_id='.$this->getRoot().' AND category_type='.$this->database->Quote($element).' LIMIT 1';
By:
$query = 'SELECT category_id FROM '.hikashop_table('category').' WHERE category_parent_id='.(int)$this->getRoot().' AND category_type='.$this->database->Quote($element).' LIMIT 1';
It should force the "0" in the request and avoid the SQL error, but the results won't be good if you don't have a root category anymore.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: MadMan

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

  • Posts: 33
  • Thank you received: 0
11 years 2 months ago #155195

Perfect !

Thanks alot Jerome, Fantastic Support.

I will upgrade to the business edition when I return to work next week !

Regards
Brian
www.MadMan.co.za

Engine Monitoring and Performance Systems

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

Time to create page: 0.063 seconds
Powered by Kunena Forum