Code: Select all

[Error] Error in updating tables query '
update revive_points, zones set zone_id=zones.id where zones.description = zone_name': #1267: Illegal mix of collations latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='

[Error]         Attempting to update database table 'revive_points' ... FAILED!

Code: Select all

[Error] Login reports that the latest version of the 'revive_points' is 65000, you are using 0.  The query that will run to update your table is:
drop table if exists revive_points

create table revive_points (id int(11) unsigned not null primary key auto_increment, location_name varchar(64) not null, zone_name varchar(64) not null default 'antonica', safe_x float not null default 0, safe_y float not null default 0, safe_z float not null default 0)
ALTER TABLE `revive_points` ADD `heading` FLOAT DEFAULT '0' NOT NULL AFTER `safe_z`
ALTER TABLE `revive_points` ADD `respawn_zone` VARCHAR(64) DEFAULT 'antonica' NOT NULL AFTER `zone_name`
alter table `revive_points` add column `zone_id` int(10) UNSIGNED DEFAULT '12' NOT NULL after `zone_name`, add column `respawn_zone_id` int(10) UNSIGNED DEFAULT '12' NOT NULL after `respawn_zone`

update revive_points, zones set zone_id=zones.id where zones.description = zone_name

update revive_points, zones set respawn_zone_id=zones.id where zones.description = respawn_zone

[Error] Error in updating tables query '
update revive_points, zones set zone_id=zones.id where zones.description = zone_name': #1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
[Error]         Attempting to update database table 'revive_points' ... FAILED!
[Status]        Table Update complete.
[Status]        Processing Data Updates.
[Error] The following queries will be inserted into your database to bring it up
 to date:
replace into revive_points (`id`,`location_name`,`zone_name`,`zone_id`,`respawn_zone`,`respawn_zone_id`,`safe_x`,`safe_y`,`safe_z`,`heading`)  values(1,'Near North Qeynos Gates','Antonica',12,'antonica',12,436.2,-37.5,819.56,0)

[Status]        Attempting to update database table 'revive_points' data ... SUCCESS!
[Status]        Data Update complete.

Code: Select all

alter table `revive_points`  Engine=InnoDB checksum=1 auto_increment=1 comment='' delay_key_write=1 row_format=dynamic charset=latin1 collate=latin1_swedish_ci ;