Sorry to do 3 posts in a row, but I think I've made some progress.
Firstly, apologies for missing one of the posts in here: An easy way to add you own dictionary words from in phpmyadmin -
http://www.bbhosts.net/vbspell/ (thanks to bbcentral).
Secondly here is how I fixed it:
I completely removed the bits in the xml file about
// Remove Old vB Spell Table and
// Create vB Spell Table. As suggested by
Erwin here.
Then I made sure that my product was uninstalled and that my dictionary.dic (with my own edits for the extra words I wanted in it) was in my home dir. I ran this sql query on my database from phpmyadmin
PHP Code:
CREATE TABLE vbspell (word varchar(30) NOT NULL, sound varchar(10) NOT NULL, UNIQUE KEY word (word), KEY sound (sound));
This created my database table correctly for vbspell.
Lastly, I installed the edited product xml file and it ran with no problems, my spell check now works and with the extra words I added too (biodiesel and biofuels).
I just have the popup problem to solve now. I had a quick look, but decided that although I know how to make this happen on its own, it might be best left to the developer to do this in his own script.
Also, I noticed that the spell check button, although it appears in almost everything, including the quick reply, it does not show in the edit, only if you click on "go advanced". It would be nice if it also showed in the edit as well.