user warning: Table 'drupal.taxonomy_fields' doesn't exist query: SELECT SUBSTRING(nfi.type_name,14) AS tid, tfa.ancestors, tf.universal, td.name, nfi.field_name, nfi.type_name, nfi.label, nfi.widget_type, nfi.weight, nf.type FROM node_field_instance nfi LEFT JOIN taxonomy_fields tf ON nfi.field_name=tf.field_name AND SUBSTRING(nfi.type_name,14)=tf.tid LEFT JOIN taxonomy_fields_ancestors tfa ON SUBSTRING(nfi.type_name,14)=tfa.tid LEFT JOIN term_data td ON SUBSTRING(nfi.type_name,14)=td.tid LEFT JOIN node_field nf ON nf.field_name=nfi.field_name WHERE nfi.type_name LIKE 'term_related_%' AND ((tf.delta IS NULL OR tf.delta=0 ) OR (tf.delta=1 AND tf.delta!=0)) ORDER BY td.name, nfi.weight in C:\Inetpub\drupal-5.2\includes\database.mysql.inc on line 172.

How do I create it manual or is there a script that works

Comments

boneless’s picture

boneless commented

it might help to reinstall the module, the 'taxonomy_fields' table should be created then.
if not you can do so manually using the following command in your MySQL admin:

CREATE TABLE taxonomy_fields (
field_name varchar(32) NOT NULL default '',
tid integer NOT NULL default '0',
field_value longtext NOT NULL default '',
delta integer NOT NULL default '0',
universal integer NOT NULL default '0',
PRIMARY KEY (field_name,tid,delta)
) /*!40100 DEFAULT CHARACTER SET utf8 */;

hope that helps :)

Naeb’s picture

Naeb commented

Hi and thanks for the quick reply
I tried the script
and got this

CREATE TABLE taxonomy_fields(

field_name varchar( 32 ) NOT NULL default '',
tid integer NOT NULL default '0',
field_value longtext NOT NULL default '',
delta integer NOT NULL default '0',
universal integer NOT NULL default '0',
PRIMARY KEY ( field_name, tid, delta )
) DEFAULT CHARACTER SET utf8

MySQL said:

#1101 - BLOB/TEXT column 'field_value' can't have a default value

so what do I do now

boneless’s picture

boneless commented

hm strange, no idea, perhaps just tryx without the default value, doesn't really matter for the module i think.
which version mysql are you using?

Naeb’s picture

Naeb commented
Status: Active » Closed (fixed)

Yes that did it Thanks