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. > 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/[EMAIL PROTECTED] > >
