HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (
-   General (
-   -   SQL Replication Error (

Gimly 31st August 2009 19:44

SQL Replication Error
Hi All,

I've an error with the sql replication

Quote: 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 1st September 2009 12:42

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 1st September 2009 15:48

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 1st September 2009 16:23

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

Gimly 1st September 2009 17:56

On all servers. Why ?

till 1st September 2009 18:07

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

Gimly 2nd September 2009 00:43

Ok, thanks Till for the info :)

All times are GMT +2. The time now is 01:51.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.