Main menu

Forum


× Forum di assistenza italiano

conflitti icagenda 3.7.10 2 joomla 3.9.8

  • vloda
  • Topic Author
  • New Member
  • New Member
More
4 years 5 months ago #16813 by vloda
Salve, ho appena aggiornato IC Agenda all'ultima versione
Non posso però inserire più nuovi eventi:
quando provo ad inserire immagini mi viene deto che non posso accedere alla risorsa (sono supeuser!)
Se salvo joomla mi chiede di riaccedere con username e pasword e quando rientro l'evento che dovevo salvare è andato perso e anche se lo rifaccio la risposta è sempre la medesima.
come posso fare?
Grazie
Valerio Loda

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

  • giusebos
  • giusebos's Avatar
  • Moderator
  • Moderator
More
4 years 5 months ago #16814 by giusebos
Replied by giusebos on topic conflitti icagenda 3.7.10 2 joomla 3.9.8
Attiva il debug e riporta li errori.

HAI BISOGNO DI ASSISTENZA?
leggi qui

Guarda tutti i video tutorial di iCagenda
Watch all video tutorials iCagenda
Regardez toutes les vidéos tutoriels iCagenda
Ver todos los videos tutoriales iCagenda

guarda qui

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

  • vloda
  • Topic Author
  • New Member
  • New Member
More
4 years 5 months ago - 4 years 5 months ago #16815 by vloda
Replied by vloda on topic conflitti icagenda 3.7.10 2 joomla 3.9.8
Ho attivato il debug,
mi riporta questo, che però non so leggere:
Last edit: 4 years 5 months ago by giusebos.

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

  • giusebos
  • giusebos's Avatar
  • Moderator
  • Moderator
More
4 years 5 months ago #16816 by giusebos
Replied by giusebos on topic conflitti icagenda 3.7.10 2 joomla 3.9.8
devi attivarlo su MAX, quelle sono solo informazioni di sistema.

HAI BISOGNO DI ASSISTENZA?
leggi qui

Guarda tutti i video tutorial di iCagenda
Watch all video tutorials iCagenda
Regardez toutes les vidéos tutoriels iCagenda
Ver todos los videos tutoriales iCagenda

guarda qui

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

  • vloda
  • Topic Author
  • New Member
  • New Member
More
4 years 5 months ago #16817 by vloda
Replied by vloda on topic conflitti icagenda 3.7.10 2 joomla 3.9.8
Scusami ma non caipsco cosa devo fare

cos'è MAX?

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

  • giusebos
  • giusebos's Avatar
  • Moderator
  • Moderator
More
4 years 5 months ago #16818 by giusebos
Replied by giusebos on topic conflitti icagenda 3.7.10 2 joomla 3.9.8
il debug è a vari livelli, devi impostarlo su MAX (MASSIMO)

HAI BISOGNO DI ASSISTENZA?
leggi qui

Guarda tutti i video tutorial di iCagenda
Watch all video tutorials iCagenda
Regardez toutes les vidéos tutoriels iCagenda
Ver todos los videos tutoriales iCagenda

guarda qui

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

  • vloda
  • Topic Author
  • New Member
  • New Member
