[isf-wifidog] Installation problem

[Allan Martinez]

Problem solved thanks to Alex suggestion. The problem was caused by my
PostgreSQL version I had to upgrade to 8.X version

Thanks for your help

Allan Martínez


-----Original Message-----
From: 'acv' [mailto:acv at miniguru.ca] 
Sent: Thursday, July 31, 2008 12:43 PM
To: Allan Martinez
Subject: Re: [isf-wifidog] Installation problem

ALTER TABLE table ALTER COLUMN column TYPE format SQL queries were
introduced in PostgreSQL version 8.0. It looks like you'll have to upgrade
PostgreSQL.

Alex

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