The Arcive of vBulletin Modifications Site.

Error while browsing articles · **Released**: 02-20-2005

Hello Cinq,

I get the following error when trying to go from an article back to the articles category (using the breadcrumb navigation)

Code:

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 · #2 02-20-2005, 12:46 AM

Yikes, missing table prefix at the line

Code:

LEFT JOIN articles_article a

add it in and you'll be fine

InDepthArts · #3 02-20-2005, 01:16 AM

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 · #4 02-20-2005, 01:21 AM

Just post it here

InDepthArts · #5 02-20-2005, 01:24 AM

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 · #6 02-20-2005, 01:29 AM

Which category did you place Victoria in ?

InDepthArts · #7 02-20-2005, 01:31 AM

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 · #8 02-20-2005, 01:33 AM

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 · #9 02-20-2005, 01:37 AM

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 · #10 02-20-2005, 01:40 AM

v2.0 will be out on the 21st

Upgrade will be easy, should be done in about 5-10 mins.