I tried this with both 4.7b6 and CVS. I'm running CCK CVS from just a couple days ago. Any ideas?



    * warning: Missing argument 4 for content_alter_db_field() in /var/www/drupal/modules/cck/content_admin.inc on line 607.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/modules/cck/content_admin.inc on line 697.
    * user warning: Table 'iheart.node_data_field_slogan' doesn't exist query: update_sql INSERT INTO node_data_field_slogan (vid, nid, field_slogan_value) SELECT vid, nid, field_shorttext FROM node_field_shorttext_data WHERE field_name = 'field_slogan' in /var/www/drupal/includes/database.mysql.inc on line 120.
    * warning: Missing argument 4 for content_alter_db_field() in /var/www/drupal/modules/cck/content_admin.inc on line 607.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/modules/cck/content_admin.inc on line 697.
    * user warning: Table 'iheart.node_data_field_description' doesn't exist query: update_sql INSERT INTO node_data_field_description (vid, nid, field_description_value, field_description_format) SELECT vid, nid, field_longtext, format FROM node_field_longtext_data WHERE field_name = 'field_description' in /var/www/drupal/includes/database.mysql.inc on line 120.
    * warning: Missing argument 4 for content_alter_db_field() in /var/www/drupal/modules/cck/content_admin.inc on line 607.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/modules/cck/content_admin.inc on line 697.
    * user warning: Table 'iheart.node_data_field_description_teaser' doesn't exist query: update_sql INSERT INTO node_data_field_description_teaser (vid, nid, field_description_teaser_value) SELECT vid, nid, field_longtext FROM node_field_longtext_data WHERE field_name = 'field_description_teaser' in /var/www/drupal/includes/database.mysql.inc on line 120.
    * warning: Missing argument 4 for content_alter_db_field() in /var/www/drupal/modules/cck/content_admin.inc on line 607.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/modules/cck/content_admin.inc on line 697.
    * user warning: Table 'iheart.node_data_field_customer_service_phone' doesn't exist query: update_sql INSERT INTO node_data_field_customer_service_phone (vid, nid, field_customer_service_phone_value) SELECT vid, nid, field_shorttext FROM node_field_shorttext_data WHERE field_name = 'field_customer_service_phone' in /var/www/drupal/includes/database.mysql.inc on line 120.
    * warning: Missing argument 4 for content_alter_db_field() in /var/www/drupal/modules/cck/content_admin.inc on line 607.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/modules/cck/content_admin.inc on line 697.
    * user warning: Table 'iheart.node_data_field_customer_service_mail' doesn't exist query: update_sql INSERT INTO node_data_field_customer_service_mail (vid, nid, field_customer_service_mail_value) SELECT vid, nid, field_shorttext FROM node_field_shorttext_data WHERE field_name = 'field_customer_service_mail' in /var/www/drupal/includes/database.mysql.inc on line 120.
    * warning: Missing argument 4 for content_alter_db_field() in /var/www/drupal/modules/cck/content_admin.inc on line 607.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/modules/cck/content_admin.inc on line 697.
    * user warning: Table 'iheart.node_data_field_license_holder' doesn't exist query: update_sql INSERT INTO node_data_field_license_holder (vid, nid, field_license_holder_value) SELECT vid, nid, field_shorttext FROM node_field_shorttext_data WHERE field_name = 'field_license_holder' in /var/www/drupal/includes/database.mysql.inc on line 120.
    * warning: Missing argument 4 for content_alter_db_field() in /var/www/drupal/modules/cck/content_admin.inc on line 607.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/modules/cck/content_admin.inc on line 697.
    * user warning: Table 'iheart.node_data_field_license_location' doesn't exist query: update_sql INSERT INTO node_data_field_license_location (vid, nid, field_license_location_value) SELECT vid, nid, field_shorttext FROM node_field_shorttext_data WHERE field_name = 'field_license_location' in /var/www/drupal/includes/database.mysql.inc on line 120.
    * warning: Missing argument 4 for content_alter_db_field() in /var/www/drupal/modules/cck/content_admin.inc on line 607.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/modules/cck/content_admin.inc on line 697.
    * user warning: Table 'iheart.node_data_field_notes' doesn't exist query: update_sql INSERT INTO node_data_field_notes (vid, nid, field_notes_value) SELECT vid, nid, field_longtext FROM node_field_longtext_data WHERE field_name = 'field_notes' in /var/www/drupal/includes/database.mysql.inc on line 120.
    * warning: Missing argument 4 for content_alter_db_field() in /var/www/drupal/modules/cck/content_admin.inc on line 607.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/modules/cck/content_admin.inc on line 697.
    * user warning: Table 'iheart.node_data_field_coupon_code' doesn't exist query: update_sql INSERT INTO node_data_field_coupon_code (vid, nid, field_coupon_code_value) SELECT vid, nid, field_shorttext FROM node_field_shorttext_data WHERE field_name = 'field_coupon_code' in /var/www/drupal/includes/database.mysql.inc on line 120.

