Problem with content after upgrade to 3.8.2

Thursday 27 July 2006 7:41:57 pm

Hi!

I have upgrade from 3.6.2 to 3.8.2 following the instructions step by step. When finish I can't view any object and get this error:

Object is unavailable

The object you requested is not currently available.

Possible reasons for this are:

* The id or name of the object was misspelled, try changing it.
* The object is no longer available on the site.

When I display the debug SQL output and run each select manually in the db server I find problem with this select:

SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name,
ezcontentclass.identifier as class_identifier
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id IN ( 2 ) AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 4 > 0

and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 ) << 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
+ ( ( ezcontentobject_name.language_id & 1 ) << 2 )
)

Looking in depth I found that all rows at "language_mask" field in "ezcontentobject" table are set to "NULL" is that right? or is there my problem?

Your help will be strongly apreciated,

Nicolay.

Thanks,

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

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?