[Import Features] Issues with 'modified' and 'id'

yopyop001
Topic Author
Offline
Moderator

10 years 7 months ago #46418 by yopyop001

[Import Features] Issues with 'modified' and 'id' was created by yopyop001

Hi,

I have done test with both FC r1873 and r1880 on Jommla 3.2.3 (fresh install) on PHP 5.4.6

I have problem with import features with the 'modified field' :

My CSV :

Code:

id~~created~~modified~~title~~text
~~1~~2006-09-27 21:39:22~~2013-11-20 18:02:18~~My item title~~<h2>&quot;Nous avons besoin de plus de conscience !&quot;</h2>

All fields (created, title and text) are well imported but not 'modified' field
when i click on "test file format", i get

Code:

Item no 1:
Array
(
    [created] => 2006-09-27 21:39:22
    [modified] => Array
        (
            [0] => 2013-11-20 18:02:18
        )

    [title] => My item title
    [text] => "Nous avons besoin de plus de conscience !"
)

So may be the fact that 'modified' is a core field and is converted to an array causes the issue.

Another strange thing, when i try to use 'id' column on import, the 'Prepare Import task' run well and give me all the items with good id, but when i 'Run Import task', import freezes to 0 and i get an error 500 on console :

Code:

GET http://xxx.dtd/administrator/index.php?option=com_f…rt.importcsv&items_per_call=2&itemcnt=0&33c62fe4eca5bc6aa4e38de0a713468e=1 500 (Internal Server Error)

Does anyone have the same bugs?

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

ggppdk
Offline
Administrator

10 years 7 months ago #46419 by ggppdk

Replied by ggppdk on topic [Import Features] Issues with 'modified' and 'id'

Hello

indeed the modified field should be an array,

there 2 list of CORE fields and modified is probably not in of the 2 lists, will verify this , and commit fix

thanks for report with good info

Regards

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

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

ggppdk
Offline
Administrator

10 years 7 months ago #46433 by ggppdk

Replied by ggppdk on topic [Import Features] Issues with 'modified' and 'id'

Hello

i have looked at it

1. about "modified" date, it is not a bug, it is simply not there, not supported by the process at all
-- i remember a different topic with same question (support for: modified, modified_by)
this will be i next commit

2. about internal server error please look at server log
(also latest import version has some bug-fixes/improvements)
a. some UTF-8 characters may make process to fail
b. importing large CSV files may fail due to memory exhausted, we now compress the session data ...

but about internal server error you will need to look at HTTP server log

Regards

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

yopyop001
Topic Author
Offline
Moderator

10 years 7 months ago #46461 by yopyop001

Replied by yopyop001 on topic [Import Features] Issues with 'modified' and 'id'

Hi,

Thanks for the answer.

I have try with r1883 from SVN, but after import i have still 'Never' in modified column. I have to do more tests with this.

About error 500
With the same file, the import works well without use 'id' column, but fails when i try to use 'id' column.

In logs, for each step, i have these lines :

Code:

