A raw_zone entry does not match any zone found in {database}

[Sylva1n]

From PacketCollector.exe

Code: Select all

C:\eq2parser>PacketParser.exe - populate eq2
[Status] Using database 'eq2_rawdata' at localhost
Populating Spawns using the 'eq2' database...
A raw_zone entry does not match any zone found in 'eq2'.
Error populating database.

Zones:
-Tradeskiller's Workshop
-The Circle of Elder's
-(part of) Outpost of the Overlord

bug?

[John Adams]

No, not a bug.

Parser looks up a zones Description in your destination DB's "zones" table. If what is in raw_zones.zone_desc does not match what's in zones.description, it fails intentionally. You cannot insert zone data into a zone if you do not know the zone ID.

This is caused by the randomness of zone_desc data we get from collects. Most raw_zones data needs to be 'massaged' before you populate.