Invision Error

[Broly238]

So I opened a support ticket about this, and (I don't mean to be rude) but it didn't help me at all.

 

Anyway, as of Tuesday my forum puts out this error.

 

>mySQL query error: SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,
			   c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
			   FROM ibf_forums f, ibf_categories c
				 LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
			   WHERE c.id=f.category
			   ORDER BY c.position, f.position

mySQL error: Unknown column 'f.id' in 'on clause'
mySQL error code: 
Date: Sunday 18th 2007f November 2007 11:20:39 PM

 

Thats when you try to view the main board, however going to admin.php works... the members list work, profiles works, just the main board puts out that error.

 

I'm not the greatest at SQL so Im not sure what to try. I've dumped the database and uploaded a backup... Same thing. So I am here to ask... what should I try now?

[TCH-Andy]

Are you running the latest version of Invision ? I'm guessing it's an old version, that you need to upgrade so that it runs on PHP5/MySQL5

 

What's the domain name - so we can have a look ? ( You can PM the domain name if you don't want to put it on the open forums)

[TCH-Bruce]

If you are running Invision version 1.2 or 1.3 see the pinned thread here.

[OJB]

I had this exact error the other day on my IPB 1.3 forum

 

 

heres the fix:

 

 

In sources/Board.php

 

find the entire of this query:

 

>SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc

 

change it to:

 

>$DB->query("SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,
		c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
		FROM ( ibf_forums f, ibf_categories c )
		  LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
		WHERE c.id=f.category
		ORDER BY c.position, f.position");

 

 

The only change is actually putting parenthesis around ibf_forums f, ibf_categories c

Edited November 26, 2007 by OJB