?
Referenced as Pull Request for: # 9595
avatar waader
waader
23 Mar 2016

Steps to reproduce the issue

Make a fresh installation with Joomla 3.5 and check in the backend (Extensions > Manage > Database) whether there are any database problems.

Expected result

No problems are reported.

Actual result

4 Problems are found:

Table 'az4v2_contentitem_tag_map' does not have index 'az4v2_contentitem_tag_map_idx_tag_name'. (From file 3.1.0.sql.)
Table 'az4v2_redirect_links' does not have column 'old_url' with type varchar. (From file 3.5.0-2016-03-01.sql.)
Table 'az4v2_redirect_links' does not have column 'new_url' with type varchar. (From file 3.5.0-2016-03-01.sql.)
Table 'az4v2_redirect_links' does not have column 'referer' with type varchar. (From file 3.5.0-2016-03-01.sql.)

The problem with the varchar fields in __redirect_links can be easily mitigated. Just replace VARCHAR with character varying(2048). But I don´t know how to deal with the index. Pressing the fix button the index is applied but we don´t need the index anymore. Deleting the line in 3.1.0.sql is probably the wrong resolution.

System information (as much as possible)

Additional comments

The

avatar waader waader - open - 23 Mar 2016
avatar brianteeman brianteeman - change - 23 Mar 2016
Status New Confirmed
avatar brianteeman brianteeman - change - 23 Mar 2016
Title
PostgreSQL: Warning: Database is not up to date!
PostgreSQL: Warning: Database is not up to date!
avatar brianteeman brianteeman - change - 23 Mar 2016
Category Postgresql
avatar brianteeman
brianteeman - comment - 23 Mar 2016

I can confirm this - sorry for not spotting it in earlier tests


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/9538.

avatar brianteeman brianteeman - change - 23 Mar 2016
Category Postgresql Installation Postgresql
avatar brianteeman brianteeman - change - 23 Mar 2016
Labels Added: ?
avatar brianteeman brianteeman - change - 25 Mar 2016
Status Confirmed Closed
Closed_Date 0000-00-00 00:00:00 2016-03-25 17:34:04
Closed_By brianteeman
avatar brianteeman brianteeman - close - 25 Mar 2016
avatar brianteeman brianteeman - close - 25 Mar 2016
avatar brianteeman
brianteeman - comment - 25 Mar 2016

Closed as we have a PR for testing see #9595


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/9538.

Add a Comment

Login with GitHub to post a comment