[coin-slider] install issues

**matchboxhero** · 10/27/2010, 11:14

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

imported_Nina · 10/27/2010, 13:03

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?).

**matchboxhero** · 10/27/2010, 13:13

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.

imported_Nina · 10/27/2010, 13:55

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

**matchboxhero** · 10/27/2010, 14:13

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

imported_Nina · 10/27/2010, 15:03

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

**matchboxhero** · 10/27/2010, 15:14

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

**xchs** · 10/28/2010, 01:09

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

**Ben_360fusion** · 11/01/2010, 10:44

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.