Staredit Network

Staredit Network -> Computers and Technical -> Problem with IPB sql query

Report, edit, etc...Posted by Pyro-Fire on 2006-09-30 at 11:15:26

CODE

mySQL query error: SELECT m.mgroup_others, m.id, m.name, m.msg_total, m.view_pop, m.email_pm, m.language, m.email, me.vdirs, g.g_max_messages, g.g_use_pm FROM ibf_members m, ibf_groups g
LEFT JOIN ibf_member_extra me ON (m.id=me.id)
WHERE LOWER(m.name) IN ('pyro')
AND m.mgroup=g.g_id

mySQL error: Unknown column 'm.id' in 'on clause'
mySQL error code:
Date: Saturday 30th of September 2006 04:13:18 PM

whats wrong here?

Report, edit, etc...Posted by Vibrator on 2006-09-30 at 17:47:10

make sure you have an id column

Report, edit, etc...Posted by Mini Moose 2707 on 2006-09-30 at 17:50:22

This happened to me on SEN when the report function broke. Don't abbreviate the tables that the columns you're selecting are in, write everything out and it should work.

Next Page (1)