COMMUNITY FORUM

insert into _k2_items

Start
Prev
1
Next
End

Cristian Negruzzi
Topic Author
Offline
New Member

12 years 4 months ago #65977 by Cristian Negruzzi

insert into _k2_items was created by Cristian Negruzzi

I've made a third party application to add automatically items to my k2 product catalog, items are inserted into database but not visible in frontend.
First i've tested this in phpMyAdmin - same problem, the script is working fine but items stil not displayed.

INSERT INTO `jos_k2_items` (
      `title`, `alias`, `catid`, `published`, `introtext`, `fulltext`, `image_caption`, `image_credits`,
      `video`, `video_caption`, `video_credits`, `gallery`, `extra_fields`, `extra_fields_search`,
     `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `publish_up`,
      `publish_down`, `checked_out`, `checked_out_time`, `trash`, `access`, `ordering`,
      `featured`, `featured_ordering`, `hits`, `metadata`, `metadesc`, `metakey`, `params`,
      `plugins`, `language`
     ) values (
     'Product Item Title', 'product-item-title-alias', 15, 1, '', '', '', '', NULL, '','',NULL, '[{"id":"2","value":"23"},{"id":"5","value":"0"},{"id":"4","value":"0"},{"id":"6","value":"1"},{"id":"7","value":"5404"}]', '', "2012-05-12 19:00:00", 62, "", "0000-00-00 00:00:00", 62, "2012-05-12 19:00:00", "0000-00-00 00:00:00", 0,  "0000-00-00 00:00:00", 0, 0, 0, 0, 0, 1, '', '', '', '', '', ''
     )

What i am doing wrong? How to add items correctly?

Please Log in or Create an account to join the conversation.

william white
Offline
Platinum Member

12 years 4 months ago #65978 by william white

Replied by william white on topic Re: insert into _k2_items

but not visible in frontend.
can you see them in the k2 backend?

Please Log in or Create an account to join the conversation.

Cristian Negruzzi
Topic Author
Offline
New Member

12 years 4 months ago #65979 by Cristian Negruzzi

Replied by Cristian Negruzzi on topic Re: insert into _k2_items

yes, I see them there, I can make changes afte that from backend, but still not showing in frontend

Please Log in or Create an account to join the conversation.

Cristian Negruzzi
Topic Author
Offline
New Member

12 years 4 months ago #65980 by Cristian Negruzzi

Replied by Cristian Negruzzi on topic Re: insert into _k2_items

anyone? any sugestions are accepted

Please Log in or Create an account to join the conversation.

promobit
Offline
New Member

12 years 3 months ago #65981 by promobit

Replied by promobit on topic Re: insert into _k2_items

I think you should see dates
there a value "0000-00-00 00:00:00" that could cause the problem.
( I had the same problem with a my import script, and it was the date) .

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End