?
avatar waader
waader
23 Apr 2017

Steps to reproduce the issue

With this message:
Warning
JInstaller: :Install: Error SQL ERROR: Relation »u762r_fields_idx_checked_out« already exists.
Files Update: SQL error file DB function reports no errors.
Error loading component: com_fields, Component not found.

Under Manage > Database you will find these problems:
Database schema version (3.6.3-2016-08-16) does not match CMS version (3.7.0-2017-04-19).
Table 'u762r_fields_values' does not exist. (From file 3.7.0-2016-08-29.sql.)
Table 'u762r_extensions' does not have column 'package_id'. (From file 3.7.0-2016-11-24.sql.)
Table 'u762r_ucm_content' does not have column 'core_title' with type IS NOT NULL. (From file 3.7.0-2017-01-08.sql.)
Table 'u762r_ucm_content' does not have column 'core_body' with type IS NOT NULL. (From file 3.7.0-2017-01-08.sql.)
Table 'u762r_ucm_content' does not have column 'core_params' with type IS NOT NULL. (From file 3.7.0-2017-01-08.sql.)
Table 'u762r_ucm_content' does not have column 'core_metadata' with type IS NOT NULL. (From file 3.7.0-2017-01-08.sql.)
Table 'u762r_ucm_content' does not have column 'core_images' with type IS NOT NULL. (From file 3.7.0-2017-01-08.sql.)
Table 'u762r_ucm_content' does not have column 'core_urls' with type IS NOT NULL. (From file 3.7.0-2017-01-08.sql.)
Table 'u762r_ucm_content' does not have column 'core_metakey' with type IS NOT NULL. (From file 3.7.0-2017-01-08.sql.)
Table 'u762r_ucm_content' does not have column 'core_metadesc' with type IS NOT NULL. (From file 3.7.0-2017-01-08.sql.)
Table 'u762r_categories' does not have column 'title' with type IS NOT NULL. (From file 3.7.0-2017-01-09.sql.)
Table 'u762r_categories' does not have column 'params' with type IS NOT NULL. (From file 3.7.0-2017-01-09.sql.)
Table 'u762r_categories' does not have column 'metadesc' with type IS NOT NULL. (From file 3.7.0-2017-01-09.sql.)
Table 'u762r_categories' does not have column 'metakey' with type IS NOT NULL. (From file 3.7.0-2017-01-09.sql.)
Table 'u762r_categories' does not have column 'metadata' with type IS NOT NULL. (From file 3.7.0-2017-01-09.sql.)
Table 'u762r_redirect_links' does not have column 'comment' with type IS NOT NULL. (From file 3.7.0-2017-02-15.sql.)
Table 'u762r_contact_details' does not have column 'sortname1' with type IS NOT NULL. (From file 3.7.0-2017-02-17.sql.)
Table 'u762r_contact_details' does not have column 'sortname2' with type IS NOT NULL. (From file 3.7.0-2017-02-17.sql.)
Table 'u762r_contact_details' does not have column 'sortname3' with type IS NOT NULL. (From file 3.7.0-2017-02-17.sql.)
Table 'u762r_contact_details' does not have column 'xreference' with type IS NOT NULL. (From file 3.7.0-2017-02-17.sql.)
Table 'u762r_newsfeeds' does not have column 'xreference' with type IS NOT NULL. (From file 3.7.0-2017-03-03.sql.)

Expected result

Actual result

System information (as much as possible)

Additional comments

avatar waader waader - open - 23 Apr 2017
avatar joomla-cms-bot joomla-cms-bot - change - 23 Apr 2017
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 23 Apr 2017
avatar franz-wohlkoenig franz-wohlkoenig - change - 23 Apr 2017
Category com_joomlaupdate SQL
avatar waader
waader - comment - 23 Apr 2017

In administrator/components/com_admin/sql/updates/postgresql/3.7.0-2016-08-29.sql lines 69 to 74 should be changed to:
CREATE INDEX "#__fields_groups_idx_checked_out" ON "#__fields_groups" ("checked_out");
CREATE INDEX "#__fields_groups_idx_state" ON "#__fields_groups" ("state");
CREATE INDEX "#__fields_groups__created_by" ON "#__fields_groups" ("created_by");
CREATE INDEX "#__fields_groups__access" ON "#__fields_groups" ("access");
CREATE INDEX "#__fields_groups__context" ON "#__fields_groups" ("context");
CREATE INDEX "#__fields_groups__language" ON "#__fields_groups" ("language");

avatar zero-24
zero-24 - comment - 23 Apr 2017

Can you send a PR for that fix?

avatar zero-24
zero-24 - comment - 23 Apr 2017

Closing as we have a PR at #15496 Thanks!

avatar zero-24 zero-24 - change - 23 Apr 2017
Status New Closed
Closed_Date 0000-00-00 00:00:00 2017-04-23 18:52:22
Closed_By zero-24
avatar zero-24 zero-24 - close - 23 Apr 2017

Add a Comment

Login with GitHub to post a comment