Mark's web presence nothing very exciting, just some guy's web presence

Note to everyone who has installed this first beta version: You only need to do this fix if you have configured additional helpers. The bug that caused this problem has been fixed and the updated version of the module will be available tomorrow (Feb. 24) some time. Don't perform this fix if you don't need it by then.

First, of course, back up your database before proceeding.

Do select * from search_attachments_helpers; to see your helpers table. I would imagine yours looks like this:

mysql> select * from search_attachments_helpers;
+------+------+-----------+-----------------------------------+----------+
| id   | name | extension | helper_path                       | log_text |
+------+------+-----------+-----------------------------------+----------+
|   1| PDF  | pdf       | /usr/local/bin/pdftotext %file% - |        0 | 
|   2| Text | txt       | /bin/cat %file% -                 |        0 | 
|   1| PPT | ppt      | /bin/cat %file%                   |        0 |
|   2| DOC  | doc       | /bin/cat %file%                   |        0 | 
|   1| XLS | xls     | /bin/cat %file%                   |        0 | 
+------+------+-----------+-----------------------------------+----------+

You need to assign unique ids to each helper. So, issue the following commands (the id values below may not be correct for you but the important point is that they are sequential and unique):

mysql> update search_attachments_helpers set id = 3 where name = 'PPT';
mysql> update search_attachments_helpers set id = 4 where name = 'DOC';
mysql> update search_attachments_helpers set id = 5 where name = 'XLS';

Now do another select * from search_attachments_helpers; to make sure that you have unique id values for all of your helpers. If you do, the last step is to update your sequences table so that it records the highest id value in your helpers table (in this example, 5):

mysql>update sequences set id = 5 where name = "search_attachments_helpers_id";

Do select * from sequences; to verify that the search_attachments_helpers_id id is the same as the highest value id value in your helpers table, and you're done.