Page 1 of 2

Unable to save or apply category

Posted: 18 Feb 2009, 16:57
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

Re: Unable to save or apply category

Posted: 20 Feb 2009, 00:56
by Jan
??? Hi, see if you get this problem in other applications in Joomla! ???

Jan

Re: Unable to save or apply category

Posted: 21 Feb 2009, 11:58
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.

Re: Unable to save or apply category

Posted: 21 Feb 2009, 12:49
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

Re: Unable to save or apply category

Posted: 21 Feb 2009, 20:05
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

Re: Unable to save or apply category

Posted: 22 Feb 2009, 12:49
by mpapas
Thank you,

I did check the db and the fields were there. so all is ok now.
:D

Re: Unable to save or apply category

Posted: 23 Feb 2009, 08:47
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

Re: Unable to save or apply category

Posted: 23 Feb 2009, 09:49
by caro84g
and do all the other tables exits? You need to have 6 phocagallery tables.

Regards, Carolien

Re: Unable to save or apply category

Posted: 23 Feb 2009, 21:44
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

Re: Unable to save or apply category

Posted: 27 Feb 2009, 20:15
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