Installing Elxis 2008.1 on postgreSQL database

[grayarti]

Hello all,
I get this message when trying to install on a postgreSQL database (UNICODE Encoding). 
It installs fine on a MySQL database.
 
Fatal error: Call to undefined function elxisdbHandler() in D:\xampp\htdocs\nemesis4\includes\adodb\adodb.inc.php on line 918

Anyone else? Any Ideas?
Thanks,
Gray

[datahell]

Please download again Elxis 2008.1 and try with the version you just downloaded. If you wish just copy the new "installation/includes/common.php" file to your existing installation and try to re-install.

We did a "last minute" change and we forgotten to update the installer. We fixed the problem afterwards and updated the Elxis 2008.1 release.

[grayarti]

Hi Datahell, thanks for your reply.
Well, the installation gets over that problem with the help you gave. thanks.
I can now get through the installation, but I get what you see in the attachment.
I am trying on a local postgre 8.3 database with UNICODE coding, but the message
refers to postgres7 ... is this a clue, maybe?
...appreciate your help!
gray

[attachment deleted by admin]

[datahell]

The first error can be solved with a CAST.
The other errors are generated by the (ADOdb's) concat operator and needs investigation ($database->_resource->Concat). Maybe Postgre 8.3 is not supported by the latest version of ADOdb. In this case we will need to patch ADOdb. I don't know, till I check it thoroughly I can not tell.

Can you install Elxis 2008.0 on postgreSQL and tell me if you face the same errors?
I will look up postgre in the next days but if you do that check it will save me some time.

[grayarti]

Hi again Datahell,
2008.0 installs ok on my postgresql 8.3, and everything works fine. The only bug I've seen, is when
I go to change the admin name, I get an error, but when I get back in, the name has been updated,
so that's no real problem.
The 2008.1 version works fine using a Mysql DB so I'll use that, but it would be great to get Postgresql
working, as that's what I'll be using for my online site.
Thanks again, nice work!
Gray

[datahell]

Elxis 2008.1 uses a newer version of ADOdb. We did nt do many tests with Elxis 2008.1 and postgre as it was working fine on 2008.0 and thought that it will be the same for 2008.1. We will fix Elxis - Postgre compatibility soon.

One of the bigest problems with postgre and Oracle is that some third party modules/component maybe wont work with them. If you want to install third party applications and want to be sure that everything will work fine use mysql...

[grayarti]

Hi again Datahell,
... that is an important point, about the third party component compatability, something that users will want to take notice of, when deciding which DB to base their Elxis projects on!
... That's not particularly worrying to me, personally, as I'm using Elxis native components only, but I'm still  just messing about to see the differences, still undecided about postgre, would you personally recommend Mysql over postgreSQL Datahell?

[turno]

Hi,
I have just downloaded Elxis 2008.1 and I am experiencing the same problems as described above (many syntax errors with PostgreSQL 8.3), making this version unusable with PostgreSQL. Elxis 2008.0 worked (nearly) flawlessly in this respect. Since the above posts are a couple of weeks old, is there any progress in fixing those bugs or is it advisable to switch to MySQL for the time being? In the latter case, I think it would be fair to put a notice in the main web page, to warn about PostgreSQL support (temporarily) broken.

I would also like to point out another potential bug with PostgreSQL: in my installations (under Mac OS X and Ubuntu Linux), connections to the database server are not closed properly (possibly as a consequence of the above errors...), so every time I access my website, a new postgres process is forked on the server, which runs forever.

Regards

[datahell]

I am sorry for the delay in releasing a patch for postgreSQL. Give us 3-5 days and a patch will be released.

[turno]

Glad to hear that! Looking forward to trying the updated version!

[datahell]

Elxis - PostgreSQL compatibility fixed. Elxis 2008.1 now works perfect with PostgreSQL (tested with version 8.3.4).
We will release a patch very soon and we will also update Elxis 2008.1 main release.

This patch also fixes some other minor bugs (such as htaccess that did not worked under some server environments)

[turno]

I have just applied the patch and I confirm that everything seems to work fine now 

Great 

[datahell]

Nice to hear that! 

turno if you find a spot where there is a problem with postgresql that we did nt notice, please inform me to fix it.

[grayarti]

Hello again Datahell,
I just wanted to let you know that I have successfully installed today's release, using a postgreSQL DB.
My compliments!
There WERE a few error messages, that maybe you would like to see?
These are not blocking errors, the installation goes ahead fine, and to me it just looks like it is just trying
to re-create tables twice, that already exist (IT: esiste già), but I thought I would let you know about this
anyway.   This CMS just gets better and better!
Many thanks, Gray.

[attachment deleted by admin]

[datahell]

I know about these errors, I saw them during test installations and tried to fix them but they come from inner adodb library and i did nt had enough time to find out what causes them. There are not important, just warnings about some indexes. Don't worry.