Ticket #129 (closed Bug report: invalid)

Opened 13 years ago

Last modified 12 years ago

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

Reported by: henk@… Owned by:
Priority: high Milestone: WifiDog Auth Server 1.0
Component: Auth server, Usability, Interface and translations Version:
Keywords: Cc:

Description

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?

Change History

Changed 13 years ago by benoitg

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

Changed 13 years ago by 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!

Changed 13 years ago by 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 :)

Changed 13 years ago by chris

Same here, on fresh install of latest version

Changed 13 years ago by benoitg

  • priority changed from normal to high
  • milestone changed from WifiDog Auth Server 1.1 to WifiDog Auth Server 1.0

Changed 13 years ago by fproulx

  • status changed from new to closed
  • resolution set to invalid

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.

Note: See TracTickets for help on using tickets.