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.
Labels |
Added:
?
|
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2018-11-08 09:38:32 |
Closed_By | ⇒ | brianteeman |
Closed as not a core issue
as already said this is not a core extension, please contact the author for further support. I deleted your last comment
"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 "
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".