More
4 years 5 months ago - 4 years 5 months ago #16819 by vloda
Replied by vloda on topic conflitti icagenda 3.7.10 2 joomla 3.9.8
ciao re grazie per l'attenzione
ho attivato max
intanto c agenda non funzona assolutamente più: se clicco su nuvo evento non solo non riesco a salvare nulla ma anche la schermata non va oltre la prima parte (nome evento e categoria, senza più nient'altro


col debug
il risultato è il seguente:
{
    "__default": {
        "session": {
            "counter": 8,
            "timer": {
                "start": 1577014069,
                "last": 1577014354,
                "now": 1577014354
            },
            "client": {
                "forwarded": "79.31.31.81"
            },
            "token": "U39CgPTuMFJGDgqAlTUtDriGMzD9IFHl"
        },
        "registry": {
            "com_installer": {
                "message": "",
                "extension_message": ""
            },
            "com_icagenda": {
                "edit": {
                    "event": {
                        "data": null
                    }
                }
            },
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuZm9jdXNpbmdpdGFsaWEuaXQvYWRtaW5pc3RyYXRvci9pbmRleC5waHA%2Fb3B0aW9uPWNvbV9pY2FnZW5kYSZ2aWV3PWV2ZW50JmxheW91dD1lZGl0"
            }
        },
        "user": {
            "id": "281",
            "name": "Super User",
            "username": "valeriogiuseppe",
            "email": "valeriooloda@gmail.com",
            "password": "$2y$10$JjduUA.NRbm.Kn37Dauu9uHS5JpLBIZaJTIct\/2ue9yPKOA8Jrsr.",
            "password_clear": "",
            "block": "0",
            "sendEmail": "1",
            "registerDate": "2016-10-26 22:00:28",
            "lastvisitDate": "2019-12-22 11:32:11",
            "activation": "0",
            "params": "{\"editor\":\"jce\",\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}",
            "groups": {
                "8": "8"
            },
            "guest": 0,
            "lastResetTime": "0000-00-00 00:00:00",
            "resetCount": "0",
            "requireReset": "0",
            "otpKey": "",
            "otep": ""
        },
        "ic_submit_catid": null,
        "ic_submit_shortdesc": null,
        "ic_submit_metadesc": null,
        "ic_submit_city": null,
        "ic_submit_country": null,
        "ic_submit_lat": null,
        "ic_submit_lng": null
    }
}


la parte query database mi riporta questo: (nonso se serve)

50 query eseguite 55.00 ms

Trovati 13 duplicati!
2 duplicati: #3  #49
2 duplicati: #4  #50
3 duplicati: #19  #23  #29
2 duplicati: #28  #30
2 duplicati: #31  #32
2 duplicati: #35  #38
Tempo della query: 0.64 ms Memoria query: 0.026 MB memoria prima della query: 1.482 MB Righe restituite: 1
SELECT `data`

  FROM `vxscv_session`

  WHERE `session_id` = '706be369e19431f41c66d38f1ba1246c'
Explain
Profilo
Call Stack
Tempo della query: 1.62 ms Dopo l'ultima query: 5.51 ms Memoria query: 0.031 MB memoria prima della query: 1.600 MB Righe restituite: 16
SHOW FULL COLUMNS 
  FROM `vxscv_users`
Explain
Profilo
Call Stack
Tempo della query: 0.79 ms Dopo l'ultima query: 0.77 ms Memoria query: 0.028 MB memoria prima della query: 1.640 MB Righe restituite: 1
Query duplicate: #49
SELECT *

  FROM `vxscv_users`

  WHERE `id` = 281
Explain
Profilo
Call Stack
Tempo della query: 9.91 ms Dopo l'ultima query: 6.04 ms Memoria query: 0.024 MB memoria prima della query: 1.716 MB Righe restituite: 1
Query duplicate: #50
SELECT `g`.`id`,`g`.`title`

  FROM `vxscv_usergroups` AS g

  INNER JOIN `vxscv_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 281
Explain
Profilo
Call Stack
Tempo della query: 2.12 ms Dopo l'ultima query: 5.81 ms Memoria query: 0.054 MB memoria prima della query: 1.733 MB Righe restituite: 48
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `vxscv_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1
Explain
Profilo
Call Stack
Tempo della query: 0.42 ms Dopo l'ultima query: 8.51 ms Memoria query: 0.023 MB memoria prima della query: 2.157 MB Righe restituite: 5
SELECT id, rules

  FROM `vxscv_viewlevels`
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vxscv_viewlevels	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	100.00	NULL
Profilo
Call Stack
Tempo della query: 0.37 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.023 MB memoria prima della query: 2.171 MB Righe restituite: 2
SELECT b.id

  FROM vxscv_user_usergroup_map AS map

  LEFT JOIN vxscv_usergroups AS a 
  ON a.id = map.group_id

  LEFT JOIN vxscv_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE map.user_id = 281
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	map	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	focusing45141.map.group_id	1	100.00	NULL
1	SIMPLE	b	ALL	idx_usergroup_nested_set_lookup	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	9	100.00	Range checked for each record (index map: 0x10)
Profilo
Call Stack
Tempo della query: 1.98 ms Dopo l'ultima query: 1.52 ms Memoria query: 0.040 MB memoria prima della query: 2.195 MB Righe restituite: 142
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM vxscv_extensions

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

  ORDER BY ordering
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vxscv_extensions	ref	extension	extension	82	const	176	100.00	Using index condition; Using where; Using filesort
Profilo
Call Stack
Tempo della query: 2.40 ms Dopo l'ultima query: 57.37 ms Memoria query: 0.029 MB memoria prima della query: 3.061 MB Righe restituite: 48
SELECT `id`,`name`,`rules`,`parent_id`

  FROM `vxscv_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_coalawebtraffic','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_db8optimize','com_fields','com_finder','com_gdpr','com_icagenda','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_minitekwall','com_modules','com_newsfeeds','com_osmap','com_pagebuilderck','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_search','com_swmenufree','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vxscv_assets	ALL	idx_asset_name	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	275	17.82	Using where
Profilo
Call Stack
Tempo della query: 1.18 ms Dopo l'ultima query: 3.60 ms Memoria query: 0.026 MB memoria prima della query: 3.151 MB Righe restituite: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `vxscv_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
Explain
Profilo
Call Stack
Tempo della query: 0.74 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.006 MB memoria prima della query: 3.143 MB
UPDATE `vxscv_extensions`

  SET `params` = '{\"mediaversion\":\"931875b7571c513e679a0343dec090ee\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
