1. Al
  2. Bug Report
  3. Monday, 26 January 2009
  4.  Subscribe via email
First of all let me thank you for a cool tool.
Now, I'm having a problem I think only you could help m with:

When trying to import comments fro Easyguestbook, I ran into a problem. even though I tried many different combination in the settings of the impot I keep on getting the same error:
Import canceled ! Comments imported from jos_easygb and for com_content ALREADY EXIST !!


Also below it I get a long error message which I attach as an image as well, which by the way then also appears when I want to edit comments under MANAGE COMMENTS.

PLEASE HELP :blush:

PS... How are you supposed to attach images here??
HEY... this is the wierd.. I now see one of the images.. anyway.. lets see what happens

let me copy paste the error massage:

Unknown column 'c.importtable' in 'where clause' SQL=SELECT count(*) FROM jos_comment AS c LEFT JOIN jos_content AS ct ON ct.id = c.contentid WHERE c.component = '' AND ( LOWER(c.comment) LIKE '%jos_easygb%' OR LOWER(ct.title) LIKE '%jos_easygb%' OR LOWER(c.name) LIKE '%jos_easygb%' OR LOWER(c.website) LIKE '%jos_easygb%' OR LOWER(c.email) LIKE '%jos_easygb%' OR LOWER(c.ip) LIKE '%jos_easygb%' OR LOWER(c.importtable) LIKE '%jos_easygb%' )DB function failed with error number 1054
Unknown column 'c.importtable' in 'where clause' SQL=SELECT c.*, u.email AS usermail, ct.title AS ctitle FROM jos_comment AS c LEFT JOIN jos_users AS u ON u.id = c.userid LEFT JOIN jos_content AS ct ON ct.id = c.contentid WHERE c.component = '' AND ( LOWER(c.comment) LIKE '%jos_easygb%' OR LOWER(ct.title) LIKE '%jos_easygb%' OR LOWER(c.name) LIKE '%jos_easygb%' OR LOWER(c.website) LIKE '%jos_easygb%' OR LOWER(c.email) LIKE '%jos_easygb%' OR LOWER(c.ip) LIKE '%jos_easygb%' OR LOWER(c.importtable) LIKE '%jos_easygb%' ) ORDER BY c.id DESC LIMIT 0,20
[img size=639]http://compojoom.com/components/com_agora/img/members/1339/Picture_1.png[/img]
Responses (4)


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
  • New
  • 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
  • New
  • 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