problem update to current nightly

[stm999999999]

hello, I have just updated a blog from 1.2-alpha1 to 1.2-alpha2 (current nightly).

the update-screen:

Code: Select all

Die folgenden SQL-Dateien wurden gefunden und müssen nun ausgeführt werden, bevor Serendipity wieder wie gewohnt funktioniert.:
db_update_1.2-alpha1_1.2_alpha2_mysql.sql
db_update_1.2-alpha2_1.1-alpha3_mysql.sql

but an error occurs:

CREATE INDEX categoryso_idx ON s9y_joseph_category (sort_order);
/ Access denied for user 'xxx'@'localhost' to database 'yyy'

Die Serendipity-Installation ist nun auf die Version 1.2-alpha2 aktualisiert!

but this is the correct db-user, db-name and the password in my config-file is correct!

any idea? any suggestion?

[judebert]

Sounds like the db-user isn't allowed to create indexes. You've checked everything else; does the db-user have the correct permissions?

[stm999999999]

hm, but with this user I was able to install s9y w/o any problem - can I see the privileges of my user in phpmyadmin?

[garvinhicking]

Hi!

Maybe your provider changed those!?

Sadly I don't know a way to see your privileges as a non-superuser.

If you can browse the mysql.* tables you could look them up via SQL queries. Else maybe something like "SHOW GRANTS" works or so.

In any cas,e judeberts right, your user does not have "INDEX" privileges.

HTH,
Garvin

[stm999999999]

hm,

Code: Select all

GRANT USAGE ON *.* TO 'xxx'@'localhost' IDENTIFIED BY PASSWORD 'xxx'

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `xxx.* TO 'xxx'@'localhost' WITH GRANT OPTION

I should talk to my hoster, or?

[garvinhicking]

Hi!

Yes, becaues 'INDEX' is missing in the list.

HTH,
Garvin