TOPIC: sobi import error

Hello there,
this problem has been posted already in the lunajoom forum (without being answered):
After trying to do the sobi import, the categories are imported, but not the entries.
Error see attachment
Hotspots 1.0 beta,
Sobi RC 2.9.2.4
php 5.2.6
joomla 1.5.20 stable
MySQL 5-0.45

Thanks in advance!

P.S. can´t see if the attachment really is uploaded. Here is the error report:

0 finished1 finished2 finished3 finished4 finished5 finished6 finished7 finished8 finished9 finished10 finishedDB function failed with error number 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 'LEFT JOIN jos_sobi2_cat_items_relations AS ct ON ct.itemid = c.itemid' at line 2 SQL=SELECT DISTINCT c.title AS name, ct.*, c.Itemid, c.publish_up AS postdate, c.image, c.published FROM jos_sobi2_item AS c WHERE published = '1' LEFT JOIN jos_sobi2_cat_items_relations AS ct ON ct.itemid = c.itemid

Hey Susanne,
Could you send me your sobi2 database tables ( This email address is being protected from spambots. You need JavaScript enabled to view it. )? If you can that would make my life easier, if you can't it is not that much of a problem.

Cheers,
Daniel

Hi Daniel,
I sent you the Sql dump through pm.
Here is the link:
unser-seligenstadt.de/virtueller-stadtplan

Got it, give me some hours and I'll come back at you.
Daniel

Sorry for the delay.
open administrator/component/com_hotspots/controllers/import.php
on line 104 you have the following code:change it to:
this should solve the problem

Hi Daniel,
thank you for your really quick reply and your help. It solved the problem. Import works now!
With one exception though:
The markers of the imported entries do not show up in the frontend.You can see that there are entries in the categories, but if you hit the category no hot spot marker appears.
When I edit the marker in the backend and move the marker around a little, then ist´s loaded in the frontend.

Just 2 little other things, but I will open a new thread for that.

Thanks again!

Hm for some of the categories it is working. Would you be so kind to go to your backend and edit the category: "Werbung und Marketing" - add an icon for it and after that check if it works.
Daniel

Hi Daniel,
still struggling with this. It was only working for the ones that I edited or added later on, not for the "freshly" imported ones.

But even worse at the moment the marker descriptions don´t show up at all. Is ist possible that I turned them off in the backend? Just can´t find a way to get them back on.

Further on: if I add a hotspot marker in the backend by filling in the adress in the adress field (because sometimes it ist impossible to get the right spot e.g. number of the house in the street)it doesn´t change the coordinates in the map accurately.

And finally the reset marker funtion doesn´t work for me..

Sorry for all the requests, maybe just simple understanding issues.

for the categories that don't show the markers, edit the categories and add an image an icon. Tell me if the markers show after this.

We use the google geocoder to translate the pin position from the map to coordinates. When you enter just the address, without moving the pin on the map, no coordinate translation takes place.
Together with the street you will need to enter the cocordinates. - We will have to improve this, I know...

Hey Daniel,
it works allright as soon as the icons are added!

The marker description with link to detail page still don´t show up any more. Any suggestion? Thanks in advance.