ok so I kept getting the database errors too. I give up. If it gets to 99% and states that you have exceeded the database limit, does this mean that 99% of it is now on my system, or can I give up and this hack, not even pieces will be on my database?

Hi,

Im getting this message when I mis-spell a word.

Any ideas?

Thanks,

C

:woot:

Thanks dude :)

im sorry for not being around for a while
for all those getting DB errors please go to your products manager and uninstall old versions of vB Spell before installing the latest version

the problem mentioned by Pyrix will be fixed in the next release

the 99% problem could be caused by one of two things
either a script time out or your database doesnt have enough space to hold the dictionary
the next release SHOULD (if i have time) ask you what exactly you want to do during the install process (like clearing old settings, installing database or not, ect)

hopefully it will be ready by the end of the week

I'm still getting this error:

I had the 3.5x version already and re-uploaded the new files, set usergroup settings and when I uploaded the xml, I got this:

Spellcheck button is not showing up as well. How do I fix this?

I am getting a similar error. This is my first install of this script. It works when there isn't anything mispelled. I am also on the newest vBulletin 3.6.1

i put the files in my ftp then tried uploaded them in product manager and got db error i ahve no idea how to fix it i deleted all the files for tihs md off my ftp and still db error can anyone help?

cancell i got it .....

Can I get help on this please?

Is anyone going to help?

Please correct me if I am wrong but, in the installcode:
Why is this listed right after the create table? - the way that appears, anyone who sets that up will immediately create a table and then remove it. What should be the case is the Remove old vb Spell Table FIRST, then the Create if not exists. Although on paper, it would appear that it would not delete a regular non-prefixed vbspell table, it does, or in my case, did delete it. We had to manually (twice now - once for initial install, and once for reinstall after I reimported the product) set up the vbspell table.

LOL, reading through, someone else has already noticed this as well. :P

So how do I get this to work on my server? I tried to delete code, I tried everything listed on all 9 pages. Anyone have any clues that they could give me?

Christian:

Thanks. That fixed it.

Just remove

// Remove Old vB Spell Table
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "vbspell");

from the product install file and it loads just fine.

What is it [not] doing?

I installed it as normal... got db error when spell checking. I removed the
// Remove Old vB Spell Table
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "vbspell");
from the .xml install file, imported it again with overwrite enabled.... now clicking on the spell check does nothing.

If I remember correctly, I had to delete mine, and actually go to the table in phpmyadmin and smoke the vbspell table as well, then it worked.

lol... it's working now... maybe I wasn't holding my mouth right.

Dear all,

I just can't get this to install at all on 3.6.1. When I first tried a normal install with the dictionary file, I got the same problems many others have had: the install script took too long to run, and the server killed it. I then uninstalled the scraps of the mod that had wound their way into the system, and tried the alternative method (as above in this thread); but now always receive the following error during the import run:I've tried modifying the installscript as per comments above, but to no success.

I would deeply appreciate some assistance from anyone who's managed to get the script to work -- right now it simply doesn't function on 3.6.1, as it won't install.

monForum I would remove your IP address and username from the above post m8:)

monforum, I suspect you have had vbspell previously installed on your forums. If so, you will need to reupload the old install script for the OLD vbspell and run the install script and choose UNINSTALL (the lower half). Once done, this will remove the duplicate entries in the database that the NEW vbspell product is objecting to. After that, you should be able to install the product.

Same error here.

Fresh install, latest version of the product.

Removed line, uninstalled, reinstalled, works.

Any news on this? Waiting to install on a 3.6.1.

Have you tried to manullay create the table in the database?

Dominic,

If you are referring to me, no. I'm afraid of a mod that I have to start by removing code lines and then manually installing databases.

