asked on

PLESK with Mysql varialbel lower_case_table_names = 1

I managed to change MYSQL lower_case_table_names=1 instead of 0
Running Linux Redhat with PLESK 9.01

Unless i change value back to 0 i get an error on plesk login screen
ERROR: PleskMainDBException
MySQL query failed: Table 'psa.skins' doesn't exist

0: /usr/local/psa/admin/plib/common_func.php3:168
      db_query(string 'select `id`,`name`,`place` from Skins where `id`=18')
1: /usr/local/psa/admin/plib/class.Table.php:183
      Table->select()
2: /usr/local/psa/admin/plib/skin/Skin.php:52
      Skin->Skin(integer '18')
3: /usr/local/psa/admin/plib/common_func.php3:3115
      objectMaker(string 'Skin', integer '18')
4: /usr/local/psa/admin/auto_prepend/auth.php3:485

Umesh

Pls check this once... http://www.mail-archive.com/mysql@lists.mysql.com/msg16280.html

Your rename command should be (INSTEAD OF ALTER)

RENAME TABLE old_table_name TO new_table_name;

rionroc

Hello

Try to set
lower_case_table_names = 2

ASKER CERTIFIED SOLUTION

Umesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CMDAI

ASKER

Ok i think i have everything now,
MYSQL config changed lower case table names = 1
PLESK & phpmyadmin changed all tables in the db lower case
Seem to have all controls working now

Thanks for answering all my questions, here and before.
I feel along the way i got some good information about linux,mysql,plesk

https://www.experts-exchange.com/questions/24194271/Change-Mysql-Config-Linux-shell-access.html
https://www.experts-exchange.com/questions/24192997/How-to-change-lower-case-table-names-to-1.html

CMDAI

ASKER

and i almost did set lower_case_table_names = 2 but read somewhere that this is not advised for relation dbs

rionroc

Sorry I did not really catch the question, that he has made changes to 0 instead of 1, then why not turn it back to 1. So it must be 1.

CMDAI

ASKER

My initial problem was i need to change the value 0 to 1 but once i did that my plesk control panel & MyPHPAdmin panel didnt work as they where installed when lower_case_table_names was set to 0.
It's all working now.

neffen

Hello,

had same problem. This solved it: on the database 'psa' run the following SQL commands:

RENAME TABLE APSApplicationItems to apsapplicationitems ;
RENAME TABLE APSCatalogUpdates to apscatalogupdates ;
RENAME TABLE APSClientApplicationItems to apsclientapplicationitems ;
RENAME TABLE APSLicenses to apslicenses ;
RENAME TABLE APSLicenseTypes to apslicensetypes ;
RENAME TABLE BackendCache to backendcache ;
RENAME TABLE BackupsRunning to backupsrunning ;
RENAME TABLE BackupsScheduled to backupsscheduled ;
RENAME TABLE BackupsSettings to backupssettings ;
RENAME TABLE BillingCache to billingcache ;
RENAME TABLE Cards to cards ;
RENAME TABLE ClientsTraffic to clientstraffic ;
RENAME TABLE Components to components ;
RENAME TABLE DashboardPreset to dashboardpreset ;
RENAME TABLE DashboardPresetConfig to dashboardpresetconfig ;
RENAME TABLE DatabaseServers to databaseservers ;
RENAME TABLE DomainServices to domainservices ;
RENAME TABLE DomainsTraffic to domainstraffic ;
RENAME TABLE IP_Addresses to ip_addresses ;
RENAME TABLE Limits to limits ;
RENAME TABLE ListsParams to listsparams ;
RENAME TABLE Logos to logos ;
RENAME TABLE MailLists to maillists ;
RENAME TABLE Modules to modules ;
RENAME TABLE NewsArticles to newsarticles ;
RENAME TABLE Notes to notes ;
RENAME TABLE Notifications to notifications ;
RENAME TABLE Parameters to parameters ;
RENAME TABLE Permissions to permissions ;
RENAME TABLE PersistentCache to persistentcache ;
RENAME TABLE PMM to pmm ;
RENAME TABLE PMMDefault to pmmdefault ;
RENAME TABLE Repository to repository ;
RENAME TABLE SBConfig to sbconfig ;
RENAME TABLE SBResellers to sbresellers ;
RENAME TABLE SBSites to sbsites ;
RENAME TABLE SiteAppFiles to siteappfiles ;
RENAME TABLE SiteAppPackages to siteapppackages ;
RENAME TABLE SiteAppResources to siteappresources ;
RENAME TABLE SiteApps to siteapps ;
RENAME TABLE SiteAppsHitsStat to siteappshitsstat ;
RENAME TABLE Skins to skins ;
RENAME TABLE SSOBranding to ssobranding ;
RENAME TABLE Templates to templates ;
RENAME TABLE TmplData to tmpldata ;
RENAME TABLE WebApps to webapps ;
RENAME TABLE Webmails to webmails;

Open in new window

CMDAI

ASKER

This is usefull :), cas i had to do all the tables by hand