On Tue, Feb 01, 2005 at 10:38:39AM +0100, Hilko Bengen wrote:
> James Clark <[EMAIL PROTECTED]> writes:
>
> > Fatal error: Table 'drupal.users_roles' doesn't exist query: SELECT r.rid,
> > r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE
> > ur.uid = 1 in /usr/share/drupal/includes/database.mysql.inc on line 125
>
> Unfortunately, you didn't tell me from which version you upgraded.
Whichever version was prior I would imagine, I upgrade at least once a week.
> It looks as if the database upgrade procedure hadn't been run. You can
> still run it manually.
Perhaps I missed something, I've tried a reconfigure, but it doesn't
appear to have helped, output below:
Did you bounce my message to [EMAIL PROTECTED], if so it
was rejected.
Appreciate your help.
Cheers,
James.
</snip>
debian:~# dpkg-reconfigure drupal
Configuring drupal
------------------
Drupal needs access to a database, along with initialized data structures
in order to function properly. This can be created automatically by this
package, for MySQL or PostgreSQL databases. Automatically creating the
database does not make sense if a Drupal database already exists or if
no database server has been setup when Drupal is installed.
Automatically create Drupal database? n
If you are upgrading Drupal from an older upstream version, the database
structure needs to be updated. This package can perform this task
automatically.
The database will be backed up to prevent data loss.
Run database update script? y
1. MySQL 2. PostgreSQL
Database engine to be used with Drupal 1
Database server for Drupal's database localhost
The answer will not be stored anywhere permanently.
Database server administrator user name on host localhost root
The answer will not be stored anywhere permanently.
Password for database server administrator root on host localhost
This username will be used by Drupal to connect to the database server.
Drupal database owner username drupal
If no password is specified here, a random password will be generated.
Drupal database owner password
Drupal database name drupal
Remove Drupal database when the package is removed? n
These backups are stored in /var/lib/drupal/backups. This will not
remove the current database from the DBMS.
Remove former database backups when the package is removed? n
1. apache 2. apache-ssl 3. apache-perl 4. apache2 5. none of the above
(Enter the items you want to select, separated by spaces.)
Web server(s) that should be configured automatically 1
I: Attempting to update database
An override for "/var/lib/drupal/files" already exists, but --force
specified so lets ignore it.
</snip>
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
