Hoy se actualizo el servidor del departamento a la nueva version de debian (etch), y nos encontramos con mas de un problema al terminar el apt, ahora les podré la solucion del error que me aparecia en el foro invision board 1.3.1

El error de ipb decia

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

solucion

Open sources/boards.php

Find:

$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
Enlace con solucion