By peterx on

Does RC2 have any differences in the database, admin or require changes to modules?

I switched from RC1 to RC2 by dumping RC2 over RC1, copying some database settings from the old settings.inc to the new settings.inc and then running update.php. Update.php did not report any changes. I am wondering if there were any changes to the way the data is used?

During quick look through the admin section I did not spot any changes. The changelog suggested RC2 has only minor code changes that do not create any new functions or settings.

The only thing not working in my test site is path but that did not work in RC1. As soon as I can get path working, I can use RC2 for live Web sites.

If that is all then RC2 is an easy upgrade from RC1. So easy that it surprised me. Has anyone hit problems?

⋅ Categories: Drupal 4.7.x

Comments

erdemkose’s picture

erdemkose commented

I have just updated my Drupal 4.7 RC1 to 4.7 RC2 and didn't see any database update. I have looked at recent CVS messages and I think there is no database structure change.

--------------------------------------------------------------
http://www.students.itu.edu.tr/~koseer/drupal/ - works on PHP-TXT-DB database layer.

robhamm’s picture

robhamm commented

I tried running the update script and got the following errors:

* user warning: Duplicate column name 'severity' query: ALTER TABLE watchdog ADD severity tinyint(3) unsigned NOT NULL default '0' in /home/worldfor/public_html/testbed/includes/database.mysql.inc on line 120.
* user warning: Duplicate column name 'referer' query: ALTER TABLE watchdog ADD COLUMN referer varchar(128) NOT NULL in /home/worldfor/public_html/testbed/includes/database.mysql.inc on line 120.
* user warning: Duplicate column name 'cache' query: ALTER TABLE sessions ADD cache int(11) NOT NULL default '0' AFTER timestamp in /home/worldfor/public_html/testbed/includes/database.mysql.inc on line 120.

I'll try doing it without running the update and see how things go.

Rob Hamm
http://www.bookmuncher.com

kzeng’s picture

kzeng commented

I update my website from beta-6 to RC2. there was no database update. I just found that RC2 killed some bugs I encountered when using beta-6, which is really great!

--------------------------
http://www.kzeng.info

Steven’s picture

Steven commented

In 4.7 the update system changed so it is more specific about which database schema version you have. Running update.php again never hurts, provided you don't change the suggested selection of updates.

--
If you have a problem, please search before posting a question.

peterx’s picture

peterx commented

4.7 has better admin screens than 4.6. I did not see any differences between RC1 and RC2. I found that I could change several things in the admin instead of having to add code to my theme. That means less custom code to maintain.

The Category module did not work 100% with RC1. I have not tried the latest version with RC2. Once Category is fully developed then most of my custom code will disappear and my theme will contain only the theme. I am looking forward to the final release of Drupal 4.7 and the final release of the Category module for 4.7.

petermoulding.com/web_architect

petermoulding.com/web_architect

peterx’s picture

peterx commented

Bug fixing for 4.7 is faster and smoother than for 4.6. Few commercial organisations, with all the expensive licensing money in their pocket, could match the clean up rate for Drupal 4.7.

"Many fingers make light work." Congratulations to those many fingers who make Drupal work.

petermoulding.com/web_architect

petermoulding.com/web_architect

peterx’s picture

peterx commented

Questions about upgrade process: http://drupal.org/node/57886

petermoulding.com/web_architect

petermoulding.com/web_architect

peterx’s picture

peterx commented

I updated RC2 to RC3 and there were no database changes.

petermoulding.com/web_architect

petermoulding.com/web_architect

peterx’s picture

peterx commented

For those who are wondering what update.php does, here is the log from Drupal 4.7.0 RC3 update.php when applied to a Drupal 4.6.5 site.

Drupal database update

Updates were attempted. If you see no failures below, you may proceed happily to the administration pages. Otherwise, you may need to update your database manually. All errors have been logged.

    * main page
    * administration pages

The following queries were executed
system module
Update #129

    * ALTER TABLE {vocabulary} ADD tags tinyint(3) unsigned default '0' NOT NULL

Update #130

    * No queries

Update #131

    * ALTER TABLE {boxes} DROP INDEX title

Update #132

    * No queries

Update #133

    * CREATE TABLE {contact} ( subject varchar(255) NOT NULL default '', recipients longtext NOT NULL default '', reply longtext NOT NULL default '' )
    * ALTER TABLE {users} ADD login int(11) NOT NULL default '0'

Update #134

    * ALTER TABLE {blocks} DROP types

Update #135

    * No queries

Update #136

    * ALTER TABLE {users} CHANGE COLUMN changed access int(11) NOT NULL default '0'
    * UPDATE {users} SET access = login WHERE login > created
    * UPDATE {users} SET access = created WHERE access = 0

Update #137

    * ALTER TABLE {locales_source} CHANGE location location varchar(255) NOT NULL default ''

Update #138

    * INSERT INTO {url_alias} (src, dst) VALUES ('node/feed', 'rss.xml')

