mySQL error: Unknown column ‘f.id’ in ‘on clause’

Hello,

On invision board if you are getting the mySQL error: Unknown column ‘f.id’ in ‘on clause’ error then you can fix it by doing these changes in your two files.
Open sources/boards.php

Find:

CODE

$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”);

Replace with:

CODE

$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”);

Save & upload sources/boards.php

Open sources/dynamiclite/csite.php
Find:

CODE

$DB->query(”SELECT t.tid, t.title, t.state, t.last_vote, p.* $sql
FROM ibf_topics t, ibf_polls p
$extra
WHERE t.tid=$tid AND p.tid=t.tid”);

Replace with:

CODE

$DB->query(”SELECT t.tid, t.title, t.state, t.last_vote, p.* $sql
FROM (ibf_topics t, ibf_polls p)
$extra
WHERE t.tid=$tid AND p.tid=t.tid”);

Save & upload sources/dynamiclite/csite.php

Enjoy…

Jason