vb.org Archive - Error while browsing articles

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vbArticles (https://vborg.vbsupport.ru/forumdisplay.php?f=106)

- - Error while browsing articles (https://vborg.vbsupport.ru/showthread.php?t=76664)

InDepthArts

02-20-2005 12:36 AM

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)

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

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	02-20-2005 01:21 AM

Just post it here :)

InDepthArts

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	02-20-2005 01:29 AM

Which category did you place Victoria in ?

InDepthArts

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

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	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.

All times are GMT. The time now is 10:30 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01002 seconds Memory Usage 1,727KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: