while updating CCK from rc4 to rc6 I got the following error

fieldgroup module
Update #6001

* UPDATE {system} SET weight = 9 WHERE name = 'fieldgroup'

Update #6002

* Failed: ALTER TABLE {node_group} RENAME TO {content_group}
* Failed: ALTER TABLE {node_group_fields} RENAME TO {content_group_fields}

Should I manually change anything in database

Comments

yched’s picture

Status: Active » Postponed (maintainer needs more info)

Hm.

Does your db currently have :
- a {node_group} table ? if yes, does it have any records ?
- a {node_group_fields} table ? if yes, does it have any records ?
- a {content_group} table ? if yes, does it have any records ?
- a {content_group_fields} table ? if yes, does it have any records ?

Are you using MySQL or PgSQL ?

Is the fieldgroup module actually enabled on your site ?

nishitdas’s picture

StatusFileSize
new32.33 KB

- a {node_group} table exits, It has many records.
- a {node_group_fields} table exits, It has many records.
- a {content_group} table exits, It has no records.
- a {content_group_fields} table exits, It has no records.

Are you using MySQL or PgSQL ?
ans: My SQL

Is the fieldgroup module actually enabled on your site ?
ans: Yes

What I have done after the update:
As there was no data in content_group & content_group_fields. and the error message was
"
* Failed: ALTER TABLE {node_group} RENAME TO {content_group}
* Failed: ALTER TABLE {node_group_fields} RENAME TO {content_group_fields}
"
I copied all the data from node_group to content_group and node_group_fields to content_group_fields.
Now I can see the CCK fields in manage field tab of each Content type but the display field is showing "There are no fields configured for this content type"

when I open any node the fields in the node are not shown.

yched’s picture

I don't get what might have happened with your node_group* / content_group* tables.
Your manual fix was the right one.
About your fields not appearing : have you tried emptying your site's cache ?
(use the 'clear cached data' button at the bottom of admin/settings/performance)

A few more questions, so that I can try to understand what happened and possibly fix for other people :

- If you go to update.php, on the page with the 'select versions' dropdowns (DON'T actually run any update :-)):
is there any module with updates still to be run, or do all dropdowns display 'no updates available' by default ?

- is your site a former D5 site, with D5 CCK and fieldgroup installed, that you upgraded to D6 ?
If yes, do you remember which version of CCK you used for the initial D6 upgrade ? was it rc4 ?
If no (meaning : your site always ran with D6), do you remember which version of CCK you first installed ?

nishitdas’s picture

No update is pending for any module

I updated from version = "5.x-1.7" to 6 rc4 and then to rc6

I can see the groups but the fields are missing.

In database the table "content_type_contenttypename" has all the informations.
Following tables also looks good
content_group
content_group_fields
content_node_field
content_node_field_instance

Is there any other table i should look into.

I had TRUNCATED all the cache tables but that did not made any difference.

nishitdas’s picture

StatusFileSize
new111.3 KB

I am not sure but following might be the problem

in CCK 5.x-1.7 there were no columns " module db_columns" but which is present in 6 rc6 version. in new version both columns are NULL. So that might be causing the problem. But i dont know what should be the values. I 'll update if get something new.

Please find attached the content_node_field table. There was no data in "module db_columns active locked" columns. I manually enterd for first row but that not yield any result.

nishitdas’s picture

Status: Postponed (maintainer needs more info) » Closed (fixed)

After putting values in "module db_columns" the problem is fixes

yched’s picture

Those columns new in CCK D6 are supposed to be populated in content_update_6000().
Something definitely went wrong with your update - hard to say what.

No similar reports for now, so let's consider this closed