Serendipity Forums

Posted: **Wed Mar 07, 2007 11:07 pm**

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

the update-screen:

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?

Posted: **Thu Mar 08, 2007 3:48 am**

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

Posted: **Thu Mar 08, 2007 8:40 pm**

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?

Posted: **Fri Mar 09, 2007 10:23 am**

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

Posted: **Sat Mar 10, 2007 9:42 pm**

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?

Posted: **Sun Mar 11, 2007 1:36 pm**

Hi!

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

HTH,
Garvin

Serendipity Forums

problem update to current nightly

problem update to current nightly