I've re-downloaded this file a few times just in case but there is a SQL error in the install file in the 'mysqli' case in the db_query function. CREATE TABLE isnt finish and looks like this:

    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {
        field_name varchar(32) NOT NULL default '0',
  	type_name varchar(32) NOT NULL default '0',
  	method int(1) NOT NULL default '0'
	) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;

It should look like this

    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {tokenize}(
        field_name varchar(32) NOT NULL default '0',
  	type_name varchar(32) NOT NULL default '0',
  	method int(1) NOT NULL default '0'
	) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;

Table name was just needed ;)

Comments

asak’s picture

asak CreditAttribution: asak commented

I'm assuming this is related to the warning i'm getting when trying to add a CCK field to a content type:

user warning: Table 'dru_drupy.tokenize' doesn't exist query: SELECT * FROM tokenize in ...includes/database.mysql.inc on line 172

But I tried disabling the module, fixing the .install file and re-enabling the module and that doesn't help.

How can I get the table created (besides creating it manually, which i'm about to do...) ?

asak’s picture

asak CreditAttribution: asak commented

So yes - creating the table manually works.

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
CreditAttribution: greggles commented
Assigned: Unassigned » greggles
Status: Active » Fixed

I just committed a fix for this and another issue in there (the ; on the mysql query is unnecessary as far as I can tell). Can you try out the latest version and see if it works for you?

Anonymous’s picture

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

Automatically closed -- issue fixed for two weeks with no activity.

dafreak’s picture

dafreak CreditAttribution: dafreak commented

I'm getting Table tokenize does not exist. I've tried your new dev version. Perhaps if you add the Case for MYSQL ?

AND don't use a curly brace for the SQL statement. doh-doh! Except maybe around tokenize but not the field definitions.

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
CreditAttribution: greggles commented

Really a better solution is http://drupal.org/project/token_filter which does all this and more.