1. Susanne Althen
  2. Bug report
  3. Monday, 11 October 2010
  4.  Subscribe via email
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
Responses (10)


There are %s replies to this question. If you want to see them you need a valid subscription.
If you have a valid subscription, please login now.
Visit store now

Last questions

Hotspots Pro 6.0.13 compatability with Joomla 5.3.
Running Hotspots Pro 6.0.13 on Joomla 4.4.13 and want to upgrade to Joomla 5.3.1...
2 Replies
Posted on Friday, 04 July 2025
some questions on Hotspots
Hi, On Hotspots extension : 1) is it possible to add our own map layer / v...
0 Replies
Posted on Thursday, 03 July 2025
Trying to resize the image in the comments
Hey everyone, Basically I am trying to make the images in the comments smalle...
9 Replies
Posted on Wednesday, 12 August 2009
J5 compatibility for Hotspots
Hi guys, Just started to update my old J3x website. Is there J5 compatibility p...
2 Replies
Posted on Monday, 24 February 2025
  • #Hotspots
  • #hotspots Joomla 5
error message when adding/cofiguring email address
When configuring the email plugin that send a email message to admin when a new ...
0 Replies
Posted on Friday, 09 May 2025