SOLVED!!! Error Saving Phoca Gallery Categories

[kessi54]

Hi Jan,
I updated phoca gallery from 2.2.0 beta to 2.2.4. Now I can`t create new categories. I had the same problem after my last update but I could solve the problem withe the help of this:

https://www.phoca.cz/documents/2-phoca-g ... em-solving

But now I think the problem is an other one because there are already six tables in the database.
Perhaps the last part of the document could save my problem, but I don`t understand this:

If you have all tables in your database (e.g. you are upgrading from 2.1.0 to 2.2.0) check the columns of your tables. E.g. in Phoca Gallery version 2.2.0 there are new colums: extlink1, extlink2 and these should be added into table: #__phocagallery. In case you are upgrading e.g. from 2.1.0 to 2.2.0 and you got some error message while automatically upgrading of Phoca Gallery tables, check the #_phocagallery table and if extlink1 or extlink2 columns are missed, then run the SQL query for 2.2.0 version:

ALTER TABLE `#__phocagallery` ADD `extlink1` text NOT NULL AFTER `params` ;
ALTER TABLE `#__phocagallery` ADD `extlink2` text NOT NULL AFTER `extlink1` ;

Please help!
Klemens

[kessi54]

Hi Jan,
Sorry, I didn`t see the thread with nearly the same title. But I´m not shure, whether it is the same problem because my update is an other one. But I thought it might be the same problem, so I tried to solve my problem with the same method I read in the other thread and got the following message:

SQL-Befehl: Dokumentation

SELECT *
FROM `jos_phocagallery`
WHERE 1
ALTER TABLE `jos_phocagallery` ADD `extlink1` text NOT NULL AFTER `params` ;

MySQL meldet: Dokumentation
#1064 - Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei 'ALTER TABLE `jos_phocagallery` ADD `extlink1` text NOT NULL AFTER `params`' in Zeile 2

After that I tried only the following query
ALTER TABLE `#__phocagallery` ADD `extlink1` text NOT NULL AFTER `params` ;
ALTER TABLE `#__phocagallery` ADD `extlink2` text NOT NULL AFTER `extlink1` ;

And got the error:
Fehler
SQL-Befehl:
ALTER TABLE `jos_phocagallery` ADD `extlink1` text NOT NULL AFTER `params` ;
MySQL meldet: Dokumentation
#1060 - Doppelter Spaltenname: 'extlink1'

Now I checked the jos_phocagallery table and saw that the two columns "extlink1" and "extlink2" are already exist.
Therefore I think my problem is an other one.

If you think the two problems are the same, please write it to me and I will finish this thread.
Best regards
Klemens

[caro84g]

Hi,

they are the same...

I think I have to update the documentation.

What you could do in the mean time: unpack the phocagallery install package on your computer.
Open the install.sql.?? file with a text editor. Scroll down until you see something like # upgrade to version....
This is below the ALTER TABLE command with extlink etc.

I thought there was another 'ALTER TABLE' command. Try to execute that in your PHPmyAdmin. When I have time I look up exactly what the command is.

Regards, Carolien

[kessi54]

Hi Carolien,
sorry but the install.sql file is empty.
Best regards
Klemens

[caro84g]

I'm sorry, it was install.bak and there is says:
to upgrade to 2.2.2:

Code: Select all

ALTER TABLE `#__phocagallery_categories` ADD `date` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `description` ;

Regards, Carolien

[kessi54]

Hi Carolien,
I did how you said but got the following error-message:

Fehler
SQL-Befehl:

ALTER TABLE `jos_phocagallery_categories` ADD `date` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `description`

MySQL meldet: Dokumentation
#1060 - Doppelter Spaltenname: 'date'

Best regards
Klemens

[kessi54]

Hi,
suddenly everything works fine in spite of the error message in phpmyadmin!!!
Best regards
Klemens

[Jan]

ok