[solved] 2.1 trunk update failure

[oliver]

while reading the announcement I thought I give the trunk a try to get at least php5.3-compatibility. Sadly it failes with:

Code: Select all

        * JInstaller::install: SQL Error. DB function failed with error number 1054
          Unknown column 'l.lang_id' in 'field list' SQL=CREATE VIEW `phoenix_jf_languages` AS SELECT `l`.`lang_id`, `l`.`lang_code`, `l`.`title`, `l`.`title_native`, `l`.`sef`, `l`.`description`, `l`.`published`, `l`.`image`, `lext`.`image_ext`, `lext`.`fallback_code`, `lext`.`params`, `lext`.`ordering` FROM `phoenix_languages` as `l` left outer join `phoenix_jf_languages_ext` as `lext`on `l`.`lang_id` = `lext`.`lang_id` ORDER BY `lext`.`ordering`
          SQL =

          CREATE VIEW `phoenix_jf_languages` AS
          SELECT `l`.`lang_id`, `l`.`lang_code`, `l`.`title`, `l`.`title_native`, `l`.`sef`, `l`.`description`, `l`.`published`, `l`.`image`, `lext`.`image_ext`, `lext`.`fallback_code`, `lext`.`params`, `lext`.`ordering`
           FROM `phoenix_languages` as `l` left outer join `phoenix_jf_languages_ext` as `lext`on `l`.`lang_id` = `lext`.`lang_id`
          ORDER BY  `lext`.`ordering`

        * Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1054
          Unknown column 'l.lang_id' in 'field list' SQL=CREATE VIEW `phoenix_jf_languages` AS SELECT `l`.`lang_id`, `l`.`lang_code`, `l`.`title`, `l`.`title_native`, `l`.`sef`, `l`.`description`, `l`.`published`, `l`.`image`, `lext`.`image_ext`, `lext`.`fallback_code`, `lext`.`params`, `lext`.`ordering` FROM `phoenix_languages` as `l` left outer join `phoenix_jf_languages_ext` as `lext`on `l`.`lang_id` = `lext`.`lang_id` ORDER BY `lext`.`ordering`
          SQL =

          CREATE VIEW `phoenix_jf_languages` AS
          SELECT `l`.`lang_id`, `l`.`lang_code`, `l`.`title`, `l`.`title_native`, `l`.`sef`, `l`.`description`, `l`.`published`, `l`.`image`, `lext`.`image_ext`, `lext`.`fallback_code`, `lext`.`params`, `lext`.`ordering`
           FROM `phoenix_languages` as `l` left outer join `phoenix_jf_languages_ext` as `lext`on `l`.`lang_id` = `lext`.`lang_id`
          ORDER BY  `lext`.`ordering`

any short fix/workaround or just wait for the final?

[alex]

Can you check if your database tables are updated? There is the need to update the languages and some other tables.

Alex

[oliver]

doesnt seem to be updated, _languages still contains id instead of lang_id aso
I even just reinstalled 2.0.4 and its still working fine so I guess db is not changed in any way?

Edit: tested it on 2 other Jfish installations (2.0.4 and 2.0.2) and both come up with the same error and the not updated db

[alex]

Can you please try to check-out the very latest trunk. The script for automatic update was added the day before yesterday. There is a SQL script included in administrator ... /install which should be executed during the installation process. The install screen shows you that he determined the old structure and upgraded it.

[oliver]

yes, I used the latest one. Theres no upgrade message coming up.
I added the sql-changes manually and next install it complains about an already existing jos_jf_languages (maybe add a drop to the sql?) so i guess the file was used by the installer this time.
Manually dropped the table and this time installs ends up with a php-error:

Code: Select all

[22-Aug-2010 23:34:01] PHP Warning:  array_key_exists() [<a href='function.array-key-exists'>function.array-key-exists</a>]: The second argument should be either an array or an object in /var/www/virtual/..../htdocs/administrator/components/com_joomfish/tables/JFLanguage.php on line 219
[22-Aug-2010 23:34:01] PHP Warning:  array_key_exists() [<a href='function.array-key-exists'>function.array-key-exists</a>]: The second argument should be either an array or an object in /var/www/virtual/.../htdocs/administrator/components/com_joomfish/tables/JFLanguage.php on line 222
[22-Aug-2010 23:34:01] PHP Fatal error:  Call to a member function bind() on a non-object in /var/www/virtual/.../htdocs/administrator/components/com_joomfish/tables/JFLanguage.php on line 407

Backend isnt reachable anymore, need to manually delete all jfish stuff.

[alex]

You seem to have a very strange copy of the trunk.

I now tried can you please post your system configuration. May be it is related to these issues.

The best way to get an installable package is to export the trunk with the following command:

Code: Select all

svn export  --revision HEAD --depth infinity http://joomlacode.org:80/svn/joomfish/development/trunk/2.x .

where '.' refers to the directory you like the export to be stored.

It is important to go for infinity as the language files and some other stuff is included via external links.

Alex

[oliver]

morning Alex, thats excactly what I used to export...strange. Tried again this morning, still the above error in first post.
System is a simple xen-based deb lenny, nothing special

PHP Built on: Linux 2-1.domain.com 2.6.26-2-xen-amd64 #1 SMP Wed Jan 13 00:12:41 UTC 2010 x86_64
Database Version: 5.0.51a-24+lenny4-log
Database Collation: utf8_general_ci
PHP Version: 5.2.6-1+lenny8
Web Server: nginx
Web Server to PHP interface: cgi-fcgi
Joomla! Version: Joomla! 1.5.20 Stable [ senu takaa ] 18-July-2010 18:00 GMT

added the packed zip as attachment
<mod-note>I removed the file to avoid others falling in the trap of downloading the wrong packages</mod-note>

[alex]

When you did the retry, did you removed the new tables and recovered the old 2.0 tables?

It seems that your process identifies that you have an existing and correct table structure as the iso field is not included in your _languages table anymore. But this field is a key field in the 2.0 table structure.

Alex

[oliver]

hmm...I used an old 2.0.4 backup this morning, the iso is still existing in _languages even after the failed update.

Code: Select all

  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `active` tinyint(1) NOT NULL default '0',
  `iso` varchar(20) default NULL,
  `code` varchar(20) NOT NULL default '',
  `shortcode` varchar(20) default NULL,
  `image` varchar(100) default NULL,
  `fallback_code` varchar(20) NOT NULL default '',
  `params` text NOT NULL,
  `ordering` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;   

[alex]

Ok we fixed the issue related the installer. Now the PHP 5.2 issue is still open.

Working on it

Alex