jDownloads Support Forum

jDownloads for Joomla 4.x and 5.x => jDownloads 4.0 => Bugs! => Topic started by: NJK on 10.11.2024 18:35:18

Title: Install: Error SQL Duplicate column name
Post by: NJK on 10.11.2024 18:35:18
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.
Title: Update from 3.9
Post by: ColinM on 11.11.2024 13:50:21
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
Title: Re: Install: Error SQL Duplicate column name
Post by: NJK on 11.11.2024 20:49:08
Hi Colin,

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

Frode
Title: ugrade to jD4
Post by: ColinM on 13.11.2024 10:30:48
Hi
What version of joomla are you using?
Think I willmaybe need to up grade the documentation!!
So setting up a test site.
Colin
Title: Re: Install: Error SQL Duplicate column name
Post by: NJK on 18.11.2024 12:53:14
Joomla 4.4.9, as mentioned above. (Sorry, didn't see your reply before today).
Title: Re:cron and special char
Post by: ColinM on 25.11.2024 13:12:11
Hi
Have you solved the updating 'challebnge' or do you need more help?
Colin
Title: Re: Install: Error SQL Duplicate column name
Post by: NJK on 25.11.2024 13:43:31
No. Didn't you get my latest answer to your PM?
Title: update
Post by: ColinM on 25.11.2024 16:30:12
Hi
Yes I have and sent an email requesting Akeeba bakup of your site
Colin