$mysqli->insert_id not working on openSUSE but is on Ubuntu

view story

http://serverfault.com – I realise that this is a pretty vague question but I have been stuck on this for over 2 days. I am moving my PHP application from Ubuntu to openSUSE and I have not got that much experience regarding server configuration. I have an iOS application that receives a JSON response from the PHP API. The application sends a POST to the API and the data is inserted correctly. However the response is failing because $mysqli->insert_id is not returning the correct value. It is returning 0. From my attempts to solve this I have noted the difference between MySQL and MySQLi. By running php -m | gre (HowTos)