User warning since updating CCK

Something is seriously broken if your node_field_instance DB table doesn't exist anymore.
And I fail to see how the CCK 2.3 upgrade would cause this. What version did you upgrade from ? CCK 2.2 ?

Aside from restoring a previous DB backup (you *should always* create a backup before updating any module), there's little advice I can think of...

Well, that's tricky.
Please first check with phpMyAdmin or equivalent that your node_field_instance db table is actually gone ? and what about the node_field table ?

If so, well, I'd probably create a separate fresh D6 site, install CCK and other field modules, re-create the fields (with the same names and also same settings if you remember them), then copy the data from the node_field_instance table over to the actual site.

*Backup* before you attempt any of this....

I'm getting these warnings after activating the cck content module:

user warning: Table 'deb19835_ikHqndr.ikhq_node_field_instance' doesn't exist query: SELECT * FROM ikhq_node_field_instance nfi LEFT JOIN ikhq_node_field nf ON nf.field_name = nfi.field_name WHERE nf.active = 1 AND nfi.widget_active = 1 in /usr/home/deb19835/domains/dutchsteampunkers.nl/public_html/modules/cck/content.install on line 187.
user warning: Table 'deb19835_ikHqndr.ikhq_node_field_instance' doesn't exist query: SELECT * FROM ikhq_node_field_instance nfi LEFT JOIN ikhq_node_field nf ON nf.field_name = nfi.field_name WHERE nf.active = 1 AND nfi.widget_active = 1 in /usr/home/deb19835/domains/dutchsteampunkers.nl/public_html/modules/cck/content.install on line 187.
user warning: Table 'deb19835_ikHqndr.ikhq_node_field_instance' doesn't exist query: SELECT * FROM ikhq_node_field_instance nfi LEFT JOIN ikhq_node_field nf ON nf.field_name = nfi.field_name WHERE nf.active = 1 AND nfi.widget_active = 1 in /usr/home/deb19835/domains/dutchsteampunkers.nl/public_html/modules/cck/content.install on line 187.
user warning: Table 'deb19835_ikHqndr.ikhq_node_field_instance' doesn't exist query: SELECT * FROM ikhq_node_field_instance nfi LEFT JOIN ikhq_node_field nf ON nf.field_name = nfi.field_name WHERE nf.active = 1 AND nfi.widget_active = 1 in /usr/home/deb19835/domains/dutchsteampunkers.nl/public_html/modules/cck/content.install on line 187.

Looks pretty much the same...
And keeps me from running ubercart with all its features.
Both tables: node_field and node_field_instance do not exist
Importing them into the database from another drupal installation (with content and ubercart working (minimal installation, just drupal, cck and ubercart) is no option, they don't exist there either.

Anyone got a solution for this? I can't put my finger on it. It seems like some modules are conflicting.

Edit: currently working on a complete rebuild of my drupal site on another server. Hell of a job, that is....

@dr.finch : did you check that the tables exist in the right database with the right db prefix ?
It seems that the code expects to find tables with 'ikhq_' prefix.
You might want to double check your multisite and tables prefix configuration.

@yched, indeed, I overlooked it.... These tables don't exist..... nor do they in my shadow installation, so I can't move them over to the life site.
Guess I'll just give up for the moment, untill drupal crashes completely and a fresh install becomes inevitable...

Where, and to which module does the table: node_field_instance belong? None of my D6 sites have this table, yet ... ?

I upgraded from D5 to D6, and as soon as I installed (and updated) CCK the problem appeared.

Any Ideas?

This happened to me also after uninstalling the acidfree module.

I am getting this same error - I do not have this table in any D6 install db.

I have no modules active other than base content - and this error will not go away:

user warning: Table '***.node_field_instance' doesn't exist query: SELECT * FROM node_field_instance nfi LEFT JOIN node_field nf ON nf.field_name = nfi.field_name WHERE nf.active = 1 AND nfi.widget_active = 1 in /var/www/vhosts/sitename/httpdocs/sites/all/modules/cck/content.install on line 187.

I got this same error after installing node_gallery and upgrading panels and ctools so I am not sure which of them was responsible for the errors. And like the others I am not looking for a complete rebuild of the site either.

I also have this same problem, regularly receiving multiple instances of the same error nessage given above, on a site with a lot of modules and data that I would not be happy having to rebuild. I do not know exactly when the problem began, but it seems to have been after a CCK upgrade.

I do not have node_field or node_field_instance tables in my database.

I do have have content_node_field and content_node_field_instance tables in my database. But these tables are empty.

The site with this problem has thousands of nodes, many which use modules dependent on the CCK.

Could these be the tables that the CCK SHOULD be looking for?

This surely seems like a bug to me. I have also inspected my other Drupal sites, and they have the same tables as the site with the problem (but not so many installed modules).

Hi, i can confirm that uninstalling acidfree module causes the above mentioned error message.

I updated from the previous version...not sure which now, oh, I also did an uninstall (via the uninstall option in "modules") of acidfree

It happended to me too. I guess the acidfree module should be banned from d.o. since it is not maintained anymore and last updated in 2008.

Yes, I had Acidfree installed at one time, did not find it useful, and uninstalled it, and that certainly does seem to be the common denominator here. I uninstalled just about every module on my site that I could, uninstalled the cck, and then reinstalled everything and the errors disappeared. Now I seem to once again have a healthy database.

I got the same error, also after uninstalling Acidfree.

I uninstalled CCK, Views and every other module depending on these. Then I changed the names of the database tables 'content_node_field' and 'content_node_field_instance' to start with 'backup-'. After this I reinstalled the previously uninstalled modules and the error messages were gone.

i had the same problem when i uninstalled the chatroll module. what happened is the "variable" table got reset/emptied. i just restored that table from a backup and all worked fine.

the cck module decides which table to use based on the variable 'content_schema_version' as you can see below. since that variable was not in the variable table cck was using the wrong table.

function content_instance_tablename($version = NULL) {
  if (is_null($version)) {
    $version = variable_get('content_schema_version', 0);
  }
  return $version < 6001 ? 'node_field_instance' : 'content_node_field_instance';
}

from content.module line 2028

Just wanted to let cvbuelow know that tip solved my problem after hours of head scratching weird error messages in Administer>Modules.

I thought I'd chime in as well since this thread has been going for quite some time. I experienced the exact same problem as the above posters. My issue occurred after dumping a content type and its associated fields (d6) into a feature. When I spun up the feature on a different site, the missing content_schema_version produced all of these errors as well. I acutally believe that cck installed properly, I deactivated the feature and then reactivated to produce the error.

Regardless @cvbuelow's solution from #17 worked for me...

I've would also put this as a configuration issue and not a bug with cck so I believe that this thread can be marked as closed but will leave the maintainers to decide. Thanks for a great module!