{"action":"closed","issue":{"url":"https://api.github.com/repos/phpipam/phpipam/issues/660","repository_url":"https://api.github.com/repos/phpipam/phpipam","labels_url":"https://api.github.com/repos/phpipam/phpipam/issues/660/labels{/name}","comments_url":"https://api.github.com/repos/phpipam/phpipam/issues/660/comments","events_url":"https://api.github.com/repos/phpipam/phpipam/issues/660/events","html_url":"https://github.com/phpipam/phpipam/issues/660","id":168369138,"number":660,"title":"Upgrade from 1.1 to 1.2 issues","user":{"login":"mrlesmithjr","id":4006149,"avatar_url":"https://avatars.githubusercontent.com/u/4006149?v=3","gravatar_id":"","url":"https://api.github.com/users/mrlesmithjr","html_url":"https://github.com/mrlesmithjr","followers_url":"https://api.github.com/users/mrlesmithjr/followers","following_url":"https://api.github.com/users/mrlesmithjr/following{/other_user}","gists_url":"https://api.github.com/users/mrlesmithjr/gists{/gist_id}","starred_url":"https://api.github.com/users/mrlesmithjr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrlesmithjr/subscriptions","organizations_url":"https://api.github.com/users/mrlesmithjr/orgs","repos_url":"https://api.github.com/users/mrlesmithjr/repos","events_url":"https://api.github.com/users/mrlesmithjr/events{/privacy}","received_events_url":"https://api.github.com/users/mrlesmithjr/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/phpipam/phpipam/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/phpipam/phpipam/milestones/1","html_url":"https://github.com/phpipam/phpipam/milestones/1.3","labels_url":"https://api.github.com/repos/phpipam/phpipam/milestones/1/labels","id":1353537,"number":1,"title":"1.3","description":null,"creator":{"login":"phpipam","id":12947690,"avatar_url":"https://avatars.githubusercontent.com/u/12947690?v=3","gravatar_id":"","url":"https://api.github.com/users/phpipam","html_url":"https://github.com/phpipam","followers_url":"https://api.github.com/users/phpipam/followers","following_url":"https://api.github.com/users/phpipam/following{/other_user}","gists_url":"https://api.github.com/users/phpipam/gists{/gist_id}","starred_url":"https://api.github.com/users/phpipam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/phpipam/subscriptions","organizations_url":"https://api.github.com/users/phpipam/orgs","repos_url":"https://api.github.com/users/phpipam/repos","events_url":"https://api.github.com/users/phpipam/events{/privacy}","received_events_url":"https://api.github.com/users/phpipam/received_events","type":"User","site_admin":false},"open_issues":21,"closed_issues":17,"state":"open","created_at":"2015-10-13T16:28:47Z","updated_at":"2016-09-12T19:10:16Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2016-07-29T16:59:33Z","updated_at":"2016-09-12T19:10:16Z","closed_at":"2016-09-12T19:10:16Z","body":"I would like to reference this [Bug] reported on sourceforge. After an upgrade from 1.1 to 1.2 I am receiving the following error.\r\n\r\n`Warning: Invalid argument supplied for foreach() in /var/www/html/phpipam/app/subnets/addresses/print-address-table.php on line 100`\r\nThe other error is in regards to the graph for the subnet...\r\n`Warning: Invalid argument supplied for foreach() in /var/www/html/phpipam/functions/classes/class.Subnets.php on line 923\r\n`\r\n`\r\nWarning: Invalid argument supplied for foreach() in /var/www/html/phpipam/functions/classes/class.Subnets.php on line 899\r\n`\r\n\r\nThe strange part is that this is in an HA setup with Apache pointing the exact same DB and the other host does not show the same symptoms. Which makes me believe that one of the hosts has something misconfigured. But they appear to be identical as well as being provisioned with the identical Ansible role. So something is odd. I am continuing to investigate but wanted to raise this here along with sourceforge.\r\n\r\n[Bug]: <https://sourceforge.net/p/phpipam/bugs/394/?limit=25>\r\n\r\nOn another note during the upgrade the following also needed to be executed to resolve additional DB migration table actions that would not resolve via the WebUI.\r\n```\r\nalter table `settings` add `scanFPingPath` VARCHAR(64)  NULL  DEFAULT '/bin/fping' after `scanPingPath`;\r\nalter table `settings` add `enableFirewallZones` TINYINT(1) NOT NULL DEFAULT '0' after `enableDNSresolving`;\r\nalter table `settings` add `firewallZoneSettings` VARCHAR(1024) NOT NULL DEFAULT '{\"zoneLength\":3,\"ipType\":{\"0\":\"v4\",\"1\":\"v6\"},\"separator\":\"_\",\"indicator\":{\"0\":\"own\",\"1\":\"customer\"},\"zoneGenerator\":\"2\",\"zoneGeneratorType\":{\"0\":\"decimal\",\"1\":\"hex\",\"2\":\"text\"},\"deviceType\":\"3\",\"padding\":\"on\",\"strictMode\":\"on\",\"pattern\":{\"0\":\"patternFQDN\"}}' after `enableFirewallZones`;\r\nalter table `settings` add `enablePowerDNS` TINYINT(1)  NULL  DEFAULT '0' after `firewallZoneSettings`;\r\nalter table `settings` add `powerDNS` TEXT  NULL after `enablePowerDNS`;\r\nalter table `subnets` add `firewallAddressObject` VARCHAR(100) NULL DEFAULT NULL after `description`;\r\nalter table `subnets` add `device` INT  UNSIGNED  NULL  DEFAULT '0' after `showName`;\r\nalter table `subnets` add `DNSrecursive` TINYINT(1)  NULL  DEFAULT '0' after `discoverSubnet`;\r\nalter table `subnets` add `DNSrecords` TINYINT(1)  NULL  DEFAULT '0' after `DNSrecursive`;\r\nalter table `subnets` add `nameserverId` INT(11) NULL DEFAULT '0' after `DNSrecords`;\r\nalter table `subnets` add `scanAgent` INT(11)  DEFAULT NULL after `nameserverId`;\r\nalter table `users` add `lastLogin` TIMESTAMP  NULL after `editDate`;\r\nalter table `users` add `lastActivity` TIMESTAMP  NULL after `lastLogin`;\r\nalter table `users` add `compressOverride` SET('default','Uncompress') NOT NULL DEFAULT 'default' after `lastActivity`;\r\nalter table `users` add `hideFreeRange` tinyint(1) DEFAULT '0' after `compressOverride`;\r\nalter table `users` add `printLimit` int(4) unsigned DEFAULT '30' after `hideFreeRange`;\r\nalter table `users` add `token` VARCHAR(24)  NULL  DEFAULT NULL after `printLimit`;\r\nalter table `users` add `token_valid_until` DATETIME  NULL after `token`;\r\n```"}}
{"actor":{"display_login":"phpipam"}}