?
Referenced as Pull Request for: # 9602
avatar topazeagle
topazeagle
23 Mar 2016

Steps to reproduce the issue

Upgrade to Joomla 3.5

Expected result

Successful upgrade

Actual result

ERROR: syntax error at or near ""#__contentitem_tag_map_idx_tag"" LINE 1: ALTER TABLE "#__contentitem_tag_map" DROP INDEX "#__conten... ^SQL=ALTER TABLE "#__contentitem_tag_map" DROP INDEX "#__contentitem_tag_map_idx_tag";

The system tells me that it has upgraded to Joomla 3.5. When I use the site it seems to work. All pages show without crashing.

I did not get the message about submitting information to Joomla (once always etc) which I got from my mariaDB site.

systeminfo-2016-03-23T05-31-06+00-00.txt
JoomlaUpgradeERror.docx

System information (as much as possible)

See attached files.

Additional comments

avatar topazeagle topazeagle - open - 23 Mar 2016
avatar brianteeman brianteeman - change - 23 Mar 2016
Category Postgresql
avatar waader
waader - comment - 23 Mar 2016

Confirmed. I made a fresh joomla 3.4.8 installation, updated to 3.5 and get the same error you are reporting.

In file 3.5.0-2015-10-26.sql there are two alter table commands
ALTER TABLE "#__contentitem_tag_map" DROP INDEX "#__contentitem_tag_map_idx_tag";
ALTER TABLE "#__contentitem_tag_map" DROP INDEX "#__contentitem_tag_map_idx_type";

When changed to

DROP INDEX "#__contentitem_tag_map_idx_tag";
DROP INDEX "#__contentitem_tag_map_idx_type";

the should do the job.

avatar brianteeman brianteeman - change - 23 Mar 2016
Labels Added: ?
avatar waader
waader - comment - 25 Mar 2016

@alikon: Am I right? My problem here: I donĀ“t know how to test this other than putting the commands in phpPgAdmin.

avatar alikon
alikon - comment - 26 Mar 2016

@waader follow #9602 for how to test

avatar brianteeman brianteeman - change - 26 Mar 2016
Status New Closed
Closed_Date 0000-00-00 00:00:00 2016-03-26 15:33:56
Closed_By brianteeman
avatar brianteeman brianteeman - close - 26 Mar 2016
avatar brianteeman brianteeman - close - 26 Mar 2016
avatar brianteeman
brianteeman - comment - 26 Mar 2016

Closed as we have a PR #9602


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

Add a Comment

Login with GitHub to post a comment