Page 1 of 1

SQL - Error

Posted: 15 Jan 2016, 04:52
by Countrybiker
Hello,

Installation for Phoca Panorama worked fine.
Uploaded Panoramafile, created category, created item (item shows correct thumpnail).

When I assign Phoca Panorama to menue item I get an error message:

1305 FUNCTION HTO01FLQJCQR.CONCAT_WS does not exist SQL=SELECT CONCAT_WS (' --> ', c.title, a.title) as text, a.id as value FROM uwa5s_phocapanorama_items AS a LEFT JOIN uwa5s_phocapanorama_categories AS c ON c.id = a.catid WHERE a.published = 1 AND c.published = 1 ORDER BY c.ordering, a.ordering

(HTO01FLQR ist the database)

Any idea?

Thank you for your help

Countrybiker

Re: SQL - Error

Posted: 15 Jan 2016, 17:13
by Countrybiker
So now I got a bit closer to it!

I understood, there should be a "panoramaname.html" file in the panorama Directory which should be created by the component.
In my case this file is missing so the Panorama cannot be displayed.
I followed the advices for adding Panorama items very stricly. Still no "*.html" file.
Is there anything else to look at?
My Panorama Image is a jpg with 8000 x 4000 Resolution and 6 MB size.

Thanks for help.

Countrybiker

Re: SQL - Error

Posted: 18 Jan 2016, 14:15
by Jan
Hi, see:
https://www.phoca.cz/documents/109-phoca ... rama-items

The panorama files should be created with help of some software like krpano is, or by google street view. The software creates more files - html, xml, flash, etc.

Jan