#196 Upgrade 1.1 to 1.2.1 - firewallZoneSubnet error

[Mateusz]

Hi Miha,
I recently upgraded my 1.1 ipam to 1.2.1 version.
I got a lot of error, but I was able to fix almost all via the admin panel

[Mateusz]

for the first task I got a false done message... that is proposed again at every new check.

The result is that under every subnet I see the error:

Database error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'phpipam.firewallZoneSubnet' doesn't exist

I attempted to create the table firewallZoneSubnet using the sql update code (1.2), but again I got an error:

1005 - Can't create table 'phpipam.firewallZoneSubnet' (errno: 150)

[Anonymous]

[Mateusz]

Upd - A friend checked my errors and suggested to modify subnets ENGINE from MyISAM to InnoDB. After this change i was able to definitively fix (via DB check menu) the last error, creating the new firewallZoneSubnet table.
I think you can close this ticket. :)

Reading UPDATE-v1.2.sql I find this lines:

/ remove the field subnetId from firewallZones, it's not longer needed /
ALTER TABLE firewallZones DROP COLUMN subnetId;

but checking my DB it's still present. Have I to remove it manually (this and other eventually still present)?

Regard, Mateusz

[Anonymous]