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 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 commented

So yes - creating the table manually works.

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
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) commented
Status: Fixed » Closed (fixed)

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

dafreak’s picture

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
commented

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