Problem I:

I got the following error message after the db script finished running. Is this something serious or can I ignore this or can I set this right in some way?

Drupal database update

* user warning: Column 'title' cannot be part of FULLTEXT index query: ALTER TABLE node CHANGE `type` `type` varbinary(32) DEFAULT '' NOT NULL, CHANGE `title` `title` varbinary(128) DEFAULT '' NOT NULL in /home/ciosaorg/public_html/47upgrade/includes/database.mysql.inc on line 120.
* user warning: Column 'name' cannot be part of FULLTEXT index query: ALTER TABLE term_data CHANGE `name` `name` varbinary(255) DEFAULT '' NOT NULL, CHANGE `description` `description` longblob DEFAULT '' NULL in /home/ciosaorg/public_html/47upgrade/includes/database.mysql.inc on line 120.

Problem II:
On the admin page, the settings are not collapsed but expanded. All the nodes made it through the update and the version of the updated site is correctly reported as 4.7.0, so I wonder what's wrong.

Problem III:
Exactly how do I update the contrib modules? They got deleted when I installed 4.7. Is it as simple as installing the 4.7 versions of those modules and enabling them at administer>>modules or is there anything else I should do? Many modules (flexinode, event) do not seem to have an update script to run.

Thanks in advance for any answers and apologies if all this has been answered for the nth time.

Comments

venkat-rk’s picture

I found this in the handbook page about optional steps:

We have developed a way to automatically update your modules in Drupal 4.7. Make sure the modulename.install file from the Drupal 4.7 version of your modules is in the modules directory and the update system will update your modules when you go to update.php.

Does this mean you simply install the 4.7 module, enable it at administer>>modules and then run www.yoursite.com/update.php?

pwolanin’s picture

Yes, that's pretty much it. Even simpler is to collect and upload the latest versions when you update the drupal core, and then all the install files will run when you run update.php for the core. You don't need to ever disable the modules.

---
Work: BioRAFT

venkat-rk’s picture

Thanks for the confirmation. I took a chance and went ahead and installed the 4.7 modules and they work fine except admin log reporting that the tables for those modules already exist.

I still face a couple of problems:

1.) Image module has its own update script, but when I ran it at www.mysite.com/drupal_upgrade_test/update-image.php, I got a blank page in the browser and admin log reported the following error:
Table 'ciosaorg_47upgrade.image' doesn't exist query: SELECT * FROM image in /home/domain/public_html/47upgrade/includes/database.mysql.inc on line 120.

2.) uid1 seems to have lost the permission for creating new flexinode types. I installed flexinode and the install went fine and all the previous flexinode based content types show up, but I cannot see anywhere the link to create a new flexinode content type.

I will be thankful for any suggestions.

venkat-rk’s picture

Guess what, the tab for adding a new flexinode content type is at administer>>content, so this is looking a much better upgrade than I had ever hoped. Now, if only flexinode 4.7 could provide the .inc files...

KuroNeko’s picture

I'm having the same problem you described. Did you find a solution?

1.) Image module has its own update script, but when I ran it at www.mysite.com/drupal_upgrade_test/update-image.php, I got a blank page in the browser and admin log reported the following error:
Table 'ciosaorg_47upgrade.image' doesn't exist query: SELECT * FROM image in /home/domain/public_html/47upgrade/includes/database.mysql.inc on line 120.

carlosmusashi’s picture

Also I am with the same error in the hour of upgrade of drupal 4,6 for the 4.7.

But mine in case that it has a newness: problems with accents in the characters. Use the Portuguese language of Brazil in my drupal.

    * user warning: Column 'title' cannot be part of FULLTEXT index query: ALTER TABLE node CHANGE `type` `type` varbinary(32) DEFAULT '' NOT NULL, CHANGE `title` `title` varbinary(128) DEFAULT '' NOT NULL in /home/.bonz/musashisama/larc4ever/drupal2/includes/database.mysql.inc on line 120.
    * user warning: Column 'name' cannot be part of FULLTEXT index query: ALTER TABLE term_data CHANGE `name` `name` varbinary(255) DEFAULT '' NOT NULL, CHANGE `description` `description` longblob DEFAULT '' NULL in /home/.bonz/musashisama/larc4ever/drupal2/includes/database.mysql.inc on line 120.

The error is this above. Here prints of the error goes links pra also:

Print 1: http://img383.imageshack.us/img383/6199/111118as.jpg

Print 2: http://img383.imageshack.us/img383/9997/27rx2.jpg

Link of host where drupal 4,7 is housed is: www.larc4ever.com/drupal2.

Use drupal 4,6 without problems in: www.larc4ever.com

Please case somebody has passed therefore and obtained to decide helps me. Since already obliged for the force =]

tjharman’s picture

This is listed on the Similar Entires module page for 4.7:

Similar Entries
A module that displays a block with the most similar nodes to the currently viewed one, based on the title and body fields.
Important Drupal 4.7 upgrade note! If you added the fulltext index to the node table in your Drupal 4.6 setup, you MUST drop the index before performing your Drupal 4.7 upgrade, or the upgrade will fail: ALTER TABLE node DROP INDEX title.

Not sure if it'll help or not, hopefully!

Tim