Tables not Compatible with OSX Servers / Windows

Table names need to be case sensitive for categories and various search functions to work correctly...

 

The MySql variable lower_case_table_names should equal zero to work properly however on

case insensitive files systems like windows and OS X this causes problems:

 

here is an Extract from the MySql User Manual:

On Windows the default value is 1. On OS X, the default value is 2. 

You should not set lower_case_table_names to 0 if you are running MySQL on a system where the data directory resides on a case-insensitive file system (such as on Windows or OS X). It is an unsupported combination that could result in a hang condition when running an INSERT INTO ... SELECT ... FROM tbl_name operation with the wrong tbl_name letter case. With MyISAM, accessing table names using different letter cases could cause index corruption. 

As of MySQL 5.6.27, an error message is printed and the server exits if you attempt to start the server with --lower_case_table_names=0 on a case-insensitive file system. 

If you are using InnoDB tables, you should set this variable to 1 on all platforms to force names to be converted to lowercase. 

The setting of this variable in MySQL 5.6 affects the behavior of replication filtering options with regard to case sensitivity.

Quote · 12 Nov 2015

I reported this some 5 or 6 years ago that they should switch to all lower case .... 

https://dolphin-techs.com - Skype: Dolphin Techs
Quote · 12 Nov 2015

if you installed dolphin on windows while lowercase table names was set to 1 / 2... (windows / OS X defaults)

Once you have managed to change this setting to 0; you can run the following script in PHPMyAdmin to get the tables cases back to what they should be, these are the only differences in table names I have found from the default installation:

 

RENAME TABLE `ddates`.`profiles` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`Profiles`;

 

RENAME TABLE `ddates`.`rayboardboards` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayBoardBoards`;

 

 

RENAME TABLE `ddates`.`rayboardcurrentusers` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayBoardCurrentUsers`;

 

RENAME TABLE `ddates`.`rayboardusers` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayBoardUsers`;

 

RENAME TABLE `ddates`.`raychatcurrentusers` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayChatCurrentUsers`;

 

RENAME TABLE `ddates`.`raychathistory` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayChatHistory`;

 

RENAME TABLE `ddates`.`raychatmemberships` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayChatMemberships`;

 

RENAME TABLE `ddates`.`raychatmembershipssettings` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayChatMembershipsSettings`;

 

RENAME TABLE `ddates`.`raychatmessages` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayChatMessages`;

 

RENAME TABLE `ddates`.`raychatprofiles` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayChatProfiles`;

 

RENAME TABLE `ddates`.`raychatrooms` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayChatRooms`;

 

RENAME TABLE `ddates`.`raychatroomsusers` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayChatRoomsUsers`;

 

RENAME TABLE `ddates`.`rayimcontacts` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayImContacts`;

 

RENAME TABLE `ddates`.`rayimmessages` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayImMessages`;

 

RENAME TABLE `ddates`.`rayimpendings` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayImPendings`;

 

RENAME TABLE `ddates`.`rayimprofiles` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayImProfiles`;

 

RENAME TABLE `ddates`.`raymp3files` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayMp3Files`;

 

RENAME TABLE `ddates`.`raymp3tokens` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayMp3Tokens`;

 

RENAME TABLE `ddates`.`rayshoutboxmessages` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayShoutboxMessages`;

 

RENAME TABLE `ddates`.`rayvideofiles` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayVideoFiles`;

 

RENAME TABLE `ddates`.`rayvideotokens` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayVideoTokens`;

 

RENAME TABLE `ddates`.`rayvideo_commentsfiles` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayVideo_commentsFiles`;

 

RENAME TABLE `ddates`.`rayvideo_commentstokens` TO `ddates`.`TempNameTable`; 

RENAME TABLE `ddates`.`TempNameTable` TO `ddates`.`RayVideo_commentsTokens`;

Quote · 13 Nov 2015

Of course the real solution is for MircoCrap to fix their problem.  By the way, where is the journalled file system that MicroCrap promised?

Geeks, making the world a better place
Quote · 13 Nov 2015
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.