Support ⇒ New installations :: Archives ⇒ Access denied for user - "Create Index" error on upgrade :: Archived ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexNew installations

Archived ⇒ Access denied for user - "Create Index" error on upgrade


CREATE INDEX physical_filename ON cms_bbattachments_desc (physical_filename)
Access denied for user: 'norbie3@%' to database 'norbie3'

Please contact the CPG-Nuke Dev Team about the error
You cannot continue with the installation


Getting this when trying to upgrade from 9.0.3.5 to 9.0.5.0 (CVS Version) on a secondary site.

I haven't changed any MYSQL permissions, and username/pass etc are all correct.

Any ideas?
Thanks.

Norbie

www.norbiesworld.co.uk

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / Apache Custom Version / 4.0.26-standard (client: 5.0.15) / 4.4.4 / 9.1.1


you sure your sql user is assigned ALL permissions?

NEMINI.org, NEMINI.us, NEMINI.info, NYMINI.org

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
1.3.34 (Unix)/4.1.18-standard/4.4.2 /9.1.0.8 CVS


I have not changed anything since the database was first set up, the database was installed originally in the exact same format as it is now.

Could my host have changed something?

Norbie

www.norbiesworld.co.uk

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / Apache Custom Version / 4.0.26-standard (client: 5.0.15) / 4.4.4 / 9.1.1


go into your hosts cpanl or whatever they use and double check that your database user has been assigned ALL permissions (I've seen several people miss ALTER for some reason which means a new DB will be created fine but you can change it)

NEMINI.org, NEMINI.us, NEMINI.info, NYMINI.org

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
1.3.34 (Unix)/4.1.18-standard/4.4.2 /9.1.0.8 CVS


My host's control panel doesn't let me assign/edit permissions so the only way I can check is by getting them to.

I'll send in a support ticket and let you know.

Thanks for your help Smile

Norbie

www.norbiesworld.co.uk

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / Apache Custom Version / 4.0.26-standard (client: 5.0.15) / 4.4.4 / 9.1.1


Response from my host:

You should have permission to create and alter tables. Could you please give me an example of a query that you can not run.


What should I do next? Email them the link to the install.php (upgrade) ?

Norbie

www.norbiesworld.co.uk

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / Apache Custom Version / 4.0.26-standard (client: 5.0.15) / 4.4.4 / 9.1.1


I'd send them the error message you posted here, that would be the best example of a query that isn't able to run.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux 2.6.9 / 1.3.34 / 4.1.14 / 4.4.1 / CVS


Just received this from them:

I have just tested and you are right there seems to be a problem creating indexes that way. Our admin is currently looking into the cause of this.

Until the problem is found I kindly ask you to use the ALTER command instead:

ALTER TABLE `table` ADD INDEX ( `field` )

I hope this helps a bit.


Is this easily enough done?

Norbie

www.norbiesworld.co.uk

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / Apache Custom Version / 4.0.26-standard (client: 5.0.15) / 4.4.4 / 9.1.1


Try this out... this seems to work. Find this in the upgrade.inc file

// add or modify the indexes

and replace the

$installer->add_query($type, $table, $key, implode(', ', $columns));

with

$installer->add_query('ADD', $table, "INDEX (".implode(', ', $columns).")");




norbie wrote
Just received this from them:

I have just tested and you are right there seems to be a problem creating indexes that way. Our admin is currently looking into the cause of this.

Until the problem is found I kindly ask you to use the ALTER command instead:

ALTER TABLE `table` ADD INDEX ( `field` )

I hope this helps a bit.


Is this easily enough done?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux 4.0.24/Apache/PHP 4.3.11/CPGNuke 9.0.5.0


Thankyou, this worked wonderfully Smile

Norbie

www.norbiesworld.co.uk

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / Apache Custom Version / 4.0.26-standard (client: 5.0.15) / 4.4.4 / 9.1.1


Any ideas how I can change this upgrade file for Downloads Pro so that I can upgrade?

cpgnuke.com/cvs/module....php?v=1.3

Brings back the same error as before - I am obviously unable to use the CREATE command for the time being.

Norbie

www.norbiesworld.co.uk

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / Apache Custom Version / 4.0.26-standard (client: 5.0.15) / 4.4.4 / 9.1.1


Any idea how I get this while upgrading from 9.1.0.7 to 9.1.0.8?

n /install.php While executing query "CREATE UNIQUE INDEX unique_cfg ON cms_config_custom (cfg_name, cfg_field)" the following error occured: INDEX command denied to user: 'web@localhost' for table 'cms_config_custom' In: /home/sites/html/includes/db/mysql_mngr.php on line: 203

I cant even find the upgrade.inc file

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / Apache2.2.8 / MySQL5.0.45 / PHP5.2.6 / CVS


DaveTomneyUK wrote
Any idea how I get this while upgrading from 9.1.0.7 to 9.1.0.8?

INDEX command denied to user: 'web@localhost'


Your Web Host has not given you permission to run INDEX.

Ask them kindly to fix this.

J.
j e r u v y a t y a h o o d o t c o m

Need help? Look here: www.dragonflycms.org/W...d=112.html
Need to chat? Look for me on irc.freenode.net

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Ubuntu7.10/Debian3.1 - 2.2.3/1.3.37 - 5.0.38/4.0.27 - 5.2.1/4.4.7 - CVS/9.1.2}


I'd say he probably did - that post is 18 months old.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


Thanks for the reply Phoenix. Not only was I aware of that, I figured I had two choices. Edit the original post to clearly explain where the problem was for 'future' reference, or add my own reply. I chose the latter, but if you think the former is a better choice (or one of your own) I'm eager to read it.

J.
j e r u v y a t y a h o o d o t c o m

Need help? Look here: www.dragonflycms.org/W...d=112.html
Need to chat? Look for me on irc.freenode.net

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Ubuntu7.10/Debian3.1 - 2.2.3/1.3.37 - 5.0.38/4.0.27 - 5.2.1/4.4.7 - CVS/9.1.2}

All times are UTC