News:

Support for jDownloads 3 has been ended
Since 17 August 2023 Joomla.org has discontinued support for Joomla 3.x. Therefore, we will no longer offer official support for our Joomla 3 jDownloads version 3.9.x from January 2024.
Please update your website to the latest Joomla version (Joomla 4 or Joomla 5) as soon as possible. Afterwards, please update jDownloads to the latest published version. The longer you delay, the more difficult the upgrade process for your website is likely to be.

Main Menu
Support-Forum

Install: Error SQL Duplicate column name

Started by NJK, 10.11.2024 18:35:18

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

NJK

Migrated dev site succesfully to Joomla 4.4.9, this a copy of one of our production sites.

Trying to upgrade from jDownloads 3.9.8.7 to 4.0.45.

First install gives this error message

A check of the jDownloads database tables revealed differences from the expected data structure. Therefore, the update was cancelled.
Nevertheless, an attempt was made to correct the affected tables. Therefore, you can now try to perform the update again. However, if you receive this message again, check the listed table. Compare the structure with the structure in this file of your old jDownloads 3.9 version: /administrator/components/com_jdownloads/sql/install.mysql.utf8.sql. Use the documentation and/or the jDownloads support forum to solve the problem.
The Table: #__jdownloads_files has an incorrect number of data fields. This means that an update can probably not be carried out without errors.
Error installing component
Warning
Extension Update: Custom install routine failure.

Second install gives this message
JInstaller: :Install: Error SQL Duplicate column name 'importance'
Extension installation stopped.
Error installing component

PHP-version is 8.1.29. MySQLi 5.7.44-cll-lve.

Please advise.
  •  

ColinM

Hi
Have you read the article
https://www.jdownloads.net/documentation/getting-started-v3-9/upgrading-from-jd3-9-to-jd4

Yes there are database changes between jD3.9 series and jD 4

The upgrade includes Joomla as well as jDownloads

Colin
Colin M
  •  

NJK

Hi Colin,

Yes we've read that, and have disabled the system plugin before Joomla upgrade.
Still, the jD upgrade fails.

Frode
  •  

ColinM

Hi
What version of joomla are you using?
Think I willmaybe need to up grade the documentation!!
So setting up a test site.
Colin
Colin M
  •  

NJK

Joomla 4.4.9, as mentioned above. (Sorry, didn't see your reply before today).
  •  

ColinM

Hi
Have you solved the updating 'challebnge' or do you need more help?
Colin
Colin M
  •  

NJK

No. Didn't you get my latest answer to your PM?
  •  

ColinM

Hi
Yes I have and sent an email requesting Akeeba bakup of your site
Colin
Colin M
  •