Phoca Forum

On this page
antiekroute-veluwe.nl/print-de-deelnemerslist.html there is an error related to Phocamaps.
The just url is antiekroute-veluwe.nl/print-de-deelnemerslijst.html
At the bottom there is mentioned:
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 ':de-deelnemerslist.html' at line 3 SQL=SELECT id, alias AS title, language FROM waqr3_phocamaps_map WHERE id=print:de-deelnemerslist.html
The start page the menu item type is Phocamaps, not an article.
How can I solve this?

Hi, which phoca maps version you are using? Are you using component or plugin? What if you disable SEF, do you get the same problem?

Anyway I cannot find any such sql in component or plugin, are you using some external extension (template override, ...) to work with Phoca Maps?

Jan

Jan,

Sorry for my late answer.
What I mentioned above was a sef extension.
But now when you click on antiekroute-veluwe.nl/print-de-deelnemerslist then I get an error:
Geen kaart geselecteerd. Selecteer de kaart in Settings in menu link naar kaart. In het geval dat meertaligheid wordt gebruikt, controleer of de kaart in de huidige taal bestaat
The good url is antiekroute-veluwe.nl/print-de-deelnemerslijst
It's coming from a dutch language file of phocamaps.
I have no sef extension installed.
I am using the component version 3.01 for Joomla 3.0 latest version.
How can I solve that?

Can you disable SEF and let me know the link to the site without SEF?

Jan

I told tou that I have no sef extensions installed.
The url's you can find in the post before.
When I disable Sef in the settings website of Joomla, there is no error from de language file of phocamaps.
I mean this fault on all pages. only the home url gives the blanc 404 error
antiekroute-veluwe.nl
Otherwise I translate you see from language file in a 404 error text.

Hi, I didn't write, you are using SEF extensions, I have written about disabling SEF (means standard Joomla! SEF) to see the raw url.

When I test the site now, I get no problem there

This link: antiekroute-veluwe.nl/route/1-de-route?tmpl=component&print=1&from=YnJubw==&to=NTIuMjM4NzYsNS42MDk5NQ==&lang=nl works ok for me, the same like this:
http://antiekroute-veluwe.nl/route/1-de ... ==&lang=de (german language)

Hmm, really no idea what can be wrong there when sef is enabled

Jan

Jan,
My question was why I get here a page with a language file coming from phoca maps:
antiekroute-veluwe.nl/print-de-deelnemerslijs (wrong url lijs instead of lijst)
Good url antiekroute-veluwe.nl/print-de-deelnemerslijst
On other pages the same problem.
The raw url without Joomla SEF is antiekroute-veluwe.nl/index.php?option=com_content&view=article&id=23&Itemid=108
Making a mistake in this url antiekroute-veluwe.nl/index.php?optio=com_content&view=article&id=23&Itemid=108 (optio= instead of option=)
The problem is the the image slider but when you scroll down you see the normal error page.

Hi, if you get wrong link, you need to check the menu link parameters, Phoca Maps does not manage the links or sef links, they are set in menu link and such are used in the component - Phoca does not create them, it just show map on menu link which is assigned to menu link.

Try to see, if you don't run some other system plugin which somehow changes the output or links on your site - in fact this does not have anything with the component - first the link is set (by menu manager) then the component displays the output - so it cannot do anything with the url as the url is build first then the component is working based on the created link

Jan

jan,

I don't agree with you, sorry.
When I disable the homepage in the menu which is linked to phocamaps, I do not see the error coming from the language file of phocamaps!
Then I get the normal Joomla error page.

All problems are solved when I link phocamaps to an article with the phocamaps plugin.
I have dowmload the dutch language files and installed it like you said here: https://www.phoca.cz/documents/46-transl ... -in-joomla
But I have tried everything, but under the cart I get From address etc. and not the dutch translation.
http://www.antiekroute-veluwe.nl/langua ... camaps.ini
http://www.antiekroute-veluwe.nl/admini ... camaps.ini

Edit: Jan its solved now.
In the downloads the are two dutch language packs.
A version for 1.5, 1.7 and 2.5 and below another one.
Because I use Joomla 3.0 I have download the last.
And that are not the right files for Joomla 3.0!!!
I have now downloaded the language files for 1.5, 1.7 and 2.5
Why not mentioned version for Joomla 3.0 in the download for 1.5. 1.7 and 2.5 and delete the other one?

Hi, great to hear it, with the languages it is not so easy, some of them are e.g. for 2.5 which work for 3 too (there are over 1000 translations and I am not able to check all of them, so when e.g. some user will not do translation for Joomla! 3, a Joomla! 2.5 can be used and updated) There are icons next to language file names - for 2.5 or 3 - so there is a difference between 1.5 x 2.5 and 3 (2.5 and 3 have the same files) but yes, not by all language files are the icons (as I wrote managing so many translation files is sometimes difficult )

Jan