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

CMigrator: Path from Drupal 6 to J5?
(Category s/b CMigrator, but didn't see it on the list) I'm interested in usi...
0 Replies
Posted on Monday, 28 April 2025
  • New
  • Dowload all Hotspots entries
    Hi there, I'm looking for a way to dowload all the Hotspots entries. I've got t...
    0 Replies
    Posted on Sunday, 06 April 2025
    • #kml
    • #download
    Set number of hotspots / user groups
    Hi, I'm working with Hotspots for my new website and I love it! After trying ...
    0 Replies
    Posted on Monday, 31 March 2025
    J5 compatibility for Hotspots
    Hi guys, Just started to update my old J3x website. Is there J5 compatibility p...
    1 Replies
    Posted on Monday, 24 February 2025
    • #Hotspots
    • #hotspots Joomla 5
    Text size in the comment input form
    Hello. How can I increase the font size in the comment input field? For examp...
    0 Replies
    Posted on Wednesday, 26 February 2025
    • #CComment 6