Phoca Forum

Hello,

i have a problem with the categories of the phoca gallery in the menu-link to show them and im getting always the error:

Error displaying the error page: SQL=SELECT parent_id FROM jos_categories WHERE id=1nameofthecategorie

the sql selection should be jos_phocagallery_categories instead of jos_categories

where can that be fixed?

im using the 4.00 beta version / this error exists also in the alpha version

best regards

example-link of the error: (by click on the photo: http://marktmusik-wolfsegg.at/foto)

Hi, try to enable debug mode and php error reporting, testing now and get no such problem Try to disable SEF and let me know the link (to see the part of the problem)

In Phoca Gallery there is no ask on SQL query to jos_categories (so maybe the SEF has some problems and some other part of Joomla! is called)

Thank you, Jan

hi jan,

i turned the SEF off and the debug ON but the problem is as before

but the ask on SQL query is jos_phocagallery_categories ...

the links:
http://www.marktmusik-wolfsegg.at/index ... Itemid=507
http://www.marktmusik-wolfsegg.at/index ... Itemid=507

TIA

Hi, some part of your site ask this query:

SELECT parent_id
FROM jos_categories
WHERE id=1

But there is no such query in Phoca Gallery ... try to check your template or system plugins
On your site I see such queries in other parts of the site (e.g. in contact but as Joomla! has unique category system for all core components, this maybe is not a problem )

But really no idea why such query is executed in Phoca Gallery ... If I add the category=x string to url for not core components they all get the same behaviour - running such query and asking jos_categories ... so maybe some system plugin or template add this query

Searching your html code, etc, cannot find what can be wrong there, and who can ask jos_categories on that site

Do tests on my test sites, nothing similar, will try to do more tests, but for now really no idea

Jan

ok, thanx.

i have no idea because it's the standard template of joomla 3 an have only installed gcalender.

when i switch the menu button direcly to a categorie of phoca then it works...

totaly strange...

Rather similar problem here viewtopic.php?f=31&t=23046 was resolve by deleting PD, reinstalling and redefining the menus.

so i debugged a little bit

i found out that:

• 1) when i set the menue to a categorie the images get out and are available
  2) when i set the menue to categorie-list - the list is available but the the link is not created correcty

Please tell me where i can fix that

Example to understand what i mean:
Menue http://www.marktmusik-wolfsegg.at/foto/ the Categorie is visible
by click on the categorie the generated link is false http://localhost/musi/foto/category/1-schlossfest-2012 that should be http://localhost/musi/foto/category/1 (this is the right link and this works - but where i can fix this?) only the category/Nr. without the text.

So could you please help me to fix that?

false code this link should be Database: SELECT * FROM `jnc_phocagallery_categories` WHERE 1 LIMIT 0, 30 ;

same without SEO
the false generated url an this is the right url - without :schlossfest-2012 (how can i fix this that this works) thx and best regards

Installed Joomla 3.2.1
Phoca Gallary 4.0.4

Hi, it is standard format for the ids - they include the number and the alias - if you remove the 2012 from the alias, then it will work, the problem is, the id=1:schlowwfest-2012 should be translated to 1. Only int (integer - number) is taken.

Test your php or database settings. What you get when you run the following script: (e.g. test.php) This way the SEF is working in Joomla! (I am not the developer of the SEF feature, Phoca Gallery does not create any SEF feature, it is just use the standard SEF rules in Joomla! - links are produced by Joomla! JRoute method)

I am testing the SEF link on all test servers without any problem, see images:

Image 1 - see the URL with SEF enabled - the url goes to right site ( 1:schlossfest-2012 is normally translated to 1 --> id 1 of the category)

Image 2 - see the URL without SEF enabled - the url goes to right site ( 1:schlossfest-2012 is normally translated to 1 --> id 1 of the category)



The behaviour is standard Joomla! behaviour - the URL is displayed with aliases and aliases are translated correctly in Joomla! system, the site is correctly displayed - the ID is taken from the alias - only number like it should be done.


So try to test the php script to get information, if everything on the server is Ok with (int). Not sure but maybe there will be other limit

Jan

Thx Jan for your answer.

i get back so this should work.

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?

TIA

Ps.:
i could not remove the alias at the admin-site of joomla by the components . the fild must be filled

ähm it is not the server - because i have downloaded the installation an i run this installation offline with xamp to an there is also the same problem.

i have also updated the files by copy paste from a new joomla zip