× Help Forum English

[SOLVED] JInstaller: :Install: SQL-Fehler Duplicate column name 'releasedate

mentil
Topic Author
New Member

6 years 7 months ago - 6 years 7 months ago #15632 by mentil

[SOLVED] JInstaller: :Install: SQL-Fehler Duplicate column name 'releasedate was created by mentil

Hallo Community,

wer weiß Rat?

Warnung
JInstaller: :Install: SQL-Fehler Duplicate column name 'releasedate'
Erweiterung „Aktualisierung“: SQL Fehler beim Ausführen der Abfrage: „DB-Funktion mit Fehlercode 1060 fehlgeschlagen!
Duplicate column name 'releasedate'
SQL =

ALTER TABLE `#__icagenda` ADD COLUMN `releasedate` TEXT(65535) NOT NULL AFTER `version`;

Installierte Version 3.6.12
Neueste Version 3.6.14

Danke.

Last edit: 6 years 7 months ago by Lyr!C. Reason: [SOLVED]

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

6 years 7 months ago #15635 by Lyr!C

Replied by Lyr!C on topic JInstaller: :Install: SQL-Fehler Duplicate column name 'releasedate

Hello,

Which was the first iCagenda version installed ? Or do you remember the date the first time you downloaded and installed iCagenda ?

Did you have use migrateMe on this site for a Joomla 2.5 to Joomla 3 upgrade ?
And which is your current Joomla version ?
Could you tell me your php version and your database type (is it MySql) ?

Best regards,
Cyril

Latest version : iCagenda 3.9.8
We recommend every user to keep iCagenda updated.
Don't forget to have your Joomla!™ up-to-date!

Do you like iCagenda?
I would appreciate if you could take 5 minutes to post a review on JED (Joomla Extensions Directory) .

Please Log in or Create an account to join the conversation.

mentil
Topic Author
New Member

6 years 7 months ago #15660 by mentil

Replied by mentil on topic JInstaller: :Install: SQL-Fehler Duplicate column name 'releasedate

Systeminformationen
Einstellung Wert

PHP erstellt für Linux tiner.ispgateway.de 3.14.79-grsec-pvops-xen-x64 #1 SMP Mon May 22 13:12:26 CEST 2017 x86_64
Database Type mysql
Datenbankversion 5.6.19-67.0-log
Datenbankzeichensatz utf8_general_ci
Datenbankverbindungszeichensatz utf8mb4_general_ci
PHP-Version 5.6.34
Webserver Apache/2.4.29
PHP-Interface für den Webserver cgi-fcgi
Joomla!-Version Joomla! 3.8.8 Stable [ Amani ] 22-May-2018 14:00 GMT
Joomla!-Plattform-Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Browsererkennung Mozilla/5.0 (Windows NT 10.0; WOW64; rv:60.0) Gecko/20100101 Firefox/60.0

No Migration. First installaation of Joomla 3.
ICAGENDA version - i don't remember.

Thank you

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

6 years 7 months ago #15661 by Lyr!C

Replied by Lyr!C on topic JInstaller: :Install: SQL-Fehler Duplicate column name 'releasedate

Hello,

Well, all seem ok for server settings...

What may happen is a wrong extension version in Joomla schemas table (this is the extension version stored by Joomla when an extension uses Joomla core SQL update: docs.joomla.org/J3.x:Developing_an_MVC_C...t/Using_the_database ).

Look in #__schemas if you have an entry for iCagenda (Extension ID in the list of extensions, or in #_extensions table for iCagenda component).

If yes, check that version is 3.6.14 or else ?

If entry for iCagenda extensions id empty, or wrong, create or modify it! (this is the version number used by Joomla to run update sql files).

What is needed is Extension ID. About version you can set 3.6.14

Hope this helps ?

Regards,
Cyril

Please Log in or Create an account to join the conversation.

mentil
Topic Author
New Member

6 years 7 months ago #15668 by mentil

Replied by mentil on topic JInstaller: :Install: SQL-Fehler Duplicate column name 'releasedate

Thanks. i don't get it.

This is what i have here.

Please Log in or Create an account to join the conversation.

mentil
Topic Author
New Member

6 years 7 months ago #15669 by mentil

Replied by mentil on topic JInstaller: :Install: SQL-Fehler Duplicate column name 'releasedate

vollständige Textfelder id version releasedate params
Bearbeiten Löschen 3 3.6.14 2017-07-27

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

6 years 7 months ago #15676 by Lyr!C

Replied by Lyr!C on topic JInstaller: :Install: SQL-Fehler Duplicate column name 'releasedate

Is it ok then by adding missing entry in #__schema table ?

Best regards,
Cyril

Please Log in or Create an account to join the conversation.

mentil
Topic Author
New Member

6 years 7 months ago #15678 by mentil

Replied by mentil on topic JInstaller: :Install: SQL-Fehler Duplicate column name 'releasedate

Cette solution fonctionne parfaitement maintenant.
Merci

Please Log in or Create an account to join the conversation.

mentil
Topic Author
New Member

6 years 7 months ago - 6 years 7 months ago #15679 by mentil

Replied by mentil on topic JInstaller: :Install: SQL-Fehler Duplicate column name 'releasedate

OOPS:

This message contains confidential information

Last edit: 6 years 7 months ago by Lyr!C.

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

6 years 7 months ago #15684 by Lyr!C

Replied by Lyr!C on topic JInstaller: :Install: SQL-Fehler Duplicate column name 'releasedate

Hello,

I've hidden as confidential the posted error report (to not diclose full server path).

What happened ?
There's missing tables, but framework errors too...
Seems a part of your site install went away ?!?...

Where all those warnings are displayed ? Admin ? Site ? only iCagenda ?...

Regards,
Cyril

Please Log in or Create an account to join the conversation.

Moderators: Lyr!C

Time to create page: 0.139 seconds

Forum

[SOLVED] JInstaller: :Install: SQL-Fehler Duplicate column name 'releasedate

Legal

Follow Us