[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