I have just upgraded my board to 3.6.1. I had vbspell installed when it was 3.5.3. Curiously, it did not appear in my list of products, therefore could not be uninstalled.
I have a clean system, with all other products removed. I have carefully followed all the instructions and I get the identical problem that everyone here reports (gets to 99% then has the error "Duplicate entry 'vbspell_allow_all' for key 1").
Finding the old product, re-installing and then removing again does not sound like fun.
Can anyone give me a rough idea where I would start to manually remove the tables from the old sucker? I am guessing that there is simply a vbspell table somewhere in my SQL and I am thinking that if I can just find it, delete the whole thing, this will fix the problem. Am I on the right track? If so, could someone please get me started on how I would go about doing this?

I didn't have to reinstall the old vbspell, but actually only upload the install file and do the uninstall from there.

Well, I did that (I'd forgotten that there was a php script used rather than the xml file - no wonder it did not appear in my list of products.)

Once I'd copied the script to the admin dir, I ran it, clicked on the uninstall and watched it go through all the steps successfully, telling me it was deleting all the bits properly on the way.

I then installed the product using the xml, but now it just seems to freeze somewhere between 50% and 98% (slightly different each time). It never gets far enough to give an error or to get complete.

It did complete (with the error) before I had done the uninstall of the old by re-uploading the php script from the old version (v0.9.12 ? vbspell_install.php). I know this because although it did not work , it still appeared in my list of products (I have since uninstalled it from there in my latest attempts).

Regardless of what I do now, the xml install just freezes at a different part with no error messages each time. When it freezes, there are no error messages, but the browser just says "done" instead of "loading" suddenly then it stops - eg:

Seems to me that I am completely stuck now and at the point of just giving up on it. A shame as this is the only real spell check for VB. I really wish it could be just built in and use AJAX to work to do funky things like automatically underlining words that it found wrong like modern apps do, but I would be happy with this if it just worked :tired: .

Curious, are you uploading the dictionary.doc file? If you are, you may want to hold off on doing so and try installing it without that in place. I had no issues just installing it as a product (without the dictionary.doc) and then I inserted the sql manually. Before you go back and retry, however, you may want to go to your vbspell table and remove the contents (what was previously inserted) including the vbspell table itself.

I'm getting a weird problem. When i type up my message and click my spell checker, i get this:

http://www.theanimeslash.com/images/error.jpg

I have tried to uninstall and reinstall the product, but to no luck.

Also, if the first word is Hey, it will give me that error (replace update with error) but if i use Hi as my first word its checks it fine. Update was another word that gave me an error.

Thanks for the help anyone.

MySQL Error: Table doesn't exist...
Read from post 132 on - on this page: https://vborg.vbsupport.ru/showthrea...=124578&page=9

David (and everyone else in here who's advice I have thus far used) - thanks very much for all your help so far. I just thought I should do a quick summary of what has happened with my install over the last few days that I have wasted doing this. It has become a long thread now and I know that most people will just read the stuff at the end, so hopefully this will help them.

As it stands now, I finally have a working spell checker, but I still get the problem of the spell checker window not opening in front (on Firefox). I might go and investigate this one myself unless someone else has already found the answer to fix this?

Here?s what I?ve done so far to get to this point:

I removed the code from the xml file (as suggested earlier by Pyrix - the bit which removed the database after it created it). I removed the dictionary.dic file so it was not referenced during the running of the xml file. This (as expected) did not spend ages installing and hanging somewhere before 99%, but immediately installed.
Now looking at my database from phpmyadmin, I can see the vbspell table has been created.
Then I import the database (the fullsql one posted by replicators) using BigDump, as suggested by Steadicamop. The vbspell table is now populated with the dictionary words when I check from phpmyadmin.
At this point the little "ABC" spelling check icon appears in my edit box as described here, but the spell check window hides behind the main one (which was meant to have been fixed in v0.10.2) :confused: This seems to be last great un-addressed issue that many people (including myself) still get.

I really like this plugin (as it really is the only option for something that should be built into all forums, of not built into all web browsers). Credit to Cynix2 for getting it this far. I look forward to the next release and I hope all these issues can be squashed soon.

Oh, one last bit I thought I should mention (this was brought up by bbcentral on the first page). The ability to add words to the dictionary is important for special interest forums. For example, I run a biofuels forum (which will be picked as a misspelled word). Curiously, "biodiesel" is now included and not corrected (this was not in the original dictionary - maybe it was in replicators one?).

Could someone perhaps outline some suggestions for editing the dictionary file before upload? (I did this on my own dictionary.dic, as it was already just a text file - sadly I could not end up using this option as I had to manually load the sql). I had a look at the format of the sql dictionaries, but was a little confused by the format of this. I'm sure it is very simple, but a little explanation would be nice. Also, is there an easy way to add a word from phpmyadmin? I'm sure there is, but being a complete newbie to mysql, a few pointers would be appreciated. :)

Also, I'm afraid I spoke too soon about it mostly working, it would seem that no words are suggested for any spelling errors. Sigh. I guess it is back to trawling through this long thread and wasting another day... :cross-eyed:

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
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). :D

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.

