×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

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

Wordpress to Joomla , "Unknown column 'importid' " 14 years 3 months ago #8373

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

Wordpress to Joomla , "Unknown column 'importid' " 14 years 3 months ago #8376

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081

Wordpress to Joomla , "Unknown column 'importid' " 14 years 3 months ago #8383

  • Suresh
  • Suresh's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
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.

Wordpress to Joomla , "Unknown column 'importid' " 14 years 2 months ago #8476

  • Suresh
  • Suresh's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
Can anyone help me with this please?

Wordpress to Joomla , "Unknown column 'importid' " 14 years 2 months ago #8481

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
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.

Wordpress to Joomla , "Unknown column 'importid' " 14 years 2 months ago #8484

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

Wordpress to Joomla , "Unknown column 'importid' " 14 years 2 months ago #8485

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
we can do a teamviewer meeting if you want. You will share the screen and I will find out what is the problem :)
  • Page:
  • 1
Time to create page: 0.108 seconds