Error while browsing articles

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.

[cinq]

Yikes, missing table prefix at the line

LEFT JOIN articles_article a

add it in and you'll be fine

[InDepthArts]

Worked like a charm Cinq! Sorry to be such a pain in the ass. I have another problem I noticed, would you rather me open a new thread or discuss it here?

Eric

[cinq]

Just post it here

[InDepthArts]

Ok, thanks! It seems that my articles (article at this point) isnt being associated with its category. The article had been assigned to a category but browsing to that category doesnt show the article. You can see what I am talking about by visiting my site:

http://www.indeptharths.org/articles.php

[cinq]

Which category did you place Victoria in ?

[InDepthArts]

Reviews > Poser

If I go to the review from the main page the breadcrumb trail looks fine but if I use the links on the left to try and browse to the review it says no reviews in this category.

[cinq]

She's a draft article probably. You need to 'un-draft' this article.

Not very logical that a draft can be seen in the first place, issue is fixed in v2.0

[InDepthArts]

Duh! I didn't even think of that! Thanks Cinq, you have been an awesome developer to work with. When is 2.0 coming out and how hard will it be to upgrade?

[cinq]

v2.0 will be out on the 21st
Upgrade will be easy, should be done in about 5-10 mins.