problemen forum

[iliander]

Hallo ik heb een eigen profielen site maar de forum geeft een sql fout ik krijg het zelf niet goed kan iemand mij helpen je kan het vinden op
www.zeeuwseprofiel.nl

alvast bedankt

[Michiel Otten]

Welke SQL fouten krijg je dan?

[Ruben K]

De layout werkt trouwens totaal niet in FireFox

[iliander]

deze fout

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 Forum_forums f, Forum_categories c
LEFT JOIN Forum_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: Monday 05th of November 2007 02:44:14 PM

[Ruben K]

de kolom "id" bestaat niet in de tabel "forum_forums"

[Joshua de Gier]

Zoals Ruben al zegt idd.. even via phpmyadmin kijken hoe dat veld heet. Waarschijnlijk iets van:

forum_id of f_id.

[iliander]

dan missen we een tabel

[iliander]

eerste fout opgelost

nu krijg ik dit


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 Forum_forums f, Forum_categories c
LEFT JOIN Forum_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: Monday 05th of November 2007 03:33:11 PM

[Niels den Otter]

de tabel Forum_forums kent nog steeds geen colom id.

[paul sohier]

Probeer dit is als 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 (Forum_forums f, Forum_categories c)
               LEFT JOIN Forum_moderators m ON (f.id=m.forum_id)
             WHERE c.id=f.category
             ORDER BY c.position, f.position