Hallo,
I’ve modx 1.0.2 running well. And I tried to upgrade to 1.0.3. I got this error :
CREATE command denied to user ’myadmin’@’localhost’ for table ’modx_active_users’ during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_active_users` ( `internalKey` int(9) NOT NULL default ’0’, `username` varchar(50) NOT NULL default ’’, `lasthit` int(20) NOT NULL default ’0’, `id` int(10) default NULL, `action` varchar(10) NOT NULL default ’’, `ip` varchar(20) NOT NULL default ’’, PRIMARY KEY (`internalKey`) ) TYPE=MyISAM COMMENT=’Contains data about active users.’.
CREATE command denied to user ’myadmin’@’localhost’ for table ’modx_categories’ during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_categories` ( `id` integer NOT NULL AUTO_INCREMENT, `category` varchar(45) NOT NULL DEFAULT ’’, PRIMARY KEY(`id`) ) Type=MyISAM COMMENT=’Categories to be used snippets,tv,chunks, etc’.
... etc ... etc ...
Does it mean? Is it an database authentication problem or the prefix of my tables is not standart ’modx_’ cause this ?
Thanks.
- pedma -
-
☆ A M B ☆
- 24,524 Posts
If you used a different table prefix, I believe you need to upgrade using the "advanced upgrade" option. You certainly don’t want all the default modx_... tables installed and being used!
Hi Pedma
Once you have selected your language on the install/upgrade screen, you should be presented with 3 options:
New Installation
Upgrade Existing Install
Advanced Upgrade
Selecting advanced upgrade, allows you to set the table prefix etc.
Cheers
Gerard
Many thanks. Modx forum is great ...