Forums / Extensions / eZ Flow / ezFlow and Posgres db

ezFlow and Posgres db

Author Message

juan uribe

Friday 05 December 2008 3:12:55 pm

lots of problems.

First install dosen't work. had to modify mysql.sql scripts so that they would work.

Now it's bracking when I try and move the block. had to modify:
extension\ezflow\datatypes\ezpage\ezpagetype.php so that the update would work.

Is there and update that will make this module stable?

Thx

Kristof Coomans

Friday 05 December 2008 3:28:31 pm

Hello Juan, and welcome to the eZ community!

It seems like eZ Flow 1.1 will have some improvements to install it on PostgreSQL, there will be for example a separate SQL file for it ( ezflow/sql/postgresql/postgresql.sql ).
I don't know about the ezpagetype datatype, can you tell us what exactly you had to change to make it work? Thanks!

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Gaetano Giunta

Sunday 07 December 2008 6:48:40 am

If you're impatient, take a look at issues.ez.no and search for ezflow+oracle. You will find bug reports and patches that most likely will apply with prostgres too.

Principal Consultant International Business
Member of the Community Project Board

juan uribe

Tuesday 09 December 2008 10:25:24 am

thanks, for your feedback. Actually I did look into the Oracle support and found several posts but 2 things happend. First no link to the updated files, and Two one of the problems didn't seem to be solved.

What I actually did was find 1.1 release code and used the postgresql.sql file and renamed it as mysql.sql so that install would work.

The code I had to go in and fix is under function:
"onPublish( $contentObjectAttribute, $contentObject, $publishedNodes )"

case 'modify':
    $db->query( "UPDATE ezm_pool SET ts_publication='0" . $item->attribute( 'ts_publication' ) . "'
    WHERE object_id='0" . $item->attribute( 'object_id' ) . "'" );
break;

Notice the object_id='0"

1) I think that object_id since it is integer it should not be enclosed in single brakets
2) for some reason $item->attribute( 'object_id' ) seams to be null or blank so I append a 0 so that if it is blank it will be changed to '0' other wise it will be a number with a leading 0 wich won't change the value.

I will keep on updateing if I find any other issues.

Thanks for the welcome to ez.

Gaetano Giunta

Tuesday 09 December 2008 3:12:15 pm

1) I think that object_id since it is integer it should not be enclosed in single brakets

a bad habit from eZ coders that were raised on milk and mysql. Does not hurt correctness on other dbs, even though some recommend removing quotes for speed...

2) for some reason $item->attribute( 'object_id' ) seams to be null or blank so I append a 0 so that if it is blank it will be changed to '0' other wise it will be a number with a leading 0 which won't change the value.

I'd say you should log an error instead, as you have some inconsistent data at this point...

Principal Consultant International Business
Member of the Community Project Board