.png.022b5452a8f28f552bc9430097a16da2.png)
5 hours ago, dandumit said:I get many warnings that he cannot read name of indexes :
Notice: Undefined index: index_name in /pts/copy_shopdata_functions.inc.php on line 326
Notice: Undefined index: index_name in /pts/copy_shopdata_functions.inc.php on line 340
Notice: Undefined index: non_unique in/pts/copy_shopdata_functions.inc.php on line 342
These are fieldnames from the information_schema.statistics table. I have those from the MariaDb version. I wonder whether you have Mysql instead and there is some difference. Can you check that?
5 hours ago, dandumit said:And finally I have an error and stops on:
MySQL error 1062: Duplicate entry '2-3-001Ω' for key 'ps_search_word.id_lang'
Generated by URL '/pts/copy_shopdata.php'
with Query ps_search_word` (`id_lang`,`id_shop`,`id_word`,`word`) SEL `id_lang`,`id_shop`,`id_word`,`word` FROM ps_search_word
I suspect that the Ohm sign gives problems. Note that you may be moving between slightly different character sets (like utf8mbt4_general and utf8_unicode) and that can result in this kind of errors. The easiest solution is to set $skip_search_tables in the config table to true and re-index the new shop when you are ready.