I'm trying to get the Faceted Search module installed in Drupal 5.7 with php 5.x MySQL 5.0 and when I tried enabling the module I go this error:

user warning: BLOB/TEXT column 'value' can't have a default value query: CREATE TABLE faceted_search_variables ( env_id int(10) unsigned NOT NULL default '0', name varchar(48) NOT NULL default '', value longtext NOT NULL default '', PRIMARY KEY (env_id, name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\Program Files\Apache Group\Apache2\htdocs\drupal\includes\database.mysql.inc on line 172.

Whatever this means, it has the effect of preventing me from adding an environment.

Any suggestions?

Thanks.

Bobb Menk
bmenk@ll.mit.edu

Comments

David Lesieur’s picture

David Lesieur commented
Title: Installation error » Text columns cannot have default values in MySQL
Version: 5.x-1.0-beta3 » 5.x-1.x-dev
Component: General » Code
Category: support » bug
Priority: Normal » Critical
Status: Active » Fixed

Committed a fix for this. Thanks for the report!

Reference: http://dev.mysql.com/doc/refman/5.0/en/blob.html.

bmenk’s picture

bmenk commented

Sorry to be dense on this - but I'm new to Drupal. Where do I find the fix you made? Is it a revised download of the module, or something else?

Thanks.

Bobb Menk

David Lesieur’s picture

David Lesieur commented

The change has been made to the development version. A snapshot of the current development version is automatically packaged once or twice a day, which you can download as the 5.x-1.x-dev package. Because of the latency in updating the package, you might have to wait a little to get a snapshot that has the change included.

Development versions are often less stable than official releases, so it is best to use them only for testing purposes (not on production sites).

You might want to look at the CVS messages to see the details (diff) of what has been committed.

bmenk’s picture

bmenk commented

Ok. I downloaded the most recent dev package from today. I disabled all the Faceted Search modules, then I deleted the Faceted Search folder inside modules and installed the dev version.

I didn't get the blob error again, so I went on to add the environment. Now I get this error:

user warning: Table 'drupal.faceted_search_variables' doesn't exist query: SELECT * FROM faceted_search_variables in C:\Program Files\Apache Group\Apache2\htdocs\drupal\includes\database.mysql.inc on line 172.

Which seems to be saying that one of the table it needs never got created. Is that because I needed to do something else to install the dev version? Or is something else actually bombing out?

Thanks.

Bobb Menk

David Lesieur’s picture

David Lesieur commented

Did you go to the Uninstall tab and uninstall Faceted Search before replacing it? If not, try disabling the module again, then uninstalling it from the Uninstall tab, and then re-enabling the module. Otherwise Drupal won't go through the table creation process.

bmenk’s picture

bmenk commented

That did the trick - now it works like a charm!

Thanks.

Bobb Menk

Anonymous’s picture

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

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