all of them individually?Test run this queries:
UPDATE `furniture` SET `behaviour_data` = `furniture`.`clothing_id` WHERE `furniture`.`clothing_id` > 0 AND `furniture`.`behaviour_data` = 0;
UPDATE `furniture` SET `behaviour_data` = `furniture`.`wired_id` WHERE `furniture`.`wired_id` > 0 AND (`furniture`.`interaction_type` = 'wired_effect' OR `furniture`.`interaction_type` = 'wired_trigger' OR `furniture`.`interaction_type` = 'wired_condition');
Then restart emu.
First this: UPDATE `furniture` SET `behaviour_data` = `furniture`.`clothing_id` WHERE `furniture`.`clothing_id` > 0 AND `furniture`.`behaviour_data` = 0;all of them individually?
a bunch of them won't runFirst this: UPDATE `furniture` SET `behaviour_data` = `furniture`.`clothing_id` WHERE `furniture`.`clothing_id` > 0 AND `furniture`.`behaviour_data` = 0;
and then this one: UPDATE `furniture` SET `behaviour_data` = `furniture`.`wired_id` WHERE `furniture`.`wired_id` > 0 AND (`furniture`.`interaction_type` = 'wired_effect' OR `furniture`.`interaction_type` = 'wired_trigger' OR `furniture`.`interaction_type` = 'wired_condition');
Run this firsta bunch of them won't run
SET @@global.sql_mode= '';
Run this first
Code:SET @@global.sql_mode= '';
then try running what sup said
thank you so much guys, it worked!Test run this queries:
UPDATE `furniture` SET `behaviour_data` = `furniture`.`clothing_id` WHERE `furniture`.`clothing_id` > 0 AND `furniture`.`behaviour_data` = 0;
UPDATE `furniture` SET `behaviour_data` = `furniture`.`wired_id` WHERE `furniture`.`wired_id` > 0 AND (`furniture`.`interaction_type` = 'wired_effect' OR `furniture`.`interaction_type` = 'wired_trigger' OR `furniture`.`interaction_type` = 'wired_condition');
Then restart emu.