Cannot update to 2.3.4

  • Posts: 5
  • Thank you received: 1
10 years 7 months ago #180322

-- url of the page with the problem -- : igenerac.com/administrator/index.php?opt...staller&view=install
-- HikaShop version -- : 2.3.3
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.3.3
-- Browser(s) name and version -- : Firefox 33.1
-- Error-message(debug-mod must be tuned on) -- : Error

There was an error uploading this file to the server.
Maximum PHP file upload size is too small: This is set in php.ini in both upload_max_filesize and post_max_size settings of your PHP settings (located in php.ini and/or .htaccess file)

Joomla! Debug Console
Session
__default
__wf
Profile Information
Time
Memory
Time: 0.0 ms / 0.0 ms Memory: 0.349 MB / 0.35 MB Application: afterLoad
Time: 18.9 ms / 18.9 ms Memory: 1.979 MB / 2.33 MB Application: afterInitialise
Time: 79.0 ms / 97.9 ms Memory: 0.173 MB / 2.50 MB Application: afterRoute
Time: 34.5 ms / 132.3 ms Memory: 0.790 MB / 3.29 MB Application: afterDispatch
Time: 2.1 ms / 134.4 ms Memory: 0.076 MB / 3.37 MB Application: beforeRenderModule mod_submenu (Admin Submenu)
Time: 1.7 ms / 136.1 ms Memory: 0.007 MB / 3.38 MB Application: afterRenderModule mod_submenu (Admin Submenu)
Time: 2.2 ms / 138.3 ms Memory: 0.018 MB / 3.39 MB Application: beforeRenderModule mod_status (User Status)
Time: 2.0 ms / 140.3 ms Memory: 0.059 MB / 3.45 MB Application: afterRenderModule mod_status (User Status)
Time: 0.1 ms / 140.4 ms Memory: 0.000 MB / 3.45 MB Application: beforeRenderModule mod_version (Joomla Version)
Time: 1.3 ms / 141.7 ms Memory: 0.010 MB / 3.46 MB Application: afterRenderModule mod_version (Joomla Version)
Time: 0.1 ms / 141.8 ms Memory: 0.000 MB / 3.46 MB Application: beforeRenderModule mod_toolbar (Toolbar)
Time: 5.9 ms / 147.6 ms Memory: 0.038 MB / 3.50 MB Application: afterRenderModule mod_toolbar (Toolbar)
Time: 0.1 ms / 147.7 ms Memory: 0.000 MB / 3.50 MB Application: beforeRenderModule mod_title (Title)
Time: 1.1 ms / 148.8 ms Memory: 0.006 MB / 3.50 MB Application: afterRenderModule mod_title (Title)
Time: 0.1 ms / 148.9 ms Memory: 0.001 MB / 3.50 MB Application: beforeRenderModule mod_menu (Admin Menu)
Time: 28.6 ms / 177.5 ms Memory: 0.418 MB / 3.92 MB Application: afterRenderModule mod_menu (Admin Menu)
Time: 2.6 ms / 180.1 ms Memory: 0.025 MB / 3.95 MB Application: afterRender

Database queries total: 123.2 ms
Memory Usage
4.04 MB (4,239,664 Bytes)
Database Queries
26 Queries Logged 123.2 ms

