SQL - Error

Phoca Panorama - displaying list of panorama images and detail of selected panorama image
Countrybiker
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 15 Jan 2016, 04:39

SQL - Error

Post 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
Countrybiker
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 15 Jan 2016, 04:39

Re: SQL - Error

Post 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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48416
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: SQL - Error

Post 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
If you find Phoca extensions useful, please support the project
Post Reply