List:General Discussion« Previous MessageNext Message »
From:Jesse Date:August 25 2008 6:31pm
Subject:Error stops replication
View as plain text  
I have been getting an error which stops replication on my slave server. 
The error is as follows:

You have an error in your SQL syntax; check the manual that corresponds to 
your MySQL server version for the right syntax to use near '' at line 1' on 
query. Default database: 'tsa'. Query: 'SELECT 
`tsa`.`AddSchool`(_latin1'Grenada High School',_latin1'2','

The thing is that I'm not getting an error on the master server, to my 
knowledge. When I check the error log, there is no such error in there. 
Does the "Machine.err" file log these sort of errors?  If not, where can I 
look to see if it is happening on the master server?

I'm running version 5.0.67-community-nt on the slave and version 
5.0.51a-nt-log on the master.

If anyone has any ideas on what might be causing this, please let me know 
what you think.

Jesse 

Thread
Error stops replicationJesse25 Aug
  • Re: Error stops replicationAnanda Kumar26 Aug
  • Re: Error stops replicationJesse26 Aug
    • Re: Error stops replicationAnanda Kumar26 Aug
  • Re: Error stops replicationJesse27 Aug