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

Upgrade 3.2.51>3.2.52 DB function failed with error number 1060 Duplicate colum

Started by wocomm, 21.07.2017 19:50:24

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

wocomm

Upgrading JDownloads 3.2.51 to 3.2.52.  Joomla v3.7.3, PHP 5.6.31, DB v5.5.57

Warning
JInstaller: :Install: Error SQL Duplicate column name 'importance'
Extension Update: SQL error processing query: DB function failed with error number 1060
Duplicate column name 'importance'
SQL =
ALTER TABLE `#__jdownloads_usergroups_limits` ADD `importance` SMALLINT( 6 ) NOT NULL DEFAULT '0' AFTER `id`;
×
Message
Error updating component.

Any ideas?

Thank you

Tom
  •  

Arno

QuoteUpgrading JDownloads 3.5.1 to 3.5.2.
Hi Tom,
versions like this exist not. Please check it again.
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!
  •  

Arno

You can try this:
- download the newest version 3.2.52
- unzip it on your PC
- open this file: /admin/sql/updates/mysql/3.2.9.sql
- make this file empty (remove every text) and save it
- go back to the first folder com_jdownloads and zip it again
- try again to install it

Just use the file below.  ;)

[gelöscht durch Administrator]
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!
  •  

wocomm

Thank you, I have updated to correct versions.

I tried the file and now receive a new error message

Warning
JInstaller: :Install: Error SQL Duplicate column name 'uploads_use_tabs'
Extension Update: SQL error processing query: DB function failed with error number 1060
Duplicate column name 'uploads_use_tabs'
SQL =
ALTER TABLE `#__jdownloads_usergroups_limits` ADD `uploads_use_tabs` TINYINT( 1 ) NOT NULL DEFAULT '1' AFTER `uploads_use_editor`;
×
Error
Error installing component

I used Joomla Installer to upload

Thank you

Tom
  •  

Arno

Which is really your old version?

Edit:
maybe it would be easier when you send me login data for your backend via PM.
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!
  •  

Arno

Thanks for the login data. I hope I can check this at the weekend.
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!
  •