Import date field values directly in phpMyAdmin

vlester
Topic Author
Offline
Premium Member

13 years 1 month ago #14634 by vlester

Import date field values directly in phpMyAdmin was created by vlester

Hello,

I would like to import new field values directly in PhpMyAdmin but it doesn't work. For example, I insert a date field value for one of my items with that :

Code:

INSERT INTO `jos_flexicontent_fields_item_relations` (`field_id`, `item_id`, `valueorder`, `value`) VALUES ('97', '65', '5', '2011-02-20 16:00');

The import is done successfully but when I edit the item in the FlexiContent backend, the new field value doesn't appear and when I go back to PhpMyAdmin, the new line I have just inserted has been deleted.

I suppose there is something more that the backend plugin does to save a field value but I don't know what. If someone could help me on this, that would be nice.
thanks

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

vlester
Topic Author
Offline
Premium Member

13 years 3 weeks ago #14883 by vlester

Replied by vlester on topic Import date field values directly in phpMyAdmin

The solution was to disable the versioning in the FlexiContent configuration

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

micker
Away
Administrator

13 years 3 weeks ago #14893 by micker

Replied by micker on topic Import date field values directly in phpMyAdmin

thanks for this issue

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

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