I have a problem with an update query not replicating through to the slave.
The query is "update content_review_site as a,site_rating_factors as b set a.overall_rating = 77 where a.content_id=243"
Version : 4.0.22 OS : Linux X86
How to replicate the error.
CREATE TABLE content_review_site ( content_id int(11) unsigned NOT NULL default '0', site_id int(10) unsigned NOT NULL default '0', overall_rating float(4,2) unsigned NOT NULL default '0.00', rating_software_and_graphics tinyint(4) unsigned NOT NULL default '0', rating_game_variety tinyint(4) unsigned NOT NULL default '0', rating_maximum_bonus tinyint(4) unsigned NOT NULL default '0', rating_bonus_match tinyint(4) unsigned NOT NULL default '0', rating_wagering_requirements tinyint(4) unsigned NOT NULL default '0', rating_payout_ratio tinyint(4) unsigned NOT NULL default '0', rating_multiplayer_games tinyint(4) unsigned NOT NULL default '0', rating_loyalty_bonus tinyint(4) unsigned NOT NULL default '0', rating_deposit_withdrawal_options tinyint(4) unsigned NOT NULL default '0', rating_support tinyint(4) unsigned NOT NULL default '0', rating_progressive_jackpots tinyint(4) unsigned NOT NULL default '0', rating_languages tinyint(4) unsigned NOT NULL default '0', rating_reputation_fairness tinyint(4) unsigned NOT NULL default '0', rating_free_bonus tinyint(4) unsigned NOT NULL default '0', create_ts datetime NOT NULL default '0000-00-00 00:00:00', modify_ts datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (content_id,site_id) ) TYPE=MyISAM;
CREATE TABLE site_rating_factors ( site_id int(11) unsigned NOT NULL default '0', factor_software_and_graphics tinyint(4) unsigned NOT NULL default '0', factor_game_variety tinyint(4) unsigned NOT NULL default '0', factor_bonus_amount tinyint(4) unsigned NOT NULL default '0', factor_bonus_clauses tinyint(4) unsigned NOT NULL default '0', factor_payout_ratio tinyint(4) unsigned NOT NULL default '0', factor_multiplayer_games tinyint(4) unsigned NOT NULL default '0', factor_loyalty_bonus tinyint(4) unsigned NOT NULL default '0', factor_deposit_withdrawal_options tinyint(4) unsigned NOT NULL default '0', factor_support tinyint(4) unsigned NOT NULL default '0', factor_graphics tinyint(4) unsigned NOT NULL default '0', factor_progressive_jackpots tinyint(4) unsigned NOT NULL default '0', factor_languages tinyint(4) unsigned NOT NULL default '0', factor_reputation_fairness tinyint(4) unsigned NOT NULL default '0', factor_free_bonus tinyint(4) unsigned NOT NULL default '0', create_ts datetime NOT NULL default '0000-00-00 00:00:00', modify_ts datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (site_id) ) TYPE=MyISAM;
insert into site_rating_factors values (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,now(),now());
insert into content_review_site values (243,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,now(),now());
On the slave get the data with "load data from master". Both slave and master shows : +------------+----------------+ | content_id | overall_rating | +------------+----------------+ | 243 | 1.00 | +------------+----------------+
update content_review_site set overall_rating = 666; updates the tables just fine on both slave and master.
But the troubling query below does NOT it only updates on the master.
update content_review_site as a,site_rating_factors as b set a.overall_rating = 77 where a.content_id=243;
Any suggestions?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
