Welcome Guest, Not a member yet? Register   Sign In
Production Server - Table - Case Insensitive But Dev Server is Case Sensitive
#1

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
Reply
#2

Guys ... solved by setting 'lower_case_table_names' ;

-- /etc/my.cnf.d/server.cnf :::

[mariadb-5.5]
lower_case_table_names=1
Reply




Theme © iAndrew 2016 - Forum software by © MyBB