The update method supplied with the recent db scheme change for text.module (v1.15) drops the tables but does not recreate the new ones.
Marked as critical since it breaks text.module functionality altogether :-)

Figuring out what the expected fields are by looking at the code in content_field function in content.module is not trivial. Maybe you could post the new db scheme here them so that we can at least manually create it ?

Comments

yched’s picture

yched commented
Title: update : Data tables dropped but not re-created » Text fields broken

It seems that new text fields creation is also broken :

Unknown table 'node_data_' query: DROP TABLE node_data_ in (...)\includes\database.mysql.inc

Occurs after the first form page has been submitted (the one where you specify the field type)

jonbob’s picture

jonbob commented

The new db scheme is dynamic, so it will differ depending on which fields you have created. A node_data_(your field name here) table should be created each time you make a new text field. This is the first part of a two-step plan; eventually we will move fields that are used in only one content type into a single table for extra efficiency. Even this first step is a speed boost, though.

For each table, you'll have:
vid int unsigned NOT NULL default '0',
delta int unsigned NOT NULL default '0',
nid int unsigned NOT NULL default '0',
(your field name)_value varchar(255) NOT NULL default '',
(your field name)_format int unsigned NOT NULL default '0',
but the specifics will differ (delta and format will only be there if multiple values or filtering are allowed, respectively).

I just checked in a patch that I hope will solve this problem for you. It turns out there is some weird interaction between unset() and static variables.

yched’s picture

yched commented

The issues with text field creation are solved.

Which reveals other issues with node creation (and probably update) :-)

Unknown column 'Array' in 'field list' query: INSERT INTO node_data_field_my_field (vid, nid, field_essai_texte_value) VALUES (77, 40, Array) in (...)

There probably is a missing implode on $column_placeholders in the lines 

db_query('INSERT INTO {'. $table_name .'} (vid, delta, nid, '. implode(', ', $column_names) .') VALUES (%d, %d, %d, '. $column_placeholders .')', $data);

in function content_field('update' / 'insert')

yched’s picture

yched commented

Hum. Not very readable. And it seems preview is broken since drupal.org upgrade. Repost :

The issues with text field creation are solved.

Which reveals other issues with node creation (and probably update) :-)

Unknown column 'Array' in 'field list' query: 
INSERT INTO node_data_field_my_field (vid, nid, field_my_field_value) 
VALUES (77, 40, Array) in (...)

There probably is a missing implode on $column_placeholders in the lines

db_query('INSERT INTO {'. $table_name .'} 
(vid, delta, nid, '. implode(', ', $column_names) .') 
VALUES (%d, %d, %d, '. $column_placeholders .')', $data);

in function content_field('update' / 'insert')

jonbob’s picture

jonbob commented
Status: Active » Fixed

Corrected. Thank you.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)