By maastrix on

Is it possible to run CCK on Drupal 6.1? I read about some problems. I myself get a nasty page of errors on the module page in the administration:
user warning: Unknown column 'nf.active' in 'where clause' query: SELECT * FROM drup_node_field_instance nfi JOIN drup_node_field nf ON nfi.field_name = nf.field_name WHERE nf.active = 1 AND nfi.widget_active = 1 AND nfi.type_name = 'blog' ORDER BY nfi.weight ASC, nfi.label ASC in /home/username/domains/domain/public_html/modules/cck/content_crud.inc on line 436.
A message like this is posted about 10 times. With my select knowledge about mysql and php, I guess it can't find the tables in the database. How to fix this? Will creating these tables by hand solve the problem?

When I run update.php I get the following errors/warnings:
content module can not be updated. Its schema version is 1001. Updates up to and including 1008 have been removed in this release. In order to update content module, you will first need to upgrade to the last version in which these updates were available.

fieldgroup module can not be updated. Its schema version is 1. Updates up to and including 4 have been removed in this release. In order to update fieldgroup module, you will first need to upgrade to the last version in which these updates were available.

Please help me with this.. and if possible in userfriendly jargon ^_^

-Offtopic-
Quite strange, in my opinion, to release drupal 6 without the main cck module (which I estimate is installed on 75% of the drupal installs and I think it is and should be a core module).. Without it, drupal is even less flexible to a user than, for instance, a basic wordpress install.

⋅ Categories: Drupal 6.x

Comments

maxrisc’s picture

maxrisc commented

These are not part of the Core in Drupal. Being that is the case then releasing 6 is perfectly fine.

The only thing stopping me from using Drupal for more projects is this separation between core and cck/views.

Drupal 6 standalone = Win
Drupal 6 with CCK or View = Fail

Moonshine’s picture

Moonshine commented

Well, it's certainly possible. I'm running 6.1/CCK on a couple sites under development.

From your post I'm *guessing* that you're updating from Drupal 5 site to Drupal 6?

IIRC all the CCK updates for Drupal 6.x have update number prefixed with a 6. (6000,6001, etc). All the old updates (1000 series) are from the Drupal 5 CCK updates.

So my guess is that you had an *old* CCK install from Drupal 5 (schema 1001) that was never updated to the latest Drupal 5 CCK (schema 1008) before trying to go to the Druapal 6 version. That's what this is telling you I believe:

content module can not be updated. Its schema version is 1001. Updates up to and including 1008 have been removed in this release. In order to update content module, you will first need to upgrade to the last version in which these updates were available.

At least that's my guess..

maastrix’s picture

maastrix commented

Yes, I updated.. and possibly I hadn't updated the modules before. It didn't say in the update documents though. I tried installing an 5.x cck version but it doesn't run on drupal 6.1. Is there a way to get the tables updated?

I guess going back to drupal 5.x with the current updated database isn't possible either.

*Edit: Got it to work; Restored backup, Installed latest 5.x version of CCK, updated database, followed Drupal 6.1 upgrade procedure again, installed new version of CCK and ran update script again. Still have some problem with the Fivestars CCK field but I will look into that later.. The moduledevelopment can't keep up with the coredevelopment ^_^