After updating to 6.x-2.0-rc9 the following messages were reported:

Drupal database update

user warning: Table 'ourpr1_db.node_group' doesn't exist query: UPDATE node_group SET group_name = CONCAT('group_', SUBSTRING(group_name FROM 7)) in /home/ourpr1/public_html/sites/all/modules/cck/modules/fieldgroup/fieldgroup.install on line 84.
user warning: Table 'ourpr1_db.node_group_fields' doesn't exist query: UPDATE node_group_fields SET group_name = CONCAT('group_', SUBSTRING(group_name FROM 7)) in /home/ourpr1/public_html/sites/all/modules/cck/modules/fieldgroup/fieldgroup.install on line 85.
user warning: Table 'ourpr1_db.node_group' doesn't exist query: ALTER TABLE node_group CHANGE settings settings mediumtext NOT NULL in /home/ourpr1/public_html/sites/all/modules/cck/modules/fieldgroup/fieldgroup.install on line 101.
user warning: Table 'ourpr1_db.node_group' doesn't exist query: SELECT * FROM node_group in /home/ourpr1/public_html/sites/all/modules/cck/modules/fieldgroup/fieldgroup.install on line 110.
user warning: Table 'ourpr1_db.node_group' doesn't exist query: ALTER TABLE node_group DROP description in /home/ourpr1/public_html/sites/all/modules/cck/modules/fieldgroup/fieldgroup.install on line 123.
user warning: Table 'ourpr1_db.node_group' doesn't exist query: SELECT * FROM node_group in /home/ourpr1/public_html/sites/all/modules/cck/modules/fieldgroup/fieldgroup.install on line 140.

The following queries were executed

content module
Update #6000
No queries
Update #6001
No queries
Update #6002
No queries
Update #6003
No queries
fieldgroup module
Update #1
Failed: UPDATE {node_group} SET group_name = CONCAT('group_', SUBSTRING(group_name FROM 7))
Failed: UPDATE {node_group_fields} SET group_name = CONCAT('group_', SUBSTRING(group_name FROM 7))
Update #2
Failed: ALTER TABLE {node_group} CHANGE settings settings mediumtext NOT NULL
Failed: ALTER TABLE {node_group} DROP description
Update #3
No queries
Update #4
UPDATE {system} SET weight = 9 WHERE name = 'fieldgroup'
Update #6000
No queries

I looked inside the database and noticed that indeed those 2 tables do not exist in any form.

Where do I go from here?

Thank,
Marc P

Comments

KarenS’s picture

Status: Active » Postponed (maintainer needs more info)

Your system was trying to run the very very old update_1 for fieldgroup, an update that should have been run long ago when the tables looked quite different. It appears that there was information in your system table that indicated it had never been updated and needed that old update, when it obviously didn't. I don't know how your system table got goofed up that way, but I've seen this happen before, so I'm going to add a couple lines to the .install file to prevent attempts to update those tables if they don't exist.

Check one thing to be sure you didn't need that fix. See if you have a table called content_group and if all the groups in that table have group names that start with 'group_'. If so, your database should be OK in spite of those messages. It didn't do something that it shouldn't have done (nice double negative, huh?) so you should be OK now.

marcparker’s picture

Thanks Karen.

I do have the table "content_group."

I did not have any content groups, so I added one as a test and it appeared in the table as expected.

Marc P

KarenS’s picture

Status: Postponed (maintainer needs more info) » Fixed

Empty is OK, so you are fine.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.