FlexSlider Database SQL error

[Ben_360fusion]

We are having an issue with this module.

When it is installed the database fields keep appearing to be created and dropped in the updates database section.

This is because the table names are in upper case in \system\modules\flexslider\config\database.sql

CREATE TABLE `tl_flexSlider`
CREATE TABLE `tl_flexPictures`

Should be:

CREATE TABLE `tl_flexslider`
CREATE TABLE `tl_flexpictures`

this will stop it showing in the updates database section

[xchs]

Yeah, that's the well known problem with the upper/lower case database table names. It's mainly an issue on Windows systems.

What to do:

• edit the MySQL configuration file "my.ini"
• add the setting lower_case_table_names = 2 in the [mysqld] section
• restart the MySQL server

[Ben_360fusion]

Thanks for the info, we have made these changes to our server.

Surely though it is just best practice to not use capitals when naming database tables?

[xchs]

Yes, preferably only lower case database table names.