***BOGO*** Re: Error stops replication

["Ananda Kumar" <anandkl@xxxxxxxxx>]

does tsa table exists on both master and slave.
If you have enabled general log, then u can see most of the errors.

I am suspecting that this table is not present in slave


On 8/26/08, Jesse <jc@xxxxxxxxx> wrote:
>
> 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
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=anandkl@xxxxxxxxx
>
>