
06-25-2015, 03:29 AM
|
Discordant
|
|
Join Date: Apr 2013
Posts: 419
|
|
Quote:
Originally Posted by Shendare
Alternatively, this would add all missing zone entries in the `grid` table so the code doesn't crash looking up the max(id) for them:
Code:
INSERT INTO `grid`
SELECT DISTINCT 0, `zoneidnumber`, 0, 0 FROM `zone` WHERE `zoneidnumber` NOT IN
(SELECT DISTINCT `zoneid` FROM `grid`);
|
This fixed the issue.
__________________
I am the All Mighty Mittens!
|