Error import
Avatar image
Sep 26, 2019
Frederic Schmidt wrote
Hello,
When i want to import a excel file catalog i have the error :
#HY000Field 'description' doesn't have a default value

i use last wordpress version, woocommerce latest version on apache server on local mode.

do you have a idea

thanxs a lot
Reply
4 Answers
Avatar image
Sep 27, 2019
Andrii Yanosh agent wrote

Hello Frederic,


Thank you for contacting us.


Please provide us with a screenshots of the error so we could see it clearly.


Also please specify:


- what version of Store Manager for WooCommerce do you use and the connector version


1) Store Configuration file (can be saved in Preferences(F12) > Save current configuration https://www.screencast.com/t/eKt3AlWk0l5M )


2) FTP access details (username, password, host address) and store URL


3) Logs (You can find Log on your pc here: C:\Users\%USERNAME%\AppData\Local\eMagicOne Store Manager for OpenCart\Logs - type this path manually in path field)


4) Import file


5) Import Configuration file (can be saved on the last step of the import: in cfg format https://www.screencast.com/t/Gb5Sm0D7Kr8g )


And we will check it with our tech manager in a more urgent and technical manner.


Wishing you a great day!

Avatar image
Sep 30, 2019
Frederic Schmidt wrote
Hello,

thanxs for answer the version of WooCommerce SM is 1.21.0 build 1073

this is the log file
30.09.2019 11:53:04:181 - *************************************************
30.09.2019 11:53:04:190 - STARTING [C:\Program Files (x86)\eMagicOne\Store Manager for WooCommerce\WooCommerce_Manager.exe]
30.09.2019 11:53:04:199 - OS: Windows 10 (Version 10.0, Build 18362, 64-bit Edition)
30.09.2019 11:53:04:457 - CPU frequency: 3392 Mhz
30.09.2019 11:53:04:461 - System memory: 33419 Mb, Available: 5812 Mb
30.09.2019 11:53:04:465 - Windows started on vendredi, septembre 27, 2019, at 12:48:48 PM It is been up for 2 days, 23 hours, 4 minutes, 15 seconds
30.09.2019 11:53:04:470 - User: frede
30.09.2019 11:53:04:472 - Is administrator: Yes
30.09.2019 11:53:04:475 - Module ver.: [1.21.0 (Build: 1073)]
30.09.2019 11:53:04:782 - Module info: [67a987811c2007a1b134921348ee8b5f]
30.09.2019 11:53:04:785 - WooCommerce_Manager.exe initializing...

30.09.2019 11:53:04:789 - [TSMPluginManager.LoadPlugins()]: Start addons library loading
30.09.2019 11:53:04:794 - [TSMPluginManager.LoadPlugins()]: Trying to load addon file "C:\Program Files (x86)\eMagicOne\Store Manager for WooCommerce\Plugins\AmazonIntegration.dll".
30.09.2019 11:53:04:796 - [TSMPluginLibrary.ReadInfoFromXml()]: Addon "AmazonIntegration.dll": loading addon info
30.09.2019 11:53:04:800 - [TSMPluginLibrary.ReadInfoFromXml()]: Addon info loaded
30.09.2019 11:53:04:801 - [TSMPluginManager.LoadPlugins()]: Trying to load addon file "C:\Program Files (x86)\eMagicOne\Store Manager for WooCommerce\Plugins\eBayIntegration.dll".
30.09.2019 11:53:04:804 - [TSMPluginLibrary.ReadInfoFromXml()]: Addon "eBayIntegration.dll": loading addon info
30.09.2019 11:53:04:807 - [TSMPluginLibrary.ReadInfoFromXml()]: Addon info loaded
30.09.2019 11:53:04:809 - [TSMPluginManager.LoadPlugins()]: Trying to load addon file "C:\Program Files (x86)\eMagicOne\Store Manager for WooCommerce\Plugins\PDF_Catalog_Creator.dll".
30.09.2019 11:53:04:811 - [TSMPluginLibrary.ReadInfoFromXml()]: Addon "PDF_Catalog_Creator.dll": loading addon info
30.09.2019 11:53:04:815 - [TSMPluginLibrary.ReadInfoFromXml()]: Addon info loaded
30.09.2019 11:53:04:817 - [TSMPluginManager.LoadPlugins()]: Trying to load addon file "C:\Program Files (x86)\eMagicOne\Store Manager for WooCommerce\Plugins\qbimportexport.dll".
30.09.2019 11:53:04:819 - [TSMPluginLibrary.ReadInfoFromXml()]: Addon "qbimportexport.dll": loading addon info
30.09.2019 11:53:04:824 - [TSMPluginLibrary.ReadInfoFromXml()]: Addon info loaded
30.09.2019 11:53:04:835 - [TSMPluginManager.LoadPlugins()]: Addons loading complete
30.09.2019 11:53:06:576 - [Store Compatibility Check]: Required table not found: wplab01_icl_content_status
30.09.2019 11:53:06:579 - [Store Compatibility Check]: Required table not found: wplab01_icl_core_status
30.09.2019 11:53:06:581 - [Store Compatibility Check]: Required table not found: wplab01_icl_flags
30.09.2019 11:53:06:584 - [Store Compatibility Check]: Required table not found: wplab01_icl_languages
30.09.2019 11:53:06:586 - [Store Compatibility Check]: Required table not found: wplab01_icl_languages_translations
30.09.2019 11:53:06:589 - [Store Compatibility Check]: Required table not found: wplab01_icl_locale_map
30.09.2019 11:53:06:591 - [Store Compatibility Check]: Required table not found: wplab01_icl_message_status
30.09.2019 11:53:06:593 - [Store Compatibility Check]: Required table not found: wplab01_icl_node
30.09.2019 11:53:06:595 - [Store Compatibility Check]: Required table not found: wplab01_icl_reminders
30.09.2019 11:53:06:597 - [Store Compatibility Check]: Required table not found: wplab01_icl_string_positions
30.09.2019 11:53:06:599 - [Store Compatibility Check]: Required table not found: wplab01_icl_string_status
30.09.2019 11:53:06:602 - [Store Compatibility Check]: Required table not found: wplab01_icl_string_translations
30.09.2019 11:53:06:604 - [Store Compatibility Check]: Required table not found: wplab01_icl_strings
30.09.2019 11:53:06:607 - [Store Compatibility Check]: Required table not found: wplab01_icl_translate
30.09.2019 11:53:06:612 - [Store Compatibility Check]: Required table not found: wplab01_icl_translate_job
30.09.2019 11:53:06:617 - [Store Compatibility Check]: Required table not found: wplab01_icl_translation_status
30.09.2019 11:53:06:622 - [Store Compatibility Check]: Required table not found: wplab01_icl_translations
30.09.2019 11:53:06:626 - [Store Compatibility Check]: Required table not found: wplab01_sm_advanced_search_temp
30.09.2019 11:53:06:631 - [Store Compatibility Check]: Required table not found: wplab01_blogs
30.09.2019 11:53:06:637 - [Store Compatibility Check]: Required table not found: wplab01_blog_versions
30.09.2019 11:53:06:642 - [Store Compatibility Check]: Required table not found: wplab01_site
30.09.2019 11:53:06:648 - [Store Compatibility Check]: Required table not found: wplab01_sitemeta
30.09.2019 11:53:08:860 - [%AL%]: User "admin" closing "Produits" MDI Child form
30.09.2019 11:53:12:957 - [%AL%]: User "admin" is trying to create "Produits" MDI Child form
30.09.2019 11:53:13:297 - [%AL%]: User "admin" showing "Produits" MDI Child form
30.09.2019 11:53:23:378 - [%AL%]: User "admin" try to create "Formulaire d'état de la licence d'essai" dialog form
30.09.2019 11:53:23:430 - [%AL%]: User "admin" showing "Formulaire d'état de la licence d'essai" dialog form
30.09.2019 11:53:30:776 - [%AL%]: User "admin" destroying "Formulaire d'état de la licence d'essai" dialog form
30.09.2019 11:54:06:363 - [%AL%]: User "admin" try to create "Export de produits" dialog form
30.09.2019 11:54:06:744 - [%AL%]: User "admin" showing "Export de produits" dialog form
30.09.2019 11:54:24:291 - Initializig export of entity "PostProduct"
30.09.2019 11:54:24:311 - Starting export of entity "PostProduct"
30.09.2019 11:54:24:468 - Finalizig export of entity "PostProduct"
30.09.2019 11:54:24:471 - Export of entity "PostProduct" is finished
30.09.2019 11:54:27:791 - [%AL%]: User "admin" closing "Export de produits" dialog form
30.09.2019 11:54:27:864 - [%AL%]: User "admin" destroying "Export de produits" dialog form
30.09.2019 11:54:37:438 - [%AL%]: User "admin" try to create "Import de produits" dialog form
30.09.2019 11:54:38:045 - [%AL%]: User "admin" showing "Import de produits" dialog form
30.09.2019 11:54:54:203 - Initializing Import of entity "Products"
30.09.2019 11:54:55:586 - [TSMThreadQuery.Execute]: Exception EMyError message:
#HY000Field 'description' doesn't have a default value
30.09.2019 11:54:55:590 - [TSMThreadQuery.Execute]: Call stack:
30.09.2019 11:54:55:635 - Finalizig Import of entity "Products"
30.09.2019 11:54:55:639 - Finalizig Import of entity "Products"
30.09.2019 11:54:55:645 - Import of entity "Products" was successfully performed
30.09.2019 11:54:55:651 - 0 data base records were inserted
30.09.2019 11:54:55:657 - 0 data base records were updated
30.09.2019 11:54:55:661 - 0 data base records were skipped
30.09.2019 11:54:55:667 - 0 source rows were skipped

my installation isn't visible from outside but, the server is apache on ubuntu last version with last update the woocommerce version is 3.7.0, the wordpress press is the lastest up to date too.

i try a simple export and import with no update data in the csv file and i have the same error.

thanxs for your help

Avatar image
Oct 01, 2019
Andrii Yanosh agent wrote

Hello Frederic,


Thank you for your reply.


Please sendus the logs in the file format.


And we need also your other technical details ( as we mentioned previously), such as.



1) Store Configuration file (can be saved in Preferences(F12) > Save current configuration https://www.screencast.com/t/eKt3AlWk0l5M )



2) FTP access details (username, password, host address) and store URL



3) Logs (You can find Log on your pc here: C:\Users\%USERNAME%\AppData\Local\eMagicOne Store Manager for OpenCart\Logs - type this path manually in path field)



4) Import file



5) Import Configuration file (can be saved on the last step of the import: in cfg format https://www.screencast.com/t/Gb5Sm0D7Kr8g )


Wishing you a great day!

Oct 06, 2019
System wrote
Hello,

We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com

Maybe we are waiting for some information from your side? In this case please get back to us.

In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.

If you do not reply us back, the ticket will be automatically closed within 24 hours.

With kind regards,

The eMagicOne Administration Team