Results 1 to 4 of 4

Thread: FlexSlider Database SQL error

  1. #1
    User
    Join Date
    06-20-09.
    Location
    Middlesbrough, UK
    Posts
    246

    Default FlexSlider Database SQL error

    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
    360fusion: Virtual Tours - Web Design
    Social Media: Twitter - Facebook Page

  2. #2
    Community-Moderator xchs's Avatar
    Join Date
    06-19-09.
    Posts
    1,278

    Default

    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
    Contao Community Moderator
    → Support options

  3. #3
    User
    Join Date
    06-20-09.
    Location
    Middlesbrough, UK
    Posts
    246

    Default

    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?
    360fusion: Virtual Tours - Web Design
    Social Media: Twitter - Facebook Page

  4. #4
    Community-Moderator xchs's Avatar
    Join Date
    06-19-09.
    Posts
    1,278

    Default

    Yes, preferably only lower case database table names.
    Contao Community Moderator
    → Support options

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •