cpartassides
New Pleskian
centos plesk 10.3.1
------------------------------------------------
adding into my.cnf LOWER_CASE_TABLE_NAMES = 1 which is necessary for my applications work which use mix case SQL queries produced the following error on plesk access.
------------------------------------------------
ERROR: PleskMainDBException
MySQL query failed: Table 'psa.skins' doesn't exist
0: common_func.php3:200
db_query(string 'select `id`,`name`,`place` from Skins where `id`=1')
1: Table.php:154
Table->select()
2: Skin.php:120
Skin->__construct(integer '1')
3: common_func.php3:3262
objectMaker(string 'Skin', integer '1', boolean false, NULL null)
4: common_func.php3:3271
objectMakerEx(string 'Skin', integer '1')
5: Skin.php:588
Skin::initSkin()
6: auth.php3:513
------------------------------------------------
switching back LOWER_CASE_TABLE_NAMES = 0 or removing the entry reverses the issue
Anyone with ideas ?
------------------------------------------------
adding into my.cnf LOWER_CASE_TABLE_NAMES = 1 which is necessary for my applications work which use mix case SQL queries produced the following error on plesk access.
------------------------------------------------
ERROR: PleskMainDBException
MySQL query failed: Table 'psa.skins' doesn't exist
0: common_func.php3:200
db_query(string 'select `id`,`name`,`place` from Skins where `id`=1')
1: Table.php:154
Table->select()
2: Skin.php:120
Skin->__construct(integer '1')
3: common_func.php3:3262
objectMaker(string 'Skin', integer '1', boolean false, NULL null)
4: common_func.php3:3271
objectMakerEx(string 'Skin', integer '1')
5: Skin.php:588
Skin::initSkin()
6: auth.php3:513
------------------------------------------------
switching back LOWER_CASE_TABLE_NAMES = 0 or removing the entry reverses the issue
Anyone with ideas ?