×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Archive
!joomlacomment
Bug Report
ID-column unknown at import (from wordpress)
  • Page:
  • 1

TOPIC: ID-column unknown at import (from wordpress)

ID-column unknown at import (from wordpress) 15 years 5 months ago #1478

  • Simon de Vries
  • Simon de Vries's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
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

ID-column unknown at import (from wordpress) 15 years 5 months ago #1479

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
try this one:
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 f.id

ID-column unknown at import (from wordpress) 15 years 5 months ago #1483

  • Simon de Vries
  • Simon de Vries's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
Thx for your quick reply, Daniel. Now I get:

SQL-Befehl:

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 f.id

MySQL meldet:
#1054 - Unknown column 'f.id' in 'order clause'

ID-column unknown at import (from wordpress) 15 years 5 months ago #1485

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
and what about:
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 jos_comments.id

and if this is not working:
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 importid

ID-column unknown at import (from wordpress) 15 years 5 months ago #1486

  • Simon de Vries
  • Simon de Vries's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
I get

#1109 - Unknown table 'jos_comments' in order clause

and

#1054 - Unknown column 'importid' in 'order clause'

I found this in google: http://www.phpfreaks.com/forums/index.php?topic=2507.0 But since I have no clue about sql I don't understand if it is related to my problem.

ID-column unknown at import (from wordpress) 15 years 5 months ago #1487

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
can you send me your database with the comments, so I can try to import it locally on my pc and tell you where the problem is?

ID-column unknown at import (from wordpress) 15 years 5 months ago #1492

  • Simon de Vries
  • Simon de Vries's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
Thx for looking into it - I sent you a private message where to download it.

ID-column unknown at import (from wordpress) 15 years 5 months ago #1493

  • Simon de Vries
  • Simon de Vries's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
Thx for looking into it - I sent you a private message where to download it.

ID-column unknown at import (from wordpress) 15 years 5 months ago #1496

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
ok, as usual very easy, but I'm blind :)
and what about:
Code:
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 comment_ID

ID-column unknown at import (from wordpress) 15 years 5 months ago #1497

  • Simon de Vries
  • Simon de Vries's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
Perfect. Thx, Daniel. I got all my comments imported - really all of them ... including 500 spam :-) Maybe I should have sorted them out beforehand :-)

Now I have another problem: The page navigation doesn't seem to work in the admin panel "manage comments" and also I cannot show all comments (about 2200) - that means I can only publish the last 100 comments ...

ID-column unknown at import (from wordpress) 15 years 5 months ago #1508

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Look here:
compojoom.com/index.php/forum.html?func=view&id=1499&catid=6
  • Page:
  • 1
Forum
Archive
!joomlacomment
Bug Report
ID-column unknown at import (from wordpress)
Time to create page: 0.116 seconds