Error saving catagory

[susanpenter]

I have followed the manual and I seem to have a problem.
When I use the back end and create new catagory even if I just input the catagory name I get the error message: Error saving Phoco gallery catagories. I have tried this several times.

I am using version 2.2.3

Many thanks for any advice

[Jan]

Did you check this:

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

Jan

[felix.lamour]

Hello,
this is my first post here. I find Phocagallery really a great component and I have just done the upgrade to the last version, but I have the same problem creating the galleries. I checked the "Installation Problem Solving" guidelines and actually I found some useful information. But since I never managed a SQL database, I really don't know how to write in the SQL query ...

I have six tables in my database, but I don't know exactly how to add the new colums to the table. I tried to run the following SQL query:

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

or even

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

but I just receive an error message:

"
query SQL: Documentazione

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

Messaggio di MySQL: Documentazione
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `#__phocagallery` ADD `extlink1` text NOT NULL AFTER `params`' at line 2

Since I don't know anything about it, I just think it's really a syntax error. But what I should exactly write there?
Thank you very much

[caro84g]

Hi,

it needs to be jos_phocagallery, so with only 1 underscore

Regards, Carolien

[felix.lamour]

Hello,
thank you very much for your answer. I get rid of the double underscore, but I still receive a synatx error when I input this SQL query:

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

This is the message:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `jos_phocagallery` ADD `extlink1` text NOT NULL AFTER `params`' at line 2

What am I doing wrong?
Thanks again

[felix.lamour]

Hello,
finally I was able to input correctly the SQL Query, but I still receive the "Error saving phoca galleries categories". Any idea?

[Jan]

Hi, there must be some error still, check the prefixes, etc

[felix.lamour]

Hello,
thank you for your kind answer, but I'm a SQL dummy, what should I check? What is a prefix?
Thank you again

[caro84g]

Hi,

in the global configuration, tab server, you see 'database prefix'. Whatever is entered there you should replace with the #__

Regards, Carolien

[felix.lamour]

Hello,
I don't think it's a very good idea! I followed your suggeestion and then suddenly the website crashed and compromised all the database. It took one whole day to recreate the tables of the database!

Any other ideas?