From today i am facing strange error on replication slave. Don’t how to fix it please help.
mysql> show slave status\G
Last_Error: Query caused different errors on master and slave. Error on master: ‘Unknown column ‘%-.192s’ in ‘%-.192s’’ (1054), Error on slave: ‘no error’ (0).Default database: ‘DB NAME’. Query: ‘UPDATE TABLE QUERY’
I verified table schema and structure on master/slave which is same on both.
Please help me out to get rid of this.
Error 1054 stats following:
Error Code: 1054 means SQLSTATE: 42S22 (ER_BAD_FIELD_ERROR) Unknown column ‘%s’ in ‘%s’
Not sure what does that means 'Unknown column ‘%-.192s’ in ‘%-.192s’