×

Notice

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

TOPIC: Import from yvcomment

Import from yvcomment 15 years 2 months ago #2470

  • dumil
  • dumil's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
Hello everybody,
I'm trying to import comments from yvcomment, but I receive this message in the preview section: "Id column is obligatory ! Please, select the column."

I've selected the right id column (I think it is "ID")

What do you recommend?

Thx

Import from yvcomment 15 years 2 months ago #2471

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Look the database table of yvcomment and check if it is really id.

Import from yvcomment 15 years 2 months ago #2481

  • dumil
  • dumil's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
Yvcomment use the articles table (jos_content) with a dedicated section and category
This is the structure:
id title alias title_alias introtext fulltext state sectionid mask catid created created_by created_by_alias modified modified_by checked_out checked_out_time publish_up publish_down images urls attribs version parentid ordering metakey metadesc access hits metadata

so, id is id

in your import wizard you have a combo call "Commented component value (obligatory)" with some value that I don't understand, I chose com_content (but tried different values too)

when I click preview I obtain this message "Id column is obligatory ! Please, select the column."

Import from yvcomment 15 years 2 months ago #2522

  • dumil
  • dumil's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
hello, I try to import without preview and the problem seems to be that the field containing the text is call "fulltext" and the generated query doesn't work, 'cause it is a reserved sql word.
My solution:
I tried to run the query in phpmyadmin but fulltext field was still a problem (even included in [ ])
so I renamed the field in fulltext1, run the query and re-renamed the field to fulltext.

Hope it will help someone

Bye

G

Import from yvcomment 15 years 2 months ago #2541

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Thanks for sharing dumil.
  • Page:
  • 1
Time to create page: 0.118 seconds