[0.3.4] Errors

Pharexys

Apprentice

Offline

Posts: 94

[0.3.4] Errors

« on: June 11, 2007, 07:44:31 AM »

Code:

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.


	Logged

Alreadythere

BeBot Maintainer
Administrator
Grandmaster

Offline

Posts: 1085

Re: [0.3.4] Errors

« Reply #1 on: June 11, 2007, 08:03:20 AM »

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.


« Last Edit: June 11, 2007, 08:09:02 AM by Alreadythere »	Logged

Pharexys

Apprentice

Offline

Posts: 94

Re: [0.3.4] Errors

« Reply #2 on: June 11, 2007, 02:34:59 PM »

yeah the error disapeared now


	Logged

Alreadythere

BeBot Maintainer
Administrator
Grandmaster

Offline

Posts: 1085

Re: [0.3.4] Errors

« Reply #3 on: June 11, 2007, 02:48:35 PM »

Thanks, fixed in SVN.


	Logged

Pages: [1] Go Up

BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Support > Support for older versions > BeBot 0.3 support > Topic: [0.3.4] Errors

« previous next »