[Resolved] strange behavior after importing childred CTP

[Author]

Posts

[JeremyN9794]

Hi

I've created 2 CTP : Organisme and Activités.
One organism can have many Activités.
So, in my CTP, I setted that the children of the Organisme are the Activités.

I imported all my Organismes using CSV importer as you adviced it me a few month ago : and it's ok for this.
But now, I'm trying to import the Activites file in which I set a column '_wpcf_belongs_organisme_id' to do a match with the parent already present in the database.
It's a little bit strange, because, when I'm trying to edit a CTP Activites using the wordpress admin page, it's turning arround, and finally giving me a http 500 error.
But when I go to the permalink to view this activité, it's ok.
Now, it's a problem, because I can't edit the activités after importing them.

Do you have an idea about it?

Regards,

[Christian Cox]

That's unusual, I'll be happy to help get this working correctly. I would like to see more information about the 500 server errors. You can see how to enable debug logging here:
https://toolset.com/documentation/user-guides/debugging-toolset/

Go in your wp-config.php file and look for define(‘WP_DEBUG’, false);. Change it to:

define('WP_DEBUG', true);

Edit your wp-config.php file and add these lines, just before it says 'stop editing here':

ini_set('log_errors',TRUE);
ini_set('error_reporting', E_ALL);
ini_set('error_log', dirname(__FILE__) . '/error_log.txt');

Then, try to edit one of your Activités. This should create an error_log.txt file in your site's root directory. Please send me its contents. Once that is done, you can revert the updates you made to wp-config.php.

If possible, please also paste the contents of the CSV file you were using to upload the Activités.

[JeremyN9794]

Hi Christian

thanks for your answer.
Here is the content of the error_log.txt after try to edit a concerned "activite" :

[16-Feb-2017 21:46:03 UTC] PHP Fatal error:  Maximum execution time of 30 seconds exceeded in /var/www/www.inforjeunesmons.be/wp-content/plugins/types/library/toolset/toolset-common/lib/adodb-time.inc.php on line 656

And here is the content of the sample CSV file I've imported (without any errors while importing).

"csv_post_title","csv_post_post","csv_post_excerpt","wpcf-act-code-organisme","wpcf-type-d-activite","wpcf-categorie-d-activite","wpcf-acces-aux-personnes-a-mobilites-reduites","wpcf-type-de-handicap","wpcf-place","wpcf-adresse-activite","wpcf-pays","wpcf-code-postal","wpcf-ville","wpcf-telephone","wpcf-fax","wpcf-description-de-l-activite","wpcf-site-web","wpcf-contacts","wpcf-age-minimum","wpcf-age-maximum","wpcf-date-de-debut-activite","wpcf-date-de-fin-activite","wpcf-type-de-logement","csv_post_type","_wpcf_belongs_organisme_id"
"VILLE DE MONS"," bl"," ","2146145008","1","73302","0","","Auditorium Abel Dubois","Esplanade Anne-Charlotte de Lorraine","","7000","MONS","","","Atelier Théâtre Performatif et Sonore du Collectif québécois L'eau du bain.Lien pour l'inscription : <em><u>hidden link</u></em>","","","15","18","20150406000000000","20150410000000000","0","activite","2499"

Regards

[Christian Cox]

Thanks. Can you tell me what dates these fields should represent?

20150406000000000
20150410000000000

[JeremyN9794]

Hi,

these dates represent dates for the beginnig and the end of the activity I'm trying to import?
And ok, you found the problem....
I deleted the last 0 directly in the database, and, so I could open it the admin wordpress page.
But, it stores the dates in a special way.
For example, I'm trying to import the date '20150406' (6th april 2015), but it stores the date as '1487203200'.
Should I create a script to serialize the date?

Regards

Jérémy

[Christian Cox]

I don't think you need to serialize anything. You should create a Unix timestamp for each date. Please refer to this document:
https://toolset.com/documentation/user-guides/how-to-import-content-into-wordpress-using-csv/

There's a section called "Importing date fields" that mentions timestamps and links to some documentation. You can manually generate timestamps for each date using something like epochconverter.com. I'm not sure how you're generating the CSV file, but it may be possible to automate date conversion somehow during the export.

Please let me know if I can be of further assistance, and I'll be happy to take another look.

[JeremyN9794]

Hi Christian,

thank you for your help.
It's now resolved, I converted all my dates into a Epoch time and it's ok.

Thank you very much.

Regards