general log is different from machine.err log, it stores all logs of the db.
On 8/26/08, Jesse <[EMAIL PROTECTED]> wrote: > > "tsa" is actually the database. It's running the function "AddSchool()", > and it appears that something went wrong in that situation. The actual table > affected inside the function is "school", and that table does exist on both > master and slave. > > If by "general log", you mean the log named machine.err, I've checked that > file on both master and slave, and there is no reference 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]> > *To:* Jesse <[EMAIL PROTECTED]> > *Cc:* MySQL List <mysql@lists.mysql.com> > *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 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] >> >> >