?
avatar toshidex
toshidex
8 Nov 2018

Hello everyone! I have a problem with the sites I'm managing. I'm noticing very strange queries:

SELECT m.id, m.title AS name, m.link, m.id AS parent, 1 as expandible, 1 as selectable, 0 as doc_icon, "submenu" AS view FROM iave_menu AS m INNER JOIN iave_menu_types AS s ON s. menutype = m.menutype AND s.menutype = "" OR SLEEP (5) - yPMC "INNER JOIN #__menu AS c on c.parent_id = m.id WHERE m.published = 1 AND m.parent_id = 1 AND m. access IN (1,1) UNION SELECT m.id, m.title AS name, m.link, 0 AS parent, 0 as expandible, 1 as selectable, 1 as doc_icon, "submenu" AS view FROM #__menu AS m INNER JOIN #__menu_types AS s ON s.menutype = m.menutype AND s.menutype = "" OR SLEEP (5) - yPMC "LEFT JOIN iave_menu AS c on c.parent_id = m.id WHERE m.published = 1 AND c .id IS NULL AND m.parent_id = 1 AND m.access IN (1,1) ORDER BY name

Is that "OR SLEEP (5) - yPMC" normal? Also because the queries are going for 5 minutes without doing anything.

Sorry for my bad English.

avatar toshidex toshidex - open - 8 Nov 2018
avatar joomla-cms-bot joomla-cms-bot - change - 8 Nov 2018
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 8 Nov 2018
avatar csthomas
csthomas - comment - 8 Nov 2018

Very likely. IMO this is no related to the joomla core.

I suggest looking in installed extensions (probably some menu module) that generates such a sql.

Try to find text like "doc_icon".

avatar brianteeman brianteeman - change - 8 Nov 2018
Status New Closed
Closed_Date 0000-00-00 00:00:00 2018-11-08 09:38:32
Closed_By brianteeman
avatar brianteeman
brianteeman - comment - 8 Nov 2018

Closed as not a core issue

avatar brianteeman brianteeman - close - 8 Nov 2018
avatar rdeutz
rdeutz - comment - 8 Nov 2018

as already said this is not a core extension, please contact the author for further support. I deleted your last comment

avatar infograf768
infograf768 - comment - 9 Nov 2018

"The JCK Editor has been a faithful friend and it is with some sadness that we announce its end-of-life. It's last maintenance release was on 09 March 2015 "
?

Add a Comment

Login with GitHub to post a comment