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

More
10 years 6 months ago #46418 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.

More
10 years 6 months ago #46419 by ggppdk
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.

More
10 years 6 months ago #46433 by ggppdk
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


-- 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.

More
10 years 6 months ago #46461 by yopyop001
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.

More
10 years 6 months ago #46584 by yopyop001
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.

More
10 years 2 weeks ago #50247 by mdma
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.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.313 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline