Forums / Install & configuration / 3.7 to 3.8 upgrade fails - ezcontent_language problem?

3.7 to 3.8 upgrade fails - ezcontent_language problem?

Author Message

David Barber

Friday 16 February 2007 2:39:00 pm

Hi all,

I finally found the time to bring our install up to snuff, and so made a few copies of the site to play with. The first step was to get us to 3.8 from 3.7.2. The db upgrade was fine, and the update multilingual appeared to work:

Step 1/6: Removing the drafts:
Step 2/6: Identifying languages used on the site:
  language: eng-GB (id 2)
Step 3/6: Fixing the ezcontentclass table.
Step 4/6: Fixing the ezcontentobject_name table.
Step 5/6: Fixing content object versions and attributes. Please be patient, this might take a while...
  done
Step 6/6: Fixing content objects. Please be patient, this might take a while...
  done
Done.
-bash-3.00$ /usr/local/covalent/ers/php4.4/bin/php update/common/scripts/updaterssimport.php -s nitle
Using siteaccess nitle for rss import update
Starting object re-indexing

done

and the ezcontent_language table is empty

mysql> select * from ezcontent_language;
Empty set (0.00 sec)

which seems to make the website unhappy. It errors out, and the code says:

SELECT id, name, locale, disabled
FROM   ezcontent_language
ORDER BY name ASC

Warning: eZContentLanguage::prioritizedLanguages 	Feb 16 2007 16:33:46

Language 'eng-GB' does not exist or is not used!

Notice: eZMySQLDB::query(0 rows, 0.612 ms) query number per page:4 	Feb 16 2007 16:33:46

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 ( 108 ) AND
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 1 > 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_name.language_id & 1 )
 )

Error: error/view.php 	Feb 16 2007 16:33:46

Error ocurred using URI: /ez38/index.php/nitle_admin/

Any thoughts on where in the world this is coming from?

Łukasz Serwatka

Wednesday 21 February 2007 11:25:18 pm

Hi David,

Did you follow all upgrade steps? It looks like you missed some points. Make sure that you followed all upgrade steps (especially INI file configuration) mention on this page:
http://ez.no/doc/ez_publish/upgrading/upgrading_to_3_8/from_3_6_x_or_3_7_x_to_3_8_0

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

John Smith

Thursday 27 March 2008 4:15:04 am

Hi Łukasz,

This morning I was trying to upgrade 3.6.0 to 3.8.0, 3.8.0 to 3.9.0 and 3.9.0 to 3.10.0.

3.6.0 to 3.8.0 -> no problems, worked fine.

3.8.0. to 3.9.0

Error while running
update/common/scripts/3.9/updateclasstranslations.php -s <site_name> --languge=eng-GB

Error:
Language "eng-GB" doesn't exit.

I checked the script, the value for the language is empty. Checked the database, there is nothing in the table named as ezcontent_language.

I have already updated site.ini.append.php in public and admin siteaccess which is as follows:

For <site>_admin

[Regional Settings]
Locale=eng-GB
ContentObjectLocale=eng-GB
TextTranslation=disabled
SiteLanguageList[]
SiteLanguageList[]=eng-GB
ShowUntranslatedObjects=enabled

For public siteaccess

[Regional Settings]
Locale=eng-GB
ContentObjectLocale=eng-GB
TextTranslation=disabled
SiteLanguageList[]
SiteLanguageList[]=eng-GB
ShowUntranslatedObjects=disabled

Am I missing something???

eZ debug

Timing: Jan 18 2025 15:06:03
Script start
Timing: Jan 18 2025 15:06:03
Module start 'content'
Timing: Jan 18 2025 15:06:04
Module end 'content'
Timing: Jan 18 2025 15:06:04
Script end

Main resources:

Total runtime1.2602 sec
Peak memory usage4,096.0000 KB
Database Queries196

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0058 587.9609180.8047
Module start 'content' 0.00581.1395 768.7656593.5156
Module end 'content' 1.14530.1148 1,362.2813336.7500
Script end 1.2602  1,699.0313 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00380.3046210.0002
Check MTime0.00150.1163210.0001
Mysql Total
Database connection0.00110.084810.0011
Mysqli_queries1.187994.26031960.0061
Looping result0.00190.14721940.0000
Template Total1.228797.520.6144
Template load0.00180.141320.0009
Template processing1.226997.356920.6135
Template load and register function0.00020.013410.0002
states
state_id_array0.00140.114810.0014
state_identifier_array0.00170.131020.0008
Override
Cache load0.00150.1182440.0000
Sytem overhead
Fetch class attribute can translate value0.00090.070940.0002
Fetch class attribute name0.00170.136640.0004
XML
Image XML parsing0.00100.076740.0002
class_abstraction
Instantiating content class attribute0.00000.000840.0000
General
dbfile0.00570.4557290.0002
String conversion0.00000.000330.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
3content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
11content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
3content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
5content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 25
 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs