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
QuoteUpgrading JDownloads 3.5.1 to 3.5.2.
Hi Tom,
versions like this exist not. Please check it again.
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]
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
Which is really your old version?
Edit:
maybe it would be easier when you send me login data for your backend via PM.
Thanks for the login data. I hope I can check this at the weekend.