Guys,
I am new to the CI framework.
I have been given an app designed few years ago running CI v3.1.x
The Production Server is a Linux Centos 7.8 box and the Dev Server ( which i just setup
recently is also a Centos 7.8 box - So both are Linux boxes and are nearly identical).
The app works fine in the Production server but in the Dev Server, its throws up an error about the table not existing even though
its there in all lower case.
Looking at the table names in the Database ( via phpmyadmin in both servers, the table names are all lower case in BOTH servers ) but
no error is thrown up in the Production Server and the app works properly. The error in the Dev Server is as follows;
Code:
Error Number: 1146
Table 'inventory.sys_Info' doesn't exist <== Does exist except its all lower case
SELECT * FROM `sys_Info` WHERE `Info_ID` = '20'
Filename: models/DataSystem.php
Line Number: 30
Any reason why this discrepancy happens ? What can i do ?
Thanks.
Czen