News:

Dear forum visitors, if the support forum is not available, please try again a few minutes later. Thanks!

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!
  •