Re: Error stops replication

2008-08-27 Thread Jesse
Where can I find a "general log" if I've got one running? What's it's file name, and where it is usually located? Thanks, Jesse - Original Message - From: Ananda Kumar To: Jesse Cc: MySQL List Sent: Tuesday, August 26, 2008 8:03 AM Subject: Re

Re: Error stops replication

2008-08-26 Thread Ananda Kumar
e there at all to a > "AddSchool(" function error. Other than that, I don't see that any other > logs are activated (other than the binary logs, of course). > > Jesse > > - Original Message - > *From:* Ananda Kumar <[EMAIL PROTECTED]> >

Re: Error stops replication

2008-08-26 Thread Jesse
rse). Jesse - Original Message - From: Ananda Kumar To: Jesse Cc: MySQL List Sent: Tuesday, August 26, 2008 12:55 AM Subject: Re: Error stops replication does tsa table exists on both master and slave. If you have enabled general log, then u can see most of the e

Re: Error stops replication

2008-08-25 Thread Ananda Kumar
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 <[EMAIL PROTECTED]> wrote: > > I have been getting an error which stops replication on my slave server. >

Error stops replication

2008-08-25 Thread Jesse
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: 'SELEC