1. Simon de Vries
  2. Bug Report
  3. Tuesday, 04 November 2008
  4.  Subscribe via email
Hello - first of all: thx for this great plugin.

I am trying to import a table from my wordpress-blog (it's already part of the Joomla-database and I can choose almost all the information in the import admin menu of JoomlaComments and I identified all the required fields). The name of the comment ID column is comment_ID, the name of the Content Item ID is comment_post_ID.

But the error I get is this:

Error: DB function failed with error number 1054
Unknown column 'id' in 'order clause' SQL=INSERT INTO jos_comment (importid,contentid,ip,date,name,email,website,notify,comment,component,importtable) SELECT comment_ID,comment_post_ID,comment_author_IP,comment_date,comment_author,comment_author_email,comment_author_url,comment_subscribe,comment_content,'','jos_comments' FROM jos_comments AS f ORDER BY id

Any idea what I did wrong? Thx, Simon

[img size=499]http://compojoom.com/components/com_agora/img/members/915/Bild_1.jpg[/img]
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

Anzeige von mehrtägigen Events auf Buchungsseite
We have been using Matukio for quite some time now. Unfortunately, we have been ...
5 Replies
Posted on Sunday, 03 August 2025
  • Resolved
  • Is Ccomment still alive?
    Is Ccomment still being supported? It's time for my Pro renewal but I haven't se...
    2 Replies
    Posted on Thursday, 14 August 2025
  • Resolved
  • Assistance Needed – Error When Posting Comments
    Hello, I’m experiencing an issue when trying to submit a comment on my site u...
    0 Replies
    Posted on Sunday, 10 August 2025
    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