I took Sabkor's Quotes module, and implemeted most (if not all, I don't remember) of the fixes mentioned, plus added some extra functionality.

Download: Quotes_1.5.1.zip

Also I made some other changes and added some functionality.

• Added Automatic Quote "spam" feature. Will output a random quote to gc|pgroup|both on a set interval if enabled.
• Changed VARCHAR to TEXT to facilitate searching of quotes
• Added process_command() to remove redundant code.
• Added load_settings, change_setting, show_settings to deal with settings related to quote spam.
• Added cron(), and connect() functions to enable quote spam feature.
  
• Modified add_quote() function to use addslashes() instead of str_replace() when inserting into database.
• Added a FULLTEXT MySQL index to assist with searching the Quotes table.
• Added upgrade_table() to automatically add the FULLTEXT index to users of previous module versions.
• Added search_quotes() function that searches the quotes table.

To configure the quote spammer, /tell yourbot !quotes set. Everything can be configured through the settings window.

To search the quotes, just do !quotes <search string>. If there is only one result, the quote will just be displayed. If there are multiple results, you will get a text window with the results and a 72 character preview of the quote.

Whoops, thanks

Updated to add searching of the quotes table.

Do you have MySQL configured to use a storage engine besides MyISAM by default? That's the only cause I can come up with unless you're running a version of earlier than 3.23.23.

You could try:
mysqldump -u user -p dbname --tables quotes > quotes-backup.sql
(Always backup your data when you're about to do something that could destroy your data.)
ALTER TABLE quotes ENGINE = MYISAM;
ALTER TABLE quotes ADD FULLTEXT(quote,contributor);

Otherwise around L253 you can find where I'm switching between doing a LIKE query (for a search term of 1 to 3 characters.) and a FULLTEXT search. If you remove the FULLTEXT search SQL you can stick to just a LIKE query, but you'll loose the flexibility and reverence sorting that comes with a FULLTEXT index search.

Updated again. Found and fixed a typo, also changed full text searching to bolean mode. You can now (optionally) use the boolean operators from http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html in your searches.

Even with the table set correctly to MyISAM I still got the same error as JJ. To fix this issue in a default installation of MySQL 5 on the MS Windows OS you need to go to:

c:\program files\mysql\mysql server 5.0\    and edit the my.ini file and change the line:

"default-storage-engine=innodb"
to
"default-storage-engine=myisam"

Then restart the mysql service.

Cheers 

Converted module to use Glara's new module settings plugin for all settings options.

No other changes.

http://www.jjones.co.uk/files/quotes.php

-jj-

You might get that in php5 if you don't have any quotes in your db. If you don't, add one then try.