Hi!
Have anybody experienced the situation when query, insert, update syntax used when developed app under Xampp - does not work if you put the app on newly installed Ubundtu server. Browser shows enormos errors and actually app does not work because query syntax does not work.
I installed Xamp on VM- put the app there - everything works, moved it to regular server - does not...
After analysis it is obvious that MySQL on Xampp is somehow configured in a way which is different from typical Ubuntu installation.
Any suggestion how to handle this - what those special settings? or need to rewrite all queries, inserts and updates to run app on typical server.
Simple example insert in DB when you define only values for 2 fields where there are 4 fields in DB - works in Xampp, but under typical Linux MySQL does not, you have to define values for all 4 fields - then it works... Also Group by under Xampp works if the aggregating function defined on 4 fields, but group by only by one field - under Xampp works perfectly under Ubuntu - does not. I understand that syntax used under Xampp is not ISO standard query, but it works... where it does not under typical server.
Thank you for thoughts and suggestions.
I have XAMPP 7.1.8 under Windows and Mac.