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

Complete Uninstall to Work in J4??
We have recently updated a site from Joomlav3 to v4 (4.4.2). Now when we go to m...
3 Replies
Posted on Tuesday, 30 April 2024
  • New
  • verschiedene URL's für Kursübersicht einer Kategor
    Hallo, ich habe eine Frage in Bezug auf SEO: ein externer Spezialist macht die...
    1 Replies
    Posted on Monday, 29 April 2024
  • New
  • Google no index für bestimmte Seiten/Details
    Hallo ich habe eine kleine Frage: wo kann ich einstellen, dass Google die Seite...
    1 Replies
    Posted on Wednesday, 24 April 2024
  • New
  • Changes to Submission Form?
    Are you able to make changes to the Hotspot submission form? There are several f...
    0 Replies
    Posted on Friday, 26 April 2024
  • New
  • Question regarding custom fields
    How do I access custom fields after I have created them?...
    0 Replies
    Posted on Wednesday, 24 April 2024
  • New
    • #custom fields