Ubuntu
serendipity package

apt: DB upgrade failed. Serendipity is broken. How to proceed?

Asked by Hannes

When running "apt-get upgrade", I got the error message that the upgrade failed due to "Duplicate key name 'pluginretr_idx' ".

Apt tells me that there is a database backup at /var/cache... but I don't know how to proceed to get either the old, or the new version running.

Currently, my serendipity site shows three errors:

1) Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'www-data'@'localhost' (using password: NO) in /usr/share/serendipity/www/include/db/mysql.inc.php on line 270

2) Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'www-data'@'localhost' (using password: NO) in /usr/share/serendipity/www/include/db/mysql.inc.php on line 271

3) Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /usr/share/serendipity/www/include/db/mysql.inc.php on line 271
serendipity error: unable to connect to database - exiting.

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu serendipity Edit question
Assignee:
No assignee Edit question
Solved by:
Hannes
Solved:
Last query:
Last reply:
Revision history for this message
Hannes (derhannes) said : 		#1

Solved.

- Reinstalled serendipity (this included dropping/deleting the old "serendipity" mysql table and adjusting the "serendipity" mysql user account's password)
- read the db backup back into the newly created "serendipity" mysql table