Explain
Profilo
Call Stack
Tempo della query: 0.61 ms Dopo l'ultima query: 3.29 ms Memoria query: 0.022 MB memoria prima della query: 3.229 MB Righe restituite: 1
SELECT count(*)

  FROM `vxscv_extensions`

  WHERE `element` = 'cwgears' 
  AND `extension_id` = ''
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 1.63 ms Dopo l'ultima query: 1.64 ms Memoria query: 0.021 MB memoria prima della query: 3.238 MB Righe restituite: 1
SELECT template, s.params

  FROM vxscv_template_styles as s

  LEFT JOIN vxscv_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	filtered	Extra
1	SIMPLE	s	ref	idx_home	idx_home	28	const	2	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	focusing45141.s.template,const	1	100.00	Using where
Profilo
Call Stack
Tempo della query: 2.66 ms Dopo l'ultima query: 25.35 ms Memoria query: 0.038 MB memoria prima della query: 3.862 MB Righe restituite: 47
SHOW FULL COLUMNS 
  FROM `vxscv_icagenda_events`
Explain
Profilo
Call Stack
Tempo della query: 1.28 ms Dopo l'ultima query: 68.01 ms Memoria query: 0.027 MB memoria prima della query: 4.849 MB Righe restituite: 1
SELECT enabled

  FROM `vxscv_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'system' 
  AND `element` = 'languagefilter'
Explain
Profilo
Call Stack
Tempo della query: 2.11 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.039 MB memoria prima della query: 4.865 MB Righe restituite: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM vxscv_fields AS a

  LEFT JOIN `vxscv_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN vxscv_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN vxscv_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN vxscv_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN vxscv_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_icagenda.event' 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	focusing45141.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	focusing45141.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	focusing45141.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	focusing45141.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	focusing45141.a.group_id	1	100.00	Using where
Profilo
Call Stack
Tempo della query: 0.83 ms Dopo l'ultima query: 10.56 ms Memoria query: 0.024 MB memoria prima della query: 4.886 MB Righe restituite: 3
SELECT c.color AS color, c.title AS title

  FROM vxscv_icagenda_category AS c

  WHERE c.state = 1
Explain
Profilo
Call Stack
Tempo della query: 1.04 ms Dopo l'ultima query: 15.88 ms Memoria query: 0.027 MB memoria prima della query: 5.115 MB Righe restituite: 3
SELECT c.ordering, c.title, c.state, c.id

  FROM `vxscv_icagenda_category` AS c

  WHERE `c`.`state` <> -2 
  AND `c`.`state` IN (1) 

  ORDER BY c.title ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ref	idx_state	idx_state	1	const	2	100.00	Using where; Using filesort
