Friday 28 July 2006 8:52:45 am

That's right!! I think the problem is related with updatemultilingual.php script or something like that. Unfortunately when I run the script I get the following error:

Step 2/6: Identifying languages used on the site:

Fatal error: Call to undefined function:  pg_escape_string() in /home/reyte/www/lib/ezdb/classes/ezpostgresqldb.php on line 573

 

Note that my ezp root path is: /home/reyte/www

I have overcome this error by changing in ezpostgresqldb.php on line 573 the <b>pg_escape_string()</b> function to <b>addslashes( $str )</b> function which is almost the same. Then the script ran successfully but the problem is still there.

Furthermore there are something bad in the db because ezcontent_language table is empty and all rows at "language_mask" field in "ezcontentobject" table are set to "NULL".

someone have any idea?

Thanks,

Nicolay
Corenet S.A.
Bogota - Colombia
www.corenet.net.co
acamargo@corenet.net.co

Friday 28 July 2006 9:14:08 am

Are you using PostgreSQL as your database? Did you enable the pgsql PHP extension (http://www.php.net/pg_escape_string is part of it)? Which version of PHP are you running?

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

Saturday 29 July 2006 1:55:21 am

Hello Nicolay

Your webserver environment seems alright. You should check if the cli version of php also has the pgsql extension enabled (does it use the same php.ini file as the webserver?).

could this problem be related with New bug: problem with sql update file update/database/postgresql/3.8/dbupdate-3.6.0-to-3.8.0.sql?

No idea. We always use MySQL.

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

Friday 04 August 2006 4:52:14 am

Hi folks,

I'm having similar problems to Nokolay, trying to upgrade from 3.7.6 to 3.8.3.
When running update/database/postgresql/3.8/dbupdate-3.6.0-to-3.8.0.sql I'm getting
complaints of colums containing null values.
Is there a fix for this?
Is the script written incorrectly, or is it a case of incompatability with existing data?

Andy

Thursday 10 August 2006 7:32:08 am

In fact, here's a patch file if it's easier.

--- ezpublish-3.8.3/update/database/postgresql/3.8/dbupdate-3.6.0-to-3.8.0.sql 2006-07-26 12:41:15.000000000 +0200
+++ portal/update/database/postgresql/3.8/dbupdate-3.6.0-to-3.8.0.sql   2006-08-10 16:08:16.000000000 +0200
@@ -20,8 +20,8 @@

 -- Improved RSS import. -- START --
 ALTER TABLE ezrss_import ADD COLUMN import_description text;
-ALTER TABLE ezrss_import ALTER import_description SET NOT NULL;
 ALTER TABLE ezrss_import ALTER import_description SET DEFAULT '';
+ALTER TABLE ezrss_import ALTER import_description SET NOT NULL;
 -- Improved RSS import. -- END --

 -- Multicurrency. -- START --
@@ -75,8 +75,9 @@


 ALTER TABLE ezproductcollection ADD currency_code varchar(4);
-ALTER TABLE ezproductcollection ALTER currency_code SET NOT NULL;
 ALTER TABLE ezproductcollection ALTER currency_code SET DEFAULT '';
+UPDATE ezproductcollection SET currency_code = '' WHERE currency_code IS NULL;
+ALTER TABLE ezproductcollection ALTER currency_code SET NOT NULL;
 -- Multicurrency. -- END --

 -- Improved packages system -- START --
@@ -136,38 +137,47 @@

 ALTER TABLE ezcontentobject ADD COLUMN language_mask int;
 ALTER TABLE ezcontentobject ALTER COLUMN language_mask SET DEFAULT 0;
+UPDATE ezcontentobject SET language_mask = '0' WHERE language_mask IS NULL;
 ALTER TABLE ezcontentobject ALTER COLUMN language_mask SET NOT NULL;

 ALTER TABLE ezcontentobject ADD COLUMN initial_language_id int;
 ALTER TABLE ezcontentobject ALTER COLUMN initial_language_id SET DEFAULT 0;
+UPDATE ezcontentobject SET initial_language_id = '0' WHERE initial_language_id IS NULL;
 ALTER TABLE ezcontentobject ALTER COLUMN initial_language_id SET NOT NULL;

 ALTER TABLE ezcontentobject_name ADD COLUMN language_id int;
 ALTER TABLE ezcontentobject_name ALTER COLUMN language_id SET DEFAULT 0;
+UPDATE ezcontentobject_name SET language_id = '0' WHERE language_id IS NULL;
 ALTER TABLE ezcontentobject_name ALTER COLUMN language_id SET NOT NULL;

 ALTER TABLE ezcontentobject_attribute ADD COLUMN language_id int;
 ALTER TABLE ezcontentobject_attribute ALTER COLUMN language_id SET DEFAULT 0;
+UPDATE ezcontentobject_attribute SET language_id = '0' WHERE language_id IS NULL;
 ALTER TABLE ezcontentobject_attribute ALTER COLUMN language_id SET NOT NULL;

 ALTER TABLE ezcontentobject_version ADD COLUMN language_mask int;
 ALTER TABLE ezcontentobject_version ALTER COLUMN language_mask SET DEFAULT 0;
+UPDATE ezcontentobject_version SET language_mask = '0' WHERE language_mask IS NULL;
 ALTER TABLE ezcontentobject_version ALTER COLUMN language_mask SET NOT NULL;

 ALTER TABLE ezcontentobject_version ADD COLUMN initial_language_id int;
 ALTER TABLE ezcontentobject_version ALTER COLUMN initial_language_id SET DEFAULT 0;
+UPDATE ezcontentobject_version SET initial_language_id = '0' WHERE initial_language_id IS NULL;
 ALTER TABLE ezcontentobject_version ALTER COLUMN initial_language_id SET NOT NULL;

 ALTER TABLE ezcontentclass ADD COLUMN always_available int;
 ALTER TABLE ezcontentclass ALTER COLUMN always_available SET DEFAULT 0;
+UPDATE ezcontentclass SET always_available = '0' WHERE always_available IS NULL;
 ALTER TABLE ezcontentclass ALTER COLUMN always_available SET NOT NULL;

 ALTER TABLE ezcontentobject_link ADD COLUMN op_code int;
 ALTER TABLE ezcontentobject_link ALTER COLUMN op_code SET DEFAULT 0;
+UPDATE ezcontentobject_link SET op_code = '0' WHERE op_code IS NULL;
 ALTER TABLE ezcontentobject_link ALTER COLUMN op_code SET NOT NULL;

 ALTER TABLE eznode_assignment ADD COLUMN op_code int;
 ALTER TABLE eznode_assignment ALTER COLUMN op_code SET DEFAULT 0;
+UPDATE eznode_assignment SET op_code = '0' WHERE op_code IS NULL;
 ALTER TABLE eznode_assignment ALTER COLUMN op_code SET NOT NULL;

 -- updates
@@ -186,4 +196,5 @@
 -- Information collection improvments
 ALTER TABLE ezinfocollection ADD creator_id INT;
 ALTER TABLE ezinfocollection ALTER COLUMN creator_id SET DEFAULT 0;
+UPDATE ezinfocollection SET creator_id = '0' WHERE creator_id IS NULL;
 ALTER TABLE ezinfocollection ALTER COLUMN creator_id SET NOT NULL;

Andy

Friday 11 August 2006 4:19:49 am

Hi John
I know this problem. I have had this one after update from 3.5.x to 3.6.x, 3.6.x to 3.6.y, and 3.6.x to 3.7.x but I dont know why. maybe bug in previous eZp versions, hmmm.

http://ez-publish.pl

Wednesday 16 August 2006 8:49:07 am

I'm having similar problems, but am running mysql. The updatemultilingual.php crashes at once after launch, with the following error message:

Fatal error: eZ publish did not finish its request
The execution of eZ publish was abruptly ended, the debug output is present below.

But there is no error message printed.. How do I enable debug, or even better, how do I get around this problem?

I'm upgrading from an 3.6.0 to 3.8.3, on Apache/1.3.34 (Ubuntu) PHP/4.4.2-1build1.

Friday 18 August 2006 10:48:31 am

Hi John :)

Could you describe your problem with the "missing siteaccess" a little more thorough?

Wednesday 23 August 2006 1:15:41 am

This didn't happen to me, so I'm pretty blank on this, unfortunatly. Perhaps someone else have experience with this?