Re: Errors with Information_Schema in Create Target Results
Posted by: Peter Brawley
Date: October 30, 2021 08:16PM

> ERROR 1128 (HY000): Function 'newforma_wordbreaker' is not defined
Query OK, 0 rows affected (0.00 sec)

> ERROR 1146 (42S02): Table 'newformaglobal_nix.search_content' doesn't exist

You'll need to study the dump file in a good plain text editor (NOT Word!) to see the calls that elicit those errors. Perhaps the function and table are referenced before they are created? It's also possible you're tripping over a MySQL bug that has been fixed since 5.7.18 (you'd need to review the version 5.7 release notes).

> Warning (Code 1300): Invalid utf8 character string: '9C73B1'

The charset of the data being imported does not match the charset definition of the column defined for it. That indicates incompatible data has been inserted into the lab table. It needs to be fixed before you try exporting & importing the db.

It's not known as character set hell for nothing---see https://ironfeather.com/bbs/viewtopic.php?t=3010 for diagnosis & repair approaches.

Options: ReplyQuote


Subject
Written By
Posted
Re: Errors with Information_Schema in Create Target Results
October 30, 2021 08:16PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.