and

The following queries were executed
text module
Update #4

    * Failed: INSERT INTO {node_data_field_slogan} (vid, nid, field_slogan_value) SELECT vid, nid, field_shorttext FROM {node_field_shorttext_data} WHERE field_name = 'field_slogan'
    * Failed: INSERT INTO {node_data_field_description} (vid, nid, field_description_value, field_description_format) SELECT vid, nid, field_longtext, format FROM {node_field_longtext_data} WHERE field_name = 'field_description'
    * Failed: INSERT INTO {node_data_field_description_teaser} (vid, nid, field_description_teaser_value) SELECT vid, nid, field_longtext FROM {node_field_longtext_data} WHERE field_name = 'field_description_teaser'
    * Failed: INSERT INTO {node_data_field_customer_service_phone} (vid, nid, field_customer_service_phone_value) SELECT vid, nid, field_shorttext FROM {node_field_shorttext_data} WHERE field_name = 'field_customer_service_phone'
    * Failed: INSERT INTO {node_data_field_customer_service_mail} (vid, nid, field_customer_service_mail_value) SELECT vid, nid, field_shorttext FROM {node_field_shorttext_data} WHERE field_name = 'field_customer_service_mail'
    * Failed: INSERT INTO {node_data_field_license_holder} (vid, nid, field_license_holder_value) SELECT vid, nid, field_shorttext FROM {node_field_shorttext_data} WHERE field_name = 'field_license_holder'
    * Failed: INSERT INTO {node_data_field_license_location} (vid, nid, field_license_location_value) SELECT vid, nid, field_shorttext FROM {node_field_shorttext_data} WHERE field_name = 'field_license_location'
    * Failed: INSERT INTO {node_data_field_notes} (vid, nid, field_notes_value) SELECT vid, nid, field_longtext FROM {node_field_longtext_data} WHERE field_name = 'field_notes'
    * Failed: INSERT INTO {node_data_field_coupon_code} (vid, nid, field_coupon_code_value) SELECT vid, nid, field_shorttext FROM {node_field_shorttext_data} WHERE field_name = 'field_coupon_code'
    * DROP TABLE {node_field_shorttext_data}
    * DROP TABLE {node_field_longtext_data}

Comments

Julien PHAM’s picture

Yes, and I lost all my datas because the update script dropped the tables where my datas were stored:

in fact the update script failed to create the new tables and so to insert infos into them, and dropped the tables with datas...

jonbob’s picture

It sounds like your files are out of sync; maybe content_admin.module is up to date but content.module and/or text.install is not. Is that possible? What are the version numbers on the top of these files?

I know there's been some weirdness with the automatic module packaging system of late.

Julien PHAM’s picture

I doubt it, as I use a cvs manager and I updated all my drupal files to the latest versions.
content.module is 1.30
text.install is 1.5
content_admin.inc is 1.4

I see no content_admin.module in the cvs...

jonbob’s picture

Status: Active » Fixed

Ack, that's bad. A CVS commit to text.install failed, so things were indeed out of sync; but that wasn't your fault! CVS now has the fix.

Julien PHAM’s picture

Now I just have to write my articles again ;) But I have only 27 articles so this is ok... but to write'em I need you to fix this varchar(255) limit stuff ;)

yched’s picture

I can confirm that current text.install update discards old text data tables, but fails to recreate the new ones, causing data loss.
That's probably allright considering CCK is "under development", but as long the update bug is not fixed, there should be a warning somewhere...

yched’s picture

Seems a new version of text.install has been committed already...

Sometimes I should definitely think twice before posting...

seandunaway’s picture

thanks jonbob; that fixed it :)

Anonymous’s picture

Status: Fixed » Closed (fixed)