Server Help

Gravitron · Posted: Sat Jul 30, 2005 5:31 pm *Post maybe stupid* Post subject: Help time.

My turn to ask.

Gravitron · Posted: Sat Jul 30, 2005 5:46 pm *Post maybe stupid* Post subject:

Alright, so I'm missing a category table.
I think I know why, I messed with categories and forums earlier (like 24 hours ago, heh).
But which table indexes the missing table?
Where is it hiding, must find...then can remove...then no more errors!

Solo Ace · Posted: Sat Jul 30, 2005 5:46 pm *Post maybe stupid* Post subject:

This really looks a little different from the last version I downloaded of phpBB2 and the package I just downloaded now.

Code: Show/Hide

$sql = "SELECT f.*
   FROM " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c
   WHERE f.cat_id = c.cat_id
   ORDER BY c.cat_order, f.forum_order ASC";
if ( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, "Couldn't obtain forum information", "", __LINE__, __FILE__, $sql);
}

It's even on another line.

I'd suggest re-downloading instead of trying to fix all these problems manually.
I doubt you need any explaination about the bugged SQL query after what I just posted, it's obvious the definition for 'c' is missing in your version.

Solo Ace · Posted: Sat Jul 30, 2005 5:47 pm *Post maybe stupid* Post subject:

Damn you, posting 2 seconds before I do huh.

Gravitron · Posted: Sat Jul 30, 2005 6:39 pm *Post maybe stupid* Post subject:

http://www.phpbbfm.net

Pests · Novice Joined: Feb 24 2003 Posts: 84 Offline

If you look at the original query:

SELECT * FROM phpbb_forums f WHERE f.cat_id = c.cat_id ORDER BY c.cat_order, f.forum_order ASC

You see phpbb_forums is being represented as f later in the query. The problem is, c is being used as a reference before it was defined. I'm assuming c stands for category, so you need to change the query to:

SELECT * FROM phpbb_forums f, phpbb_category c WHERE f.cat_id = c.cat_id ORDER BY c.cat_order, f.forum_order ASC

Assuming phpbb_category is the name of the category table (not sure if its plural or whatnot).

Cyan~Fire · Posted: Mon Aug 01, 2005 11:21 am *Post maybe stupid* Post subject:

Uhhh, Pests, look at Solo Ace's post.
_________________
This help is informational only. No representation is made or warranty given as to its content. User assumes all risk of use. Cyan~Fire assumes no responsibility for any loss or delay resulting from such use.
Wise men STILL seek Him.

Pests · Novice Joined: Feb 24 2003 Posts: 84 Offline

Damn, thats what I get for not reading replies.