[isf-wifidog] Installation problem

Allan Martinez allan.martinez at avemaria.edu.ni
Jeu 31 Juil 14:07:02 EDT 2008


I’ve been trying to install wifidog on my debian box but I get this error
during installation process at Database installation specifically:

execSqlUpdate(): SQL Query : 

BEGIN;

 

 

UPDATE schema_info SET value='62' WHERE tag='schema_version';

ALTER TABLE networks ALTER COLUMN connection_limit_network_max_total_bytes
TYPE bigint;

ALTER TABLE networks ALTER COLUMN connection_limit_node_max_total_bytes TYPE
bigint;

ALTER TABLE nodes ALTER COLUMN
connection_limit_node_max_total_bytes_override TYPE bigint;

 

COMMIT;


Warning: pg_affected_rows(): supplied argument is not a valid PostgreSQL
result resource in /var/www/wifidog-auth/wifidog/classes/AbstractDb.php on
line 484

0 rows affected by the SQL query.
Elapsed time for query execution : 0.001700 second(s)

execSqlUpdate() : An error occured while executing the following SQL query :
BEGIN; UPDATE schema_info SET value='62' WHERE tag='schema_version'; ALTER
TABLE networks ALTER COLUMN connection_limit_network_max_total_bytes TYPE
bigint; ALTER TABLE networks ALTER COLUMN
connection_limit_node_max_total_bytes TYPE bigint; ALTER TABLE nodes ALTER
COLUMN connection_limit_node_max_total_bytes_override TYPE bigint; COMMIT; 

Error message : 
ERROR: syntax error at or near "TYPE" at character 147

Backtrace:

#0 /var/www/wifidog-auth/wifidog/include/schema_validate.php(1441):
AbstractDb->execSqlUpdate()

#1 /var/www/wifidog-auth/wifidog/include/schema_validate.php(161):
real_update_schema()

#2 /var/www/wifidog-auth/wifidog/include/schema_validate.php(83):
update_schema()

#3 /var/www/wifidog-auth/wifidog/install.php(664): validate_schema()

Update to schema 62 failed!

Any suggestions? 

 

Allan Martínez

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listes.ilesansfil.org/pipermail/wifidog/attachments/20080731/77a40ae9/attachment.htm 


Plus d'informations sur la liste de diffusion WiFiDog