I am running MOS 4.5.1.0.9 and installed a component (Docman1.23). The component listing shows it but whenever I try to do anything with it I get a long statement saying that the database table I am trying to use does not exist.
Quote:
|
Table 'db91181488.arr_docman' doesn't exist SQL=SELECT c.*, g.name AS groupname, u.name AS editor,COUNT(DISTINCT s2.checked_out) AS checked_out, COUNT(DISTINCT s1.id) AS num FROM arr_categories AS c LEFT JOIN arr_users AS u ON u.id = c.checked_out LEFT JOIN arr_groups AS g ON g.id = c.access LEFT JOIN arr_docman AS s1 ON s1.catid = c.id LEFT JOIN arr_docman AS s2 ON s2.catid = c.id AND s2.checked_out > 0 WHERE section='com_docman' GROUP BY c.id ORDER BY c.ordering, c.name LIMIT 0,10
|
- Checked via phpmyadmin, and the table does exist.
- Everything else in the site works thus (possibly) eliminating problems of connectivity to the database, i.e. other components work fine on both frontend and backends.
Thoughts? Suggestions on what to check? While I understand the basic principles of coding, I am most definitely not a coder - the reason I chose Mambo is because of its user-friendliness! - so please bear with me.
Also, my hosting company only allows for one database so I have been creating the tables using different prefixes (dbinstall hack) which appears to be working so far to set up a couple of demo/proof-of-concept sites. Any caveats? Before I install any components I have been checking the XML file to point it to the right table prefix.
Thanks!
Problems with component accessing database 
Linear Mode
