Upgrading from Drupal 4.4 to 4.5
If you upgrade from Drupal 4.4.x, you will need to create the users_roles and locales_meta tables manually before upgrading. To create these tables, issue the following SQL commands:
MySQL specific example:
CREATE TABLE users_roles (
uid int(10) unsigned NOT NULL default '0',
rid int(10) unsigned NOT NULL default '0',
PRIMARY KEY (uid, rid)
);
CREATE TABLE locales_meta (
locale varchar(12) NOT NULL default '',
name varchar(64) NOT NULL default '',
enabled int(2) NOT NULL default '0',
isdefault int(2) NOT NULL default '0',
plurals int(1) NOT NULL default '0',
formula varchar(128) NOT NULL default '',
PRIMARY KEY (locale)
);
PostgreSQL specific example:
CREATE TABLE users_roles (
uid integer NOT NULL default '0',
rid integer NOT NULL default '0',
PRIMARY KEY (uid, rid)
);
CREATE TABLE locales_meta (
locale varchar(12) NOT NULL default '',
name varchar(64) NOT NULL default '',
enabled int4 NOT NULL default '0',
isdefault int4 NOT NULL default '0',
plurals int4 NOT NULL default '0',
formula varchar(128) NOT NULL default '',
PRIMARY KEY (locale)
);
Note from comments:
For upgrading from 4.4 to 4.5 you need to run extra SQL stuff.
If your phpwebdmin broken, you can use this small php script to do the update.
<?php
// Connecting, selecting database
$link = mysql_connect('host', 'dbuname', 'dbpw')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('dbname') or die('Could not select database');
// Performing SQL query
$query = "CREATE TABLE users_roles (uid int(10) unsigned NOT NULL default '0', rid int(10) unsigned NOT NULL default '0',PRIMARY KEY (uid, rid))";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
$query = "CREATE TABLE locales_meta (locale varchar(12) NOT NULL default '',name varchar(64) NOT NULL default '',enabled int(2) NOT NULL default '0',isdefault int(2) NOT NULL default '0',plurals int(1) NOT NULL default '0',formula varchar(128) NOT NULL default '',PRIMARY KEY (locale))";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
// Closing connection
mysql_close($link);
?>