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
Powered by EasyDiscuss for Joomla!