Profilo
Call Stack
Tempo della query: 0.71 ms Dopo l'ultima query: 13.68 ms Memoria query: 0.032 MB memoria prima della query: 5.230 MB Righe restituite: 1
Query duplicate: #23  #29
SELECT *

  FROM vxscv_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vxscv_wf_profiles	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	4	100.00	Using where; Using filesort
Profilo
Call Stack
Tempo della query: 1.76 ms Dopo l'ultima query: 0.75 ms Memoria query: 0.036 MB memoria prima della query: 5.247 MB Righe restituite: 18
SHOW FULL COLUMNS 
  FROM `vxscv_extensions`
Explain
Profilo
Call Stack
Tempo della query: 1.07 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.029 MB memoria prima della query: 5.292 MB Righe restituite: 1
SELECT `extension_id`

  FROM `vxscv_extensions`

  WHERE type = 'component' 
  AND element = 'com_icagenda'
Explain
Profilo
Call Stack
Tempo della query: 0.61 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.034 MB memoria prima della query: 5.305 MB Righe restituite: 1
SELECT *

  FROM vxscv_extensions

  WHERE `extension_id` = '10026'
Explain
Profilo
Call Stack
Tempo della query: 0.49 ms Dopo l'ultima query: 19.85 ms Memoria query: 0.034 MB memoria prima della query: 5.606 MB Righe restituite: 1
Query duplicate: #19  #29
SELECT *

  FROM vxscv_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vxscv_wf_profiles	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	4	100.00	Using where; Using filesort
Profilo
Call Stack
Tempo della query: 0.57 ms Dopo l'ultima query: 0.64 ms Memoria query: 0.031 MB memoria prima della query: 5.707 MB Righe restituite: 1
SELECT `extension_id`

  FROM `vxscv_extensions`

  WHERE type = 'plugin' 
  AND folder = 'editors' 
  AND element = 'jce'
Explain
Profilo
Call Stack
Tempo della query: 0.36 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.036 MB memoria prima della query: 5.722 MB Righe restituite: 1
SELECT *

  FROM vxscv_extensions

  WHERE `extension_id` = '10038'
Explain
Profilo
Call Stack
Tempo della query: 0.54 ms Dopo l'ultima query: 0.45 ms Memoria query: 0.031 MB memoria prima della query: 5.738 MB Righe restituite: 1
SELECT `extension_id`

  FROM `vxscv_extensions`

  WHERE type = 'component' 
  AND element = 'com_jce'
Explain
Profilo
Call Stack
Tempo della query: 0.40 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.036 MB memoria prima della query: 5.753 MB Righe restituite: 1
SELECT *

  FROM vxscv_extensions

  WHERE `extension_id` = '10037'
Explain
Profilo
Call Stack
Tempo della query: 0.40 ms Dopo l'ultima query: 11.12 ms Memoria query: 0.031 MB memoria prima della query: 5.794 MB Righe restituite: 1
Query duplicate: #30
SELECT id, template

  FROM vxscv_template_styles

  WHERE client_id = 0 
  AND home = '1'
Explain
Profilo
Call Stack
Tempo della query: 0.44 ms Dopo l'ultima query: 13.46 ms Memoria query: 0.038 MB memoria prima della query: 5.983 MB Righe restituite: 1
Query duplicate: #19  #23
SELECT *

  FROM vxscv_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vxscv_wf_profiles	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	4	100.00	Using where; Using filesort
Profilo
Call Stack
Tempo della query: 0.86 ms Dopo l'ultima query: 4.21 ms Memoria query: 0.031 MB memoria prima della query: 6.035 MB Righe restituite: 1
Query duplicate: #28
SELECT id, template

  FROM vxscv_template_styles

  WHERE client_id = 0 
  AND home = '1'
