Mandatory information about my setup:
Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? yes
PHP Built On Linux ubuntu 2.6.32-24-server #43-Ubuntu SMP Thu Sep 16 16:05:42 UTC 2010 x86_64
Database Version 5.1.41-3ubuntu12.10
Database Collation utf8_general_ci
PHP Version 5.3.2-1ubuntu4.18
Web Server Apache/2.2.14 (Ubuntu)
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 2.5.6 Stable [ Ember ] 19-June-2012 14:00 GMT
Joomla! Platform Version Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0
Description of my issue:
Cannot install Admin tools on my webbsite.
JInstaller: :Install: Error SQL DB function failed with error number 1142
CREATE command denied to user 'cms'@'localhost' for table 'bkqcf_admintools_acl' SQL=CREATE TABLE IF NOT EXISTS `bkqcf_admintools_acl` ( `user_id` bigint(20) unsigned NOT NULL, `permissions` mediumtext, PRIMARY KEY (`user_id`) ) DEFAULT COLLATE utf8_general_ci CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `#__admintools_acl` (
`user_id` bigint(20) unsigned NOT NULL,
`permissions` mediumtext,
PRIMARY KEY (`user_id`)
) DEFAULT COLLATE utf8_general_ci CHARSET=utf8;
Component Install: SQL error file DB function failed with error number 1142
CREATE command denied to user 'cms'@'localhost' for table 'bkqcf_admintools_acl' SQL=CREATE TABLE IF NOT EXISTS `bkqcf_admintools_acl` ( `user_id` bigint(20) unsigned NOT NULL, `permissions` mediumtext, PRIMARY KEY (`user_id`) ) DEFAULT COLLATE utf8_general_ci CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `#__admintools_acl` (
`user_id` bigint(20) unsigned NOT NULL,
`permissions` mediumtext,
PRIMARY KEY (`user_id`)
) DEFAULT COLLATE utf8_general_ci CHARSET=utf8;
Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? yes
PHP Built On Linux ubuntu 2.6.32-24-server #43-Ubuntu SMP Thu Sep 16 16:05:42 UTC 2010 x86_64
Database Version 5.1.41-3ubuntu12.10
Database Collation utf8_general_ci
PHP Version 5.3.2-1ubuntu4.18
Web Server Apache/2.2.14 (Ubuntu)
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 2.5.6 Stable [ Ember ] 19-June-2012 14:00 GMT
Joomla! Platform Version Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0
Description of my issue:
Cannot install Admin tools on my webbsite.
JInstaller: :Install: Error SQL DB function failed with error number 1142
CREATE command denied to user 'cms'@'localhost' for table 'bkqcf_admintools_acl' SQL=CREATE TABLE IF NOT EXISTS `bkqcf_admintools_acl` ( `user_id` bigint(20) unsigned NOT NULL, `permissions` mediumtext, PRIMARY KEY (`user_id`) ) DEFAULT COLLATE utf8_general_ci CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `#__admintools_acl` (
`user_id` bigint(20) unsigned NOT NULL,
`permissions` mediumtext,
PRIMARY KEY (`user_id`)
) DEFAULT COLLATE utf8_general_ci CHARSET=utf8;
Component Install: SQL error file DB function failed with error number 1142
CREATE command denied to user 'cms'@'localhost' for table 'bkqcf_admintools_acl' SQL=CREATE TABLE IF NOT EXISTS `bkqcf_admintools_acl` ( `user_id` bigint(20) unsigned NOT NULL, `permissions` mediumtext, PRIMARY KEY (`user_id`) ) DEFAULT COLLATE utf8_general_ci CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `#__admintools_acl` (
`user_id` bigint(20) unsigned NOT NULL,
`permissions` mediumtext,
PRIMARY KEY (`user_id`)
) DEFAULT COLLATE utf8_general_ci CHARSET=utf8;
