Hi,

I've been experimenting with all sorts of approaches to try and create some kind of 'Finder' wizard Block only to discover that you've already done it!

Problem is though, when I install your Finder module (in anticipation of then installing your Finder Wizard module!), I get the following SQL error...

* user warning: BLOB/TEXT column 'description' can't have a default value query: CREATE TABLE finder ( `finder_id` INT unsigned NOT NULL auto_increment, `base` VARCHAR(32) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `description` LONGTEXT NOT NULL DEFAULT '', `path` VARCHAR(128) NOT NULL DEFAULT '', `block` TINYINT NOT NULL DEFAULT 0, `settings` LONGTEXT NOT NULL DEFAULT '', PRIMARY KEY (finder_id) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\includes\database.inc on line 515.
* user warning: BLOB/TEXT column 'settings' can't have a default value query: CREATE TABLE finder_element ( `finder_element_id` INT unsigned NOT NULL auto_increment, `finder_id` INT unsigned NOT NULL DEFAULT 0, `element` VARCHAR(32) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `weight` TINYINT NOT NULL DEFAULT 0, `settings` LONGTEXT NOT NULL DEFAULT '', PRIMARY KEY (finder_element_id) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\includes\database.inc on line 515.
* user warning: Table 'robertingram.finder' doesn't exist query: SELECT * FROM finder in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\sites\ingram.ikosdev.co.uk\modules\additional\finder\finder.module on line 672.

Can you help / advise and I'd love to get going with this - it seems perfect for the job.

Comments

danielb’s picture

Status: Active » Fixed

I don't get this problem but I've had a guess at a fix, so lets hope this doesn't happen anymore.

sirclickalot’s picture

Thank you for your quick response. Does this mean that I should expect to see a small revision released soon or cna you just give me the details of the quick fix that you think will address my problem?

danielb’s picture

There is a new release available, you'll have to disable and then uninstall your current version of finder first.

Status: Fixed » Closed (fixed)

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