Helpful Information
 
 
Category: vbArticles
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.

Yikes, missing table prefix at the line


LEFT JOIN articles_article a


add it in and you'll be fine :)

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

Just post it here :)

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

Which category did you place Victoria in ?

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.

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

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?

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

Is there a list somewhere that shows the features that are going to be added?

Can't wait, can you :D
See the change log thread here (http://www.vbulletin.org/forum/showthread.php?t=76394) ;)

Some additional stuff I did not list ... did quite a lot of changes, some I've already forgotten lol

Can't wait for the submit article feature so I can have the rest of my team help me move them over without giving them access to the admin CP :-)

Any way to get an early release?










privacy (GDPR)