phoca gallery joomla 3.0

Phoca Gallery - image gallery extension
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: phoca gallery joomla 3.0

Post by Jan »

Hi, really no idea what can be wrong, as you can see on the screenshots, it is normally working.
Can i manipulate the code of phoca to get the right url? Please could you tell me in which of the script the link is generated?
Not sure if you read my posts above correctly, but there I have written, the links are made by Joomla! method - by JRoute() - so links in Joomla! (their encoding and decoding to SEF, etc.) are made by Joomla! methods.

You can somehow try to change removing all aliases in the component but for this you need to search for the "JRoute" code in the component and see the $link (or similar variables). Such link variables you should somehow clean (remove the alias) ... But removing alias is removing standard Joomla! feature and I really don't know how the links will work - I still think, the alias is not a problem as this is standard Joomla! method which normally works on millions of the world sites. :idea:

Jan
If you find Phoca extensions useful, please support the project
mmwolfsegg
Phoca Newbie
Phoca Newbie
Posts: 9
Joined: 27 Mar 2013, 10:30

Re: phoca gallery joomla 3.0

Post by mmwolfsegg »

Hello,

today i installed local on xampp a new joomla 3.2.3. Stable (german) and phoca gallery 4.1.0

then i first created a new categorie after that i uploaded so pictures but i got the same error?


<title>Fehler: 1054 Unknown column '2schlossfest2012' in 'where clause' SQL=SELECT parent_id FROM fcum9_categories WHERE id=2schlossfest2012</title>

Code: Select all

Error displaying the error page: Unknown column '2schlossfest2012' in 'where clause' SQL=SELECT parent_id FROM fcum9_categories WHERE id=2schlossfest2012: Unknown column '2schlossfest2012' in 'where clause' SQL=SELECT parent_id FROM fcum9_categories WHERE id=2schlossfest2012
so i don't really know how to solve the problem...
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: phoca gallery joomla 3.0

Post by Jan »

Hi, you get some errors inside Joomla!, Phoca Gallery does not ask joomla ..._categories table, so this seems like some problem in Joomla! or another part of the system (e.g. system plugin,e tc.)

Jan
If you find Phoca extensions useful, please support the project
mmwolfsegg
Phoca Newbie
Phoca Newbie
Posts: 9
Joined: 27 Mar 2013, 10:30

Re: phoca gallery joomla 3.0

Post by mmwolfsegg »

Hello Jan,

if i delete the alias of the categorie in the database this works - so how i can fix that?
tia
mmwolfsegg
Phoca Newbie
Phoca Newbie
Posts: 9
Joined: 27 Mar 2013, 10:30

Re: phoca gallery joomla 3.0

Post by mmwolfsegg »

Hello Jan,

maybe i have solved this problem :twisted:

i have set the length of the alias value (varchar) to zero :D

i know thats a work around but it works :lol:

i hope this could help other guys with that problem

best regards
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: phoca gallery joomla 3.0

Post by Jan »

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