There are two things you must do:
1) *** YOU MUST EDIT ‘all.sql’ BEFORE THIS STEP ***
On or around line 117 – you will need to enter your database name first!!
The all.sql MySQL stored procedures supplied with the filePro® installation must be inserted into
every Database with a Table that filePro® will map.
Failure to do so will cause indexes searches to fail.
This can be done by at a command prompt with the following command
mysql –user=userName –password=userPassword databaseName < all.sql
2) Indexes must be unique and can only be created in MySQL.
Use or Add an ‘id’ field to your table (auto-increment)
Add this ‘id’ to the end of the index(es) to make unique.