If it exists, please can you try removing STRICT_TRANS_TABLES from sql-mode in my.ini
Robin.
-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of John Palmer
Sent: 21 December 2011 08:13
To: Robin Jones
Subject: [Bug 907203] [NEW] PING causes 500 Internal Server Error - Incorrectdatetime value
Public bug reported:
I just installed Authpuppy on IIS 7. Everything else seems to be working but when APs "ping" the auth server I get the following error in the W3SVC log (x,y,z have been used to replace IP addresses):
Title:
PING causes 500 Internal Server Error - Incorrect datetime value
Status in AuthPuppy authentication server for Wifidog networks:
New
Bug description:
I just installed Authpuppy on IIS 7. Everything else seems to be
working but when APs "ping" the auth server I get the following error
in the W3SVC log (x,y,z have been used to replace IP addresses):
If it exists, please can you try removing STRICT_TRANS_TABLES from sql-mode in my.ini
Robin.
-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of John Palmer
Sent: 21 December 2011 08:13
To: Robin Jones
Subject: [Bug 907203] [NEW] PING causes 500 Internal Server Error - Incorrectdatetime value
Public bug reported:
I just installed Authpuppy on IIS 7. Everything else seems to be working but when APs "ping" the auth server I get the following error in the W3SVC log (x,y,z have been used to replace IP addresses):
2011-12-21 01:10:17 x.x.x.x GET /ping/ 0001&sys_ uptime= 61219&sys_ memfree= 1580&sys_ load=0. 00&wifidog_ uptime= 61186
gw_id=citrius00
80 - y.y.y.y WiFiDog+1.1.3_beta6 500 0 0 171
Running that query string through frontend_dev.php returns this additional detail:
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: 21T07:04: 50+00:00' for column 'last_heartbeat_at' at row 1
'2011-12-
The logs show this statement caused the error:
execute : UPDATE nodes SET last_heartbeat_at = ?, last_heartbeat_ip = ?, last_heartbeat_ sys_uptime = ?, last_heartbeat_ sys_load = ?, last_heartbeat_ sys_memfree = ?, last_heartbeat_ wifidog_ uptime = ?, updated_at = ? WHERE id = ? - (2011-12- 21T08:03: 15+00:00, z.z.z.z, 61219, 0.00, 1580, 61186, 2011-12-21 08:03:15, 2)
I'm not sure where to look to investigate further... Any help would be appreciated.
Thanks!
John
** Affects: authpuppy
Importance: Undecided
Status: New
-- /bugs.launchpad .net/bugs/ 907203
You received this bug notification because you are subscribed to AuthPuppy.
https:/
Title:
PING causes 500 Internal Server Error - Incorrect datetime value
Status in AuthPuppy authentication server for Wifidog networks:
New
Bug description:
I just installed Authpuppy on IIS 7. Everything else seems to be
working but when APs "ping" the auth server I get the following error
in the W3SVC log (x,y,z have been used to replace IP addresses):
2011-12-21 01:10:17 x.x.x.x GET /ping/ citrius000001& sys_uptime= 61219&sys_ memfree= 1580&sys_ load=0. 00&wifidog_ uptime= 61186
gw_id=
80 - y.y.y.y WiFiDog+1.1.3_beta6 500 0 0 171
Running that query string through frontend_dev.php returns this
additional detail:
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime 21T07:04: 50+00:00' for column 'last_heartbeat_at' at
value: '2011-12-
row 1
The logs show this statement caused the error:
execute : UPDATE nodes SET last_heartbeat_at = ?, last_heartbeat_ip = sys_uptime = ?, last_heartbeat_ sys_load = ?, heartbeat_ sys_memfree = ?, last_heartbeat_ wifidog_ uptime = ?, 21T08:03: 15+00:00, z.z.z.z,
?, last_heartbeat_
last_
updated_at = ? WHERE id = ? - (2011-12-
61219, 0.00, 1580, 61186, 2011-12-21 08:03:15, 2)
I'm not sure where to look to investigate further... Any help would
be appreciated.
Thanks!
John
To manage notifications about this bug go to: /bugs.launchpad .net/authpuppy/ +bug/907203/ +subscriptions
https:/