EGLUG drupal 4.6 upgrade, Test site - Please help.

NOTE: The test site is running on a PII 400 with only 96 MB RAM, It's my home server. It'll be slow, I only have a 256/64 kbps ADSL; So please don't feel like visiting the test site to see something new, It's all the same. Please pass by ONLY if you really want to test.

Once we know that the upgrade was smooth, I shall upgrade the main website.

Please also note that any added content there'll not be migrated to eglug.

All the accounts have been preserved.

Just documenting the steps I did:

1. delete from cache;
2. delete from sessions;
3. edit themes/eglug/template to get rid of query_check() and node_access_join_sql()
4. During the upgrade: ALTER TABLE term_node ADD PRIMARY KEY (tid,nid);

The above query failed because of duplicate entries, I had to remove all the duplicates:

delete from term_node where tid=88 and nid=88;

delete from term_node where tid=0 and nid=88;

delete from term_node where tid=0 and nid=90;

delete from term_node where tid=0 and nid=91;

delete from term_node where tid=0 and nid=808;

delete from term_node where tid=0 and nid=823;

delete from term_node where tid=0 and nid=790;

ALTER TABLE term_node ADD PRIMARY KEY (tid,nid);

Those nodes should be re-tagged, We can do a simple INSERT query.

1. The privatemsg module:

ALTER TABLE privatemsg CHANGE new newmsg tinyint UNSIGNED NOT NULL;

ALTER TABLE privatemsg ADD format int(4) NOT NULL DEFAULT '0';

ALTER TABLE privatemsg_archive ADD format int(4) NOT NULL DEFAULT '0';

UPDATE privatemsg SET format=1;

UPDATE privatemsg_archive SET format=1;

1. The image module: b0rked, The damn module did the same stupid thing when updating foolab.org, The freaking "file copy failed" error.

1. flexinode upgrade: seems fine.

1. event mdule: Make sure to keep fields.inc in the module directory. Not sure whether it worked or not. But anyway:

ALTER TABLE event DROP data;

ALTER TABLE event DROP location;