Jump to content

Invision Error


Recommended Posts

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?

Link to post
Share on other sites

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)

Link to post
Share on other sites

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 by OJB
Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...