Explain
Profilo
Call Stack
Tempo della query: 0.41 ms Dopo l'ultima query: 30.63 ms Memoria query: 0.029 MB memoria prima della query: 6.441 MB Righe restituite: 0
Query duplicate: #32
SELECT title, id 
  FROM vxscv_pagebuilderck_pages 
  WHERE state=1
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 0.24 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.030 MB memoria prima della query: 6.453 MB Righe restituite: 0
Query duplicate: #31
SELECT title, id 
  FROM vxscv_pagebuilderck_pages 
  WHERE state=1
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 0.35 ms Dopo l'ultima query: 5.22 ms Memoria query: 0.029 MB memoria prima della query: 6.496 MB Righe restituite: 0
SELECT id AS value, title AS features 
  FROM vxscv_icagenda_feature 
  WHERE state=1 
  AND icon IS NOT NULL 
  AND icon!='' 
  ORDER BY features
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 0.44 ms Dopo l'ultima query: 19.23 ms Memoria query: 0.032 MB memoria prima della query: 6.505 MB Righe restituite: 0
SELECT cf.*

  FROM `vxscv_icagenda_customfields` AS cf

  WHERE `cf`.`parent_form` = '2' 
  AND `cf`.`state` = 1

  ORDER BY cf.ordering ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 0.46 ms Dopo l'ultima query: 6.96 ms Memoria query: 0.028 MB memoria prima della query: 6.561 MB Righe restituite: 5
Query duplicate: #38
SELECT `a`.`id` AS `value`, `a`.`title` AS `text`

  FROM `vxscv_viewlevels` AS `a`

  GROUP BY `a`.`id`,`a`.`title`,`a`.`ordering`

  ORDER BY `a`.`ordering` ASC,`title` ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	100.00	Using filesort
Profilo
Call Stack
Tempo della query: 0.41 ms Dopo l'ultima query: 4.04 ms Memoria query: 0.029 MB memoria prima della query: 6.571 MB Righe restituite: 0
SELECT f.*

  FROM `vxscv_icagenda_filters` AS f

  WHERE `type` = "customfield" 
  AND `filter` = "groups" 
  AND `state` = 1

  ORDER BY f.option ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 0.43 ms Dopo l'ultima query: 7.50 ms Memoria query: 0.026 MB memoria prima della query: 6.627 MB Righe restituite: 0
SELECT title 
  FROM vxscv_content 
  WHERE id = 0
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 0.76 ms Dopo l'ultima query: 14.70 ms Memoria query: 0.029 MB memoria prima della query: 6.653 MB Righe restituite: 5
Query duplicate: #35
SELECT `a`.`id` AS `value`, `a`.`title` AS `text`

  FROM `vxscv_viewlevels` AS `a`

  GROUP BY `a`.`id`,`a`.`title`,`a`.`ordering`

  ORDER BY `a`.`ordering` ASC,`title` ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	100.00	Using filesort
