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

Changes to the Submission form
Can you make changes to the Submission form? There are a few fields I'd like to ...
0 Replies
Posted on Thursday, 18 April 2024
  • New
  • Questions on new installation...
    Working on getting this set up... https://eastend2024.joepolecheck.com/rumma...
    2 Replies
    Posted on Wednesday, 17 April 2024
  • New
  • Error received? Class "XMLReader" not fo
    Just installed the Pro version of Hotspots, but am getting an error when I try t...
    1 Replies
    Posted on Wednesday, 17 April 2024
  • Resolved
  • New
  • Links aus Veranstaltungsübersicht funktionieren ni
    Nach der Migration von Joomla 3.10 auf Joomla 5.0.3 treten folgende Probleme auf...
    2 Replies
    Posted on Monday, 08 April 2024
    Custom Hotspot Marker fails to load
    I just updated from Joomla 3 to Joomla 4.3.4 and Hotspots 6.0.12. I decided to e...
    0 Replies
    Posted on Tuesday, 09 April 2024