Unable to save or apply category

Phoca Gallery - image gallery extension
HrLaursen
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 18 Jan 2008, 23:56

Unable to save or apply category

Post by HrLaursen »

Hi!

I just updated my Joomla from 1.5.0 to 1.5.9 and installed Phoca Gallery 2.2.0 beta.
Now I want to create a category, but I can’t. When I have chosen a name and folder and want to save the category nothing happens. The only thing that changes is the URL. By clicking the save or apply button it adds a # at the end. I’m able to click cancel, but that’s not creating my category. :)

Please help.

Thanks

Best Regards
Michael
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49297
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Unable to save or apply category

Post by Jan »

??? Hi, see if you get this problem in other applications in Joomla! ???

Jan
If you find Phoca extensions useful, please support the project
mpapas
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 21 Feb 2009, 11:37

Re: Unable to save or apply category

Post by mpapas »

Hi ,
I have Joomla 1.5.9 and installed com_phocagallery_v2.2.0_beta and have the same issue.
Checked db and install.sql script. The script has NO code in it and therefore there are no db tables created for phoca.
can any one point us in the right direction to retrieve the latest install.sql script ?
'Page not found' errors are coming up from other forum solutions to the db table issue.

thanks in advance.
mpapas
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 21 Feb 2009, 11:37

Re: Unable to save or apply category

Post by mpapas »

SOLVED
ran the install.bak script located at: administrator\components\com_phocagallery
however these lines are NOT working: (sql syntax error?)

jos 2.0.0
jos ALTER TABLE `jos_phocagallery_categories` ADD `hits` INT( 11 ) NOT NULL DEFAULT '0' AFTER `count` ;

jos 2.2.0
jos ALTER TABLE `jos_phocagallery` ADD `extlink1` text NOT NULL AFTER `params` ;
jos ALTER TABLE `jos_phocagallery` ADD `extlink2` text NOT NULL AFTER `extlink1` ;

If you run the install.bak script be sure to change #__ with your table prefix eg: jos_

thanks
User avatar
caro84g
Phoca Hero
Phoca Hero
Posts: 1369
Joined: 11 Feb 2008, 17:52
Location: Holland
Contact:

Re: Unable to save or apply category

Post by caro84g »

in the beginning of the row it must no be 'jos'.

Those are not #_, but only #

If you installed I am not sure if you have to run these commands. Check in you jos_phocagallery table if 'extlink1' and 'extlink2' exist. If this is the case, then it's ok. - otherwise run those queries too.

Regards, Carolien
Please ask your support questions in the forums and not via PM - I delete those PM's
Backup before you do any major change to your website (and test first)
mpapas
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 21 Feb 2009, 11:37

Re: Unable to save or apply category

Post by mpapas »

Thank you,

I did check the db and the fields were there. so all is ok now.
:D
HrLaursen
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 18 Jan 2008, 23:56

Re: Unable to save or apply category

Post by HrLaursen »

Hi

It's nice to see you people work while I'm not. :-)

Thanks

Jan → It looks like my old version of Phoca Gallery does the same, but the other Apply and Save button works.

Mpapas → I tried running the SQL script in install.bak and I have the extlink1 and 2 in jos_phocagallery, but unfortunately my situation is the same.

What to do?

Thanks

-Michael
User avatar
caro84g
Phoca Hero
Phoca Hero
Posts: 1369
Joined: 11 Feb 2008, 17:52
Location: Holland
Contact:

Re: Unable to save or apply category

Post by caro84g »

and do all the other tables exits? You need to have 6 phocagallery tables.

Regards, Carolien
Please ask your support questions in the forums and not via PM - I delete those PM's
Backup before you do any major change to your website (and test first)
HrLaursen
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 18 Jan 2008, 23:56

Re: Unable to save or apply category

Post by HrLaursen »

caro84g -> Yes...

jos_phocagallery
jos_phocagallery_categories
jos_phocagallery_comments
jos_phocagallery_user_category
jos_phocagallery_votes
jos_phocagallery_votes_statistics

I ran the whole install.bak sql script.

Thanks

-M
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49297
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Unable to save or apply category

Post by Jan »

If all the tables exist and all the prefix are ok (jos_) then there is other then database problem :-(, where exactly do you get the problems?

Jan
If you find Phoca extensions useful, please support the project
Post Reply