problems with Module Manager
-
-
Hi,
I have already posted this problem at Joomla.org but not one has come up with a solution.
When I enter the Module Manager, this is the debug output and everything is OK
16 queries executed
1
SELECT template
FROM jos_templates_menu
WHERE client_id = 1
AND menuid = 0
2
DELETE FROM jos_session
WHERE time < '1176384453'
AND guest = 1
AND gid = 0
AND userid <> 0
3
UPDATE jos_session
SET time = '1176386253'
WHERE session_id = '53978d9be0bd74a0d4dd80305a4c10b6'
4
SELECT COUNT( session_id )
FROM jos_session
WHERE session_id = '53978d9be0bd74a0d4dd80305a4c10b6'
AND username = 'eurep999'
AND userid = 62
5
SELECT COUNT(*)
FROM jos_modules AS m
WHERE m.client_id = 0
6
SELECT m.*, u.name AS editor, g.name AS groupname, MIN(mm.menuid) AS pages
FROM jos_modules AS m
LEFT JOIN jos_users AS u ON u.id = m.checked_out
LEFT JOIN jos_groups AS g ON g.id = m.access
LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
WHERE m.client_id = 0
GROUP BY m.id
ORDER BY position ASC, ordering ASC
LIMIT 30
7
SELECT t.position AS value, t.position AS text
FROM jos_template_positions as t
LEFT JOIN jos_modules AS m ON m.position = t.position
WHERE m.client_id = 0
GROUP BY t.position
ORDER BY t.position
8
SELECT module AS value, module AS text
FROM jos_modules
WHERE client_id = 0
GROUP BY module
ORDER BY module
9
SELECT a.id, a.title, a.name
FROM jos_sections AS a
WHERE a.scope = 'content'
GROUP BY a.id
ORDER BY a.ordering
10
SELECT params
FROM jos_modules
WHERE module = 'mod_mainmenu'
ORDER BY title
11
SELECT menutype
FROM jos_menu
GROUP BY menutype
ORDER BY menutype
12
SELECT *
FROM jos_components
WHERE name != 'frontpage'
AND name != 'media manager'
ORDER BY ordering, name
13
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
WHERE m.published = 1
AND m.position = 'header'
AND m.client_id = 1
ORDER BY m.ordering
14
SELECT COUNT(*)
FROM jos_messages
WHERE state = 0
AND user_id_to = 62
15
SELECT COUNT( session_id )
FROM jos_session
WHERE session_id != '53978d9be0bd74a0d4dd80305a4c10b6'
16
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
WHERE m.published = 1
AND m.position = 'debug'
AND m.client_id = 1
ORDER BY m.ordering
When I select a module to edit, and go to the URL
eureporter.co.uk/administrator/index2.ph...hidemainmenu=1&id=61
I get this error.
"The server encountered an unexpected condition which prevented it from fulfilling the request.
The script had an error or it did not produce any output. If there was an error, you should be able to see it in the error log. "
I have already posted this before but not one has come up with a solution. It appears that the problem is to do with the number of rows in the JOS_MENU table - if I insert over about 1200 rows, I get the below error - if I delete rows from the JOS_MENU table, I can edit modules .
As I have stated before, I do not understand why the number of rows in the JOS_MENU table is giving an error when trying to edit a module.
As this thread is about HIGH: sql executions , could this be a problem.
I have struggled to overcome this problem - the only solution at the present is to backup the JOS_MENU table, delete the rows, modify a module, then re-import the JOS_MENU table.
Any help please
Ian.
-
Time to create page: 0.051 seconds