Update #139

    * ALTER TABLE {accesslog} ADD timer int(10) unsigned NOT NULL default '0'

Update #140

    * ALTER TABLE {url_alias} ADD INDEX (src)

Update #141

    * No queries

Update #142

    * No queries

Update #143

    * ALTER TABLE {contact} CHANGE subject category VARCHAR(255) NOT NULL
    * ALTER TABLE {contact} ADD PRIMARY KEY (category)

Update #144

    * ALTER TABLE {node} CHANGE type type VARCHAR(32) NOT NULL

Update #145

    * ALTER TABLE {blocks} CHANGE region region varchar(64) default 'left' NOT NULL
    * ALTER TABLE {blocks} ADD theme varchar(255) NOT NULL default ''
    * UPDATE {blocks} SET region = 'left' WHERE region = '0'
    * UPDATE {blocks} SET region = 'right' WHERE region = '1'

Update #146

    * CREATE TABLE {node_revisions} SELECT nid, nid AS vid, uid, type, title, body, teaser, changed AS timestamp, format FROM {node}
    * ALTER TABLE {node_revisions} CHANGE nid nid int(10) unsigned NOT NULL default '0'
    * ALTER TABLE {node_revisions} ADD log longtext
    * ALTER TABLE {node} ADD vid int(10) unsigned NOT NULL default '0'
    * ALTER TABLE {files} ADD vid int(10) unsigned NOT NULL default '0'
    * ALTER TABLE {book} ADD vid int(10) unsigned NOT NULL default '0'
    * ALTER TABLE {forum} ADD vid int(10) unsigned NOT NULL default '0'
    * ALTER TABLE {book} DROP PRIMARY KEY
    * ALTER TABLE {forum} DROP PRIMARY KEY
    * ALTER TABLE {files} DROP PRIMARY KEY
    * UPDATE {node} SET vid = nid
    * UPDATE {forum} SET vid = nid
    * UPDATE {book} SET vid = nid
    * UPDATE {files} SET vid = nid
    * ALTER TABLE {book} ADD PRIMARY KEY vid (vid)
    * ALTER TABLE {forum} ADD PRIMARY KEY vid (vid)
    * ALTER TABLE {node_revisions} ADD PRIMARY KEY vid (vid)
    * ALTER TABLE {node_revisions} ADD KEY nid (nid)
    * ALTER TABLE {node_revisions} ADD KEY uid (uid)
    * CREATE TABLE {old_revisions} SELECT nid, type, revisions FROM {node} WHERE revisions != ''
    * ALTER TABLE {book} ADD KEY nid (nid)
    * ALTER TABLE {forum} ADD KEY nid (nid)
    * ALTER TABLE {files} ADD KEY fid (fid)
    * ALTER TABLE {files} ADD KEY vid (vid)
    * INSERT INTO {sequences} (name, id) VALUES ('{node_revisions}_vid', 383)
    * ALTER TABLE {book} DROP log
    * ALTER TABLE {node} DROP teaser
    * ALTER TABLE {node} DROP body
    * ALTER TABLE {node} DROP format
    * ALTER TABLE {node} DROP revisions

Update #147

    * ALTER TABLE {node_revisions} DROP type

Update #148

    * ALTER TABLE {accesslog} ADD sid varchar(32) NOT NULL default ''

Update #149

    * ALTER TABLE {files} ADD COLUMN description VARCHAR(255) NOT NULL DEFAULT ''

Update #150

    * DELETE FROM {variable} WHERE name = 'node_cron_last'
    * DELETE FROM {variable} WHERE name = 'minimum_word_size'
    * DELETE FROM {variable} WHERE name = 'remove_short'
    * DELETE FROM {node_counter} WHERE nid = 0
    * DROP TABLE {search_index}
    * DROP TABLE {search_total}
    * CREATE TABLE {search_dataset} ( sid int(10) unsigned NOT NULL default '0', type varchar(16) default NULL, data longtext NOT NULL, KEY sid_type (sid, type) )
    * CREATE TABLE {search_index} ( word varchar(50) NOT NULL default '', sid int(10) unsigned NOT NULL default '0', type varchar(16) default NULL, fromsid int(10) unsigned NOT NULL default '0', fromtype varchar(16) default NULL, score float default NULL, KEY sid_type (sid, type), KEY from_sid_type (fromsid, fromtype), KEY word (word) )
    * CREATE TABLE {search_total} ( word varchar(50) NOT NULL default '', count float default NULL, PRIMARY KEY word (word) )

Update #151

    * INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (1110, 0, '', 'Primary links', '', 0, 115)
    * INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (1111, 1110, 'admin/themes/settings\" class=\"active', 'edit primary links', '', 0, 118)
    * INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (1112, 0, '', 'Secondary links', '', 0, 115)
    * INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (1113, 1112, 'admin/themes/settings\" class=\"active', 'edit secondary links', '', 0, 118)
    * UPDATE {system} SET status = 1 WHERE name = 'menu'