4 duplicate found!
2 duplicates: #8  #24
2 duplicates: #9  #25

    Query Time: 0.10 ms

    SELECT `data`

      FROM `jos_session`

      WHERE `session_id` = 'b3i2um7vsf53ooham5tueseeb4'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	602	const	1	
    Profile
    Error
    MySql have_profiling = off
    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:668
    JROOT/libraries/cms/application/cms.php:131
    JROOT/libraries/cms/application/administrator.php:45
    JROOT/libraries/cms/application/cms.php:328
    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]
    Query Time: 0.60 ms After last query: 2.73 ms

    SELECT folder AS type, element AS name, params

      FROM jos_extensions

      WHERE enabled >= 1 
      AND type ='plugin' 
      AND state >= 0 
      AND access IN (1,1,2,3)

      ORDER BY ordering

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_extensions	ref	extension	extension	62	const	96	Using where; Using filesort
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    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:569
    JROOT/libraries/cms/application/administrator.php:301
    JROOT/libraries/cms/application/administrator.php:116
    JROOT/libraries/cms/application/cms.php:251
    JROOT/administrator/index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.22 ms After last query: 3.30 ms

    SELECT `query`

      FROM `jos_admintools_wafexceptions`

      WHERE (`option` IS NULL OR `option` = '' OR `option` = 'com_installer') 
      AND (`view` IS NULL OR `view` = '' OR `view` = 'install')

      GROUP BY `query`

      ORDER BY `query` ASC

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_admintools_wafexceptions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary; Using filesort
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT/plugins/system/admintools/admintools/main.php:488
    JROOT/plugins/system/admintools/admintools/main.php:96
    JROOT/libraries/cms/plugin/helper.php:257
    JROOT/libraries/cms/plugin/helper.php:172
    JROOT/libraries/cms/application/cms.php:582
    JROOT/libraries/cms/application/administrator.php:301
    JROOT/libraries/cms/application/administrator.php:116
    JROOT/libraries/cms/application/cms.php:251
    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: 5.92 ms

    select email 
      from jos_users 
      where id=62 
      LIMIT 1

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_users	const	PRIMARY	PRIMARY	4	const	1	
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT/plugins/system/bfstop/helpers/db.php:225
    JROOT/plugins/system/bfstop/helpers/db.php:232
    JROOT/plugins/system/bfstop/helpers/notify.php:23
    JROOT/plugins/system/bfstop/bfstop.php:172
    JROOT/plugins/system/bfstop/bfstop.php:337
    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/cms.php:583
    JROOT/libraries/cms/application/administrator.php:301
    JROOT/libraries/cms/application/administrator.php:116
    JROOT/libraries/cms/application/cms.php:251
    JROOT/administrator/index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.12 ms After last query: 0.08 ms

    SELECT id, ipaddress, crdate 
      from jos_bfstop_whitelist 
      WHERE (ipaddress='87.11.237.56' OR (LENGTH(ipaddress)    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:91
    JROOT/plugins/system/encrypt/encrypt.php:550
    JROOT/plugins/system/encrypt/encrypt.php:155
    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:464
    JROOT/libraries/cms/application/administrator.php:153
    JROOT/libraries/cms/application/cms.php:251
    JROOT/administrator/index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.12 ms After last query: 0.37 ms

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

      FROM jos_extensions

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

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_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: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:464
    JROOT/libraries/cms/application/administrator.php:153
    JROOT/libraries/cms/application/cms.php:251
    JROOT/administrator/index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 77.37 ms After last query: 0.16 ms

    UPDATE `jos_extensions`

      SET `params` = '{\"mediaversion\":\"00cfd880c886abfa2b46acafb0e3c3dd\"}'

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

    Explain
    EXPLAIN not possible on query: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"00cfd880c886abfa2b46acafb0e3c3dd\"}' 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: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:464
    JROOT/libraries/cms/application/administrator.php:153
    JROOT/libraries/cms/application/cms.php:251
    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.42 ms

    SELECT template, s.params

      FROM jos_template_styles as s

      LEFT JOIN jos_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	joomla_6.s.template,const	1	
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT/libraries/cms/application/administrator.php:219
    JROOT/libraries/cms/application/administrator.php:82
    JROOT/libraries/cms/application/administrator.php:159
    JROOT/libraries/cms/application/cms.php:251
    JROOT/administrator/index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.11 ms After last query: 1.03 ms

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

      FROM jos_extensions

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

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	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: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:159
    JROOT/libraries/cms/application/cms.php:251
    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: 20.70 ms

    SELECT params 
      FROM jos_extensions AS e 
      WHERE e.element='com_widgetkit'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	302	const	1	Using where
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT/administrator/components/com_widgetkit/helpers/system.php:278
    JROOT/administrator/components/com_widgetkit/helpers/system.php:54
    JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
    JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
    JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
    JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    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:103
    JROOT/libraries/cms/application/administrator.php:159
    JROOT/libraries/cms/application/cms.php:251
    JROOT/administrator/index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.10 ms After last query: 1.91 ms

    SELECT id,template 
      FROM jos_template_styles 
      WHERE client_id=0 
      AND home=1

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using where
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT/administrator/components/com_widgetkit/helpers/system.php:78
    JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    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:103
    JROOT/libraries/cms/application/administrator.php:159
    JROOT/libraries/cms/application/cms.php:251
    JROOT/administrator/index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.12 ms After last query: 0.27 ms

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

      FROM jos_extensions

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

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	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:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:91
    JROOT/administrator/components/com_widgetkit/helpers/system.php:94
    JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    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:103
    JROOT/libraries/cms/application/administrator.php:159
    JROOT/libraries/cms/application/cms.php:251
    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: 11.46 ms

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

      FROM jos_modules AS m

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

      LEFT JOIN jos_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-11-19 13:34:24') 
      AND m.access IN (1,1,2,3) 
      AND m.client_id = 1 
      AND (mm.menuid = 0 OR mm.menuid  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	30	Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	joomla_6.m.component_id	1	Using where
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    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/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/administrator.php:436
    JROOT/libraries/cms/application/cms.php:257
    JROOT/administrator/index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.11 ms After last query: 25.36 ms
    Duplicate queries: #8

    SELECT * 
      FROM jos_encrypt_controls

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_encrypt_controls	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	13	
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT/plugins/system/encrypt/encrypt.php:498
    JROOT/plugins/system/encrypt/encrypt.php:318
    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/cms.php:994
    JROOT/libraries/cms/application/administrator.php:436
    JROOT/libraries/cms/application/cms.php:257
    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.14 ms
    Duplicate queries: #9

    SELECT algorithm, private_key, e, n, des_key, random_des, 
    				TO_DAYS(NOW()) - TO_DAYS(gen_time) AS age_in_days
    				
      FROM jos_encrypt_keys

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_encrypt_keys	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT/plugins/system/encrypt/encrypt.php:549
    JROOT/plugins/system/encrypt/encrypt.php:319
    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/cms.php:994
    JROOT/libraries/cms/application/administrator.php:436
    JROOT/libraries/cms/application/cms.php:257
    JROOT/administrator/index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 41.63 ms After last query: 0.57 ms

    UPDATE `jos_session`

      SET `data` = '__default|a:11:{s:15:\"session.counter\";i:23;s:19:\"session.timer.start\";i:1416401621;s:18:\"session.timer.last\";i:1416404064;s:17:\"session.timer.now\";i:1416404064;s:24:\"session.client.forwarded\";s:12:\"87.11.237.56\";s:22:\"session.client.browser\";s:81:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:33.0) Gecko/20100101 Firefox/33.0\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":3:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:13:\"com_installer\";O:8:\"stdClass\":3:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;}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:86:{s:7:\"offline\";s:1:\"0\";s:15:\"offline_message\";s:70:\"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:8:\"iGenerac\";s:6:\"editor\";s:3:\"jce\";s:7:\"captcha\";s:1:\"0\";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:5:\"mysql\";s:4:\"host\";s:14:\"localhost:3306\";s:4:\"user\";s:8:\"joomla_a\";s:8:\"password\";s:10:\"i84byE3V!F\";s:2:\"db\";s:8:\"joomla_6\";s:8:\"dbprefix\";s:4:\"jos_\";s:9:\"live_site\";s:0:\"\";s:6:\"secret\";s:16:\"SZ6VuOEmpeP5S41U\";s:4:\"gzip\";s:1:\"0\";s:15:\"error_reporting\";s:7:\"default\";s:7:\"helpurl\";s:89:\"http://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"ftp_host\";s:9:\"127.0.0.1\";s:8:\"ftp_port\";s:2:\"21\";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:11:\"offset_user\";s:3:\"UTC\";s:6:\"mailer\";s:4:\"mail\";s:8:\"mailfrom\";s:20:\"paoloilling@paga.com\";s:8:\"fromname\";s:8:\"iGenerac\";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:11:\"example.com\";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:\"1\";s:11:\"MetaVersion\";s:1:\"0\";s:6:\"robots\";s:0:\"\";s:3:\"sef\";s:1:\"1\";s:11:\"sef_rewrite\";s:1:\"0\";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:42:\"/var/www/vhosts/igenerac.com/httpdocs/logs\";s:8:\"tmp_path\";s:41:\"/var/www/vhosts/igenerac.com/httpdocs/tmp\";s:8:\"lifetime\";s:2:\"30\";s:15:\"session_handler\";s:8:\"database\";s:10:\"MetaRights\";s:0:\"\";s:19:\"sitename_pagetitles\";s:1:\"0\";s:9:\"force_ssl\";s:1:\"0\";s:10:\"feed_email\";s:6:\"author\";s:13:\"cookie_domain\";s:0:\"\";s:11:\"cookie_path\";s:0:\"\";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: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:10:\"mailonline\";s:1:\"1\";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:8:\"asset_id\";i:1;s:7:\"filters\";a:9:{i:1;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:9;a:3:{s:11:\"filter_type\";s:2:\"BL\";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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:10:\"core.admin\";a:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:4:\"user\";O:5:\"JUser\":27:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:6:\"illing\";s:5:\"email\";s:20:\"paoloilling@paga.com\";s:8:\"password\";s:60:\"$2y$10$LhqoIHCCJO/WuvU0OB9zuOYCsRkGadlARag2xVYG05SkvA7.wIPVe\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2014-05-22 19:49:29\";s:13:\"lastvisitDate\";s:19:\"2014-11-07 19:37:44\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:2:\"{}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"2014-05-22 19:49:29\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}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:\"9ecb3a77113b76ae8101524ee6597d7f\";s:9:\"formtoken\";s:0:\"\";s:6:\"deskey\";s:0:\"\";}__wf|a:1:{s:13:\"session.token\";s:32:\"f64da7322409d642a35c307c68078228\";}'
    	, `time` = '1416404064'

      WHERE `session_id` = 'b3i2um7vsf53ooham5tueseeb4'

    Explain
    EXPLAIN not possible on query: UPDATE `jos_session` SET `data` = '__default|a:11:{s:15:\"session.counter\";i:23;s:19:\"session.timer.start\";i:1416401621;s:18:\"session.timer.last\";i:1416404064;s:17:\"session.timer.now\";i:1416404064;s:24:\"session.client.forwarded\";s:12:\"87.11.237.56\";s:22:\"session.client.browser\";s:81:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:33.0) Gecko/20100101 Firefox/33.0\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":3:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:13:\"com_installer\";O:8:\"stdClass\":3:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;}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:86:{s:7:\"offline\";s:1:\"0\";s:15:\"offline_message\";s:70:\"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:8:\"iGenerac\";s:6:\"editor\";s:3:\"jce\";s:7:\"captcha\";s:1:\"0\";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:5:\"mysql\";s:4:\"host\";s:14:\"localhost:3306\";s:4:\"user\";s:8:\"joomla_a\";s:8:\"password\";s:10:\"i84byE3V!F\";s:2:\"db\";s:8:\"joomla_6\";s:8:\"dbprefix\";s:4:\"jos_\";s:9:\"live_site\";s:0:\"\";s:6:\"secret\";s:16:\"SZ6VuOEmpeP5S41U\";s:4:\"gzip\";s:1:\"0\";s:15:\"error_reporting\";s:7:\"default\";s:7:\"helpurl\";s:89:\"http://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"ftp_host\";s:9:\"127.0.0.1\";s:8:\"ftp_port\";s:2:\"21\";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:11:\"offset_user\";s:3:\"UTC\";s:6:\"mailer\";s:4:\"mail\";s:8:\"mailfrom\";s:20:\"paoloilling@paga.com\";s:8:\"fromname\";s:8:\"iGenerac\";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:11:\"example.com\";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:\"1\";s:11:\"MetaVersion\";s:1:\"0\";s:6:\"robots\";s:0:\"\";s:3:\"sef\";s:1:\"1\";s:11:\"sef_rewrite\";s:1:\"0\";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:42:\"/var/www/vhosts/igenerac.com/httpdocs/logs\";s:8:\"tmp_path\";s:41:\"/var/www/vhosts/igenerac.com/httpdocs/tmp\";s:8:\"lifetime\";s:2:\"30\";s:15:\"session_handler\";s:8:\"database\";s:10:\"MetaRights\";s:0:\"\";s:19:\"sitename_pagetitles\";s:1:\"0\";s:9:\"force_ssl\";s:1:\"0\";s:10:\"feed_email\";s:6:\"author\";s:13:\"cookie_domain\";s:0:\"\";s:11:\"cookie_path\";s:0:\"\";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: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:10:\"mailonline\";s:1:\"1\";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:8:\"asset_id\";i:1;s:7:\"filters\";a:9:{i:1;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:9;a:3:{s:11:\"filter_type\";s:2:\"BL\";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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:10:\"core.admin\";a:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:4:\"user\";O:5:\"JUser\":27:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:6:\"illing\";s:5:\"email\";s:20:\"paoloilling@paga.com\";s:8:\"password\";s:60:\"$2y$10$LhqoIHCCJO/WuvU0OB9zuOYCsRkGadlARag2xVYG05SkvA7.wIPVe\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2014-05-22 19:49:29\";s:13:\"lastvisitDate\";s:19:\"2014-11-07 19:37:44\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:2:\"{}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"2014-05-22 19:49:29\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}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:\"9ecb3a77113b76ae8101524ee6597d7f\";s:9:\"formtoken\";s:0:\"\";s:6:\"deskey\";s:0:\"\";}__wf|a:1:{s:13:\"session.token\";s:32:\"f64da7322409d642a35c307c68078228\";}' , `time` = '1416404064' WHERE `session_id` = 'b3i2um7vsf53ooham5tueseeb4'
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    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]

19 Query Types Logged, Sorted by Occurrences.
SELECT Tables:

    5 × SELECT extension_id AS id, element AS "option", params, enabled 
      FROM jos_extensions

    2 × SELECT * 
      FROM jos_encrypt_control

    2 × SELECT COUNT(session_id) 
      FROM jos_session

    2 × SELECT algorithm, private_key, e, n, des_key, random_des, 
         TO_DAYS(NOW()) - TO_DAYS(gen_time) AS age_in_days
         
      FROM jos_encrypt_key

    1 × SELECT COUNT(*) 
      FROM jos_messages

    1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM jos_modules AS m 
      LEFT JOIN jos_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN jos_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

    1 × SELECT folder AS type, element AS name, params 
      FROM jos_extensions

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

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

    1 × SELECT id,template 
      FROM jos_template_styles

    1 × SELECT params 
      FROM jos_extensions AS e

    1 × select email 
      from jos_users

    1 × SELECT id, ipaddress, crdate, duration 
      FROM jos_bfstop_bannedip b

    1 × SELECT `query` 
      FROM `jos_admintools_wafexceptions`

    1 × SELECT `data` 
      FROM `jos_session`

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

    1 × SELECT id, ipaddress, crdate 
      from jos_bfstop_whitelist

OTHER Tables:

    1 × UPDATE `jos_session` 
      SET `data` = '__default|a:11:{s:15:\"session.counter\";i:23;s:19:\"session.timer.start\";i:1416401621;s:18:\"session.timer.last\";i:1416404064;s:17:\"session.timer.now\";i:1416404064;s:24:\"session.client.forwarded\";s:12:\"87.11.237.56\";s:22:\"session.client.browser\";s:81:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:33.0) Gecko/20100101 Firefox/33.0\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":3:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:13:\"com_installer\";O:8:\"stdClass\":3:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;}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:86:{s:7:\"offline\";s:1:\"0\";s:15:\"offline_message\";s:70:\"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:8:\"iGenerac\";s:6:\"editor\";s:3:\"jce\";s:7:\"captcha\";s:1:\"0\";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:5:\"mysql\";s:4:\"host\";s:14:\"localhost:3306\";s:4:\"user\";s:8:\"joomla_a\";s:8:\"password\";s:10:\"i84byE3V!F\";s:2:\"db\";s:8:\"joomla_6\";s:8:\"dbprefix\";s:4:\"jos_\";s:9:\"live_site\";s:0:\"\";s:6:\"secret\";s:16:\"SZ6VuOEmpeP5S41U\";s:4:\"gzip\";s:1:\"0\";s:15:\"error_reporting\";s:7:\"default\";s:7:\"helpurl\";s:89:\"http://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"ftp_host\";s:9:\"127.0.0.1\";s:8:\"ftp_port\";s:2:\"21\";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:11:\"offset_user\";s:3:\"UTC\";s:6:\"mailer\";s:4:\"mail\";s:8:\"mailfrom\";s:20:\"paoloilling@paga.com\";s:8:\"fromname\";s:8:\"iGenerac\";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:11:\"example.com\";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:\"1\";s:11:\"MetaVersion\";s:1:\"0\";s:6:\"robots\";s:0:\"\";s:3:\"sef\";s:1:\"1\";s:11:\"sef_rewrite\";s:1:\"0\";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:42:\"/var/www/vhosts/igenerac.com/httpdocs/logs\";s:8:\"tmp_path\";s:41:\"/var/www/vhosts/igenerac.com/httpdocs/tmp\";s:8:\"lifetime\";s:2:\"30\";s:15:\"session_handler\";s:8:\"database\";s:10:\"MetaRights\";s:0:\"\";s:19:\"sitename_pagetitles\";s:1:\"0\";s:9:\"force_ssl\";s:1:\"0\";s:10:\"feed_email\";s:6:\"author\";s:13:\"cookie_domain\";s:0:\"\";s:11:\"cookie_path\";s:0:\"\";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: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:10:\"mailonline\";s:1:\"1\";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:8:\"asset_id\";i:1;s:7:\"filters\";a:9:{i:1;a:3:{s:11:\"filter_type\";s:2:\"NH\";s:11:\"filter_tags\";s:0:\"\";s:17:\"filter_attributes\";s:0:\"\";}i:9;a:3:{s:11:\"filter_type\";s:2:\"BL\";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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:10:\"core.admin\";a:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:9:{i:1;s:0:\"\";i:9;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:4:\"user\";O:5:\"JUser\":27:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:6:\"illing\";s:5:\"email\";s:20:\"paoloilling@paga.com\";s:8:\"password\";s:60:\"$2y$10$LhqoIHCCJO/WuvU0OB9zuOYCsRkGadlARag2xVYG05SkvA7.wIPVe\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2014-05-22 19:49:29\";s:13:\"lastvisitDate\";s:19:\"2014-11-07 19:37:44\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:2:\"{}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"2014-05-22 19:49:29\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}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:\"9ecb3a77113b76ae8101524ee6597d7f\";s:9:\"formtoken\";s:0:\"\";s:6:\"deskey\";s:0:\"\";}__wf|a:1:{s:13:\"session.token\";s:32:\"f64da7322409d642a35c307c68078228\";}'  , `time` = '1416404064'

    1 × UPDATE `jos_extensions` 
      SET `params` = '{\"mediaversion\":\"00cfd880c886abfa2b46acafb0e3c3dd\"}'
php.ini was doubled in size to 4000Mb. There is NO .htaccess file, just the default htaccess.txt created by Plesk 12.

Os: CentOS 6.6 updated.

Consequently I cannot install Hikamarket either.

Last edit: 10 years 7 months ago by Xavier. Reason: Use of [code][/code] tags

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

  • Posts: 13201
  • Thank you received: 2322
10 years 7 months ago #180325

Hi,

You can potentially try to install HikaShop via FTP:
www.hikashop.com/support/support/documen...-to-install.html#ftp

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

Time to create page: 0.045 seconds
Powered by Kunena Forum