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\u00c3\u00a9 la solucion del error que me aparecia en el foro invision board 1.3.1<\/p>\n
El error de ipb decia<\/p>\n
mysql error: Unknown column ‘f.id’ in ‘on clause’ <\/strong><\/p>\n Open sources\/boards.php<\/em><\/p>\n Find:<\/strong><\/p>\n $DB->query(\u00e2\u20ac\u009dSELECT 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, Replace with:<\/strong><\/p>\n CODE<\/p>\n $DB->query(\u00e2\u20ac\u009dSELECT 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, Save & upload sources\/boards.php<\/em><\/p>\n Open sources\/dynamiclite\/csite.php<\/em> CODE<\/p>\n $DB->query(\u00e2\u20ac\u009dSELECT t.tid, t.title, t.state, t.last_vote, p.* $sql Replace with:<\/strong><\/p>\n CODE<\/p>\n $DB->query(\u00e2\u20ac\u009dSELECT t.tid, t.title, t.state, t.last_vote, p.* $sqlsolucion<\/strike><\/p>\n
\nc.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
\nFROM ibf_forums f, ibf_categories c
\nLEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
\nWHERE c.id=f.category
\nORDER BY c.position, f.position\u00e2\u20ac\u009d);<\/p>\n
\nc.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
\nFROM (ibf_forums f, ibf_categories c)
\nLEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
\nWHERE c.id=f.category
\nORDER BY c.position, f.position\u00e2\u20ac\u009d);<\/p>\n
\nFind:<\/strong><\/p>\n
\nFROM ibf_topics t, ibf_polls p
\n$extra
\nWHERE t.tid=$tid AND p.tid=t.tid\u00e2\u20ac\u009d);<\/p>\n
\nFROM (ibf_topics t, ibf_polls p)
\n$extra
\nWHERE t.tid=$tid AND p.tid=t.tid\u00e2\u20ac\u009d);<\/p>\n