Hi,
When using the installer to setup the Gallery where I enter my mySQL database authenication information, the following error message is returned :
mysqli): SHOW TABLES
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysqli): CREATE TABLE gtst0Schema( g_name varchar(128) NOT NULL, g_major int(11) NOT NULL, g_minor int(11) NOT NULL, PRIMARY KEY(g_name) ) /*!40100 DEFAULT CHARACTER SET utf8 */
--------------------------------------------------------------------------------
Query: CREATE TABLE gtst0Schema( g_name varchar(128) NOT NULL, g_major int(11) NOT NULL, g_minor int(11) NOT NULL, PRIMARY KEY(g_name) ) /*!40100 DEFAULT CHARACTER SET utf8 */ failed. CREATE command denied to user 'gecko_gecko'@'localhost' for table 'gtst0Schema'
1142: CREATE command denied to user 'gecko_gecko'@'localhost' for table 'gtst0Schema'
ADOConnection._Execute(CREATE TABLE gtst0Schema(
g_name varchar(128) NOT NULL,
g_major int(11) NOT NULL,
g_minor int(11) NOT NULL,
PRIMARY KEY(g_na..., false) % line 891, file: adodb.inc.php
ADOConnection.Execute(CREATE TABLE gtst0Schema(
g_name varchar(128) NOT NULL,
g_major int(11) NOT NULL,
g_minor int(11) NOT NULL,
PRIMARY KEY(g_na...) % line 502, file: DatabaseSetupStep.class
DatabaseSetupStep._executeSql(CREATE TABLE DB_TABLE_PREFIXSchema(
DB_COLUMN_PREFIXname varchar(128) NOT NULL,
DB_COLUMN_PREFIXmajor int(11) NOT NULL,
DB_CO..., gtst0) % line 450, file: DatabaseSetupStep.class
DatabaseSetupStep._testPrivileges(mysql, Array[6]) % line 203, file: DatabaseSetupStep.class
DatabaseSetupStep.loadTemplateData(Array[2]) % line 170, file: index.php
I'm tsaking a guess that new tables cannot be created, perhaps due to priveledges setup on my server, which prevents me (the SQL script) from adding tables to the database. That would be my guess.
But if anyone can point out what the problem may be and how to colve it, I'd very much appreciate it!
Thanks!
Posted: Fri, 2009-01-30 14:10
