I’m working on writing a new module, and I wanted to associate a couple Snippets and Chunks with it, but when I go to Manage Module Dependencies, I get a nasty MODx Parse Error:
Execution of a query to the database failed - Table ’mydatabase.smd’ doesn’t exist
I haven’t done anything to the database that I know of. Is there any hope of repairing this?
Here’s the SQL query that’s causing problems:
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 `mydatabase`.`site_htmlsnippets` sc ON sc.id = smd.resource AND smd.type = '10' LEFT JOIN `mydatabase`.`site_content` sd ON sd.id = smd.resource AND smd.type = '20' LEFT JOIN `mydatabase`.`site_plugins` sp ON sp.id = smd.resource AND smd.type = '30' LEFT JOIN `mydatabase`.`site_snippets` ss ON ss.id = smd.resource AND smd.type = '40' LEFT JOIN `mydatabase`.`site_templates` st ON st.id = smd.resource AND smd.type = '50' LEFT JOIN `mydatabase`.`site_tmplvars` sv ON sv.id = smd.resource AND smd.type = '60' WHERE smd.module=4 ORDER BY smd.type,name
☆ A M B ☆
MODX Staff
