1. cncdubai
  2. RO CSVI
  3. Saturday, 31 August 2019
  4.  Subscribe via email
When i import a File into the CSVI ; i get an error.
it is a big file .100s of products. upto many rows ( some 2000 products) it gets imported and i see the products in Virtuemart okay.
even after cutting down the files the remaining Rows refuse to get imported.

An error has occured during the import. Below the information received from the server.
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='

Can you please guide me how to go about correcting the File ( how to identify and remove the un wanted chracters by the way i already removed ä,ö,ü characters manually but still the errors) or alternatively If there is any Setting that enables the database so it accepts the file in its present form.
let me admit I am a novice in web and have no experience in database etc.
Accepted Answer Pending Moderation
Hello,

Not sure if you used the search but this question has been asked many times ;) We even wrote a dedicated article for this, Deal with different collations in MySQL.

The problem is not your import file but your database. Check the article and see if that helps, we explained step by step how to fix the problem.
Kind regards,

RolandD

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
so should we make all the Tables : utf8_general_ci,IMPLICIT or utf8mb4_general_ci ?
i see some tables are utf8_general_ci and some are utf8mb4_general_ci . Should we change the database to either utf8_general_ci,IMPLICIT or utf8mb4_general_ci
can you write an sql querry please "
the databse name is : Database: instocks_ser
Thanks
  1. 2 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

Easiest way to fix this is to download and install Admin Tools by Akeeba as they have a built-in option to fix the collation. See their documentation on the Database Tools for more info.

You don't need to mess with the database queries yourself.
Kind regards,

RolandD

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
We used Admin tools and now all the tables read: utf8mb4_gen
eral_Ci
but still when i imported the attached file.. the error is :
All tables read: utf8mb4_general_ci except one table jos_tabulizer_user_permissions 0 InnoDB utf8_general_ci 16 KiB

Also when we save the CSV as UTF8 then we get the attached error .
Kindly guide us how to go about it. Thanks.

