PDA

View Full Version : forum just stopped working


nemt1
10-17-07, 01:25 AM
Haven't made any changes to anything, forums have been giving me this error for the past few weeks:

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 nemt_forums f, nemt_categories c
LEFT JOIN nemt_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: Wednesday 17th of October 2007 12:24:34 AM

http://www.nemesisz.net/forums

HalfaBee
10-17-07, 02:44 AM
This is an issue caused by the upgrade to mysql5.

Search on your fourm software site for an upgrade or patch.

nemt1
10-17-07, 01:49 PM
Hmm that's the problem, invision power board doesn't have a free version anymore, and doesn't support the older free versions.

HalfaBee
10-17-07, 05:22 PM
you might need some ()'s

like this
FROM ( nemt_forums f, nemt_categories c )
LEFT JOIN nemt_moderators m