[isf-wifidog] Portal crashes on login
Jan Lühr
wifidog-list at arcor.de
Dim 10 Mai 06:42:01 EDT 2009
Hello,
every time I try to login, the portal throws an error-Message:
execSqlUpdate() : An error occured while executing the following SQL query :
DELETE FROM connections USING tokens WHERE
tokens.token_id=connections.token_id AND token_status='UNUSED' AND user_id =
'35af1963f47ef3968cab3bdd835cd799'; INSERT INTO tokens (token_owner,
token_issuer, token_id, token_status) VALUES
('35af1963f47ef3968cab3bdd835cd799', '35af1963f47ef3968cab3bdd835cd799',
'9fc039d97d841eed16277ae37158f166', 'UNUSED'); INSERT INTO connections
(user_id, token_id, timestamp_in, node_id, node_ip, last_updated) VALUES
('35af1963f47ef3968cab3bdd835cd799', '9fc039d97d841eed16277ae37158f166',
CURRENT_TIMESTAMP, 'a5dc97f8f65b0a56b45347e40ba667fa', '84.63.16.252',
CURRENT_TIMESTAMP)
Error message :
ERROR: syntax error at or near "USING" at character 25
Backtrace:
#0 /var/www/vhosts/org-koeln.de/subdomains/wifi/httpdocs/classes/User.php(642):
AbstractDb->execSqlUpdate()
#1 /var/www/vhosts/org-koeln.de/subdomains/wifi/httpdocs/login/index.php(208):
User->generateConnectionToken()
Warning: Cannot modify header information - headers already sent by (output
started at /var/www/vhosts/org-
koeln.de/subdomains/wifi/httpdocs/classes/AbstractDb.php:490) in
/var/www/vhosts/org-koeln.de/subdomains/wifi/httpdocs/login/index.php on line
215
What might be wrong here?
Thanks,
Keep smiling
yanosz
Plus d'informations sur la liste de diffusion WiFiDog