SQL Replication Error

[Gimly]

Hi All,

I've an error with the sql replication

mail.espace4you.org Error Replication failed. Error: (client) in mysql server: (localhost) 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 [...]

I've delete client which do this error.

So and I want to know is there a way to delete this replication sql job because this error returns every minute and it block my jobqueue ...



Thanks in advance for your help

[till]

Find the corresponding item in the sys_datalog table on the master and the slave server(s) and delete it there.

Is the above the complete error message? Does it not contain the failed sql query?

[Gimly]

Hi Till,

Thanks for your reply.

In ISPConfig the message is complete but it contains data about an user.

I test delete error in sys_datalog and now it work

[till]

Did you update ISPConfig on all servers to 3.0.1.4b2 or just on the master?

[Gimly]

On all servers. Why ?

[till]

On all servers is fine. If you would have installed it only on the master, this would explain the replication error.

[Gimly]

Ok, thanks Till for the info