Installation - Database initialization error

[takalani@…]

 free text hosting  Acheter Generique France Sans Ordonnance, Achat Medicaments bon marche sur internet  Farmacia Espanola , Comprar Genericos En Espana Sin Receta , Compra Medicamentos Por Internet  Medical Assistant - Your Assistant Online  L'Assistant Medical - Ton Assistant en ligne

[benoitg]

What version of postgres are your running?

[benoitg]

Just a hunch, check if you have the plpgsql language installed. I heard some distributions still have that as a separate package.

[takalani@…]

Thanks for the reply,

I am using PostgreSQL 7.4.13

How do I check if I have plpgsql?

Thanks

[takalani@…]

My situation has changed to desparate.

Help....please.... :-(

[oe@…]

I have something similar; Gentoo server, Postgresql 8.0.13, PHP 5.2.2

Svn checkout of auth-server 27.July.2007

When install script load DB schema/initial data i get the following message;

Creating wifidog database schema : Warning: pg_query() [function.pg-query]: Query failed: ERROR: function nextval(regclass) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. in /var/www/localhost/htdocs/wifidog/install.php on line 938 ERROR: function nextval(regclass) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. <=

[bmichalski@…]

I'm having the same problem with PostgreSQL 7.4, looks like the function is supported PostgreSQL 8.1, which is unfortunately because the install guide for wifidog is only complete for 7.4.

Is there any solution yet?

[mathias@…]

The nextval(regclass) problem is still there. Also upgraded to postgres-8.1 (under debian stable), but nothing changes. Would be nice to have this issue fixed.

[benoitg]

About the original problem: It has probably been fixed in [1266]

About the nextval problem: Thats definitely a different issue. That being said, nextval() has existed since at least postgres 7.3. So either there is a problem with your postgres install, or the actual issue is the schema syntax.

But once again, postgresql 7.4 is not recommended.

[benoitg]

Experimental fix commited in [1283]