Author Topic: [0.3.4] Errors (Read 2050 times)

Pharexys · « **on:** June 11, 2007, 02:44:31 pm »

Bugy [2007-06-11 12:33:52]      [TELL]  [INC]   Parazitul: !flexible
MySQL error (# 0) on query: SELECT t2.gid, name, description, access_level, cond
ition FROM security_flexible AS t1, security_groups AS t2 WHERE t1.field = 'join
' AND t1.gid = t2.gid ORDER BY access_level DESC, name ASC
You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'condition FROM security_f
lexible AS t1, security_groups AS t2 WHERE t1.field = '' at line 1

I havent edited anything on it, just downloaded and runned.
I dont really get it how this Flexible module works so i wont bother with finding a solution.

i'll post more when i find them.

Alreadythere · « **Reply #1 on:** June 11, 2007, 03:03:20 pm »

I can only guess that condition is a reserved word in mysql 5 or something like that, as I don't have any errors there.

Try replacing the line SELECT t2.gid, name, description, access_level, condition FROM #___security_flexible with SELECT t2.gid, name, description, access_level, `condition` FROM #___security_flexible (note the added `).

PS: that will just resolve that single error, as condition is used in almost every query though it won't get the module running. It's just a test to see if that is the error.