Publishing a Zone in a GEOZone fails

[ChrisFrench]

when creating a new zone, you create zone and select type that works.

if you try to publish zones to your geozone it fails with this error

Error: 3613: TiendaTableZonerelations: :store failed
Cannot add or update a child row: a foreign key constraint fails (ammonite.b3hq7_tienda_zonerelations, CONSTRAINT fk_geozone_zonerelations FOREIGN KEY (geozone_id) REFERENCES b3hq7_tienda_geozones (geozone_id) ON DELETE CASCADE ON UPDATE CASCADE) SQL=INSERT INTO b3hq7_tienda_zonerelations (zone_id,geozone_id,created_date) VALUES ('3613','3613','2012-09-27 22:19:23')

[ChrisFrench]

turns out this was just a local problem with my database and now it is working after a database repair