MODx CMF

Manage Dependencies causes error

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Duplicate
  • Affects Version/s: 0.9.6.2-rc1
  • Fix Version/s: None
  • Description:
    Hide

    Going to the Module Dependencies page causes a fatal error:

    « MODx Parse Error »
    MODx encountered the following error while attempting to parse the requested resource:
    « Execution of a query to the database failed - Table 'modx_096.smd' doesn't exist »
    SQL: SELECT smd.id,COALESCE(ss.name,st.templatename,sv.name,sc.name,sp.name,sd.pagetitle) as 'name',CASE smd.type WHEN 10 THEN 'Chunk' WHEN 20 THEN 'Document' WHEN 30 THEN 'Plugin' WHEN 40 THEN 'Snippet' WHEN 50 THEN 'Template' WHEN 60 THEN 'TV' END as 'type' FROM smd LEFT JOIN `modx_096`.`modx_site_htmlsnippets` sc ON sc.id = smd.resource AND smd.type = '10' LEFT JOIN `modx_096`.`modx_site_content` sd ON sd.id = smd.resource AND smd.type = '20' LEFT JOIN `modx_096`.`modx_site_plugins` sp ON sp.id = smd.resource AND smd.type = '30' LEFT JOIN `modx_096`.`modx_site_snippets` ss ON ss.id = smd.resource AND smd.type = '40' LEFT JOIN `modx_096`.`modx_site_templates` st ON st.id = smd.resource AND smd.type = '50' LEFT JOIN `modx_096`.`modx_site_tmplvars` sv ON sv.id = smd.resource AND smd.type = '60' WHERE smd.module=3 ORDER BY smd.type,name
    [Copy SQL to ClipBoard]

    Parser timing
    MySQL: 0.0024 s (0 Requests)
    PHP: 1216828601.8480 s
    Total: 1216828601.8504 s

    Show
    Going to the Module Dependencies page causes a fatal error: « MODx Parse Error » MODx encountered the following error while attempting to parse the requested resource: « Execution of a query to the database failed - Table 'modx_096.smd' doesn't exist » SQL: SELECT smd.id,COALESCE(ss.name,st.templatename,sv.name,sc.name,sp.name,sd.pagetitle) as 'name',CASE smd.type WHEN 10 THEN 'Chunk' WHEN 20 THEN 'Document' WHEN 30 THEN 'Plugin' WHEN 40 THEN 'Snippet' WHEN 50 THEN 'Template' WHEN 60 THEN 'TV' END as 'type' FROM smd LEFT JOIN `modx_096`.`modx_site_htmlsnippets` sc ON sc.id = smd.resource AND smd.type = '10' LEFT JOIN `modx_096`.`modx_site_content` sd ON sd.id = smd.resource AND smd.type = '20' LEFT JOIN `modx_096`.`modx_site_plugins` sp ON sp.id = smd.resource AND smd.type = '30' LEFT JOIN `modx_096`.`modx_site_snippets` ss ON ss.id = smd.resource AND smd.type = '40' LEFT JOIN `modx_096`.`modx_site_templates` st ON st.id = smd.resource AND smd.type = '50' LEFT JOIN `modx_096`.`modx_site_tmplvars` sv ON sv.id = smd.resource AND smd.type = '60' WHERE smd.module=3 ORDER BY smd.type,name [Copy SQL to ClipBoard] Parser timing MySQL: 0.0024 s (0 Requests) PHP: 1216828601.8480 s Total: 1216828601.8504 s
  • Environment:
    WinXP, XAMPP for Windows Version 1.6.6a, PHP 5.2.5, Apache 2.0, MySQL 5.0.51a

Activity

Hide
Max Paprikas added a comment - 01/Sep/08 11:22 AM - edited

oops. I missed this issue..
my duplicate with fix http://svn.modxcms.com/jira/browse/MODX-289

Show
Max Paprikas added a comment - 01/Sep/08 11:22 AM - edited oops. I missed this issue.. my duplicate with fix http://svn.modxcms.com/jira/browse/MODX-289
Hide
Garry Nutting added a comment - 17/Sep/08 8:31 PM

Duplicate of MODX-289 and other issue has fix posted so will close this one down.

Show
Garry Nutting added a comment - 17/Sep/08 8:31 PM Duplicate of MODX-289 and other issue has fix posted so will close this one down.

People

Dates

  • Created:
    23/Jul/08 11:01 AM
    Updated:
    17/Sep/08 8:31 PM
    Resolved:
    17/Sep/08 8:31 PM