Production Server - Table - Case Insensitive But Dev Server is Case Sensitive - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: Installation & Setup (https://forum.codeigniter.com/forumdisplay.php?fid=9) +--- Thread: Production Server - Table - Case Insensitive But Dev Server is Case Sensitive (/showthread.php?tid=80411) |
Production Server - Table - Case Insensitive But Dev Server is Case Sensitive - czenmarco - 10-28-2021 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 Any reason why this discrepancy happens ? What can i do ? Thanks. Czen RE: Production Server - Table - Case Insensitive But Dev Server is Case Sensitive - czenmarco - 10-30-2021 Guys ... solved by setting 'lower_case_table_names' ; -- /etc/my.cnf.d/server.cnf ::: [mariadb-5.5] lower_case_table_names=1 |