I just got my Ubuntu PEQ server up and running and am getting a few table errors. They don't seem to impact anything but I don't like errors. Is there something I can do to fix these?
The first appears to be on startup:
Code:
World] [Info] Purging expired expeditions
[World] [MySQL Error] [1146] [Table 'eqemu.dynamic_zone_members' doesn't exist]
[SELECT expeditions.id, expeditions.dynamic_zone_id FROM expeditions LEFT JOIN dynamic_zones ON expeditions.dynamic_zone_id = dynamic_zones.id LEFT JOIN instance_list ON dynamic_zones.instance_id = instance_list.id LEFT JOIN ( SELECT dynamic_zone_id, COUNT(IF(is_current_member = TRUE, 1, NULL)) member_count FROM dynamic_zone_members GROUP BY dynamic_zone_id ) dynamic_zone_members ON dynamic_zone_members.dynamic_zone_id = expeditions.dynamic_zone_id WHERE instance_list.id IS NULL OR dynamic_zone_members.member_count IS NULL OR dynamic_zone_members.member_count = 0 OR (instance_list.start_time + instance_list.duration) <= UNIX_TIMESTAMP();]
[World] [Info] Purging expired instances
The second appears to be when zoning. Looks like whatever it is, it's the same table so I suspect they're related.
Code:
[Zone] [MySQL Error] [1146] [Table 'eqemu.dynamic_zone_members' doesn't exist]
[SELECT expeditions.id FROM expeditions INNER JOIN dynamic_zone_members ON expeditions.dynamic_zone_id = dynamic_zone_members.dynamic_zone_id WHERE dynamic_zone_members.character_id = 1 AND dynamic_zone_members.is_current_member = TRUE;]
Any suggestions?