Re: Errors with Information_Schema in Create Target Results

[Vaughan Wickham]

Hello Peter,

Thanks for your last reply, that was very comprehensive. That would have taken me a long time to figure out, if at all.

I have started restoring the databases to the Lab server and am reviewing the log.

Some errors have occurred

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

Not sure about the significance of this error.


ERROR 1146 (42S02): Table 'newformaglobal_nix.search_content' doesn't exist
ERROR 1146 (42S02): Table 'newformaglobal_nix.search_content' doesn't exist
ERROR 1146 (42S02): Table 'newformaglobal_nix.search_content' doesn't exist
ERROR 1146 (42S02): Table 'newformaglobal_nix.search_content' doesn't exist
Query OK, 0 rows affected (0.00 sec)

I think this one is a concern, because the table doesn't exist in the Lab server but does exist in production.

What's not clear to me, is why this would be the case. As I would have thought that if a table wasn't created, that would lead to an error being reported.

Unless the consequences of that first error, is the table not being created?

Do you have any ideas?

There were also a bunch of the following (of which I have only shown a few)

Warning (Code 1300): Invalid utf8 character string: '9C73B1'
Warning (Code 1300): Invalid utf8 character string: '9CCBCC'
Warning (Code 1300): Invalid utf8 character string: '9C3306'
Warning (Code 1300): Invalid utf8 character string: '9C3333'
Warning (Code 1300): Invalid utf8 character string: '9C3336'
Warning (Code 1300): Invalid utf8 character string: '9C3332'
Warning (Code 1300): Invalid utf8 character string: '9C3334'
Warning (Code 1300): Invalid utf8 character string: '9C3333'

Can these warnings be ignored?