duke wrote:

hi,

i tried the plugin today and failed. when i click the submit button on the import page nothing happens.
apache logs this error:

Code:

[Sat May 22 16:01:30 2010] [error] [client xx.xx.xx.xx] PHP Warning:  pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR:  syntax error at or near &quot;EXISTS&quot; at character 15 in /var/www/www.example.com/gallery/include/dblayer/functions_pgsql.inc.php on line 122, referer: http://www.example.com/gallery/admin.php?page=plugin&section=database_migration%2Fadmin.php&tab=import

any idea?

bye,
duke.

Stange. That message would say that you don't have posgresql extension for php. Do you see postgresql extension in a phpinfo() ?

duke wrote:

nicolas wrote:

Stange. That message would say that you don't have posgresql extension for php. Do you see postgresql extension in a phpinfo() ?

yup, it has to be, coz i'm running phpBB with postgres :)

i digged a little deeper now and found the problem, it's the db version i'm running. it seems i need at least postgres 8.3 to run
piwigo, but i still got 8.1 installed.

so next task for me: upgrade postgres, hell yeah :)

duke.

I didn't test with postgresql 8.1 but I think it should be ok. The needed version must be at least 8.0. So it's not the problem.

Did you have the native posgresql support or the pdo driver for postgresql ? I only add support for native one. But I could add the pdo one easily if you need it !

Sorry I didn't see your answer. :-(

duke wrote:

nicolas wrote:

I didn't test with postgresql 8.1 but I think it should be ok. The needed version must be at least 8.0. So it's not the problem.

the problems i encountered were raised by piwigo_structure-pgsql.sql:

Code:

DROP TABLE IF EXISTS piwigo_caddie;

IF EXISTS is available since postgres 8.2

Code:

CREATE TYPE CATEGORIES_STATUS AS ENUM('public', 'private');

the ENUM type was introduced with postgres 8.3.

Thanks for the report. I think I will have to change needed version !

duke wrote:

i can easily remove the IF EXISTS options to CREATE TABLE, because i'm deploying a new db.
but i guess piwigo needs the the ENUMs, doesn't it?

Yes they are mandatory.

duke wrote:

nicolas wrote:

Did you have the native posgresql support or the pdo driver for postgresql ? I only add support for native one. But I could add the pdo one easily if you need it !

i use the pdo driver. should i switch to the native one for piwigo?

I only wrote code for native extension but the pdo driver one is not so difficult to write. If you want it I can write it. Just say it !

duke wrote:

nicolas wrote:

I only wrote code for native extension but the pdo driver one is not so difficult to write. If you want it I can write it. Just say it !

sure, that would be great :)

I just created [Bugtracker] ticket 1708. Just need to add code now !