InDepthArts
02-20-2005, 12:36 AM
Hello Cinq,
I get the following error when trying to go from an article back to the articles category (using the breadcrumb navigation)
Invalid SQL:
SELECT c.categoryname, c.categorydesc, c.categoryimg, COUNT(*)
FROM ida_articles_category c
LEFT JOIN articles_article a
ON c.articles_categoryid = a.categoryid
WHERE c.articles_categoryid=1 AND a.draft!='1'
GROUP BY a.articles_articleid ;
mysql error: Table 'articles_article' doesn't exist
The table exists but it has my table prefix on it.
Any help would be appreciated,
Eric
PS: I sent you a PM about this but I figured I would post it here in case someone else has the same problem.
I get the following error when trying to go from an article back to the articles category (using the breadcrumb navigation)
Invalid SQL:
SELECT c.categoryname, c.categorydesc, c.categoryimg, COUNT(*)
FROM ida_articles_category c
LEFT JOIN articles_article a
ON c.articles_categoryid = a.categoryid
WHERE c.articles_categoryid=1 AND a.draft!='1'
GROUP BY a.articles_articleid ;
mysql error: Table 'articles_article' doesn't exist
The table exists but it has my table prefix on it.
Any help would be appreciated,
Eric
PS: I sent you a PM about this but I figured I would post it here in case someone else has the same problem.