Error upgrading from 3.8.12 to 3.9 Topic is solved

Need help upgrading your Joomla! website or converting to Joomla! 3.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
GeoBiker
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Tue Feb 07, 2012 7:23 am

Error upgrading from 3.8.12 to 3.9

Post by GeoBiker » Sat Nov 03, 2018 3:43 pm

Installer: :Install: Error SQL Duplicate entry '1' for key 'PRIMARY'
Files Update: SQL error file DB function failed with error number 1062
Duplicate entry '1' for key 'PRIMARY'
SQL =
INSERT INTO `#__action_logs_extensions` (`id`, `extension`) VALUES
(1, 'com_banners'),
(2, 'com_cache'),
(3, 'com_categories'),
(4, 'com_config'),
(5, 'com_contact'),
(6, 'com_content'),
(7, 'com_installer'),
(8, 'com_media'),
(9, 'com_menus'),
(10, 'com_messages'),
(11, 'com_modules'),
(12, 'com_newsfeeds'),
(13, 'com_plugins'),
(14, 'com_redirect'),
(15, 'com_tags'),
(16, 'com_templates'),
(17, 'com_users');

database action_logs_extensions is OK
will not let me add articles

GeoBiker
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Tue Feb 07, 2012 7:23 am

Re: Error upgrading from 3.8.12 to 3.9

Post by GeoBiker » Sat Nov 03, 2018 4:01 pm

Could the error be trying to add (1, 'com_articles') ?

DB check did not show any errors

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 30918
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Error upgrading from 3.8.12 to 3.9

Post by Per Yngve Berg » Sat Nov 03, 2018 5:37 pm

They cannot be added because they already exist in the database table.

GeoBiker
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Tue Feb 07, 2012 7:23 am

Re: Error upgrading from 3.8.12 to 3.9

Post by GeoBiker » Sun Nov 04, 2018 4:13 am

why is the update trying to add something that already exists in DB?

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 30918
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Error upgrading from 3.8.12 to 3.9

Post by Per Yngve Berg » Sun Nov 04, 2018 9:26 am

You must have run an update that failed. The changes have been made, but the version is not updated.

Run Extensions->Installer->Database->Fix

The sql files is located in /administrator/components/com_admin/sql/updates/mysql

GeoBiker
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Tue Feb 07, 2012 7:23 am

Re: Error upgrading from 3.8.12 to 3.9

Post by GeoBiker » Sun Nov 04, 2018 10:19 pm

Thank you so much!
Ran fix, updated extension for 3.9 & website humming along. :)


Locked

Return to “Migrating and Upgrading to Joomla! 3.x”