[isf-wifidog] Installation problem
acv
acv at miniguru.ca
Jeu 31 Juil 14:13:06 EDT 2008
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/b9257bbe/attachment.pgp
Plus d'informations sur la liste de diffusion WiFiDog