BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => BeBot 0.3 support => Topic started by: Pharexys on June 11, 2007, 02:44:31 pm

Title: [0.3.4] Errors
Post by: Pharexys on June 11, 2007, 02:44:31 pm

Code: [Select]

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.

Title: Re: [0.3.4] Errors
Post by: Alreadythere 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.

Title: Re: [0.3.4] Errors
Post by: Pharexys on June 11, 2007, 09:34:59 pm

yeah the error disapeared now

Title: Re: [0.3.4] Errors
Post by: Alreadythere on June 11, 2007, 09:48:35 pm

Thanks, fixed in SVN.