Profilo
Call Stack
Tempo della query: 0.51 ms Dopo l'ultima query: 0.76 ms Memoria query: 0.029 MB memoria prima della query: 6.665 MB Righe restituite: 2
SELECT a.lang_code AS value, a.title AS text, a.title_native

  FROM vxscv_languages AS a

  WHERE a.published >= 0

  ORDER BY a.title
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	100.00	Using where; Using filesort
Profilo
Call Stack
Tempo della query: 1.12 ms Dopo l'ultima query: 14.10 ms Memoria query: 0.025 MB memoria prima della query: 6.823 MB Righe restituite: 4
SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `vxscv_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1
Explain
Profilo
Call Stack
Tempo della query: 2.11 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.028 MB memoria prima della query: 6.848 MB Righe restituite: 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM vxscv_modules AS m

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

  LEFT JOIN vxscv_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 <= '2019-12-22 11:32:35') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-22 11:32:35') 
  AND m.access IN (1,1,2,3,6) 
  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	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	9	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	focusing45141.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	focusing45141.m.id	2	100.00	Using where; Using index
Profilo
Call Stack
Tempo della query: 1.34 ms Dopo l'ultima query: 4.96 ms Memoria query: 0.024 MB memoria prima della query: 6.881 MB Righe restituite: 4
SELECT element, name

  FROM vxscv_extensions

  WHERE `type` = 'plugin' 
  AND `folder` = 'editors' 
  AND `enabled` = 1
Explain
Profilo
Call Stack
Tempo della query: 0.51 ms Dopo l'ultima query: 2.74 ms Memoria query: 0.023 MB memoria prima della query: 6.903 MB Righe restituite: 1
SELECT COUNT(*)

  FROM vxscv_messages

  WHERE state = 0 
  AND user_id_to = 281
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 1.25 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 6.909 MB Righe restituite: 1
SELECT COUNT(session_id)

  FROM vxscv_session

  WHERE guest = 0 
  AND client_id = 1
Explain
Profilo
Call Stack
Tempo della query: 0.52 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 6.915 MB Righe restituite: 1
SELECT COUNT(session_id)

  FROM vxscv_session

  WHERE guest = 0 
  AND client_id = 0
Explain
Profilo
Call Stack
Tempo della query: 1.05 ms Dopo l'ultima query: 8.10 ms Memoria query: 0.025 MB memoria prima della query: 7.078 MB Righe restituite: 4
SELECT a.title, a.menutype, 
  CASE COALESCE(SUM(m.home), 0) WHEN 0 THEN '' WHEN 1 THEN 
  CASE m.language WHEN '*' THEN 'class:icon-home' ELSE CONCAT('image:mod_languages/', l.image, '.gif') END ELSE 'image:mod_languages/icon-16-language.png' END AS icon

  FROM vxscv_menu_types AS a

  LEFT JOIN vxscv_menu AS m 
  ON m.menutype = a.menutype 
  AND m.home = 1 
  LEFT JOIN vxscv_languages AS l 
  ON l.lang_code = m.language

  WHERE a.client_id = 0

  GROUP BY a.id, m.language, l.image

  ORDER BY a.title ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	4	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	m	ref	idx_menutype	idx_menutype	98	focusing45141.a.menutype	18	100.00	Using where
1	SIMPLE	l	ALL	idx_langcode	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
Profilo
Call Stack
Tempo della query: 0.36 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.025 MB memoria prima della query: 7.097 MB Righe restituite: 0
SELECT title, menutype

  FROM vxscv_menu_types

  WHERE client_id = 1

  ORDER BY title ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vxscv_menu_types	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	4	100.00	Using where; Using filesort
Profilo
Call Stack
Tempo della query: 1.35 ms Dopo l'ultima query: 6.72 ms Memoria query: 0.061 MB memoria prima della query: 7.201 MB Righe restituite: 71
SELECT m.*,e.element

  FROM vxscv_menu AS m

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

  WHERE m.menutype = 'main' 
  AND m.client_id = 1 
  AND m.id > 1 
  AND (e.enabled = 1 OR e.enabled IS NULL)

  ORDER BY m.lft
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,idx_client_id_parent_id_alias_language,idx_menutype	idx_client_id_parent_id_alias_language	1	const	59	100.00	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	focusing45141.m.component_id	1	100.00	Using where
Profilo
Call Stack
Tempo della query: 0.51 ms Dopo l'ultima query: 18.44 ms Memoria query: 0.028 MB memoria prima della query: 7.424 MB Righe restituite: 1
Query duplicate: #3
SELECT *

  FROM `vxscv_users`

  WHERE `id` = 281
Explain
Profilo
Call Stack
Tempo della query: 0.34 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.024 MB memoria prima della query: 7.434 MB Righe restituite: 1
Query duplicate: #4
SELECT `g`.`id`,`g`.`title`

  FROM `vxscv_usergroups` AS g

  INNER JOIN `vxscv_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 281
Explain
Profilo
Call Stack
37 tipi di query eseguite, ordinate per Occurrences
Tabelle SELECT:
3 × SELECT * 
  FROM vxscv_extensions
3 × SELECT `extension_id` 
  FROM `vxscv_extensions`
3 × SELECT * 
  FROM vxscv_wf_profiles
2 × SELECT `a`.`id` AS `value`, `a`.`title` AS `text` 
  FROM `vxscv_viewlevels` AS `a` 
  GROUP BY `a`.`id`,`a`.`title`,`a`.`ordering`
2 × SELECT id, template 
  FROM vxscv_template_styles
2 × SELECT * 
  FROM `vxscv_users`
2 × SELECT title, id 
  FROM vxscv_pagebuilderck_pages
2 × SELECT COUNT(session_id) 
  FROM vxscv_session
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `vxscv_extensions`
2 × SELECT `g`.`id`,`g`.`title` 
  FROM `vxscv_usergroups` AS g 
  INNER JOIN `vxscv_user_usergroup_map` AS m 
  ON m.group_id = g.id