Just a note to say that the key to the problem I was having with install (as per my above post in this thread) was indeed on account of remnants of the older version still around. Re-uploading the installer for the 3.5.4 version and using it to firmly uninstall the old system seemed to sort the issue. The main installer for the new vbSpell still would work; but I did manage to get the 'alternative' installer to work, via importing the dictionary SQL files directly into the database. All now does seem to be working properly.

Comments on vbSpell for 3.6.x at present:

I'm delighted that vbSpell has finally been ported over to a version for 3.6, and indeed with some very pleasant improvements (the new check spelling icon, automatic integration into most templates, etc.). Once up and running, it seems to work rather well, and is a great asset to any forum.

I would summarize the issues with the 3.6 version at present as follows:

• Problematic installation process: The main problem with the hack is the complexity and unreliability of its installer. The default installer, with the dictionary as a flatfile for import, takes to much extended server time for most hosting server configurations, which kill the process and abandon the install. The 'alternate' installer provided in the discussion thread (1st page) provides a workaround for this, but the workaround presumes the user installing the hack has a working knowledge of SQL imports into a database (and indeed, has access to MySQLAdmin on their server, which many do not). All in all, it's a problematic process. I would think first priority would be to re-work the installer slightly, so that it uses a series of flat files (e.g. dict1.dic, dict2.dic, etc.) rather than simply one great enormous file, importing them in series so that the server is not in one sustained process. The installer really does need to work first go, first time.
• Traces of old installations: Many admins may not be clear that uninstalling the old 3.5. version of the hack from AdminCP > Manage Plugins > Uninstall doesn't actually remove all traces of the hack, and that the bits and pieces left behind from that manner of install in fact prevent sucessful installation of the 3.6 version. Either this should be explained explicitly in the current version's instructions, with guidance given on re-uploading the old installer and using it for a complete uninstall prior to running the new installer; or - far better - the installer for the current version should have a 'remove all traces of vbSpell for 3.5.x' feature as an option in the new installation process.
• Customizable dictionaries: One of the nicest 'new features' that could be added to really flesh out the hack would be some concrete guidance on how to use customized dictionaries with the hack, or advice on how to customize the standard/default dictionary that is provided. Ideally, an ability for the admin to upload a file of 'additional words' to augment the standard dictionary, without replacing it, would be perfect -- i.e. if there are a host of specialist or local words in common use on a forum, these could be compiled to a list and uploaded (or otherwise added in) by the administrator, so that they become a part of the standard dictionary.

It has been found that this hack causes a problem with the comments box in PhotoPost Pro. When this hack is enabled the Comments post box in each of the showphoto pages does not show at all and when disabled it does. Any idea how that can be fixed?

<a href="https://vborg.vbsupport.ru/showpost.php?p=1065575&postcount=97" target="_blank">https://vborg.vbsupport.ru/showp...5&postcount=97</a>

Thanks! That did it! :)

<i>If it ain't broke, don't fix it.</i>

I guess I shouldn't have upgraded to v0.10.2b (08/26/06).