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
Comment #1
danielb commentedI don't get this problem but I've had a guess at a fix, so lets hope this doesn't happen anymore.
Comment #2
sirclickalotThank 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?
Comment #3
danielb commentedThere is a new release available, you'll have to disable and then uninstall your current version of finder first.