TOPIC: Wordpress to Joomla , "Unknown column 'importid' "

Hi there,

Scenario:
I'm trying to import my Wordpress comments to Joomla using JoomlaComment Importcomment.

I've followed all the steps in this thread,
compojoom.com/forum/10-newbies-area/7322...o-joomlacomment#7369

But I'm getting this error,

Error: DB function failed with error number 1054
Unknown column 'importid' in 'field list' SQL=INSERT INTO jos_comment (importid,contentid,ip,userid,date,name,email,website,title,comment,published,importparentid,component,importtable)
SELECT comment_ID,comment_post_ID,comment_author_IP,user_id,comment_date,comment_author,comment_author_email,comment_author_url,comment_content,comment_content,comment_approved,comment_parent,'',
'jos_wp_comments' FROM jos_wp_comments AS f ORDER BY f.comment_ID

Now I've tried a variety of different ways to choose the items from the dropdown list, but I keep getting this importid error.
This is a very clean joomla and wordpress install, and i'm puzzled.

Can someone please help
Thanks

look at this thread:
compojoom.com/forum/6-bug-report/1478-id...mport-from-wordpress

Hi Daniel,

When I use the code you supplied in the other thread

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

I modified it slightly
jos_wp_comments instead and i took out the comment_subscribe field

it gives me this error

#1136 - Column count doesn't match value count at row 1

help, please.

Can anyone help me with this please?

Hey Suresh,
As I told you I tried it with joomlacomment 4.1 and I was very happy to find that it worked.

Today I tried it joomlacomment 4.0beta2 and it worked also. I just selected the right table, matched the fields and clicked on import. No error message or whatsoever.

The only thing I could suggest is to give me admin and phpmyadmin access to test it myself.

Daniel,

Can you share what comment you used to successfully make it work on the older Joomla Comment?
Or, can you tell me just overall which fields you chose for the import function on the new one?
I can't share the phpadmin because, due to my ISP's setup, it would mean opening up access to all of the sites, which is kinda lame.

Please let me know either way, as I'm two weeks behind on this and need to move to another product if this is not going to work.

Thanks

we can do a teamviewer meeting if you want. You will share the screen and I will find out what is the problem