[Bug] CustomsOffice update: Trying to get property of non-object

[smokie128]

Stacktrace: http://pastebin.com/p3FqN7xg

[eve-seat]

Ping @LunarchildEU could you have a look at this one?

[ghost]

Please execute the following querys in your DB: select itemID, locationID from corporation_assetlist where itemID = 1012674593736;

locationID is needed for next Query: select count(*) from mapDenormalize where mapDenormalize.groupID = 7 and mapDenormalize.solarSystemID = <locationID>;

That should yield at least the rowcount for the certain System, if not please execute select count(*) from mapDenormalize;.

These querys all should return somthing > 0.

[smokie128]

mysql> select itemID, locationID from corporation_assetlist where itemID = 1012674593736;
+---------------+------------+
| itemID        | locationID |
+---------------+------------+
| 1012674593736 |   30003054 |
+---------------+------------+
1 row in set (0.01 sec)

mysql> select count(*) from mapDenormalize where mapDenormalize.groupID = 7 and mapDenormalize.solarSystemID = 30003054;
+----------+
| count(*) |
+----------+
|       10 |
+----------+
1 row in set (0.00 sec)

[ghost]

Currently the function that pops this error relies that the POCO is already in the AssetList table of the Corporation, which sadly turns out it is not good.

• Assetlist ~7h Cache
• CustomsOffice ~1h Cache

That could have caused the problem - 9a14350cd4437502fdfc7c772171a53fd7eddb7e should sort that out.

[eve-seat]

Sweet. @smokie128 can you test @LunarchildEU fix and let us know?

[smokie128]

Tested #313 Working fine so far. Issued a full update on the corp key, finished without errors.