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 :-)