Serendipity Forums

Posted: **Sun Apr 10, 2005 6:49 pm**

When executing the sql update script it gave me an error, now I tried to apply it manually with phpmyadmin:

@ALTER TABLE {PREFIX}suppress DROP INDEX url_idx;
CREATE INDEX url_idx on {PREFIX}suppress (host, ip);

Code: Select all

Error
SQL-query:
@ALTER TABLE {PREFIX}suppress DROP INDEX url_idx

MySQL said:
#1064 - You have an error in your SQL syntax near '@ALTER TABLE {PREFIX}suppress DROP INDEX url_idx' at line 1

MfG. Psy

Posted: **Sun Apr 10, 2005 8:14 pm**

Which error did the upgrade script give you?

If you execute the SQL manually you need to

1. Remove the '@' from Alter table statement
2. Replace {PREFIX} with the dbPrefix you chose. Usually that is 'serendipity_'.

Regards,
Garvin

Posted: **Mon Apr 11, 2005 9:27 pm**

It gave me a permission error.

Applying it manually with phpmyadmin gave me a permission error, too:
#1044 - Access denied for user: 'xxx@localhost' to database 'xxx'

The rights were set up correctly, user has rights to "SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER"

However, performing it this way worked:
ALTER TABLE serendipity_suppress DROP INDEX url_idx;

ALTER TABLE `serendipity_suppress` ADD INDEX `url_idx` ( `host` , `ip` );

MySQL version used: MySQL 3.23.58
phpmyadmin version used: phpMyAdmin 2.6.1-pl3

And thanks for your help

MfG. Psy

Serendipity Forums

Problem upgrading 0.8-beta5 to 0.8-beta6

Problem upgrading 0.8-beta5 to 0.8-beta6

Re: Problem upgrading 0.8-beta5 to 0.8-beta6