ERROR: syntax error at or near "networks" at character 49

[henk@…]

Hi there,

I keep getting this error when i try to login on the server, is this a configuration error, or is this a communication error between the login.php and postgresql?

Any tips?

[benoitg]

Please provide the actual error displayed on screen with the line number, and which revision of the auth server you are using.

[adam@…]

Hi there, I'm getting the same error as this chap! Any other user except for admin gets this error, even if they have just registered.

The full output in the browser when i hit the error is:

ExecSqlUniqueRes?() : An error occured while executing the following SQL query : SELECT CASE WHEN ((NOW() - reg_date) > interval networks.validation_grace_time) THEN true ELSE false END AS validation_grace_time_expired, networks.validation_grace_time FROM users JOIN networks ON (users.account_origin = networks.network_id) WHERE (user_id='7d4324c15ad5737d06f9b010219ff6d5')

Error message : ERROR: syntax error at or near "networks" at character 49

ExecSqlUniqueRes?() : An error occured while executing the following SQL query : SELECT CASE WHEN ((NOW() - reg_date) > interval networks.validation_grace_time) THEN true ELSE false END AS validation_grace_time_expired, networks.validation_grace_time FROM users JOIN networks ON (users.account_origin = networks.network_id) WHERE (user_id='7d4324c15ad5737d06f9b010219ff6d5')

Error message : ERROR: syntax error at or near "networks" at character 49

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/forda/wifi/wifidog-auth-1.0.0_m2/wifidog/classes/AbstractDbPostgres.php:221) in /usr/home/forda/wifi/wifidog-auth-1.0.0_m2/wifidog/login/index.php on line 107

I did the query manually against postgres, and it seems to fail, unless i manually modify it to fix it! Hrm!

[anonymous]

Ok i just removed the word 'interval' from the code, and that appears to fix it. :) - hope this helps someone else.. or someone can tell me if what i've done is wrong :)

[chris]

Same here, on fresh install of latest version

[fproulx]

Huh, these guys are running "wifidog-auth-1.0.0_m2" which is the Sf.net milestone. Maybe we should remove it because it confuses too many people.

This has been fixed a long time ago.