1 × SELECT COUNT(*) 
  FROM vxscv_messages
1 × SELECT element, name 
  FROM vxscv_extensions
1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `vxscv_extensions`
1 × SELECT a.lang_code AS value, a.title AS text, a.title_native 
  FROM vxscv_languages AS a
1 × SELECT title 
  FROM vxscv_content
1 × SELECT f.* 
  FROM `vxscv_icagenda_filters` AS f
1 × SELECT a.title, a.menutype, 
  CASE COALESCE(SUM(m.home), 0) WHEN 0 THEN '' WHEN 1 THEN 
  CASE m.language WHEN '*' THEN 'class:icon-home' ELSE CONCAT('image:mod_languages/', l.image, '.gif') END ELSE 'image:mod_languages/icon-16-language.png' END AS icon 
  FROM vxscv_menu_types AS a 
  LEFT JOIN vxscv_menu AS m 
  ON m.menutype = a.menutype 
  AND m.home = 1 
  LEFT JOIN vxscv_languages AS l 
  ON l.lang_code = m.language
1 × SELECT title, menutype 
  FROM vxscv_menu_types
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM vxscv_modules AS m 
  LEFT JOIN vxscv_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN vxscv_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id
1 × SELECT `data` 
  FROM `vxscv_session`
1 × SELECT cf.* 
  FROM `vxscv_icagenda_customfields` AS cf
1 × SELECT id AS value, title AS features 
  FROM vxscv_icagenda_feature
1 × SELECT c.ordering, c.title, c.state, c.id 
  FROM `vxscv_icagenda_category` AS c
1 × SELECT c.color AS color, c.title AS title 
  FROM vxscv_icagenda_category AS c
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM vxscv_fields AS a 
  LEFT JOIN `vxscv_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN vxscv_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN vxscv_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN vxscv_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN vxscv_fields_groups AS g 
  ON g.id = a.group_id
1 × SELECT enabled 
  FROM `vxscv_extensions`
1 × SELECT template, s.params 
  FROM vxscv_template_styles as s 
  LEFT JOIN vxscv_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id
1 × SELECT count(*) 
  FROM `vxscv_extensions`
1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `vxscv_assets`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM vxscv_extensions
1 × SELECT b.id 
  FROM vxscv_user_usergroup_map AS map 
  LEFT JOIN vxscv_usergroups AS a 
  ON a.id = map.group_id 
  LEFT JOIN vxscv_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt
1 × SELECT id, rules 
  FROM `vxscv_viewlevels
1 × SELECT m.*,e.element 
  FROM vxscv_menu AS m 
  LEFT JOIN vxscv_extensions AS e 
  ON m.component_id = e.extension_id
ALTRE tabelle:
1 × SHOW FULL COLUMNS 
  FROM `vxscv_users
1 × UPDATE `vxscv_extensions` 
  SET `params` = '{\"mediaversion\":\"931875b7571c513e679a0343dec090ee\"}'
1 × SHOW FULL COLUMNS 
  FROM `vxscv_icagenda_events
1 × SHOW FULL COLUMNS 
  FROM `vxscv_extensions
Last edit: 4 years 5 months ago by giusebos.

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

  • giusebos
  • giusebos's Avatar
  • Moderator
  • Moderator
More
4 years 5 months ago #16820 by giusebos
Replied by giusebos on topic conflitti icagenda 3.7.10 2 joomla 3.9.8
mi dispiace, ma non vedo nessun errore. controlla i requisiti minimi di joomla e icagenda, prova a nche a vedere se hai lo stesso problema con il template protostar.

cortesemente (per la sicurezza di questo forum) se posti del codice usa i tag CODE altrimenti mi vedrò costretto a cancellarlo. questa volta l'ho fatto io per te.

HAI BISOGNO DI ASSISTENZA?
leggi qui

Guarda tutti i video tutorial di iCagenda
Watch all video tutorials iCagenda
Regardez toutes les vidéos tutoriels iCagenda
Ver todos los videos tutoriales iCagenda

guarda qui

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

Moderators: giusebos
Time to create page: 0.278 seconds

Follow Us

Create your Joomla templates with Template Creator CK

acymailing logo new