Update #152

    * No queries

Update #153

    * ALTER TABLE {contact} DROP PRIMARY KEY
    * ALTER TABLE {contact} ADD COLUMN cid int(11) NOT NULL PRIMARY KEY auto_increment
    * ALTER TABLE {contact} ADD UNIQUE KEY category (category)

Update #154

    * ALTER TABLE {contact} ADD COLUMN weight tinyint(3) NOT NULL DEFAULT 0
    * ALTER TABLE {contact} ADD COLUMN selected tinyint(1) NOT NULL DEFAULT 0

Update #155

    * No queries

Update #156

    * DELETE FROM {cache}

Update #157

    * DELETE FROM {url_alias} WHERE src = 'node/feed' AND dst = 'rss.xml'
    * INSERT INTO {url_alias} (src, dst) VALUES ('rss.xml', 'node/feed')

Update #158

    * ALTER TABLE {old_revisions} ADD done tinyint(1) NOT NULL DEFAULT 0
    * ALTER TABLE {old_revisions} ADD INDEX (done)

Update #159

    * UPDATE {sequences} SET id = 384 WHERE name = '{node_revisions}_vid'
    * ALTER TABLE {old_revisions} DROP done

Update #160

    * No queries

Update #161

    * No queries

Update #162

    * No queries

Update #163

    * ALTER TABLE {cache} CHANGE data data LONGBLOB

Update #164

    * CREATE TABLE {poll_votes} ( nid int(10) unsigned NOT NULL, uid int(10) unsigned NOT NULL default 0, hostname varchar(128) NOT NULL default '', INDEX (nid), INDEX (uid), INDEX (hostname) )
    * ALTER TABLE {poll} DROP polled

Update #165

    * No queries

Update #166

    * DROP TABLE {directory}
    * CREATE TABLE {client} ( cid int(10) unsigned NOT NULL auto_increment, link varchar(255) NOT NULL default '', name varchar(128) NOT NULL default '', mail varchar(128) NOT NULL default '', slogan longtext NOT NULL, mission longtext NOT NULL, users int(10) NOT NULL default '0', nodes int(10) NOT NULL default '0', version varchar(35) NOT NULL default'', created int(11) NOT NULL default '0', changed int(11) NOT NULL default '0', PRIMARY KEY (cid) )
    * CREATE TABLE {client_system} ( cid int(10) NOT NULL default '0', name varchar(255) NOT NULL default '', type varchar(255) NOT NULL default '', PRIMARY KEY (cid,name) )

Update #167

    * ALTER TABLE {vocabulary_node_types} CHANGE type type varchar(32) NOT NULL default ''

Update #168

    * ALTER TABLE {term_hierarchy} ADD PRIMARY KEY (tid, parent)

Update #169

    * No queries

Update #170

    * No queries

Update #171

    * DELETE FROM {users_roles} WHERE rid IN (1, 2)

Update #172

    * No queries

Update #173

    * CREATE TABLE {files_backup} SELECT * FROM {files}
    * DELETE FROM {files} WHERE fid = 0
    * UPDATE {files} SET vid = nid WHERE vid = 0
    * CREATE TABLE {files_tmp} SELECT * FROM {files}
    * DROP TABLE {files}
    * CREATE TABLE {file_revisions} ( fid int(10) unsigned NOT NULL default 0, vid int(10) unsigned NOT NULL default 0, description varchar(255) NOT NULL default '', list tinyint(1) unsigned NOT NULL default 0, PRIMARY KEY (fid, vid) ) /*!40100 DEFAULT CHARACTER SET utf8 */
    * INSERT INTO {file_revisions} SELECT DISTINCT fid , vid, description, list FROM {files_tmp}
    * CREATE TABLE {files} ( fid int(10) unsigned NOT NULL default 0, nid int(10) unsigned NOT NULL default 0, filename varchar(255) NOT NULL default '', filepath varchar(255) NOT NULL default '', filemime varchar(255) NOT NULL default '', filesize int(10) unsigned NOT NULL default 0, PRIMARY KEY (fid) ) /*!40100 DEFAULT CHARACTER SET utf8 */
    * INSERT INTO {files} SELECT DISTINCT fid, nid, filename, filepath, filemime, filesize FROM {files_tmp}
    * DROP TABLE {files_tmp}
    * DROP TABLE {files_backup}

Update #174

    * No queries

Update #175

    * No queries

Update #176

    * ALTER TABLE {filter_formats} ADD UNIQUE (name)

Update #177

    * No queries

Update #178

    * No queries

Update #179

    * No queries

petermoulding.com/web_architect

petermoulding.com/web_architect

peterx’s picture

peterx commented

No database updates. http://drupal.org/node/59466 still exists. Everything else looks good.

petermoulding.com/web_architect

petermoulding.com/web_architect