#153 PHP allowed memory size exhausted

[proxymus-o]

Hello,

I'm getting the following error in version 1.1:

PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 80 bytes) in /www/phpipam/functions/functions-network.php on line 1282

Is there any chance to solve this issue?

Thank you in advance.

Kind regards

proxymus-o

[Passie]

Try so set everything to 0 in discoverSubnet;
then one by one set them to 1 and see where it fails.

select * from subnets where discoverSubnet=1;

HTH

[proxymus-o]

Just to be sure. When I run the select statement

SELECT id, subnet, mask, sectionId, masterSubnetId, permissions, pingSubnet, discoverSubnet
FROM subnets
WHERE discoverSubnet =1;

I'm getting entries with discoverSubnet = 31. Is this correct?

[Passie]

The only values I have are 1 ( on ) and 0 ( off ).
Not sure why you have 31.
Otherwise make an backup and set it to 0 and then one by one to 1

[Anonymous]

I ran into the same issue; all of the values for discoverSubnet are 31.

[proxymus-o]

I've set the value from 31 to 0. When I refresh the table view the 0 value will be 30 after the refresh. When I set it to 1 it will be 31 after a refresh. Currently I don't have the memory issue.
I'll now set one by one back to 1/31 to see if I can find the cause.

[Passie]

May I ask to print your view here ?
Since I can't find any function within phpipam which add's 30 everytime

[proxymus-o]

I've created a test subnet with discovery check enabled. Then I run the select command (step 1). Then I've set the discovery check to 0 (step 2). Afterwards I've run the select command again.

You can see the results in the attachment (I hope that this is what you want to see).

I don't understand it because the column format is binary (in the table structure). When I try to insert the value 31 or 30 I'm getting the error.

1265 Data truncated for column 'discoverSubnet' at row 1

[Passie]

The truncate error is normal since it's an binary(1) field.
Why or what is updating it to 30 is an mystery :S
Sorry

[proxymus-o]

It seems to be a phpMyAdmin issue. On the CLI the discoverSubnet value is 0 or 1 and not 30 or 31.