[Resolved] Reletionship Migration MySQL error

[Author]

Posts

[corineV]

Tell us what you are trying to do?
I tried to migrate, as toolset asks me to. Then I got this error.
> Post relationships migration started.
> Onderhoudsmodus ingeschakeld.
> Er hoefden geen tabellen verwijderd te worden.
> Kon tabel m22Kr_toolset_associations niet creëren vanwege een MySQL Fout:
> Kon tabel m22Kr_toolset_relationships niet creëren vanwege een MySQL Fout:
> Kon tabel m22Kr_toolset_type_sets niet creëren vanwege een MySQL Fout:
> Onderhoudsmodus uitgeschakeld

I searched in the support-section and found this:
https://toolset.com/forums/topic/mysql-errors-while-migrating-posts-relationships/

I tried to
- deactivate types
- edit the MYSQL-options table and deleting the option "toolset_is_m2M etc".
- activate types again
- run migration again.

Still the same error

What is the link to your site?
hidden link

[Luo Yang]

Hello,

Please provide more details for the problem:
1) Provide the Toolset Debug Information of your website:
https://toolset.com/faq/provide-debug-information-faster-support/

Make sure your webserver satisfies Toolset requirements:
https://toolset.com/toolset-requirements/
MySQL 5.6 and above.

2) There should be some errors occur in your website, please provide the PHP debug logs:
https://toolset.com/documentation/programmer-reference/debugging-sites-built-with-toolset/#php-debugging

[corineV]

Hi Luo,

1) debug info is below

2) php is 7.3

3) I added the code to wp-config.php an made a writable file error_log.txt. But no errors in that file.

{"core":{"Wordpress":{"Multisite":"No","SiteURL":"http:\/\/rijdendeschool.webwerkplaats.com","HomeURL":"http:\/\/rijdendeschool.webwerkplaats.com","Version":"5.2.4","PermalinkStructure":"","PostTypes":"post, page, attachment, revision, nav_menu_item, custom_css, customize_changeset, oembed_cache, user_request, wp_block, wp-types-group, wp-types-user-group, wp-types-term-group, view, view-template, medewerker, document","PostSatus":"publish, future, draft, pending, private, trash, auto-draft, inherit, request-pending, request-confirmed, request-failed, request-completed"},"Server":{"jQueryVersion":"1.12.4-wp","PHPVersion":"7.3.4","MySQLVersion":"5.6.39","ServerSoftware":"Microsoft-IIS\/8.5"},"PHP":{"MemoryLimit":"512M","UploadMax":"1024M","PostMax":"1024M","TimeLimit":"900","MaxInputVars":"1000"}},"plugins":{"active_plugins":{"codepress-admin-columns\/codepress-admin-columns.php":{"Name":"Admin Columns","PluginURI":"https:\/\/www.admincolumns.com","Version":"3.4.6","Author":"AdminColumns.com","AuthorURI":"https:\/\/www.admincolumns.com","TextDomain":"codepress-admin-columns","DomainPath":"\/languages","Network":false,"Title":"Admin Columns","AuthorName":"AdminColumns.com"},"types\/wpcf.php":{"Name":"Toolset Types","PluginURI":"https:\/\/toolset.com\/?utm_source=typesplugin\u0026utm_campaign=types\u0026utm_medium=plugins-list-full-version\u0026utm_term=Visit plugin site","Version":"3.3.7","Author":"OnTheGoSystems","AuthorURI":"http:\/\/www.onthegosystems.com","TextDomain":"types","DomainPath":"","Network":false,"Title":"Toolset Types","AuthorName":"OnTheGoSystems"},"wp-views\/wp-views.php":{"Name":"Toolset Views","PluginURI":"https:\/\/toolset.com\/?utm_source=viewsplugin\u0026utm_campaign=views\u0026utm_medium=plugins-list-full-version\u0026utm_term=Visit plugin site","Version":"2.9.4","Author":"OnTheGoSystems","AuthorURI":"https:\/\/toolset.com","TextDomain":"wp-views","DomainPath":"","Network":false,"Title":"Toolset Views","AuthorName":"OnTheGoSystems"}},"mu_plugins":[],"dropins":[]},"theme":{"Name":"Monochrome Pro - Stichting Rijdende School","ThemeURI":null,"Author":"\u003Ca href=\u0022https:\/\/www.studiopress.com\/\u0022\u003EStudioPress\u003C\/a\u003E","AuthorURI":null,"Template":"genesis","Version":"1.3.0","TextDomain":null,"DomainPath":null},"extra-debug":{"types":{"add_resized_images_to_library":0,"register_translations_on_import":1,"images_remote":0,"images_remote_cache_time":"36","help_box":"by_types","hide_standard_custom_fields_metabox":"show","postmeta_unfiltered_html":"on","usermeta_unfiltered_html":"on"},"views":{"views_template_loop_blog":0,"wpv_bootstrap_version":1,"wpv_custom_conditional_functions":[],"wpv_custom_inner_shortcodes":[],"wpv_debug_mode":"","wpv_debug_mode_type":"compact","wpv_map_plugin":0,"wpv_show_hidden_fields":"","wpv_saved_auto_detected_framework":"","wpv_codemirror_autoresize":"","wpv_enable_pagination_manage_history":true,"wpv_enable_parametric_search_manage_history":true,"support_spaces_in_meta_filters":0,"allow_views_wp_widgets_in_elementor":0,"default_user_editor":"basic","manage_meta_transient_method":"cron","view_cpt_medewerker":100},"installer":{"version":"2.2.1","repositories":{"wpml":{"api-url":"https:\/\/api.wpml.org\/","bucket-url":"not assigned","subscription":""},"toolset":{"api-url":"https:\/\/api.toolset.com\/","bucket-url":"https:\/\/wptypes.s3.amazonaws.com\/toolset-bucket-7.json","subscription":{"key":"OJcTXPIFsV","data":{"subscription_type":5740,"expires":null,"status":"4"},"registered_by":1,"site_url":"http:\/\/rijdendeschool.webwerkplaats.com"}}},"instances":{"D:\\appdata\\IIS\\vhosts\\rijdendeschool.nl\\httpdocs\\wp-content\\plugins\\types\\vendor\\otgs\\installer\/installer.php":{"bootfile":"D:\\appdata\\IIS\\vhosts\\rijdendeschool.nl\\httpdocs\\wp-content\\plugins\\types\\vendor\\otgs\\installer\/installer.php","version":"2.2.1","args":{"plugins_install_tab":"1","repositories_include":["toolset","wpml"]},"delegated":true}}}}}

[Luo Yang]

The problem is abnormal, please provide a test site with same problem, fill your website credentials and FTP access in below private message box, I need a live website to debug. Thanks

[Luo Yang]

Thanks for the details, I can log into your website, will update here if there is anything found.

[Luo Yang]

Here are what I found, in your website root folder, file wp-config.php, line 121, you are using below database table prefix setting:

$table_prefix = 'm22Kr_';

the character K is upper case, but your database tables is using lower case prefix "m22kr_", it conducts the problem.

Please try these:
1) Backup your website database first
2) Edit file wp-config.php, line 121, change it to:

$table_prefix = 'm22kr_';

3) Use some MYSQL tools, for example PHPmyadmin, in your website database, run below SQL:

UPDATE m22kr_usermeta SET meta_key = REPLACE(meta_key, 'm22Kr_', 'm22kr_') WHERE meta_key NOT LIKE '%{%';

Then test again.

[corineV]

My issue is resolved now. Thank you!