[isf-wifidog] Installation problem

['acv']

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
> 
-------------- section suivante --------------
Une pièce jointe non texte a été nettoyée...
Nom: non disponible
Type: application/pgp-signature
Taille: 187 octets
Desc: non disponible
Url: http://listes.ilesansfil.org/pipermail/wifidog/attachments/20080731/d1152d17/attachment.pgp