The tables in database are as follows;
jos_tabulizer_user_permissions 0 InnoDB utf8_general_ci 16 KiB
jos_virtuemart_products 71,810 MyISAM utf8mb4_general_ci 22.8 MiB
jos_virtuemart_shipmentmethods 2 MyISAM utf8mb4_general_ci 4.8 KiB
jos_virtuemart_vendor_medias 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_worldzones 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_products_en_gb 71,810 MyISAM utf8mb4_general_ci 98 MiB
jos_virtuemart_shipmentmethods_en_gb 2 MyISAM utf8mb4_general_ci 8.1 KiB
jos_virtuemart_vendor_users 0 MyISAM utf8mb4_general_ci 1 KiB
jos_wblib_keystore 0 InnoDB utf8mb4_general_ci 32 KiB
jos_virtuemart_product_customfields 2 MyISAM utf8mb4_general_ci 6.1 KiB
jos_virtuemart_rating_reviews 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_shoppergroups 4 MyISAM utf8mb4_general_ci 12.3 KiB
jos_virtuemart_vendors 1 MyISAM utf8mb4_general_ci 7.2 KiB
jos_wblib_messages 11 InnoDB utf8mb4_general_ci 64 KiB
jos_virtuemart_product_manufacturers 73,257 MyISAM utf8mb4_general_ci 2.9 MiB
jos_virtuemart_rating_votes 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_states 801 MyISAM utf8mb4_general_ci 128 KiB
jos_virtuemart_vendors_en_gb 1 MyISAM utf8mb4_general_ci 34 KiB
jos_wf_profiles 4 InnoDB utf8mb4_general_ci 16 KiB
jos_virtuemart_product_medias 79,064 MyISAM utf8mb4_general_ci 5 MiB
jos_virtuemart_ratings 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_userfield_values 19 MyISAM utf8mb4_general_ci 4.2 KiB
jos_virtuemart_vmuser_shoppergroups 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_product_prices 73,287 MyISAM utf8mb4_general_ci 12 MiB
jos_virtuemart_shipment_plg_weight_countries 6 MyISAM utf8mb4_general_ci 2.7 KiB
jos_virtuemart_userfields 28 MyISAM utf8mb4_general_ci 18.9 KiB
jos_virtuemart_vmusers 2 InnoDB utf8mb4_general_ci 64 KiB
jos_virtuemart_product_shoppergroups 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_shipmentmethod_shoppergroups 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_userinfos 3 InnoDB utf8mb4_general_ci 80 KiB
jos_virtuemart_waitingusers 0 InnoDB utf8mb4_general_ci 48 KiB
jos_update_sites 72 InnoDB utf8mb4_general_ci 16 KiB
jos_usergroups 9 InnoDB utf8mb4_general_ci 80 KiB
jos_virtuemart_calc_manufacturers 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_category_categories 621 MyISAM utf8mb4_general_ci 47.3 KiB
jos_virtuemart_invoices 2 InnoDB utf8mb4_general_ci 64 KiB
jos_jaem_services 2 MyISAM utf8mb4_general_ci 2.1 KiB
jos_virtuemart_migration_oldtonew_ids 0 MyISAM utf8mb4_general_ci 1 KiB
jos_jmap 7 InnoDB utf8mb4_general_ci 32 KiB
jos_virtuemart_orders 6 InnoDB utf8mb4_general_ci 112 KiB
jos_jmap_menu_priorities 0 InnoDB utf8mb4_general_ci 16 KiB
jos_virtuemart_product_categories 144,600 MyISAM utf8mb4_general_ci 7.6 MiB
jos_jvshrinktheweb_localthumbs 0 MyISAM utf8mb4_general_ci 1 KiB
jos_modules 93 InnoDB utf8mb4_general_ci 304 KiB
jos_redirect_links 0 InnoDB utf8mb4_general_ci 48 KiB
jos_sh404sef_keystore 1 InnoDB utf8mb4_general_ci 32 KiB
jos_update_sites_extensions 81 InnoDB utf8mb4_general_ci 16 KiB
jos_users 56 InnoDB utf8mb4_general_ci 80 KiB
jos_virtuemart_calc_shoppergroups 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_category_medias 422 MyISAM utf8mb4_general_ci 28 KiB
jos_finder_terms 12,867 InnoDB utf8mb4_general_ci 2.8 MiB
jos_virtuemart_manufacturer_medias 231 MyISAM utf8mb4_general_ci 17.8 KiB
jos_jhackguard_input_filters 13 MyISAM utf8mb4_general_ci 15.7 KiB
jos_virtuemart_modules 12 MyISAM utf8mb4_general_ci 12.5 KiB
jos_jmap_canonicals 0 InnoDB utf8mb4_general_ci 16 KiB
jos_virtuemart_orderstates 8 MyISAM utf8mb4_general_ci 5.6 KiB
jos_jmap_metainfo 10 InnoDB utf8mb4_general_ci 64 KiB
jos_jvshrinktheweb_previews 186 MyISAM utf8mb4_general_ci 61.6 KiB
jos_modules_menu 836 InnoDB utf8mb4_general_ci 48 KiB
jos_schemas 2 InnoDB utf8mb4_general_ci 16 KiB
jos_sh404sef_metas 0 InnoDB utf8mb4_general_ci 32 KiB
jos_tags 13 InnoDB utf8mb4_general_ci 128 KiB
jos_updates 1,781 InnoDB utf8mb4_general_ci 400 KiB
jos_utf8_conversion 1 InnoDB utf8mb4_general_ci 16 KiB
jos_virtuemart_calc_states 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_configs 1 MyISAM utf8mb4_general_ci 8.3 KiB
jos_finder_terms_common 115 InnoDB utf8mb4_general_ci 48 KiB
jos_virtuemart_manufacturercategories 36 MyISAM utf8mb4_general_ci 4.2 KiB
jos_jhackguard_ip_filters 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_order_calc_rules 6 MyISAM utf8mb4_general_ci 5.5 KiB
jos_jmap_cats_priorities 0 InnoDB utf8mb4_general_ci 16 KiB
jos_virtuemart_payment_plg_paypal 8 MyISAM utf8mb4_general_ci 5.7 KiB
jos_jmap_pingomatic 0 InnoDB utf8mb4_general_ci 16 KiB
jos_languages 1 InnoDB utf8mb4_general_ci 80 KiB
jos_newsfeeds 0 InnoDB utf8mb4_general_ci 128 KiB
jos_session 3 InnoDB utf8mb4_general_ci 64 KiB
jos_sh404sef_pageids 0 InnoDB utf8mb4_general_ci 64 KiB
jos_template_styles 7 InnoDB utf8mb4_general_ci 64 KiB
jos_user_keys 0 InnoDB utf8mb4_general_ci 48 KiB
jos_viewlevels 5 InnoDB utf8mb4_general_ci 32 KiB
jos_virtuemart_calcs 5 MyISAM utf8mb4_general_ci 8.6 KiB
jos_virtuemart_countries 245 MyISAM utf8mb4_general_ci 41.4 KiB
jos_finder_tokens 0 MEMORY utf8mb4_general_ci 0 B
jos_virtuemart_manufacturercategories_en_gb 20 MyISAM utf8mb4_general_ci 10 KiB
jos_jhackguard_logs 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_order_histories 8 InnoDB utf8mb4_general_ci 32 KiB
jos_jmap_datasets 0 InnoDB utf8mb4_general_ci 32 KiB
jos_virtuemart_payment_plg_standard 0 MyISAM utf8mb4_general_ci 1 KiB
jos_jo_options 4 InnoDB utf8mb4_general_ci 32 KiB
jos_menu 458 InnoDB utf8mb4_general_ci 624 KiB
jos_overrider 0 InnoDB utf8mb4_general_ci 16 KiB
jos_sh404sef_aliases 77 InnoDB utf8mb4_general_ci 144 KiB
jos_sh404sef_urls 37,752 InnoDB utf8mb4_general_ci 27.7 MiB
jos_ucm_base 12 InnoDB utf8mb4_general_ci 64 KiB
jos_user_notes 0 InnoDB utf8mb4_general_ci 48 KiB
jos_virtuemart_adminmenuentries 29 MyISAM utf8mb4_general_ci 59.6 KiB
jos_virtuemart_carts 1 InnoDB utf8mb4_general_ci 48 KiB
jos_virtuemart_coupons 1 MyISAM utf8mb4_general_ci 6.1 KiB
jos_finder_tokens_aggregate 0 MEMORY utf8mb4_general_ci 0 B
jos_virtuemart_manufacturers 3,212 MyISAM utf8mb4_general_ci 208.2 KiB
jos_jhackguard_output_filters 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_order_item_histories 0 InnoDB utf8mb4_general_ci 32 KiB
jos_jmap_dss_relations 0 InnoDB utf8mb4_general_ci 16 KiB
jos_virtuemart_paymentmethod_shoppergroups 0 MyISAM utf8mb4_general_ci 1 KiB
jos_jo_postmeta 142 InnoDB utf8mb4_general_ci 384 KiB
jos_menu_types 4 InnoDB utf8mb4_general_ci 32 KiB
jos_postinstall_messages 11 InnoDB utf8mb4_general_ci 16 KiB
jos_sh404sef_hits_404s 0 InnoDB utf8mb4_general_ci 96 KiB
jos_sh404sef_urls_src 0 InnoDB utf8mb4_general_ci 80 KiB
jos_ucm_content 12 InnoDB utf8mb4_general_ci 272 KiB
jos_user_profiles 0 InnoDB utf8mb4_general_ci 16 KiB
jos_virtuemart_calc_categories 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_categories 621 MyISAM utf8mb4_general_ci 232 KiB
jos_virtuemart_currencies 163 MyISAM utf8mb4_general_ci 48.5 KiB
jos_finder_types 5 InnoDB utf8mb4_general_ci 32 KiB
jos_virtuemart_manufacturers_en_gb 3,201 MyISAM utf8mb4_general_ci 738.6 KiB
jos_jhackguard_scan_files 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_order_items 6 InnoDB utf8mb4_general_ci 80 KiB
jos_jmap_google 1 InnoDB utf8mb4_general_ci 16 KiB
jos_virtuemart_paymentmethods 2 MyISAM utf8mb4_general_ci 7.1 KiB
jos_jo_posts 11 InnoDB utf8mb4_general_ci 80 KiB
jos_messages 0 InnoDB utf8mb4_general_ci 32 KiB
jos_privacy_consents 0 InnoDB utf8mb4_general_ci 32 KiB
jos_sh404sef_hits_aliases 0 InnoDB utf8mb4_general_ci 96 KiB
jos_shlib_consumers 2 InnoDB utf8mb4_general_ci 32 KiB
jos_ucm_history 678 InnoDB utf8mb4_general_ci 9.5 MiB
jos_user_usergroup_map 56 InnoDB utf8mb4_general_ci 16 KiB
jos_virtuemart_calc_countries 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_categories_en_gb 621 MyISAM utf8mb4_general_ci 352.5 KiB
jos_virtuemart_customs 17 MyISAM utf8mb4_general_ci 14.3 KiB
jos_jaem_log 28 MyISAM utf8mb4_general_ci 13.5 KiB
jos_virtuemart_medias 6,396 MyISAM utf8mb4_general_ci 2 MiB
jos_jhackguard_scan_hits 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_order_userinfos 9 InnoDB utf8mb4_general_ci 64 KiB
jos_jmap_headings 0 InnoDB utf8mb4_general_ci 16 KiB
jos_virtuemart_paymentmethods_en_gb 2 MyISAM utf8mb4_general_ci 8.1 KiB
jos_jvshrinktheweb 1 MyISAM utf8mb4_general_ci 2.4 KiB
jos_messages_cfg 0 InnoDB utf8mb4_general_ci 16 KiB
jos_privacy_requests 0 InnoDB utf8mb4_general_ci 16 KiB
jos_sh404sef_hits_shurls 0 InnoDB utf8mb4_general_ci 96 KiB
jos_shlib_resources 1 InnoDB utf8mb4_general_ci 32 KiB
jos_csvi_sefurls 0 InnoDB utf8mb4_general_ci 32 KiB
jos_easytables 0 InnoDB utf8mb4_general_ci 16 KiB
jos_action_logs 0 InnoDB utf8mb4_general_ci 80 KiB
jos_finder_filters 0 InnoDB utf8mb4_general_ci 16 KiB
jos_acymailing_geolocation 0 InnoDB utf8mb4_general_ci 48 KiB
jos_finder_links_terms5 0 InnoDB utf8mb4_general_ci 48 KiB
jos_acymailing_queue 0 InnoDB utf8mb4_general_ci 64 KiB
jos_finder_links_termsc 93 InnoDB utf8mb4_general_ci 48 KiB
jos_acymailing_userstats 0 InnoDB utf8mb4_general_ci 48 KiB
jos_admintools_ipautoban 0 InnoDB utf8mb4_general_ci 32 KiB
jos_admintools_scans 0 InnoDB utf8mb4_general_ci 48 KiB
jos_ak_stats 2 InnoDB utf8mb4_general_ci 48 KiB
jos_assets 360 InnoDB utf8mb4_general_ci 144 KiB
jos_content 122 InnoDB utf8mb4_general_ci 3.7 MiB
jos_csvi_availabletables 116 InnoDB utf8mb4_general_ci 32 KiB
jos_csvi_maps 3 InnoDB utf8mb4_general_ci 16 KiB
jos_csvi_settings 2 InnoDB utf8mb4_general_ci 16 KiB
jos_easytables_table_meta 0 InnoDB utf8mb4_general_ci 32 KiB
jos_action_logs_extensions 18 InnoDB utf8mb4_general_ci 16 KiB
jos_finder_links 37 InnoDB utf8mb4_general_ci 240 KiB
jos_acymailing_history 13 InnoDB utf8mb4_general_ci 64 KiB
jos_finder_links_terms6 421 InnoDB utf8mb4_general_ci 48 KiB
jos_acymailing_rules 0 InnoDB utf8mb4_general_ci 32 KiB
jos_finder_links_termsd 450 InnoDB utf8mb4_general_ci 48 KiB
jos_admintools_acl 0 InnoDB utf8mb4_general_ci 16 KiB
jos_admintools_ipautobanhistory 0 InnoDB utf8mb4_general_ci 16 KiB
jos_admintools_storage 2 InnoDB utf8mb4_general_ci 16 KiB
jos_ak_storage 9 InnoDB utf8mb4_general_ci 6.5 MiB
jos_associations 0 InnoDB utf8mb4_general_ci 32 KiB
jos_content_frontpage 9 InnoDB utf8mb4_general_ci 16 KiB
jos_csvi_currency 0 InnoDB utf8mb4_general_ci 32 KiB
jos_csvi_processed 0 InnoDB utf8mb4_general_ci 16 KiB
jos_csvi_tasks 62 InnoDB utf8mb4_general_ci 32 KiB
jos_extensions 426 InnoDB utf8mb4_general_ci 400 KiB
jos_action_logs_users 0 InnoDB utf8mb4_general_ci 32 KiB
jos_finder_links_terms0 1,660 InnoDB utf8mb4_general_ci 208 KiB
jos_acymailing_list 1 InnoDB utf8mb4_general_ci 64 KiB
jos_finder_links_terms7 221 InnoDB utf8mb4_general_ci 48 KiB
jos_acymailing_stats 0 InnoDB utf8mb4_general_ci 32 KiB
jos_finder_links_termse 1,437 InnoDB utf8mb4_general_ci 208 KiB
jos_admintools_adminiplist 0 InnoDB utf8mb4_general_ci 16 KiB
jos_admintools_ipblock 0 InnoDB utf8mb4_general_ci 16 KiB
jos_admintools_tempsupers 0 InnoDB utf8mb4_general_ci 16 KiB
jos_akeeba_common 5 InnoDB utf8mb4_general_ci 16 KiB
jos_banner_clients 6 InnoDB utf8mb4_general_ci 48 KiB
jos_content_rating 0 InnoDB utf8mb4_general_ci 16 KiB
jos_csvi_icecat_index 0 InnoDB utf8mb4_general_ci 48 KiB
jos_csvi_processes 165 InnoDB utf8mb4_general_ci 64 KiB
jos_csvi_templatefields 496 InnoDB utf8mb4_general_ci 64 KiB
jos_fields 0 InnoDB utf8mb4_general_ci 112 KiB
jos_acymailing_action 0 InnoDB utf8mb4_general_ci 16 KiB
jos_finder_links_terms1 17 InnoDB utf8mb4_general_ci 48 KiB
jos_acymailing_listcampaign 0 InnoDB utf8mb4_general_ci 16 KiB
jos_finder_links_terms8 1,509 InnoDB utf8mb4_general_ci 208 KiB
jos_acymailing_subscriber 10 InnoDB utf8mb4_general_ci 64 KiB
jos_finder_links_termsf 224 InnoDB utf8mb4_general_ci 48 KiB
jos_admintools_badwords 0 InnoDB utf8mb4_general_ci 16 KiB
jos_admintools_log 0 InnoDB utf8mb4_general_ci 32 KiB
jos_admintools_wafblacklists 2 InnoDB utf8mb4_general_ci 16 KiB
jos_ark_editor_inline_views 1 InnoDB utf8mb4_general_ci 16 KiB
jos_banner_tracks 0 InnoDB utf8mb4_general_ci 64 KiB
jos_content_types 14 InnoDB utf8mb4_general_ci 80 KiB
jos_csvi_icecat_suppliers 0 InnoDB utf8mb4_general_ci 32 KiB
jos_csvi_related_categories 0 InnoDB utf8mb4_general_ci 16 KiB
jos_csvi_templatefields_rules 0 InnoDB utf8mb4_general_ci 48 KiB
jos_fields_categories 0 InnoDB utf8mb4_general_ci 16 KiB
jos_acymailing_config 81 InnoDB utf8mb4_general_ci 16 KiB
jos_finder_links_terms2 376 InnoDB utf8mb4_general_ci 48 KiB
jos_acymailing_listmail 0 InnoDB utf8mb4_general_ci 16 KiB
jos_finder_links_terms9 410 InnoDB utf8mb4_general_ci 48 KiB
jos_acymailing_template 4 InnoDB utf8mb4_general_ci 96 KiB
jos_finder_taxonomy 10 InnoDB utf8mb4_general_ci 96 KiB
jos_admintools_cookies 0 InnoDB utf8mb4_general_ci 16 KiB
jos_admintools_profiles 1 InnoDB utf8mb4_general_ci 16 KiB
jos_admintools_wafexceptions 0 InnoDB utf8mb4_general_ci 16 KiB
jos_ark_editor_languages 0 InnoDB utf8mb4_general_ci 16 KiB
jos_banners 8 InnoDB utf8mb4_general_ci 96 KiB
jos_contentitem_tag_map 47 InnoDB utf8mb4_general_ci 64 KiB
jos_csvi_logdetails 67,519 InnoDB utf8mb4_general_ci 7.5 MiB
jos_csvi_related_products 0 InnoDB utf8mb4_general_ci 16 KiB
jos_csvi_templates 45 InnoDB utf8mb4_general_ci 96 KiB
jos_fields_groups 0 InnoDB utf8mb4_general_ci 112 KiB
jos_acymailing_fields 3 InnoDB utf8mb4_general_ci 48 KiB
jos_finder_links_terms3 48 InnoDB utf8mb4_general_ci 48 KiB
jos_acymailing_listsub 2 InnoDB utf8mb4_general_ci 48 KiB
jos_finder_links_termsa 20 InnoDB utf8mb4_general_ci 48 KiB
jos_acymailing_url 0 InnoDB utf8mb4_general_ci 32 KiB
jos_finder_taxonomy_map 78 InnoDB utf8mb4_general_ci 48 KiB
jos_admintools_customperms 0 InnoDB utf8mb4_general_ci 32 KiB
jos_admintools_redirects 0 InnoDB utf8mb4_general_ci 16 KiB
jos_admintools_waftemplates 10 InnoDB utf8mb4_general_ci 64 KiB
jos_ark_editor_plugins 137 InnoDB utf8mb4_general_ci 32 KiB
jos_categories 50 InnoDB utf8mb4_general_ci 160 KiB
jos_core_log_searches 0 InnoDB utf8mb4_general_ci 16 KiB
jos_csvi_logs 25 InnoDB utf8mb4_general_ci 16 KiB
jos_csvi_rules 0 InnoDB utf8mb4_general_ci 16 KiB
jos_datasafe_pro 12 InnoDB utf8mb4_general_ci 16 KiB
jos_action_log_config 83 InnoDB utf8mb4_general_ci 16 KiB
jos_fields_values 0 InnoDB utf8mb4_general_ci 48 KiB
jos_acymailing_filter 0 InnoDB utf8mb4_general_ci 16 KiB
jos_finder_links_terms4 1,156 InnoDB utf8mb4_general_ci 160 KiB
jos_acymailing_mail 10 InnoDB utf8mb4_general_ci 64 KiB
jos_finder_links_termsb 177 InnoDB utf8mb4_general_ci 48 KiB
jos_acymailing_urlclick 0 InnoDB utf8mb4_general_ci 64 KiB
jos_admintools_filescache 0 InnoDB utf8mb4_general_ci 16 KiB
jos_admintools_scanalerts 0 InnoDB utf8mb4_general_ci 16 KiB
jos_ak_profiles 1 InnoDB utf8mb4_general_ci 16 KiB
jos_ark_editor_toolbars 7 InnoDB utf8mb4_general_ci 32 KiB
jos_contact_details 0 InnoDB utf8mb4_general_ci 144 KiB
jos_virtuemart_vendor_medias 0 MyISAM utf8mb4_general_ci 1 KiB
jos_virtuemart_worldzones 0 MyISAM utf8mb4_general_ci 1 KiB
Attachments (2)
  1. 2 weeks ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
The error is : I missed in the last mail:
An error has occured during the import. Below the information received from the server.
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='

We have reduced the size of file.. and still. same. Kindly suggest. Akeeba admin tool is already used for changing collation/ repair- optimize tables done
  1. 2 weeks ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,

An error has occured during the import. Below the information received from the server.
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
This still means that the database tables/fields is not the same everywhere. This is not a problem with your file.

See if you can get Admin Tools to set utf8mb4 on all your tables and columns. Then it should be fine.
Kind regards,

RolandD

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!