Hello.
Check the structure of `bartran` table on the slave. You master is very old, upgrade to the latest release (4.1.13 or 4.0.25). >Dear All, > >Here's our setup : > >Master : MySQL v4.0.16-max-log > >Slave : MySQL v4.1.10a-max-log > >Everytime I do an ALTER TABLE on the master server, I get the following >error message on the slave server. > >050723 1:51:26 [ERROR] Slave: Error 'Duplicate column name >'TimefileDate'' on query. Default database: 'barmain_es'. Query: 'ALTER >TABLE `bartran` ADD `TimefileDate` DATETIME DEFAULT NULL AFTER >`SignOffBy`', Error_code: 1060 > >050723 1:51:26 [ERROR] Error running query, slave SQL thread aborted. >Fix the problem, and restart the slave SQL thread with "SLAVE START". We >stopped at log 'CentracDB-bin.013' position 2989111 > >Any idea on what could be causing this ? "Sinang, Danny" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
