Duplicate column name 'importance' - [Not a bug]

[JohnCasey]

Hey,

first of all: great software, you build there! Now the Problem:

I want to update jDownloads 3.2.14 to 3.2.20 (latest stable Joomla 3.3.6). At first, I got the same error as Chuck ( http://www.jdownloads.com/forum/index.php?topic=7697.0 ). After the todays fix, I get the following error message:

1060 Duplicate column name 'importance' SQL=ALTER TABLE `joomla_jdownloads_usergroups_limits` ADD `importance` SMALLINT( 6 ) NOT NULL DEFAULT '0' AFTER `id`;

Any thoughts?

[gelöscht durch Administrator]

[Arno]

Hm... have you activated the debug option in Joomla? If so then deactivate it please.

I must search a little bit more to find a solution with the sql error. But for a temporary fix can it be usefull to do this:
- unzip the install package on your pc
- go to this folder: ..\com_jdownloads\admin\sql\updates\mysql
- open the file 3.2.9.sql delete the content and save it
- open the file 3.2.12.sql delete the content and save it
- zip the main folder now and try again an installation

I want to update jDownloads 3.2.14 to 3.2.20

Are you sure with 3.2.14?

[JohnCasey]

Thanks for the reply.

With your fix I could install the update and as far as I can see, it works out fine.

Are you sure with 3.2.14?

I installed 3.2.14 from the web catalog. After the installation, the update to 3.2.20 was available.

[Arno]

Okay. Thanks for the info. I will check this.

[Arno]

I have succesful updated from 3.2.14 to 3.2.20. Without any error. See pic.
No idea what in your case was really wrong.  

Edit: i think you have uninstall the older version before you have tried to install the newer one. This is not usefull and not required.
In this case must you also delete manually the jD db tables before you can install the new version.


[gelöscht durch Administrator]

[triumvirato]

Hi!

Same issue here. i'm traying to update from jD 3.2.17 Beta to jD 3.2.33 If i do it automatically from extension manager/update i get the error:
1060 Duplicate column name 'uploads_default_access_level' SQL=ALTER TABLE `jos_jdownloads_usergroups_limits` ADD `uploads_default_access_level` INT( 10 ) NOT NULL DEFAULT '0' AFTER `uploads_can_change_category`;

Same problem if try to do it uploading the ZIP file of the new version.

Any idea?

thank's in advace

[gelöscht durch Administrator]

[Arno]

Hi,
sorry for this problem. It has to do with your very old version 3.2.17.

You can try to remove the data field 'uploads_default_access_level' via phpmyadmin and start then again the install script.
In the next version 3.2.34 is your problem fixed.

[gelöscht durch Administrator]

[triumvirato]

Hi Arno,

Thank's for your fast reply.

i've been exploring my DB and do not find that data field... 
Another solution?

Thank's in advance



[gelöscht durch Administrator]

[Arno]

Sorry. I had forgot to tell you, what for a table you must open:
_jdownloads_usergroups_limits

[triumvirato]

Thank's Arno!

That not solve the problem. I deleted the data field, but when execute the script, the same error occurs and the data field is created again...

Also uploading the Zip file. Same result.

Thank's

[gelöscht durch Administrator]

[Arno]

Okay.
Please remove the data field again and use then the version below for the update.
I hope that this will solve the problem.

Edit:
special version removed as we have now the version 3.2.34 published. Use this for the update.

[triumvirato]

Arno,

Ok, it worked!
I've been traveling a few days and I have not been able to test it.
Thank you very much for your help and thanks for the great support you give. I've been really impressed.
Thank you very much for everything, again.

Best Regards.