@JoshuaPowell; Thanks for the reply, i hope you can fix this

When i access the search settings page i get the following error:

user warning: Table 'drupaldb.search_files_files' doesn't exist query: SELECT COUNT(*) as `count` FROM search_files_files in C:\Inetpub\wwwroot\drupal\sites\all\modules\search_files\search_files.module on line 754.

user warning: Table 'drupaldb.search_files_files' doesn't exist query: SELECT COUNT(*) AS `count` FROM search_files_files LEFT JOIN ( SELECT * FROM search_dataset WHERE `type` = 'search_files' ) AS `dataset` ON search_files_files.`id` = `dataset`.`sid` WHERE ( `dataset`.`reindex` IS NULL OR `dataset`.`reindex` != 0 ) in C:\Inetpub\wwwroot\drupal\sites\all\modules\search_files\search_files.module on line 775.

It seems the database table is not created ???

Please help me out.

Comments

jrglasgow’s picture

jrglasgow commented

Do you know what version of PHP you are using? What version of MySQL? or are you using PostgreSQL?

Have you tried the latest release 6.x-1.4?

Richhh’s picture

Richhh commented

Wow that is a quick reply!

Im using PHP 5.2.5 and MySQL 5.0.51a on a Win2003 server with IIS6 and i have got the 6.x-1.4 module installed

Richhh’s picture

Richhh commented
Version: 6.x-1.2 » 6.x-1.4

changed this issue version to 6.x-1.4

jrglasgow’s picture

jrglasgow commented

Wow that is a quick reply!

- I just happen to be up right now, usually I am trying to sleep this time of night, but can't.

Currently the only thing I can think of to try is to disable the module, then uninstall the module (this will try to remove the tables), then re-enable the module (this will then retry to create the tables).

I just did a test to make sure it would create the tables required on my test server and it worked fine. There might have been a problem with a previous release that didn't get the tables created. Just upgrading the module would not have changed anything, I haven't changed the install function since 6.x-1.2.

Test Server:
gentoo-linux
PHP-5.2.6_rc1-r1
MySQL-5.0.54
Apache-2.2.6-r5

Richhh’s picture

Richhh commented

Still no go...

After uninstalling the module i got the next error, but this would make sense becouse the table hasn't been created
user warning: Unknown table 'search_files_files' query: DROP TABLE search_files_files in C:\Inetpub\wwwroot\drupal\includes\database.mysql-common.inc on line 261.

After re-enbale of the module everythings seems to bo running smoothly but when accessing Administer › Site configuration › Search Settings im getting the dredded error message back!

jrglasgow try to get some sleep first... you will feel fresh in the morning!

jrglasgow’s picture

jrglasgow commented

I just created a new release 6.x-1.5, in this release I added more transparency in the install function to help us see the problems when not creating tables. When the drupal_install_schema('search_files') function returns errors: let the user know how many tables were created successfully, how many were created unsuccessfully, and show the queries that were unsuccessfully executed. we also record these queries to the log.

Download this module, re-install it, then paste the messages after the install into your next comment.

spamjim’s picture

spamjim commented

Here's the error I get with search_files-6.x-1.6:

user warning: Specified key was too long; max key length is 767 bytes query: CREATE TABLE 6_search_files_files ( `id` INT NOT NULL auto_increment, `full_path` VARCHAR(300) NOT NULL, `directory_id` INT NOT NULL, `index_attempts` TINYINT NOT NULL, PRIMARY KEY (id), UNIQUE KEY full_path (full_path) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\htdocs\6\includes\database.inc on line 515.

PHP Version 5.2.6
Apache/2.2.9 (Win32)
MySQL Client API version 5.0.51a

...then I see this thread ( http://drupal.org/node/264115 ) for a possible resolution.