[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP Strict standards:  Declaration of flexicontent_items::_getAssetParentId() should be compatible with JTable::_getAssetParentId(JTable $table = NULL, $id = NULL) in D:\\Program Files\\wamp3\\www\\intranet-v3\\administrator\\components\\com_flexicontent\\tables\\flexicontent_items.php on line 623, referer: http://localhost/intranet-v3/administrator/index.php
[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP Stack trace:, referer: http://localhost/intranet-v3/administrator/index.php
[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP   1. {main}() D:\\Program Files\\wamp3\\www\\intranet-v3\\administrator\\index.php:0, referer: http://localhost/intranet-v3/administrator/index.php
[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP   2. JApplicationCms->execute() D:\\Program Files\\wamp3\\www\\intranet-v3\\administrator\\index.php:42, referer: http://localhost/intranet-v3/administrator/index.php
[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP   3. JApplicationAdministrator->doExecute() D:\\Program Files\\wamp3\\www\\intranet-v3\\libraries\\cms\\application\\cms.php:255, referer: http://localhost/intranet-v3/administrator/index.php
[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP   4. JApplicationAdministrator->dispatch() D:\\Program Files\\wamp3\\www\\intranet-v3\\libraries\\cms\\application\\administrator.php:143, referer: http://localhost/intranet-v3/administrator/index.php
[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP   5. JComponentHelper::renderComponent() D:\\Program Files\\wamp3\\www\\intranet-v3\\libraries\\cms\\application\\administrator.php:98, referer: http://localhost/intranet-v3/administrator/index.php
[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP   6. JComponentHelper::executeComponent() D:\\Program Files\\wamp3\\www\\intranet-v3\\libraries\\cms\\component\\helper.php:332, referer: http://localhost/intranet-v3/administrator/index.php
[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP   7. require_once() D:\\Program Files\\wamp3\\www\\intranet-v3\\libraries\\cms\\component\\helper.php:352, referer: http://localhost/intranet-v3/administrator/index.php
[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP   8. require_once() D:\\Program Files\\wamp3\\www\\intranet-v3\\administrator\\components\\com_flexicontent\\flexicontent.php:22, referer: http://localhost/intranet-v3/administrator/index.php
[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP   9. JControllerLegacy->execute() D:\\Program Files\\wamp3\\www\\intranet-v3\\administrator\\components\\com_flexicontent\\admin.flexicontent.php:201, referer: http://localhost/intranet-v3/administrator/index.php
[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP  10. FlexicontentControllerImport->importcsv() D:\\Program Files\\wamp3\\www\\intranet-v3\\libraries\\legacy\\controller\\legacy.php:722, referer: http://localhost/intranet-v3/administrator/index.php
[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP  11. ParentClassItem->store() D:\\Program Files\\wamp3\\www\\intranet-v3\\administrator\\components\\com_flexicontent\\controllers\\import.php:604, referer: http://localhost/intranet-v3/administrator/index.php
[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP  12. ParentClassItem->getTable() D:\\Program Files\\wamp3\\www\\intranet-v3\\administrator\\components\\com_flexicontent\\models\\parentclassitem.php:1528, referer: http://localhost/intranet-v3/administrator/index.php
[Thu Apr 10 09:05:51.906528 2014] [:error] [pid 5112:tid 1592] [client 127.0.0.1:1809] PHP  13. JTable::getInstance() D:\\Program Files\\wamp3\\www\\intranet-v3\\administrator\\components\\com_flexicontent\\models\\parentclassitem.php:840, referer: http://localhost/intranet-v3/administrator/index.php

Any idea?

And thanks for all.

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

yopyop001
Topic Author
Offline
Moderator

10 years 7 months ago #46584 by yopyop001

Replied by yopyop001 on topic [Import Features] Issues with 'modified' and 'id'

Hi,

With FC 2.2.0.r1884

Here is the type of error i get on import task with 'id' column :

On first import : Some items are correctly imported but the process stop and i get this error :

Code:

Erreur: 1062 Duplicate entry '3' for key 'PRIMARY' SQL=UPDATE intrav3_assets SET id='3' WHERE id='2'

When i try to 'continue Import task' i get this error :

Code:

Erreur: 1062 Duplicate entry '3' for key 'PRIMARY' SQL=INSERT INTO `intrav3_content`
(`id`,`title`,`alias`,`introtext`,

For the second, if data are inserted in #__content before #__assets, i think it's normal to have a duplicate Primary Key.

Note that with the exactly same file if i don't use 'id' column , import is perfect.

Have a nice day!

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

mdma
Offline
Senior Member

10 years 1 month ago #50247 by mdma

Replied by mdma on topic [Import Features] Issues with 'modified' and 'id'

hello!
with id used process stops
"NetworkError: 500 Internal Server Error - http://localhost/flexitest/administrato ... 5ff5416e=1"

thumbnails created! but when opening item:

Notice

Image/Gallery field: 'flexi folder mode', some values of this field have been skipped: [ 00.jpg,01.jpg,03.jpg ], because the original file seems to have been deleted (thumbnailing of it has failed).
This message will go away once you save this content item

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