[isf-wifidog] Installation problem

[Allan Martinez]

I got PostgreSQL 7.4.19

Regards,

Allan Martínez

-----Original Message-----
From: acv [mailto:acv at miniguru.ca] 
Sent: Thursday, July 31, 2008 12:13 PM
To: allan.martinez at avemaria.edu.ni; WiFiDog Captive Portal
Subject: Re: [isf-wifidog] Installation problem

	What's your version of PostgreSQL ?

Alex

On Thu, Jul 31, 2008 at 12:07:02PM -0600, Allan Martinez wrote:
> From: "Allan Martinez" <allan.martinez at avemaria.edu.ni>
> To: <wifidog at listes.ilesansfil.org>
> Date: Thu, 31 Jul 2008 12:07:02 -0600
> X-Mailer: Microsoft Office Outlook 12.0
> Subject: [isf-wifidog] Installation problem
> 
> 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
> 

> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog