Results 1 to 10 of 10

Thread: [coin-slider] install issues

  1. #1
    User
    Join Date
    07-20-09.
    Location
    Middlesbrough - United Kingdom
    Posts
    95

    Default [coin-slider] install issues

    when im trying to install coin-slider i get i wierd error where it is creating and droping tables.



    When i choose no matter which options i choose i get the following error

    Code:
    Fatal error: Uncaught exception Exception  with message Query error: Table 'tl_coinslider' already exists (CREATE TABLE `tl_coinSlider` ( `id` int(10) unsigned NOT NULL auto_increment, `pid` int(10) unsigned NOT NULL default '0', `sorting` int(10) unsigned NOT NULL default '0', `tstamp` int(10) unsigned NOT NULL default '0', `published` char(1) NOT NULL default '', `title` varchar(255) NOT NULL default '', `alias` varchar(128) NOT NULL default '', `width` int(10) unsigned NOT NULL default '0', `height` int(10) unsigned NOT NULL default '0', `spw` int(10) unsigned NOT NULL default '0', `sph` int(10) unsigned NOT NULL default '0', `delay` int(10) unsigned NOT NULL default '0', `sDelay` int(10) unsigned NOT NULL default '0', `opacity` float unsigned NOT NULL default '0', `titleSpeed` int(10) unsigned NOT NULL default '0', `effect` varchar(64) NOT NULL default '', `navigation` char(1) NOT NULL default '', `links` char(1) NOT NULL default '', `hoverPause` char(1) NOT NULL default '', PRIMARY KEY (`id`), KEY `pid` (`pid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;) thrown in D:\wamp\www\mcgee\system\libraries\Database.php  on line 642
    
    #0 D:\wamp\www\mcgee\system\libraries\Database.php(189): Database_Statement->query('CREATE TABLE `t...')
    #1 D:\wamp\www\mcgee\system\modules\rep_client\RepositoryManager.php(424): Database->query('CREATE TABLE `t...')
    #2 D:\wamp\www\mcgee\system\modules\rep_client\RepositoryBackendModule.php(151): RepositoryManager->update('database')
    #3 D:\wamp\www\mcgee\system\modules\backend\BackendModule.php(116): RepositoryBackendModule->compile()
    #4 D:\wamp\www\mcgee\system\modules\rep_client\RepositoryBackendModule.php(88): BackendModule->generate()
    #5 D:\wamp\www\mcgee\system\modules\rep_client\RepositoryManager.php(71): RepositoryBackendModule->generate()
    #6 D:\wamp\www\mcgee\system\modules\backend\Backend.php(186): RepositoryManager->generate()
    #7 D:\wamp\www\mcgee\contao\main.php(101): Backend->getBackendModule('repository_mana...')
    #8 D:\wamp\www\mcgee\contao\main.php(304): Main->run()
    #9 {main}
    anyone know why this is or how to fix it.

    Thanks,
    Ste

  2. #2
    imported_Nina
    Gast

    Default Re: [coin-slider] install issues

    The error message tells you, that there already exists a "tl_coinslider"-table in your database. Because of that it colides with the "Create table tl_coinslider"-action.

    When you look at the initial image, you'll see that first it tries to create both tables and below it asks you do drop both tables. So it seems you already installed it some time ago (maybe manually?).

  3. #3
    User
    Join Date
    07-20-09.
    Location
    Middlesbrough - United Kingdom
    Posts
    95

    Default Re: [coin-slider] install issues

    Its really strange becuase the module works but i get an error when I try to update the database.

    I dont think i have installed it before.

  4. #4
    imported_Nina
    Gast

    Default Re: [coin-slider] install issues

    According to the german board this could be an issue with a database setting (lowercase/uppercase table names). Are you working with a local installation like XAMPP?

    If you are using XAMPP open my.ini (in mysql/bin) and add this in the column [mysqld]
    Code:
    lower_case_table_names  = 2

  5. #5
    User
    Join Date
    07-20-09.
    Location
    Middlesbrough - United Kingdom
    Posts
    95

    Default Re: [coin-slider] install issues

    Hi yeah we are working locally using a WAMP server

    does the above code still apply?

    We have had issues with this and the RSS feed combiner extensions but no other extensions.

    Thanks,
    Ste

  6. #6
    imported_Nina
    Gast

    Default Re: [coin-slider] install issues

    Theoretically it should also apply but I don't know where the MySQL-configuration file is in WAMPP.

  7. #7
    User
    Join Date
    07-20-09.
    Location
    Middlesbrough - United Kingdom
    Posts
    95

    Default Re: [coin-slider] install issues

    Thanks for your help, we will have too look into it.

  8. #8
    Community-Moderator xchs's Avatar
    Join Date
    06-20-09.
    Posts
    1,292

    Default Re: [coin-slider] install issues

    For further information regarding this issue take a look at the according MySQL manual page: http://dev.mysql.com/doc/refman/5.0/en/ ... ivity.html
    Contao Community Moderator
    → Support options

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

    Default Re: [coin-slider] install issues

    I have had this and I edited the QSL file in system/modules/coin_slider/config to have lower case table names for `tl_coinPictures` and `tl_coinSlider` This stops the error occuring but unless the module developer changes these it will happen again once an upgrade is availiable and i upgrade.
    360fusion: Virtual Tours - Web Design
    Social Media: Twitter - Facebook Page

  10. #10
    Community-Moderator xchs's Avatar
    Join Date
    06-20-09.
    Posts
    1,292

    Default Re: [coin-slider] install issues

    Why don't you try the suggestion of Nina?
    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
  •