vB Spell

[cynix2]

What this does: vB Spell allows you to install a dictionary (English dictionary included) into your MysQL database, and provide a spell checking window that works in both of vB's editor modes, standard and WYSIWYG.

Background: This mod was originally developed by tamarian for vB 3.5.x. With the release of 3.6.x the installer stopped working for fresh installs and the template changes were considerably out of date, tamarian gave me permission to release a 3.6.x version with updates.
This version should work with both 3.5.x and 3.6.x series.

Features:
Supports most recent versions of browsers. Tested on IE, Firefox, Mozilla/Netsacpe, Opera and Konqueror (Konqueror implies Safari, but please confirm Mac folks).
Learn Feature uses cookies, so it won't increase the database size.
Admin panel options.
Spell Check button appears anywhere there is a WYSIWYG Enhanced or Standard Editor Toolbar .
Skips quoted text and other tags (PHP, code, etc.).
Usergroup permisisons.
Template based interface, and uses your default style.
Link buttons (Thesarus and Lookup) with links to Merriam Webster's online thesarus and dictionary links with the suggestion for misspelled words.


Installation:
Unzip main package.
Upload the contents of the 'upload' folder to your forum home directory.
Regular Install:
Unzip dictionary-reg.zip.
Upload DICTIONARY.DIC to your forum home directory.

Alternate Install
Unzip dictionary-alt.zip.
Import the SQL files to your database.

Import product-spellvb.xml.
Go to AdminCP > vBulletin Options > vB Spell and edit your usergroup permisisons.
Template changes are now automatic. [accept for quickedit]

Q: What is the Alternate Install method for?
A: If you are having problems with the Regular Install (such as your dictionary import freezes at x%) then you should consider using the Alternate Install. If neither of these methods work for you then there might be an issue with your server host.

Upgrading:
Unzip main package.
Upload the contents of the 'upload' folder to your forum home directory.
Import product-spellvb.xml.


To manually force the quickedit template to work with this mod:
postbit_quickedit
Find <if condition="is_browser('ie')">
<td><img src="$stylevar[imgdir_editor]/separator.gif" width="6" height="20" alt="" /></td>
<td><div class="imagebutton" id="{$editorid}_cmd_spelling"><img src="$stylevar[imgdir_editor]/spelling.gif" width="21" height="20" alt="$vbphrase[check_spelling]" /></div></td>
</if>Replace with <td><img src="$stylevar[imgdir_editor]/separator.gif" width="6" height="20" alt="" /></td>
<td><div class="imagebutton" id="{$editorid}_cmd_spelling(null)"><img onclick="spellCheck('3', '$editorid', '2');" src="$stylevar[imgdir_editor]/spelling.gif" width="21" height="20" alt="$vbphrase[check_spelling]" /></div></td>

History:
0.10.x NyNe versions
v0.10.3b - 06/22/07:
Compensated for an issue brought up in this post (https://vborg.vbsupport.ru/showpost.php?p=1253657&postcount=299).
v0.10.3 - 06/22/07:
Added a check to the product installer so it would not remove the vbspell table after just having created it.
Added $vboptions to all template code that asks for files (this *might* fix the PhotoPost issues - no promises).
v0.10.2b - 08/26/06:
Fixed error in product installer (removed table prefix).
Changed all <? to <?php for php5 compatibility.
v0.10.2a - 08/26/06:
Removed alt product installer.
Product installer included now checks for dictionary file, if dictionary file is not found it continues installing.
Product installer no longer drops dictionary table before installing.
v0.10.2 - 08/22/06:
vbspell template is now XHTML 1.0 Transitional.
Fixed a version check for vbspell template (made compatible with 3.5.x).
vB Spell window should now open on top of other windows.
Removed table prefix for vbspell sql table (product installer includes code to remove old tables).
Included alternate installation method (Credit goes to Replicators for the SQL Install method).
v0.10.1 - 08/21/06:
Beta release for 3.6.x series.
Switched to product/plugin based installer.

[I]0.9.x tamarian versions
v0.9.12 - 12/25/05:
Security fix for cases where you allow HTML posts and they contain malicious code (Credit goes to Brendan Donahue for finding the issue and alerting TechGuy, and to TechGuy for alerting me to it).
v0.9.11 - 11/02/05:
Fixes a bug with slashes in text.
v0.9.10 - 10/17/05:
Check for primary and secondary group for permission.
Bug fix for quoted words.
v0.9.9 - 09/13/05:
Bugfix for JS on IE with RC3.
v0.9.8 - 07/15/05:
Bugfix for JS code mismatch with template.
v0.9.7 - 07/14/05:
Initial release for vB 3.5 beta-4.

NOTE: The above section says NyNe versions, because I go by the name NyNe everywhere accept here.

[B]Scrrenshots: (from tamarian's 3.0.7, but it's identical)

[cynix2]

Please give feedback.

Im not sure how well this works on Macs (if at all).

[amnesia623]

Has this been successfully installed on 3.6?

[Replicators]

Ran into the same problem i had with tam's hack and that is "exceeding max questions", i would suggest having the dictionary as a .sql and just have the product small and painless, or more people will run into this problem. I get to 98% then get a db error.

I will see if i can do it myself, and put it up on here. Also you shouldn't use admincp as a directory as some people do rename this folder for security reasons.

[Replicators]

I redone the way this mod handles the dictionary. Instead of drawing from the dictionary, it will use sql files instead. This is for only the people that get "Exceeded Max Questions" when importing the product. If it imports fine, DO NOT use this!

There was some changes done to the product file aswell as the vbspell.php, as i took out the use of table prefix and instead use just vbspell as a DB table.

@cynix2 - If i was wrong for doing this, pm me, and i will remove this. It is just another way of doing it, and i did give you full credit for it.

[DaveAK]

As with the 3.5.x version the path to the DICTIONARY.DOC file is hard coded. Some people may not be using admincp for their control panel directory.

Other than that all seems good! Thanks!

(I haven't made the QuickEdit mod yet though, but I see no reason why that should give any problems.)

[DaveAK]

OK, I made the Quick Edit mod and that seems to work as well, but one annoying thing is that when you click the icon the popup window is hidden behind the main browser window. I'm using the latest FireFox on XP. Any ideas as why it does this?

[Azhrialilu]

I might try this, although I don't really like automatic template edits as they generally don't work for me as I customise my styles so much lol so expect me to be back asking what the edits are and where I need them to go :)

[Maagic]

Has this been successfully installed on 3.6?

Just did and it is working as described.

[Snake]

Excellent been waiting for this! :)

[bbcentral]

I just did a test on my 3.6.0 test server, and it failed.
It got to 97%, then:
Fatal error: Maximum execution time of 30 seconds exceeded in MY_SITE_ROOT\forum\admincp\plugin.php(1924) : eval()'d code on line 24

I am trying again using Replicators' version above.
I've imported the product XML, this time it worked.
Importing the SQL files using phpMyAdmin...
Full SQL is too large (I have an 8MB upload limit).
Trying with Split SQL...
I strongly recommend deleting the ZIP files after you import each one.
This way you don't lose track of which one you are up to, and don't get duplicate records.
Part 1 and 2 worked, part 3 isn't working.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO vbspell VALUES ('dacryon', 'TKRYN')' at line 1
Seems to be something to do with importing zip files. I'll import the SQL file instead.
Still doesn't work. I had to resave the file in DOS format for it to import correctly. Seems part 1 and 2 are DOS format SQL files, the rest are UTF-8, and I can't import them unless I resave them in DOS format.
All files imported, vbspell has 192,917 rows of data.
Just made a post, the spellcheck button appears now. It corrected both words I spelt wrong, however when you click the spellcheck button the new window opens as a pop-under. I'm using Firefox on XP.

Apart from that, all working! Thanks to both of you for doing such a great job, now I get to try doing it on my live forum! :D

[jrofosho]

I get this error when i click the "Check Spelling" icon:

Warning: main(./includes/searchwords.php): failed to open stream: No such file or directory in /vbspell.php on line 40

Fatal error: main(): Failed opening required './includes/searchwords.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/range/public_html/vbspell.php on line 40

[bbcentral]

That's a weird one jrofosho.
I know this is obvious, but does that searchwords.php file definitely exist in the includes folder?
It's part of vBulletin.

[bashy]

Hi

Just installed on 3.6 and install went 100% ok
Using it is different though, Window is behind browser and the window aint right please see image

Any ideas please....

Before anyone says out.....yes, its me, the one with all the hacks installed...
Look he's at it again....lol :p

[bbcentral]

Bashy, I guess any problems you're having are because of another mod :)
I've only got a few installed and it works with them. I think you've got some template editing to do :P
wow, I'm stunned! If I tried to install that many hacks, I'd get beaten up by my members :D

[bashy]

The issue in the image is the portal i use m8....

I would not have a clue how not to get the portal to show up in the popup :(

Oh well, looks like this aint for me :(

[cynix2]

I get this error when i click the "Check Spelling" icon:

Warning: main(./includes/searchwords.php): failed to open stream: No such file or directory in /vbspell.php on line 40

Fatal error: main(): Failed opening required './includes/searchwords.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/range/public_html/vbspell.php on line 40
searchwords.php comes with vB, you might want to re download the vB package from vbulletin.com and then upload the file to the includes folder

Hi

Just installed on 3.6 and install went 100% ok
Using it is different though, Window is behind browser and the window aint right please see image

Any ideas please....

Before anyone says out.....yes, its me, the one with all the hacks installed...
Look he's at it again....lol :p
can you send me the plugins your portal uses?

[cynix2]

I redone the way this mod handles the dictionary. Instead of drawing from the dictionary, it will use sql files instead. This is for only the people that get "Exceeded Max Questions" when importing the product. If it imports fine, DO NOT use this!

There was some changes done to the product file aswell as the vbspell.php, as i took out the use of table prefix and instead use just vbspell as a DB table.

@cynix2 - If i was wrong for doing this, pm me, and i will remove this. It is just another way of doing it, and i did give you full credit for it.
no it's cool, glad you made the changes, i'll include it as a download
the only thing i dont really like is the table prefix being missing, but it's not a big deal

[deegan]

I uploaded both the upload folder, and the dictionary zip, now I am at a loss for what to do next, as I don't see vbspell in my list on vb options?

[cynix2]

first off dont upload the upload folder, open the folder and upload what's inside
secondly dont upload the dictionary zip, unzip it and upload what's inside (assuming you're doing the regular install, if not you'll need to import the sql files)

then import the product file to vB's product manager

[bbcentral]

I run a Blues Brothers forum, and I needed a way to add "Aykroyd" to my dictionary (somehow "Belushi" was already in there!), as well as any words we come across that should be in the list.
I searched this thread, and the other vB Spell thread and couldn't find any easy way to add new words, apart from the Learn cookie method (which isn't much help in this case). Until this feature is added (perhaps as an AdminCP thing), here's a page I threw together quickly to generate the SQL required to add a new word to your dictionary. I assume this also works for 3.5.x, if they're using the same vbspell table structure.

http://www.bbhosts.net/vbspell/

You should be able to just copy/paste the SQL into phpMyAdmin, or whatever database admin software you use.

If it's useful to anyone let me know, extra feature ideas are welcome :)

[deegan]

first off dont upload the upload folder, open the folder and upload what's inside
secondly dont upload the dictionary zip, unzip it and upload what's inside (assuming you're doing the regular install, if not you'll need to import the sql files)

then import the product file to vB's product manager

O.k, thanks, did that, I did unzip the diction. sorry, I am not sure about the last part of your instruction?, please let me thank you in advance

"then import the product file to vB's product manager"

Should I erase that upload folder in there?

[cynix2]

keep everything you've done so far, go to the plugins and products section in your admin cp and click manage products, then click add/import product, browse for product-spellvb[reg].xml
click import

[cynix2]

bbc that is a good idea, i'll look around for a good way to add a page to the admincp so that this can be done

[deegan]

keep everything you've done so far, go to the plugins and products section in your admin cp and click manage products, then click add/import product, browse for product-spellvb[reg].xml
click import

When I browse, it takes me to my pictures, sorry, I am totally ignorant to this system, and computers period. How do I get to my ftp, or should I just find it on my desktop.

[transitbus]

well installing this crashed mysql (max 50,000) by using the regular install method so I think you need to break up the regular install into chunks like you do in the alt install.

Now to wait on hold forever to have my host restart mysql. :angry:

[deegan]

I think I'm missing a step here, how to communicate with my host, is there some way to do this, perhaps a setup that allows me to transfer files and what not?

[steadicamop]

Got this installed, took a bit had to do a progressive dump into mysql to get it working!!

Now I got that far, no text actually shows on the spell checker, it must give me options but the text just isn't there, it changes it to nothing!!!

Also the pop up window it opens in isn't long enough, the text box just disappears off the side....

HELP!!

[transitbus]

To me this isn't worth crashing and f'ing up your database over. I got the exceed 50k error both ways so I have decided to forget this for now.

[bashy]

There aint any m8...its a stand alone, but intergrated, does that make sense... www.mkportal.it


can you send me the plugins your portal uses?

[deegan]

Anyone know anything about importing from your server?

I can't seem to find the stuff I have put in my admincp?

[steadicamop]

Sorry - sussed out why it wasn't working correctly; I dumped the data into the DB first then installed the product - which wipes the table first, so removed everything I just uploaded!!

For anyone having problems getting the Dictionary into the database, try this:

http://www.ozerov.de/bigdump.php

It can dump very large sql files into the database in small chunks, very simple and works extremely well, and doesn't crash out your database!!

Cheers

Jason

[deegan]

Ahhh, o.k, didn't see that other file on my desktop the vb spell reg. got it now, but it says.................

Warning: filesize(): Stat failed for ./DICTIONARY.DIC (errno=2 - No such file or directory) in /admincp/plugin.php(1232) : eval()'d code on line 18

Warning: fopen(./DICTIONARY.DIC): failed to open stream: No such file or directory in /admincp/plugin.php(1232) : eval()'d code on line 19
Unable to open dictionary file: ./DICTIONARY.DIC

[cynix2]

@bashy
open ./includes/functions.php
find and remove//added from MKportal
define ( 'IN_MKP', 1 );
require_once "../mkportal/include/VB/vb_out.php";
$output = mkportal_board_out($output);
//end addedcreate a new plugin on the 'global_complete' hook call it 'MK Portal' with the following code$holdmkp[] = "vbspell";
$mkp = "yes";

foreach ($holdmkp as $id => $item) {
if(strpos($filename, $item) === false || strpos($userinfo['location'], $item) === false){ $mkp = $mkp; } else { $mkp = "no"; }
}

if ($mkp = "yes") {
//added from MKportal
define ( 'IN_MKP', 1 );
require_once "../mkportal/include/VB/vb_out.php";
$output = mkportal_board_out($output);
//end added
}if you have any other pages you dont want the sidebar on just add more lines ad the top like this$holdmkp[] = "index";
$holdmkp[] = "showthread";ect...
that SHOULD fix the problem with that portal

[cynix2]

@deegan
you didnt upload the dictionary.dic file to your forum home directory
please do this first, THEN import the product
also make sure you've uploaded all the files from the main package as well (not just the dictionary)

[deegan]

@deegan
you didnt upload the dictionary.dic file to your forum home directory
please do this first, THEN import the product
also make sure you've uploaded all the files from the main package as well (not just the dictionary)

So the dictionary. dic goes to home, not admincp?

[bashy]

Cheers m8

So...doing this, i wont loose the Forum within the portal look will i?
Cause that bit you said to remove is thet bit that does that ya see?

Nother issue....

On uninstall it dont uninstall properly.....

Please see image..... How do i rectify that please?


@bashy
open ./includes/functions.php
find and remove//added from MKportal
define ( 'IN_MKP', 1 );
require_once "../mkportal/include/VB/vb_out.php";
$output = mkportal_board_out($output);
//end addedcreate a new plugin on the 'global_complete' hook call it 'MK Portal' with the following code$holdmkp[] = "vbspell";
$mkp = "yes";

foreach ($holdmkp as $id => $item) {
if(strpos($filename, $item) === false || strpos($userinfo['location'], $item) === false){ $mkp = "yes"; } else { $mkp = "no"; }
}

if ($mkp = "yes") {
//added from MKportal
define ( 'IN_MKP', 1 );
require_once "../mkportal/include/VB/vb_out.php";
$output = mkportal_board_out($output);
//end added
}if you have any other pages you dont want the sidebar on just add more lines ad the top like this$holdmkp[] = "index";
$holdmkp[] = "showthread";ect...
that SHOULD fix the problem with that portal

[cynix2]

@bashy
wait no the plugin above is wrong
changeif(strpos($filename, $item) === false || strpos($userinfo['location'], $item) === false){ $mkp = "yes"; } else { $mkp = "no"; }toif(strpos($filename, $item) === false || strpos($userinfo['location'], $item) === false){ $mkp = $mkp; } else { $mkp = "no"; }*updated in original post*

that should keep the portal on your pages but not show it on the spell checker

as for the uninstall stuff, make sure your templates for editor_toolbar_on, postbit_quickedit, and showthread_quickreply are reverted

[deegan]

It appears to be working, thanks, I put it in the folder above admincp.

Should I erase the other dictionary files I put elsewhere, or does that matter?

[cynix2]

@deegan
it wastes space, so i recommend you delete all *.dic files now that your installation is complete, but there is no need to remove them if you dont want to or dont feel comfortable doing it

[nineball]

I did the install and it went ok, but I don't see the spell check button. Does the install modify newreply template. Mine is not modified. Usergroup permissions look ok. Does anyone know the code which needs to be in the newreply template for the button to show up

[deegan]

@deegan
it wastes space, so i recommend you delete all *.dic files now that your installation is complete, but there is no need to remove them if you dont want to or dont feel comfortable doing it

Well I see it under my plug ins, but don't see the spell ckeck on the forum. It says that something was wrong with my database at the bottom? Do I need to edit it somehow?

[bashy]

Ok i have done the plugin and removed the part from the functions.php

I aint reinstalled this yet though...
I did have the menu control hack (extra navbar buttons) showing above the navbar untill i do this delete from the functions and create the plugin..
the buttons (top buttons) only show on the forumhome template, no other.

Any ideas on this 1 please?

@bashy
wait no the plugin above is wrong
changeif(strpos($filename, $item) === false || strpos($userinfo['location'], $item) === false){ $mkp = "yes"; } else { $mkp = "no"; }toif(strpos($filename, $item) === false || strpos($userinfo['location'], $item) === false){ $mkp = $mkp; } else { $mkp = "no"; }*updated in original post*

that should keep the portal on your pages but not show it on the spell checker

as for the uninstall stuff, make sure your templates for editor_toolbar_on, postbit_quickedit, and showthread_quickreply are reverted

[bashy]

Just tried adding the lpp messenger to the plugin like below
It still shows the portal sides though in the messenger popup

Do i need to add .php to this 1 lpp_messenger

Actually i have removed the bit i added cause the messenger aint working, with it removed it still dont work.
I trnued off the plugin that i just created from your advise and it works now.... :(

Any ideas or is this getting too complicated now?


$holdmkp[] = "lpp_messenger_sent";
$holdmkp[] = "lpp_messenger_write";
$holdmkp[] = "lpp_messenger_read";
$holdmkp[] = "lpp_messenger_popup";
$holdmkp[] = "lpp_messenger";
$holdmkp[] = "vbspell";
$mkp = "yes";

foreach ($holdmkp as $id => $item) {
if(strpos($filename, $item) === false || strpos($userinfo['location'], $item) === false){ $mkp = $mkp; } else { $mkp = "no"; }
}

if ($mkp = "yes") {
//added from MKportal
define ( 'IN_MKP', 1 );
require_once "../mkportal/include/VB/vb_out.php";
$output = mkportal_board_out($output);
//end added
}

[cynix2]

what is this lpp messenger you speak of?

[bashy]

Here ya go...lpp https://vborg.vbsupport.ru/showthread.php?t=109361&highlight=lpp+messenger

Me is going bed now, uip early an all that so speak tomoz evening :)
Take care all :)

[transitbus]

Ok got this working by using multiple temp db accounts. Stupid host and their max limit :(

[kdholdom]

When I try to upload using the Plug-in & Product System I get this message:

Fatal error: Maximum execution time of 30 seconds exceeded in E:\inetpub\vhosts\nacellphoneforums.com\httpdocs\i ncludes\class_core.php on line 354

Does anyone know what I am doing wrong?

[mholtum]

I have used this plugin for 3.5.x for quite some time and love it. I installed this, no problems, and cant seem to fin the spell check button. Am I retarded? If it is the default check spelling button, it doesnt work

[cynix2]

I have used this plugin for 3.5.x for quite some time and love it. I installed this, no problems, and cant seem to fin the spell check button. Am I retarded? If it is the default check spelling button, it doesnt work
the screenshots have a picture of the editor with a spell check button in the top right corner, it's not a submit button anymore

[bashy]

Ok...any more thoughts wih this plugin lark for me please,,,,

Then hack Menu Control no longer shows on any page other than the forumhome when the plugin is activated...

[kylek]

Got this installed, took a bit had to do a progressive dump into mysql to get it working!!

Now I got that far, no text actually shows on the spell checker, it must give me options but the text just isn't there, it changes it to nothing!!!

Also the pop up window it opens in isn't long enough, the text box just disappears off the side....

HELP!!


I am having the same problem, no words are giving or shown for the correct spelling of the mispelled word.

Also the pop up screen opens but "hides" behind the original page opened, you have to go to the toolbar to find and open it.

[clearchannel]

I have used this plugin for 3.5.x for quite some time and love it. I installed this, no problems, and cant seem to fin the spell check button. Am I retarded? If it is the default check spelling button, it doesnt work

I have the same problem. I've used this program for quite sometime in 3.5x, after installing in 3.6 I click the spell check button, and nothing happens?

[clearchannel]

I reverted the few templets I had edited for the 3.5 version, and also removed the snippit of code I had forgotten about in the header and headerinclude templates.

I then reinstalled the product and all seems to be working for me now.

[clearchannel]

I spoke to soon. If there is no text in the message box and I click on the spelling icon, I get a pop up telling me the spell check is complete.

If I add text to the reply box, click on the spell icon, the spell box popsup behind the forum page, then when I close down the forum window I see the popup spelling box, it contains the errors, but does not offer suggestions to fix the spelling errors.

A complete mystery if you ask me.

[haddockman]

I have had to uninstall the hack because it won't work with photopost. It stops the quick reply working and you can't leave comments on photos.

[BETIServices]

I had installed and o.k for now, the only thing is that when I click spell check it will go and hide behind IE opened browser

[King Kovifor]

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
REPLACE INTO vbspell VALUES ('aa', 'A');
REPLACE INTO vbspell VALUES ('aaas'' at line 1

Get that when trying to run the first 9999 lines of the vbspell01.sql file.

[DaveAK]

I see you have a 10.2 - I installed 10.1. Can I upgrade without doing the dictionary install again? I just want to fix the window popup to make sure it opens on top of the browser window.

[Evolution06]

I have installed this hack and when I click the abc the window pops up but there is no suggestions in the box for the misspelled word how do i get it to show?

[cynix2]

new version with a ton of product installer updates
upgrading to new versions no longer required you to re import the dictionary

[scdurwood]

Any help on the issue of the pop-up being hidden?

[kylek]

Just uninstalled and re-installed and it is still doing the same thing, pop up window disappears under other windows, and no words are being shown for suggested words.

[Jim O]

Just uninstalled and re-installed and it is still doing the same thing, pop up window disappears under other windows, and no words are being shown for suggested words.
I had the same thing happen for the words. Turned out that even though it appeared to install the dictionary 100%, the vbspell table in the db was empty. I used the "alt" dictionary which contains 10 SQL files and inserted the data with phpMyAdmin and it is working. Can't help you with the pop-under problem. It's working as a pop-up in Firefox and IE 6 for me.

[kylek]

I had the same thing happen for the words. Turned out that even though it appeared to install the dictionary 100%, the vbspell table in the db was empty. I used the "alt" dictionary which contains 10 SQL files and inserted the data with phpMyAdmin and it is working. Can't help you with the pop-under problem. It's working as a pop-up in Firefox and IE 6 for me.

Thanks very much Jim O!!

After your post I checked and my vbspell table was empty, imported the files and now works like it should.

Pop up window works in IE 7 beta now, just in Firefox it hides, have to look if there is a setting I am missing in Firefox.

Thanks again.

[Erwin]

Something's wrong with the XML product.

All you need to do to use the default DICTIONARY.DIC way of install is to run this query:


CREATE TABLE vbspell (word varchar(30) NOT NULL, sound varchar(10) NOT NULL, UNIQUE KEY word (word), KEY sound (sound));


Then in the XML product file, delete this bit:


// Create vB Spell Table
$db->query_write("CREATE TABLE vbspell (
word varchar(30) NOT NULL,
sound varchar(10) NOT NULL,
UNIQUE KEY word (word),
KEY sound (sound)
) TYPE=MyISAM");


and the normal install procedure should work.

Also, the php files should have this changed from:


<?


to


<?php


For it to work with PHP 5.x.x.

Also, the popup hides behind other windows for some reason.

:) Works well otherwise.

[jgommel]

Okay I've fully tested the newest version of vB Spell and confirmed that it does not work with Photopost v5.31 or Reviewpost v3.31. As long as this plugin is enabled, you do not get the message box (like the one I'm typing in right now) I've tested this on both a Mac (Safari and Firefox) and a PC using (IE and Firefox).

With the plugin turned on, it works great on all platforms mentioned above. I really hope this can be fixed so that it works with both Photopost and Reviewpost. I have both of these products installed on two of my websites.
N.E.O.S.M.U.T. Paintball (http://www.neosmut.com) and F/Stopmedia Photography (http://www.fstopmedia.com)

If the developer needs me to test a build later (if he/she decides to fix this issue), please feel free to contact be via PM. I'm eagerly awaiting a fix. Great Job so far!!!!

Thanks!

[King Kovifor]

Something's wrong with the XML product.

All you need to do to use the default DICTIONARY.DIC way of install is to run this query:


CREATE TABLE vbspell (word varchar(30) NOT NULL, sound varchar(10) NOT NULL, UNIQUE KEY word (word), KEY sound (sound));


Then in the XML product file, delete this bit:



and the normal install procedure should work.

Also, the php files should have this changed from:


<?


to


<?php


For it to work with PHP 5.x.x.

Also, the popup hides behind other windows for some reason.

:) Works well otherwise.

Is that for me?

[mholtum]

the screenshots have a picture of the editor with a spell check button in the top right corner, it's not a submit button anymore
Yea, but when I click it nothing happens.. :confused:

[Masters]

Fatal error: Maximum execution time of 30 seconds exceeded in \forum\includes\class_core.php on line 354

How do I fix this problem?

[Erwin]

Is that for me?
No, that was for anyone interested.

[orphan]

hmm Installation went smoothly, no problem at all

But when i try to us it i get a redirection to http://www.iespell.com/download.php

Anyone know why ?

[mholtum]

nevermind

[orphan]

hmm Installation went smoothly, no problem at all

But when i try to us it i get a redirection to http://www.iespell.com/download.php

Anyone know why ?


just forget that question, i've just learned to read :rolleyes:

[h_kakashi]

I wonder is there anyway to make this compulsary and appear in the same window. That would be great :D

[Veer]

Hi,

I've installed but Spell checker not suggesting any words :(

Whats wrong with this? Please check my attached images.

Uploaded Files Locations:
1- DICTIONARY.DIC = Forum Home and admincp folder
2- vbspell.js = Forum Home
3- vbspell.php = Forum Home
4- vbspell_iframe.php = Forum Home


Thanks.

[h_kakashi]

Hi,

I've installed but Spell checker not suggesting any words :(

Whats wrong with this? Please check my attached images.

Uploaded Files Locations:
1- DICTIONARY.DIC = Forum Home and admincp folder
2- vbspell.js = Forum Home
3- vbspell.php = Forum Home
4- vbspell_iframe.php = Forum Home


Thanks.

The reason for this is because the dictionary wasn't loaded into the database properly. You will have to do it manualy using phpmyadmin or something similar.

[Dennis Olson]

To correct the 30 second timeout, you need to go into your PHP config file and set the timeout value UP from 30 seconds. IIRC, I set mine to 90 seconds, and I never get those messages anymore. As to this add-on, I think I'll let it "age" just a bit more before I try installing it.....;)

[jw00dy]

This mod is awesome. Thank you.

The import on mine worked just fine the automatic way.

*clicks install*

v 3.6.0

[Masters]

To correct the 30 second timeout, you need to go into your PHP config file and set the timeout value UP from 30 seconds. IIRC, I set mine to 90 seconds, and I never get those messages anymore. As to this add-on, I think I'll let it "age" just a bit more before I try installing it.....;)
Which config??

I don't see the option in config.php

[mholtum]

Ok, installed fine, checks for misspelled words, however, it doesnt give me a choice of the correct spelling when it finds one. Did I miss something?

[o0Hubba0o]

Ok, installed fine, checks for misspelled words, however, it doesnt give me a choice of the correct spelling when it finds one. Did I miss something?
Yes, about 3 or 4 posts with the same problem and the answer given. :P

The reason for this is because the dictionary wasn't loaded into the database properly. You will have to do it manualy using phpmyadmin or something similar.

This is explained how to be done in another post too.


For those that are having the problem with no replacement suggestion showing up, or like it was doing for me where every word was wrong with no suggestion see this post:

https://vborg.vbsupport.ru/showpost.php?p=1061639&postcount=66

I unistalled the product and did what's mentioned in that post and it works fine now.

[Moparx]

<script type="text/javascript" src="vbspell.js"></script> and
<form name="spell_form" id="spell_form" method="POST" target="spellWindow" action="vbspell.php">
<input type="hidden" name="spell_formname" value="" />
<input type="hidden" name="spell_fieldname" value="" />
<input type="hidden" name="spellstring" value="" />
</form>

are inserted into every single page on the forum (index, showgroups, etc etc) instead of being limited to just showthread, newthread, usercp_shell, etc.

is there an easy way to fix this?
i have disabled the plugin & inserted the code into my templates for the time being.

thanks for your help & great plugin :)

[Dennis Olson]

Which config??

I don't see the option in config.php

I gotta go find it. I'll report back when I do....

[cynix2]

<script type="text/javascript" src="vbspell.js"></script> and
<form name="spell_form" id="spell_form" method="POST" target="spellWindow" action="vbspell.php">
<input type="hidden" name="spell_formname" value="" />
<input type="hidden" name="spell_fieldname" value="" />
<input type="hidden" name="spellstring" value="" />
</form>

are inserted into every single page on the forum (index, showgroups, etc etc) instead of being limited to just showthread, newthread, usercp_shell, etc.

is there an easy way to fix this?
i have disabled the plugin & inserted the code into my templates for the time being.

thanks for your help & great plugin :)
is there any particular reason you dont want it on all pages?

[Moparx]

is there any particular reason you dont want it on all pages?
you mean besides the fact that the code does absolutely nothing on all the other pages and just takes up space? :p

[cynix2]

the code has no visual effect on any page, it does output a few more bytes of information than a page without it would, but the code shouldnt effect the performance of the page even in load times (noticably anyways)

[cynix2]

IMPORTANT UPDATE
0.10.2a had a critical error in it's installation process which prevented dictionary files from being loaded into the database. this has been fixed in 0.10.2b

[AyeCapn]

I don't appear to have a spell check button anywhere...

[Erwin]

IMPORTANT UPDATE
0.10.2a had a critical error in it's installation process which prevented dictionary files from being loaded into the database. this has been fixed in 0.10.2b
Do you know why the window minimizes straight away when it opens?

[badham]

Do you know why the window minimizes straight away when it opens?


Yeah....<a target "vbspell" href=.........in front of the vbspell index command (example)should keep the window on top......My intall with 00.10.2b did not install the database either...and mine was a fresh install.......I had to create the vbspell database and then I loaded the alt dic in the database......works fine as far as the spell check now...........but it the window does minimize...I" am gonna play with the file and see if I can alter that.

badham

[o0Hubba0o]

I don't appear to have a spell check button anywhere...

Did you look here? It tends to elude people, I was looking for the button that used to be next to the preview when I first installed it, then did a search of this thread and found out where it is.

https://vborg.vbsupport.ru/

[jw00dy]

I had to uninstall this due to it messing up the reply/comments stuff in Photopost Pro. anyone know of a fix? I'd LOVE to use this.

[brvheart]

I installed with no issues.....if I click the spell check buttong while no text is in the box.....it pops up...if I have typed and then press spell check I get the following:

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT word FROM vbspell WHERE word = 'thhis';

MySQL Error : Table 'mmaworld.vbspell' doesn't exist
Error Number : 1146
Date : Friday, September 1st 2006 @ 09:25:45 AM
Script : http://www.mmaworld.org/vbspell.php
Referrer : http://www.mmaworld.org/newthread.php?do=newthread&f=18
IP Address :
Username :
Classname : vb_database

[badham]

I installed with no issues.....if I click the spell check buttong while no text is in the box.....it pops up...if I have typed and then press spell check I get the following:
CREATE TABLE vbspell (word varchar(30) NOT NULL, sound varchar(10) NOT NULL, UNIQUE KEY word (word), KEY sound (sound));


run this qerry and then querry in the the alt dictionary both via phpmyadmin. The problem is that the product does not create the table in alot of cases...if you will not remove anything, just run the create table script via SQL and then querry in the 10 sets of dictionary querries via SQL it will work like a charm

badham

[Pyrix]

For some reason the product's install code drops the vbspell table as soon as it's created it, unless you have a table prefix!

$db->hide_errors();
// Create vB Spell Table
$db->query_write("CREATE TABLE IF NOT EXISTS vbspell (
word varchar(30) NOT NULL,
sound varchar(10) NOT NULL,
UNIQUE KEY word (word),
KEY sound (sound)
) TYPE=MyISAM");

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

I can only assume the coder was asleep when he wrote it ;)

The product file needs to be editted and reattached here. The above code would work well if it was...


$db->hide_errors();

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

// Create vB Spell Table
$db->query_write("CREATE TABLE IF NOT EXISTS vbspell (
word varchar(30) NOT NULL,
sound varchar(10) NOT NULL,
UNIQUE KEY word (word),
KEY sound (sound)
) TYPE=MyISAM");


This way the table is cleared, but a new one is created! Previously it would create a new table, then delete it straight away so your dictionary words had nowhere to go?!?!?!?

Bizarre :p

Ollie

[Pyrix]

I had to uninstall this due to it messing up the reply/comments stuff in Photopost Pro. anyone know of a fix? I'd LOVE to use this.

Sure,

Go to Plugin Manager in your admin control panel and edit the plugin 'vB Spell Template Changes'.

Add the following line at the very top before anything else:

if ( VB3_INTEGRATION != "on" ) {

and the following after the very last line:

}

Because the VB3_INTEGRATION variable should be defined when the WYSIWIG editor is being called from photopost, it'll fail that condition and the code to include the spell check won't be called.

You won't get spell check in the gallery, but you can still use it in the forums without messing up the gallery.

Works for me anyway ;)

Ollie

[brvheart]

CREATE TABLE vbspell (word varchar(30) NOT NULL, sound varchar(10) NOT NULL, UNIQUE KEY word (word), KEY sound (sound));


run this qerry and then querry in the the alt dictionary both via phpmyadmin. The problem is that the product does not create the table in alot of cases...if you will not remove anything, just run the create table script via SQL and then querry in the 10 sets of dictionary querries via SQL it will work like a charm

badham

ok thanks....I am sorry for the ignorance on this....but I do not know how to run that query....can I do it via admin panel? Again sorry...this is nothing that I have done before....

[brvheart]

I got the first one...but do not know where or how to do this:

and then querry in the the alt dictionary both via phpmyadmin


sorry :(

[badham]

ok thanks....I am sorry for the ignorance on this....but I do not know how to run that query....can I do it via admin panel? Again sorry...this is nothing that I have done before....


Yes...go to ADMINCP>>Maintance>run SQL querry You can copy and paste the above code and the run the querry....it will ask you if you are sure...click continue. What you have done is made a table in your database called vbspell....now you can unzip the dictonary alt download. you will find 10 txt notepads...open one, copy it and the paste it in the run sql querry section and click run.....do this one at a time for all 10 and you will be good to go. It is easier if you use phpmyadmin...but since you are not familiar with it....this will work......you can also edit the prdouct file as noted above......but this may be safer in your case.

badham

[badham]

I looked at your instal on your board.......a somewhat unconventional install in that you only have one level to your fourm......everything is set to your root directory www.mmaworld.org. That will be tough in the future if you decide to add a home page or certain additions......not impossible but very hard as most hacks and setups are designed assuming you set up your forums at www.yoursite.com/forums just an observation


badham

[brvheart]

I looked at your instal on your board.......a somewhat unconventional install in that you only have one level to your fourm......everything is set to your root directory www.mmaworld.org. That will be tough in the future if you decide to add a home page or certain additions......not impossible but very hard as most hacks and setups are designed assuming you set up your forums at www.yoursite.com/forums just an observation


badham

it is not really set up that way....I just had the URL drop in to the /forum directory so that you did not see www.mmaworld.org/forum instead you only see www.mmaworld.org, but on my FTP there is a /forum where the install resides.

[brvheart]

Yes...go to ADMINCP>>Maintance>run SQL querry You can copy and paste the above code and the run the querry....it will ask you if you are sure...click continue. What you have done is made a table in your database called vbspell....now you can unzip the dictonary alt download. you will find 10 txt notepads...open one, copy it and the paste it in the run sql querry section and click run.....do this one at a time for all 10 and you will be good to go. It is easier if you use phpmyadmin...but since you are not familiar with it....this will work......you can also edit the prdouct file as noted above......but this may be safer in your case.

badham


man I feel bad...this is what I get when running htat...

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
REPLACE INTO vbspell VALUES ('aa', 'A');
REPLACE INTO vbspell VALUES ('aaas'' at line 1

[webwench]

I just read through all the posts in this thread and haven't found a solution for this:

When I import the product, it goes all the way to 99% done and then I get a database error:

MySQL Error : Duplicate entry 'vbspell_allow_all' for key 1

I've been looking for a solution for an hour with no success - please, someone take pity on me and tell me what to do? :(

On edit - searched and found 3 things in vb_settings from a previous installation of vbSpell - there are three vbspell_ variables in vb_setting that need to be deleted before you import the product. I haven't tested yet but no more database errors; hopefully it worked! :)

On edit again - I spoke too soon. :( Javascript errors, and it doesn't work. :(

[jw00dy]

Sure,

Go to Plugin Manager in your admin control panel and edit the plugin 'vB Spell Template Changes'.

Add the following line at the very top before anything else:

if ( VB3_INTEGRATION != "on" ) {
and the following after the very last line:

}
Because the VB3_INTEGRATION variable should be defined when the WYSIWIG editor is being called from photopost, it'll fail that condition and the code to include the spell check won't be called.

You won't get spell check in the gallery, but you can still use it in the forums without messing up the gallery.

Works for me anyway ;)

Ollie
Works for me too. THANK YOU!!!

[badham]

man I feel bad...this is what I get when running htat...


Do you run cpanel???? If so you can log into it at www.mmaworld.org/cpanel and you can access phpmyadmin under the mysql icon and install the database querry that way. Did you remove the dictionary.dic file that you uploaded previously????


badham

[Mr Peabody]

For some reason the product's install code drops the vbspell table as soon as it's created it, unless you have a table prefix!

$db->hide_errors();
// Create vB Spell Table
$db->query_write("CREATE TABLE IF NOT EXISTS vbspell (
word varchar(30) NOT NULL,
sound varchar(10) NOT NULL,
UNIQUE KEY word (word),
KEY sound (sound)
) TYPE=MyISAM");

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

I can only assume the coder was asleep when he wrote it ;)

The product file needs to be editted and reattached here. The above code would work well if it was...


$db->hide_errors();

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

// Create vB Spell Table
$db->query_write("CREATE TABLE IF NOT EXISTS vbspell (
word varchar(30) NOT NULL,
sound varchar(10) NOT NULL,
UNIQUE KEY word (word),
KEY sound (sound)
) TYPE=MyISAM");


This way the table is cleared, but a new one is created! Previously it would create a new table, then delete it straight away so your dictionary words had nowhere to go?!?!?!?

Bizarre :p

Ollie


Cheers mate this worked great for me. I run 2 forums and for some reason it installed great on one the other it kept dropping the table like you said :confused:

[brvheart]

Do you run cpanel???? If so you can log into it at www.mmaworld.org/cpanel and you can access phpmyadmin under the mysql icon and install the database querry that way. Did you remove the dictionary.dic file that you uploaded previously????


badham

I found the mysql area from my host...but not sure how to do it..

and no I did not remove the dictionary.doc file....I will try that and let you know. Thanks for all the help!

[badham]

If you can't figure it out.....you can pm me the control panel info and I can fix it in about 10 minutes......

badham

[brvheart]

If you can't figure it out.....you can pm me the control panel info and I can fix it in about 10 minutes......


badham


Thank you, I will let you know :)

[deegan]

Well I see this is my list of plug ins, and everything looks right, but still no spell check?

[.Tim]

I just read through all the posts in this thread and haven't found a solution for this:

When I import the product, it goes all the way to 99% done and then I get a database error:

MySQL Error : Duplicate entry 'vbspell_allow_all' for key 1

I've been looking for a solution for an hour with no success - please, someone take pity on me and tell me what to do? :(

On edit - searched and found 3 things in vb_settings from a previous installation of vbSpell - there are three vbspell_ variables in vb_setting that need to be deleted before you import the product. I haven't tested yet but no more database errors; hopefully it worked! :)

On edit again - I spoke too soon. :( Javascript errors, and it doesn't work. :(

Same thing for me.

[Kihon Kata]

Having some serious issues with this. Ive tried uninstalling it and reinstalling it.

This is what I see when I upload the XML

Processing: 4722... (2%)
Processing: 11694... (6%)
Processing: 18403... (9%)
Processing: 21116... (11%)
Processing: 27726... (14%)
Processing: 34678... (17%)
Processing: 41658... (21%)
Processing: 46665... (24%)
Processing: 49069... (25%)
Processing: 53508... (27%)
Processing: 58219... (30%)
Processing: 63894... (33%)
Processing: 68849... (35%)
Processing: 72139... (37%)
Processing: 77766... (39%)
Processing: 83773... (43%)
Processing: 85938... (44%)
Processing: 90763... (47%)
Processing: 92234... (47%)
Processing: 99159... (50%)
Processing: 106065... (54%)
Processing: 110422... (56%)
Processing: 117117... (60%)
Processing: 121934... (62%)
Processing: 126720... (65%)
Processing: 133675... (68%)
Processing: 136029... (70%)
Processing: 142083... (73%)
Processing: 147608... (76%)
Processing: 151989... (78%)
Processing: 153044... (78%)
Processing: 156050... (80%)
Processing: 161434... (83%)
Processing: 168183... (86%)
Processing: 174458... (89%)
Processing: 181427... (93%)
Processing: 183975... (94%)
Processing: 184886... (95%)
Processing: 185579... (95%)
Processing: 186197... (95%)
Processing: 187205... (96%)
Processing: 190574... (97%)
Processing: 192664... (98%)
Database error

And then:

Database error in vBulletin 3.6.0:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
VALUES
(
'vbspell_allow_all',
'vbspell',
'1',
'1',
'free',
'yesno',
2,
0,
1,
'',
0,
'spellvb'
),
(
'vbspell_use_groups',
'vbspell',
'2,7,5,6,12,18,14',
'5,6',
'free',
'',
3,
0,
1,
'',
0,
'spellvb'
),
(
'vbspell_levenshtein_distance',
'vbspell',
'3',
'3',
'free',
'',
4,
0,
1,
'',
0,
'spellvb'
);

MySQL Error : Duplicate entry 'vbspell_allow_all' for key 1
Error Number : 1062
Date : Sunday, September 3rd 2006 @ 10:44:42 PM
Script :
IP Address :
Username :
Classname : vB_Database


Help?

[trackpads]

Having some serious issues with this. Ive tried uninstalling it and reinstalling it.

This is what I see when I upload the XML

Processing: 4722... (2%)
Processing: 11694... (6%)
Processing: 18403... (9%)
Processing: 21116... (11%)
Processing: 27726... (14%)
Processing: 34678... (17%)
Processing: 41658... (21%)
Processing: 46665... (24%)
Processing: 49069... (25%)
Processing: 53508... (27%)
Processing: 58219... (30%)
Processing: 63894... (33%)
Processing: 68849... (35%)
Processing: 72139... (37%)
Processing: 77766... (39%)
Processing: 83773... (43%)
Processing: 85938... (44%)
Processing: 90763... (47%)
Processing: 92234... (47%)
Processing: 99159... (50%)
Processing: 106065... (54%)
Processing: 110422... (56%)
Processing: 117117... (60%)
Processing: 121934... (62%)
Processing: 126720... (65%)
Processing: 133675... (68%)
Processing: 136029... (70%)
Processing: 142083... (73%)
Processing: 147608... (76%)
Processing: 151989... (78%)
Processing: 153044... (78%)
Processing: 156050... (80%)
Processing: 161434... (83%)
Processing: 168183... (86%)
Processing: 174458... (89%)
Processing: 181427... (93%)
Processing: 183975... (94%)
Processing: 184886... (95%)
Processing: 185579... (95%)
Processing: 186197... (95%)
Processing: 187205... (96%)
Processing: 190574... (97%)
Processing: 192664... (98%)
Database error

And then:

Database error in vBulletin 3.6.0:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
VALUES
(
'vbspell_allow_all',
'vbspell',
'1',
'1',
'free',
'yesno',
2,
0,
1,
'',
0,
'spellvb'
),
(
'vbspell_use_groups',
'vbspell',
'2,7,5,6,12,18,14',
'5,6',
'free',
'',
3,
0,
1,
'',
0,
'spellvb'
),
(
'vbspell_levenshtein_distance',
'vbspell',
'3',
'3',
'free',
'',
4,
0,
1,
'',
0,
'spellvb'
);

MySQL Error : Duplicate entry 'vbspell_allow_all' for key 1
Error Number : 1062
Date : Sunday, September 3rd 2006 @ 10:44:42 PM
Script :
IP Address :
Username :
Classname : vB_Database


Help?
Same here

[keiden]

Wewt Spellcheck.

[trackpads]

Anyone?

[B3y0nd]

I've been wanting to install this add-on for a long time, but it seems to have MAJOR integration issues with MANY members and very little support.

Pretty sad for such a promising script. :(

If the support gets better and the install process is made easier I don't see why this mod couldn't be Mod of the Month many times over.

[jgommel]

I've been wanting to install this add-on for a long time, but it seems to have MAJOR integration issues with MANY members and very little support.

Pretty sad for such a promising script. :(

If the support gets better and the install process is made easier I don't see why this mod couldn't be Mod of the Month many times over.

I can't agree with you more.... I posted some bug problems a few weeks ago and have not heard from the developer once... great app, just very poor support.

Previous post:
Okay I've fully tested the newest version of vB Spell and confirmed that it does not work with Photopost v5.31 or Reviewpost v3.31. As long as this plugin is enabled, you do not get the message box (like the one I'm typing in right now) I've tested this on both a Mac (Safari and Firefox) and a PC using (IE and Firefox).

With the plugin turned on, it works great on all platforms mentioned above. I really hope this can be fixed so that it works with both Photopost and Reviewpost. I have both of these products installed on two of my websites.
N.E.O.S.M.U.T. Paintball and F/Stopmedia Photography

If the developer needs me to test a build later (if he/she decides to fix this issue), please feel free to contact be via PM. I'm eagerly awaiting a fix. Great Job so far!!!!

[Sidewindr]

Any chance of a UK English Dictionary?

I have the problem where the window pops up behind the main window and as soon as you click on ok for the spell check is complete dialogue it closes everything.

[cygy2k]

Is this dead? I think this should have been added to vB many versions ago. Since it wasn't, can somebody please get this up to snuff so we can all share in it's splendor?

[colochris]

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?

[ColeEsque]

Hi,

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


Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT word FROM vbspell WHERE word = 'fhdfdsdafadsfdsafdadfsfadsf';

MySQL Error : Table 'courtiers.vbspell' doesn't exist
Error Number : 1146
Date : Friday, September 8th 2006 @ 03:11:00 AM
Script : http://www.thecourtiers.com/theforum/vbspell.php
Referrer : http://www.thecourtiers.com/theforum/newthread.php?do=newthread&f=23
IP Address :
Username :
Classname : vb_database

Any ideas?

Thanks,

C

[AyeCapn]

Did you look here? It tends to elude people, I was looking for the button that used to be next to the preview when I first installed it, then did a search of this thread and found out where it is.

http://img.photobucket.com/albums/v496/HubbasBedroom/Graphics%20Anon/sp.gif:woot:

Thanks dude :)

[cynix2]

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

[Masters]

I'm still getting this error:

Processing: 1... (0%)
Processing: 847... (0%)
Processing: 1619... (1%)
Processing: 2485... (1%)
Processing: 3413... (2%)
Processing: 4302... (2%)
Processing: 5191... (3%)
Processing: 6015... (3%)
Processing: 6779... (3%)
Processing: 7623... (4%)
Processing: 8546... (4%)
Processing: 9510... (5%)
Processing: 10396... (5%)
Processing: 11223... (6%)
Processing: 12036... (6%)
Processing: 12957... (7%)
Processing: 13923... (7%)
Processing: 14855... (8%)
Processing: 15662... (8%)
Processing: 16524... (8%)
Processing: 17377... (9%)
Processing: 18292... (9%)
Processing: 19237... (10%)
Processing: 20098... (10%)
Processing: 20999... (10%)
Processing: 21928... (11%)
Processing: 22739... (11%)
Processing: 23691... (12%)
Processing: 24486... (12%)
Processing: 25324... (13%)

Fatal error: Maximum execution time of 30 seconds exceeded in forum\includes\class_core.php on line 354

[Chadi]

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:



Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
VALUES
(
'vbspell_allow_all',
'vbspell',
'1',
'1',
'free',
'yesno',
2,
0,
1,
'',
0,
'spellvb'
),
(
'vbspell_use_groups',
'vbspell',
'2,5,6,7,12,13',
'5,6',
'free',
'',
3,
0,
1,
'',
0,
'spellvb'
),
(
'vbspell_levenshtein_distance',
'vbspell',
'3',
'3',
'free',
'',
4,
0,
1,
'',
0,
'spellvb'
);

MySQL Error : Duplicate entry 'vbspell_allow_all' for key 1 Error Number : 1062

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

[zan3y]

Hi,

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


Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT word FROM vbspell WHERE word = 'fhdfdsdafadsfdsafdadfsfadsf';

MySQL Error : Table 'courtiers.vbspell' doesn't exist
Error Number : 1146
Date : Friday, September 8th 2006 @ 03:11:00 AM
Script : http://www.thecourtiers.com/theforum/vbspell.php
Referrer : http://www.thecourtiers.com/theforum/newthread.php?do=newthread&f=23
IP Address :
Username :
Classname : vb_database

Any ideas?

Thanks,

C

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

[baklash]

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?

[baklash]

cancell i got it .....

[Chadi]

Can I get help on this please?

[Chadi]

Is anyone going to help?

[davidw]

Please correct me if I am wrong but, in the installcode:
<installcode><![CDATA[
$db->hide_errors();
// Create vB Spell Table
$db->query_write("CREATE TABLE IF NOT EXISTS vbspell (
word varchar(30) NOT NULL,
sound varchar(10) NOT NULL,
UNIQUE KEY word (word),
KEY sound (sound)
) TYPE=MyISAM");

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

// Add Dictionary Terms
if (is_file("./DICTIONARY.DIC")) {
$start_time = time();
$last_time = 0;
$words_processed = 0;

$FileSize = filesize("./DICTIONARY.DIC");
$fp = fopen("./DICTIONARY.DIC","r");

while (!feof($fp)) {
$data = trim(fgets($fp, 4096));
if ($data != "") {
$words_processed++;
$db->query_write("REPLACE INTO vbspell VALUES('" . addslashes($data) . "', '" . metaphone($data) . "')");
$end_time = time() - $start_time;
if ($end_time > $last_time) {
$loc = ftell($fp);
$percent = round(($loc / $FileSize)*100, 0);
echo construct_phrase($vbphrase['processing_x'], "$words_processed... (".$percent."%)") . "<br />\n";
vbflush();
}
$last_time = $end_time;
}
}
fclose($fp);
}
$db->show_errors();
]]></installcode>

Why is this // Remove Old vB Spell Table
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "vbspell"); 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.

[davidw]

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

[tspore]

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?

[Parker Clack]

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.

[davidw]

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?What is it [not] doing?

[ShackMaster]

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.

[jw00dy]

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.

[ShackMaster]

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

[user02934123123]

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:Database error in vBulletin 3.6.1:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
VALUES
(
'vbspell_allow_all',
'vbspell',
'1',
'1',
'free',
'yesno',
2,
0,
1,
'',
0,
'spellvb'
),
(
'vbspell_use_groups',
'vbspell',
'2,5,6,9,19',
'5,6',
'free',
'',
3,
0,
1,
'',
0,
'spellvb'
),
(
'vbspell_levenshtein_distance',
'vbspell',
'3',
'3',
'free',
'',
4,
0,
1,
'',
0,
'spellvb'
);

MySQL Error : Duplicate entry 'vbspell_allow_all' for key 1
Error Number : 1062
Date : Saturday, September 23rd 2006 @ 03:41:45 AM
Script : http://www.(...)/forum/admincp/plugin.php?do=productimport
Referrer : http://www.(...)/forum/admincp/plugin.php?do=productadd
IP Address : 000.000.000.000
Username : username
Classname : vb_database
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.

[bashy]

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

[davidw]

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.

[lucky64]

Hi,

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


Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT word FROM vbspell WHERE word = 'fhdfdsdafadsfdsafdadfsfadsf';

MySQL Error : Table 'courtiers.vbspell' doesn't exist
Error Number : 1146
Date : Friday, September 8th 2006 @ 03:11:00 AM
Script : http://www.thecourtiers.com/theforum/vbspell.php
Referrer : http://www.thecourtiers.com/theforum/newthread.php?do=newthread&f=23
IP Address :
Username :
Classname : vb_database

Any ideas?

Thanks,

C

Same error here.

Fresh install, latest version of the product.

Removed line, uninstalled, reinstalled, works.

[agiacosa]

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

[captainslater]

Same error here.

Fresh install, latest version of the product.

Removed line, uninstalled, reinstalled, works.
Have you tried to manullay create the table in the database?

[agiacosa]

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.

[r5e]

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?

[davidw]

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

[r5e]

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:

Processing: 181912... (93%)
Processing: 184914... (95%)
Processing: 187820... (96%)
Processing: 190621... (98%)

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

[davidw]

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.

[Zer0s]

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.

[davidw]

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

[r5e]

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 (https://vborg.vbsupport.ru/showpost.php?p=1065574&postcount=96) - 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 (https://vborg.vbsupport.ru/showpost.php?p=1057637&postcount=5)) using BigDump, as suggested by Steadicamop (https://vborg.vbsupport.ru/showpost.php?p=1058220&postcount=32). 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 (https://vborg.vbsupport.ru/showpost.php?p=1065253&postcount=92), 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.

[r5e]

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:

[r5e]

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 (https://vborg.vbsupport.ru/showpost.php?p=1061639&postcount=66).
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
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). :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.

[user02934123123]

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.

[GlitterKill]

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?

[davidw]

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

[GlitterKill]

Thanks! That did it! :)

[SpadMan]

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

[vBulletin THEN DAYLIGHT]

Has anyone come up with a solution for the pop up window loading beneath other windows yet? I am using Firefox and it is annoying me!

Other than that, no problems. I did have some when I tried to upgrade from the 3.5.4 version, but the best thing to do is just to delete and uninstall vBSpell, including the files on your server, and start all over again from scratch. That worked for me.

[davidw]

Other than a javascript issue itself, I wouldn't have any idea why it would do that personally.

[R1lover]

Has anyone come up with a solution for the pop up window loading beneath other windows yet? I am using Firefox and it is annoying me!

Other than that, no problems. I did have some when I tried to upgrade from the 3.5.4 version, but the best thing to do is just to delete and uninstall vBSpell, including the files on your server, and start all over again from scratch. That worked for me.


Yes, I need the pop up window issue solved as well.............

I don't like showing the users a new feature when it does nto work properly... The rest of the mod works great.... Thank you for the work.

But the pop up issues makes this mods look pretty sad... lol


Any help on this from a coder?

Thank you

[R1lover]

HELP PLEASE

anyone a Java Coder?

[PoetJA-1975]

If it ain't broke, don't fix it.

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

EXACTLY! reverted back - nice hack but v0.10.2b isn't so nice for 3.5.4 OR as other have noted... for 3.6.any LOL

At anyrate thanx for this one, as I'm sure my users will love the functionality ;)

Jacquii.

[pokerie]

Installed, thanks:)

Where could I get an English (Ireland) or UK (Great Britain) dictionary does anyone know? We say customise amongst other different ways of spellingt things;) Can I use the ones installed on my computer? I have a Great Britain .dic file in my open office folder, but it's 500kb compared to the one included in this which was 2MB. That probably wouldn't be ok so?


Just a suggestion is to make the pop up window for the dictionary and thesaurus look look up to be bigger as you have to maximise it to see the results.


I'm using 3.6.1 too, I'm not sure what problem you guys are talking about with it appearing under windows. Could you tell me how to replicate the problem so I can check if it's the same with me?

Is there any chance the mis-spelled words cuz have a squigly line underneatht them so you can see which ones are about to be corrected perhaps?

Thanks again for the mod.

[R1lover]

Other than a javascript issue itself, I wouldn't have any idea why it would do that personally.

Does anyone here want to help out and take a look at the java script on this new version?

I need to get this resolved asap please, please please... lol

[r5e]

I can report that I have tested this problem with the pop-up happening behind the main window (it flicks for an instant in front as it loads, then disappears behind) in many different scenarios and it does happen.

Firefox - problem
IE - problem
Opera - works fine every time.

I've tried this on a number of different PCs and they all get the same results.

I'm no expert in javascript either. I'll try and get hold of someone who is if the author cannot help. I've also emailed the author and asked him to please spare some time for a quick check in here to investigate this last little niggly problem. Perhaps someone could compare the script from the old version to the new and see if that gives any clues?

As I see it, the rest of the mod can be made to work quite well now, but this is the only bit that still has us all stumped.

Here's hoping we can all find a way to get this working soon.

[R1lover]

I can report that I have tested this problem with the pop-up happening behind the main window (it flicks for an instant in front as it loads, then disappears behind) in many different scenarios and it does happen.

Firefox - problem
IE - problem
Opera - works fine every time.

I've tried this on a number of different PCs and they all get the same results.

I'm no expert in javascript either. I'll try and get hold of someone who is if the author cannot help. I've also emailed the author and asked him to please spare some time for a quick check in here to investigate this last little niggly problem. Perhaps someone could compare the script from the old version to the new and see if that gives any clues?

As I see it, the rest of the mod can be made to work quite well now, but this is the only bit that still has us all stumped.

Here's hoping we can all find a way to get this working soon.

Thank you, I have tried to get a few pwople to look at it also....still no luck

Let's pull together and get this one solved...

:) ;)

[LisaD1]

I can report that I have tested this problem with the pop-up happening behind the main window (it flicks for an instant in front as it loads, then disappears behind) in many different scenarios and it does happen.

Firefox - problem
IE - problem
Opera - works fine every time.

I've tried this on a number of different PCs and they all get the same results.

I'm no expert in javascript either. I'll try and get hold of someone who is if the author cannot help. I've also emailed the author and asked him to please spare some time for a quick check in here to investigate this last little niggly problem. Perhaps someone could compare the script from the old version to the new and see if that gives any clues?

As I see it, the rest of the mod can be made to work quite well now, but this is the only bit that still has us all stumped.

Here's hoping we can all find a way to get this working soon.

This also happens on our forum.
I just want to thank the author in advance for his hard work and continued help with this great add on!!
Lisa

[kyzyl]

I've just installed this mod and I've gotten everything to work, except the spell check itself!

I uploaded the dictionary file, installed the product, but when I spell check a post it finds the errors but doesn't give any suggestions?!

Any help would be appreciated.

[perfphysio]

Installed OK on 3.6.2

It quickly flashes open in a new window in firefox which is annoying as it is so fast that you don't notice it and it does not remain on top of the forum window so you have to find it in the bottom nav bar of the browser.

Also does this need to learn all words? I just did a test and it did not give any options for any words really and so I had to click on learn for every second word. I did the normal install as this is the first time I have installed this hack. This meant I just ftp'd the dictionay file to the root and nothing more than that. I did not use anything in the dictionary-alt zip file. Was I supposed to use both?

Thanks for any assistance on this one

regards Richard

[R1lover]

Help Please.............

[Eq4bits]

Finally got this re-installed after upgrading forum.
I have the pop-under window problem as well as when the pop-up loads it says every other word in the post is incorrectly spell and no alternatives are offered at all.
Anyone?

[Eq4bits]

Well I've compared the vbspell.js file in this version to the previous one for 3.5.3 I think it was and they are identical line by line. So does that mean that's not the problem or that it IS the problem?

Also, just for giggles and snorts i opened the vbspell template as if i was going to edit it, clicked the 'preview' button and low and behold look at the 'message' in it.... is this a 'fluke' or normal? (see attached screenshot)

[davidw]

Just curious - for those having the pop-under problem - what version of vb are you running?

Edited for spelling :P

[Eq4bits]

3.6.2 here
but it doesn't really matter if it 'pops-under' since it doesn't offer corrections/suggestion, and recognizes correctly spelled words as incorrectly spelled/needed to be learned... In fact every word in this post would come up as needing correcting.

[davidw]

I'm wondering as I've had this working well (It's working on 3.6.1) - but I've seen where a couple people have 3.6.2 and have issues with it and if more people with 3.6.2 have issues with it then there may be an incompatibility with 3.6.2 and this hack. Possibly on more than one level.

[Eq4bits]

one thought does occur to me. My host recently made some changes to the MySQL and there is now another 'column' in all my table sturctures called 'collation'. So my question is what should the collation be for the vbspell table (latin 1?) and also since I'm having to import the sql files splitting the actual dictionary up, when I import them which character set should I use, myPHPadmin gives me a drop-down of several to choose from... should it be the utf8 or another?

[r5e]

I got the pop-up problems when I changed from 3.5.x to 3.6.x, or when I changed from the last version (0.9.12) to this latest version (0.10.2b). As such, it is hard to say whether it was the latest vbspell that caused it, or the latest vbulletin that caused it. I can say that I get the same problems on 3.6.1 and on 3.6.2 as I had these problems before 3.6.2 came out.
Now as for whether this is caused by the javascript...? I have also compared the files of vbspell.js, vbspell.php and vbspell_iframe.php between the old and the current versions. Mostly the only changes are very minor, such as changing the name ?vBSpell? to ?vB Spell?. However, there are a few key changes which might be interesting.

10.2b:
function openSpellWin(wx, hx) {

window.open("", "spellWindow", 'toolbar=no,location=no,directories=no,status=no,m enubar=no,scrollbars=no,resizable=no,width='+wx+', height='+hx);
window.focus;
}

9.12:
function openSpellWin(width, height) {

window.open("", "spellWindow", 'toolbar=no,location=no,directories=no,status=no,m enubar=no,scrollbars=no,resizable=no,width='+width +',height='+height+'\'');
}

Looks like some minor changes with height and width changing to wx and hx. Does this make a difference?

Well, I decided to test the theory by simply renaming the 3 (current veriosn) files on my server and then simply copying the 3 files of the old version (vbspell.js, vbspell.php and vbspell_iframe.php) in their place. What happened? Absolutely nothing! No difference. I still get the pop-up happening behind the edit window, not in front. It seems to me that the idea of looking at the javascript may be a dead end.

I really have no idea, but I?d have to theorise that something has changed in 3.6.x to make this happen. I?d guess this could be something along the lines of code compliance and how browsers interpret this. For example, maybe the doc type has changed (it is currently ?XHTML 1.0 Transitional?)? actually, bad example, I just checked and 3.0.x is also XHTML 1.0 Transitional.

So, I have not brought any new useful information to this thread, but I can tell you this:

1. I have written to the author asking for them to have a quick check in here as although they are regularly in the forum, they have not been here for a while. It?s not fair to nag or judge the author of free software for a lack of support, but I wanted to know if they had finished with it and would be happy with someone else to pick up and run with it. Unfortunately, they have neither replied, nor posted in here.
2. It would seem on the surface that the javascript is not at fault, as the old version which used to work does not work in here.
3. I have not yet looked into the product.xml. I think that this is where it will have to be. (If no one else can solve this before I do)

[aquariumpros]

Just curious - for those having the pop-under problem - what version of vb are you running?

Edited for spelling

3.6.2

3.6.2 here
but it doesn't really matter if it 'pops-under' since it doesn't offer corrections/suggestion, and recognizes correctly spelled words as incorrectly spelled/needed to be learned... In fact every word in this post would come up as needing correcting.

This is not the case if you import the ALT.zip into the database. Other then the pop-up behind - this is working perfectly on my board.

I got the pop-up problems when I changed from 3.5.x to 3.6.x, or when I changed from the last version (0.9.12) to this latest version (0.10.2b). As such, it is hard to say whether it was the latest vbspell that caused it, or the latest vbulletin that caused it. I can say that I get the same problems on 3.6.1 and on 3.6.2 as I had these problems before 3.6.2 came out.
Now as for whether this is caused by the javascript...? I have also compared the files of vbspell.js, vbspell.php and vbspell_iframe.php between the old and the current versions. Mostly the only changes are very minor, such as changing the name “vBSpell” to “vB Spell”. However, there are a few key changes which might be interesting.

10.2b:
function openSpellWin(wx, hx) {

window.open("", "spellWindow", 'toolbar=no,location=no,directories=no,status=no,m enubar=no,scrollbars=no,resizable=no,width='+wx+', height='+hx);
window.focus; }

9.12:
function openSpellWin(width, height) {

window.open("", "spellWindow", 'toolbar=no,location=no,directories=no,status=no,m enubar=no,scrollbars=no,resizable=no,width='+width +',height='+height+'\'');
}
Looks like some minor changes with height and width changing to wx and hx. Does this make a difference?

Well, I decided to test the theory by simply renaming the 3 (current veriosn) files on my server and then simply copying the 3 files of the old version (vbspell.js, vbspell.php and vbspell_iframe.php) in their place. What happened? Absolutely nothing! No difference. I still get the pop-up happening behind the edit window, not in front. It seems to me that the idea of looking at the javascript may be a dead end.

I really have no idea, but I’d have to theorise that something has changed in 3.6.x to make this happen. I’d guess this could be something along the lines of code compliance and how browsers interpret this. For example, maybe the doc type has changed (it is currently “XHTML 1.0 Transitional”)… actually, bad example, I just checked and 3.0.x is also XHTML 1.0 Transitional.

So, I have not brought any new useful information to this thread, but I can tell you this:

1. I have written to the author asking for them to have a quick check in here as although they are regularly in the forum, they have not been here for a while. It’s not fair to nag or judge the author of free software for a lack of support, but I wanted to know if they had finished with it and would be happy with someone else to pick up and run with it. Unfortunately, they have neither replied, nor posted in here.
2. It would seem on the surface that the javascript is not at fault, as the old version which used to work does not work in here.
3. I have not yet looked into the product.xml. I think that this is where it will have to be. (If no one else can solve this before I do)

Many thanks for your attempts to fix this.

Much appreciated!!

[LisaD1]

Just curious - for those having the pop-under problem - what version of vb are you running?

Edited for spelling :P

3.6.2 Here. I hope that someone can work this out, I really need it, because my spelling SUCKS!
Lisa

[Eq4bits]

okay, i had imported the alt sql files as latin1 instead of utf8, dropped all the entries in the table and reimported as utf8. So now spell checker is working.
Still has the annoying flicker on top then popping open UNDER main window. It seams that maybe this would be in the 'java' event coding for the button itself maybe? I did notice that someone said it works fine in Opera... and also took note that when I edited the quick_edit template the instructions only stated to removed the <if> conditional for IE and not also the one for Opera that is right above it. Is it possible that if the Opera <if> conditional is taken out of the appropriate templates that that would resolve the pop-under problem? Grasping at straws since I haven't been able to think of anything else... I mean LINKS in a post if clicked on are opened in a new window and they don't open *under*...... so what is the difference for vbspell?

[baze22]

3.6.2 Here. I hope that someone can work this out, I really need it, because my spelling SUCKS!
Lisa

I've played around a bit, but I'm no js expert. I've narrowed to having something to do with a function in the vbulletin_global.js file:

function set_unselectable(obj)

I'm not sure exactly what it does, but when I comment it out or rename it, the pop up window comes to the top. I looked at the file that came with 3.5.4 and the code is identical. So I'm assuming the change is in a function that calls this one. I tried to narrow it down further and did a search of the vb files to find where this is called and found 3 instances in vbulletin_textedit.js, but commenting one or more of those still had pop up window popping under. So I don't if there are some other templates where this is called or what the detrimental effects of having this commented out would have, but that's all I've found so far.

If anybody else has other suggestions...


baze

[perfphysio]

Also does this need to learn all words? I just did a test and it did not give any options for any words really and so I had to click on learn for every second word. I did the normal install as this is the first time I have installed this hack. This meant I just ftp'd the dictionay file to the root and nothing more than that. I did not use anything in the dictionary-alt zip file. Was I supposed to use both?

I am posting this again as I have not had any response. I have installed all as per the instructions. However there does not appear to be any directionary being used as a default? Have I missed something somewhere? The spell check comes up but asks for confirmation on about every third word and there are never any suggestions? www.physiobob.com/forum

[Eq4bits]

you need to check your vbspell table in you database, to be sure the actual words were imported into it.
I kept getting the 98%/vb error message so had to insert via sql the 10 separate sql files (these include the sql command and the words/entries for the dictionary/vbtable) into the vbtable. those 10 sql files are in the dictionary-alt file

[baze22]

I've played around a bit, but I'm no js expert. I've narrowed to having something to do with a function in the vbulletin_global.js file:

function set_unselectable(obj)

I'm not sure exactly what it does, but when I comment it out or rename it, the pop up window comes to the top. I looked at the file that came with 3.5.4 and the code is identical. So I'm assuming the change is in a function that calls this one. I tried to narrow it down further and did a search of the vb files to find where this is called and found 3 instances in vbulletin_textedit.js, but commenting one or more of those still had pop up window popping under. So I don't if there are some other templates where this is called or what the detrimental effects of having this commented out would have, but that's all I've found so far.

If anybody else has other suggestions...


baze

I did stumble across one slightly detrimental affect.... users couldn't submit posts or PM's. :D PM's give the message that there is no recipient or title, posts get the error message that the message is too short. So for now, spell check will have to stay as a pop under. When I get a chance I'll try to dig into it more, in the mean time maybe somebody else can figure this out.

baze

[baze22]

I did stumble across one slightly detrimental affect.... users couldn't submit posts or PM's. :D PM's give the message that there is no recipient or title, posts get the error message that the message is too short.
Additional info. exact error in the PM is to complete obth the subject and the message. Bottom line is that in both cases the message text goes away when submitted without this function.

baze

[perfphysio]

you need to check your vbspell table in you database, to be sure the actual words were imported into it.
I kept getting the 98%/vb error message so had to insert via sql the 10 separate sql files (these include the sql command and the words/entries for the dictionary/vbtable) into the vbtable. those 10 sql files are in the dictionary-alt file
I have found the vbspell table but there is nothing in it. I am not a code so can you suggest how you go about getting the words into it?

[aquariumpros]

I have found the vbspell table but there is nothing in it. I am not a code so can you suggest how you go about getting the words into it?
Import ALL 10 of the SQL files from within the "dictionary alt.zip" in the downloads above. Unzip them to your local drive first - then use phpMyAdmin (http://www.phpmyadmin.net/home_page/index.php) (under the Import tab) to import each one.

HTH,
*~AJ~*

[perfphysio]

many thanks. I think i've done it. I think the perosn who posted this hack should amke this more clear in the directions. It looks like you have two choices, 1. upload the dictionary.doc file or import the sql files. It seems you need to do both or at least the sql ones are as important :)

[aquariumpros]

many thanks. I think i've done it. I think the perosn who posted this hack should amke this more clear in the directions. It looks like you have two choices, 1. upload the dictionary.doc file or import the sql files. It seems you need to do both or at least the sql ones are as important :)
In my previous installations - I didn't have to do the SQL imports - just the standard way worked...however - when I upgraded to 3.6.2 - the SQL imports were the only way I found it worked (for me).

Glad you got it working - and thanks again to cynix2 for a great hack!

[R1lover]

we still need the pop up window fixed......

anyone want to tackle that one?

thank you in advance

[theArchitect]

I uninstalled the 3.5 version of this hack, but I can't install this new 3.6 version as I am getting the following error:

Database error in vBulletin 3.6.2:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
VALUES
(
'vbspell_allow_all',
'vbspell',
'0',
'1',
'free',
'yesno',
2,
0,
1,
'',
0,
'spellvb'
),
(
'vbspell_use_groups',
'vbspell',
'5,6,7,22,23,24,25',
'5,6',
'free',
'',
3,
0,
1,
'',
0,
'spellvb'
),
(
'vbspell_levenshtein_distance',
'vbspell',
'3',
'3',
'free',
'',
4,
0,
1,
'',
0,
'spellvb'
);

MySQL Error : Duplicate entry 'vbspell_allow_all' for key 1
Error Number : 1062Any help would be appreciated.

[deegan]

Is there a way to turn the symbol https://vborg.vbsupport.ru/external/2006/10/4.gif in the top right corner of the editing box into a button next to the "Preview Post" button?

[R1lover]

Is there a way to turn the symbol https://vborg.vbsupport.ru/external/2006/10/4.gif in the top right corner of the editing box into a button next to the "Preview Post" button?


You would have to edit the templates, but yes it can be done. You would have to edit both the quick reply and message editor templates.

[deegan]

You would have to edit the templates, but yes it can be done. You would have to edit both the quick reply and message editor templates.Could I get specifics?...:classic:

[4number8]

For anyone that would like the spell check button added, edit your newreply, and newthread templetes:

newreply
find:
<input type="submit" class="button" name="sbutton" id="{$editorid}_save" value="$vbphrase[submit_reply]" accesskey="s" tabindex="1" />
<input type="submit" class="button" name="preview" value="$vbphrase[preview_post]" accesskey="r" tabindex="1" />

under it add this:
<input type="button" class="button" value="Spell Check" onClick="spellCheck('vbform', '$editorid', '2');" />

newthread
find:

<input type="submit" class="button" name="sbutton" id="{$editorid}_save" value="$vbphrase[submit_new_thread]" accesskey="s" tabindex="1" />
<input type="submit" class="button" name="preview" value="$vbphrase[preview_post]" accesskey="r" tabindex="1" />

under this add:
<input type="button" class="button" value="Spell Check" onClick="spellCheck('vbform', '$editorid', '2');" />

Best of all, no more hidding windows, it pops up as it should :D

[pokerie]

Are you saying that putting them edits in the templates gets rid of the above problem of the hiding window or the link at the bottom of your post does?

[R1lover]

Best of all, no more hidding windows, it pops up as it should :D



https://vborg.vbsupport.ru/showthread.php?t=92202&highlight=vbspell


Could you explain this as I and many others are still getting the pop up issue... This link takes you back to this thread?

Thank you

[Eq4bits]

I'll be darned! That *does* make it pop over instead of popping under! YAY!
now... I can't find where to add the button to the quick reply... anybody know where that template is located?

[morrow]

First and foremost... BACK UP YOUR DATABASE BEFORE INSTALLING ANY HACK!

1. Post 105 - Fix photopost / review post issues
2. Post 198 - Fix hiding pop-up window issues.
3. Post 135 - Recomended for all other issues - Check your mysql tables to see if vbspell exists. If it doesn't, uninstall the product then refer to this post.

If you run into any errors after item 3, revert to the backup you made before installing this hack. Don't have a back-up? That's too bad.

By the way, nice hack! Clicked Install!

[deegan]

For anyone that would like the spell check button added, edit your newreply, and newthread templetes:

newreply
find:
<input type="submit" class="button" name="sbutton" id="{$editorid}_save" value="$vbphrase[submit_reply]" accesskey="s" tabindex="1" />
<input type="submit" class="button" name="preview" value="$vbphrase[preview_post]" accesskey="r" tabindex="1" />

under it add this:
<input type="button" class="button" value="Spell Check" onClick="spellCheck('vbform', '$editorid', '2');" />

newthread
find:

<input type="submit" class="button" name="sbutton" id="{$editorid}_save" value="$vbphrase[submit_new_thread]" accesskey="s" tabindex="1" />
<input type="submit" class="button" name="preview" value="$vbphrase[preview_post]" accesskey="r" tabindex="1" />

under this add:
<input type="button" class="button" value="Spell Check" onClick="spellCheck('vbform', '$editorid', '2');" />

Best of all, no more hidding windows, it pops up as it should :D



https://vborg.vbsupport.ru/showthread.php?t=92202&highlight=vbspellThat was some quality info right there...

Did it and it works great...

If this place used their own "Thank You" hack, you'd be gettin' one right now...

Thank you!...:nervous:

[4number8]

I'll be darned! That *does* make it pop over instead of popping under! YAY!
now... I can't find where to add the button to the quick reply... anybody know where that template is located?

To add the spell check button to the quick reply, simply search for this phrase in..

showthread templete find:
<input type="submit" class="button" value="$vbphrase[go_advanced]" accesskey="x" title="(Alt + X)" name="preview" tabindex="3" id="qr_preview" onclick="clickedelm = this.value" />


Below this add:
<input type="button" class="button" value="Spell Check" onClick="spellCheck('qrform', '$editorid', '2');" />

You now have a spell check button on quickreply that works as it should.

Hope that helps

[4number8]

Are you saying that putting them edits in the templates gets rid of the above problem of the hiding window or the link at the bottom of your post does?
The edits I posted will fix your problem, I removed the link to keep down confusion.

[4number8]

Could you explain this as I and many others are still getting the pop up issue... This link takes you back to this thread?

Thank you
If your still trying to use the button at the top you will still have the issue, thats why I decided to add the spell check button at the bottom where it should be, with the other buttons. IMO this looks much better and my members have no trouble finding it to use. Hope that explains it better.

[4number8]

To also add the spell check button to your go advanced options, edit your postbit_quickedit templete.

Find:
<input type="button" class="button" tabindex="1" accesskey="r" value="$vbphrase[go_advanced]" id="{$editorid}_adv" />

Below add:
<input type="button" class="button" value="Spell Check" onClick="spellCheck('vbform', '$editorid', '2');" />

[baze22]

To add the spell check button to the quick reply, simply search for this phrase in..

showthread templete find:
<input type="submit" class="button" value="$vbphrase[go_advanced]" accesskey="x" title="(Alt + X)" name="preview" tabindex="3" id="qr_preview" onclick="clickedelm = this.value" />


Below this add:
<input type="button" class="button" value="Spell Check" onClick="spellCheck('qrform', '$editorid', '2');" />

You now have a spell check button on quickreply that works as it should.

Hope that helps


Thanks for these posts, I hadn't even thought of putting the button back:rolleyes: The method you posted for newreply/newthread for for pm_newpm (didn't check the exact code, but right after the preview button). I did add the 'accesskey="l"', so that users could use Alt-L to pop it up too.

Thanks again,

baze

[4number8]

If you would like to have a spell check button for your users to use with their PMs, simply edit your pm_newpm templete.

Find:
<input type="submit" class="button" value="$vbphrase[preview_message]" accesskey="r" name="preview" tabindex="1" />

Below this add:
<input type="button" class="button" value="Spell Check" onClick="spellCheck('vbform', '$editorid', '2');" />

Now you and your users can check the spelling in your PM's

[4number8]

Thanks for these posts, I hadn't even thought of putting the button back:rolleyes: The method you posted for newreply/newthread for for pm_newpm (didn't check the exact code, but right after the preview button). I did add the 'accesskey="l"', so that users could use Alt-L to pop it up too.

Thanks again,

baze
The code is different for the 3.5.4, thats why I went ahead and posted the correct code to find in 3.6.2.

[4number8]

To add the spell check button, do this to your modifysignature templete,
Find:
<input type="submit" class="button" value="$vbphrase[preview_signature]" name="preview" accesskey="r" tabindex="1" />


Below this add:
<input type="button" class="button" value="Spell Check" onClick="spellCheck('qrform', '$editorid', '2');" />

That should have your spell check buttons everywhere except for the Calendar, if anyone wants this and don't know how, let me know.

[perfphysio]

we still need the pop up window fixed......

anyone want to tackle that one?

thank you in advanceI agree, this popup issue is a right pain in the arse. It is making a great hack an annoying one. If someone can actually fix it in the actual hack so that we can all perhaps to an update to fix the issue and keep the window open and on top of the page when you use the spell check. It gets lost in the nav bar at the bottom of the browser at present.

[baze22]

I agree, this popup issue is a right pain in the arse. It is making a great hack an annoying one. If someone can actually fix it in the actual hack so that we can all perhaps to an update to fix the issue and keep the window open and on top of the page when you use the spell check. It gets lost in the nav bar at the bottom of the browser at present.

I don't know that it's something that can be fixed in the hack. The problem seems to have something to do with the javascript for the editor.

baze

[baze22]

I don't know that it's something that can be fixed in the hack. The problem seems to have something to do with the javascript for the editor.

baze

Playing around, I found a workaround for it popping under. In the vbspell_iframe.php file:

find this:
<body class="wysiwyg" onLoad="assignSelf(); window.parent.startsp();" id="theBody">

replace with:
<body class="wysiwyg" onLoad="assignSelf(); window.parent.startsp(); window.focus();" onblur="window.focus();" id="theBody">

It still pops under initially but then comes back to the top. Like I said, it's a workaround.

baze

[perfphysio]

I don't know that it's something that can be fixed in the hack. The problem seems to have something to do with the javascript for the editor.

baze

Yeah I am not a coder but I do notice that in my Squirrelmail email system, the spell check works in almost the same way and this script forces the spellcheck window to appear on top. Maybe someone who is a coder can take a look at this opensource code to see what they do?

[Chadi]

I installed this and uploaded DICTIONARY.DIC to my forum home.

I tested the thread with various spelling errors, it gave no suggestions or change to words at all, even for words like churc (church), hly (holy), mke (make), etc.

I reuploaded the product and now I get db errors when clicking the spell icon


Database error in vBulletin 3.6.2:

Invalid SQL:
SELECT word FROM vbspell WHERE word = 'test';

MySQL Error : Table 'user_vbulletin.vbspell' doesn't exist
Error Number : 1146
Date : Saturday, October 28th 2006 @ 10:24:25 AM
Script : http://www.talkjesus.com/vbspell.php
Referrer : http://www.talkjesus.com/newthread.php?do=newthread&f=51
IP Address : xxx
Username : user
Classname : vb_database

[Benj]

I installed this and uploaded DICTIONARY.DIC to my forum home.

I tested the thread with various spelling errors, it gave no suggestions or change to words at all, even for words like churc (church), hly (holy), mke (make), etc.

I reuploaded the product and now I get db errors when clicking the spell icon


Database error in vBulletin 3.6.2:

Invalid SQL:
SELECT word FROM vbspell WHERE word = 'test';

MySQL Error : Table 'user_vbulletin.vbspell' doesn't exist
Error Number : 1146
Date : Saturday, October 28th 2006 @ 10:24:25 AM
Script : http://www.talkjesus.com/vbspell.php
Referrer : http://www.talkjesus.com/newthread.php?do=newthread&f=51
IP Address : xxx
Username : user
Classname : vb_database

same here

[gothicuser]

same here
Check this (https://vborg.vbsupport.ru/showpost.php?p=1086550&postcount=155)
Cured it for me

[davidw]

Playing around, I found a workaround for it popping under. In the vbspell_iframe.php file:

find this:
<body class="wysiwyg" onLoad="assignSelf(); window.parent.startsp();" id="theBody">
replace with:
<body class="wysiwyg" onLoad="assignSelf(); window.parent.startsp(); window.focus();" onblur="window.focus();" id="theBody">
It still pops under initially but then comes back to the top. Like I said, it's a workaround.

bazeDoes everyone having these popunder problems also use the advanced wysiwyg editor - or the standard editor? I've noted a lot of problems with the advanced and therefore don't use it - perhaps this might be a clue to the problem.

[pewp]

i did everything the way the directions said... uploaded all the vbspell and dictionary.dic to the forums home directory then installed the product and got this error:
Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'vB Spell Template Changes', 'parse_templates', '$vbulletin->templatecache[\'headinclude\'] .= addslashes(\'<script type=\"text/javascript\" src=\"vbspell.js\"></script>\');\r\n$vBSpell_temp_header = <<< html\r\n<form name=\"spell_form\" id=\"spell_form\" method=\"POST\" target=\"spellWindow\" action=\"vbspell.php\">\r\n<input type=\"hidden\" name=\"spell_formname\" value=\"\" />\r\n<input type=\"hidden\" name=\"spell_fieldname\" value=\"\" />\r\n<input type=\"hidden\" name=\"spellstring\" value=\"\" />\r\n</form>\r\nhtml;\r\n$vbulletin->templatecache[\'header\'] .= addslashes($vBSpell_temp_header);\r\n\r\n$vBSpell_ search_editor_toolbar_on = array(\"is_browser(\'ie\') AND !is_browser(\'mac\')\", \"_cmd_spelling\\\\\\\"><img\");\r\n$vBSpell_replace_editor_toolbar_on = array(\"1==1\", \"_cmd_spelling(null)\\\\\\\"><img onclick=\\\\\\\"spellCheck(\'vbform\', \'\\$editorid\', \'2\');\\\\\\\"\");\r\n\r\n$vBSpell_search_postbit_quickedit = array(\"is_browser(\'ie\')\", \"_cmd_spelling\\\\\\\"><img\");\r\n$vBSpell_replace_postbit_quickedit = array(\"1==1\", \"_cmd_spelling(null)\\\\\\\"><img onclick=\\\\\\\"spellCheck(\'3\', \'\\$editorid\', \'2\');\\\\\\\"\");\r\n\r\n$vBSpell_search_showthread_quickreply = array(\"is_browser(\'ie\')\", \"_cmd_spelling\\\\\\\"><img\");\r\n$vBSpell_replace_showthread_quickreply = array(\"1==1\", \"_cmd_spelling(null)\\\\\\\"><img onclick=\\\\\\\"spellCheck(\'qrform\', \'\\$editorid\', \'2\');\\\\\\\"\");\r\n\r\nforeach ($vBSpell_search_editor_toolbar_on as $id => $item) {\r\n$vbulletin->templatecache[\'editor_toolbar_on\'] = str_replace($vBSpell_search_editor_toolbar_on[\"$id\"], $vBSpell_replace_editor_toolbar_on[\"$id\"], $vbulletin->templatecache[\'editor_toolbar_on\']);\r\n//quickedit doesnt work yet\r\n//$vbulletin->templatecache[\'postbit_quickedit\'] = str_replace($vBSpell_search_postbit_quickedit[\"$id\"], $vBSpell_replace_postbit_quickedit[\"$id\"], $vbulletin->templatecache[\'postbit_quickedit\']);\r\n$vbulletin->templatecache[\'showthread_quickreply\'] = str_replace($vBSpell_search_showthread_quickreply[\"$id\"], $vBSpell_replace_showthread_quickreply[\"$id\"], $vbulletin->templatecache[\'showthread_quickreply\']);\r\n}', 'spellvb');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Friday, November 3rd 2006 @ 10:40:13 AM
Script : http://www.decimators.net/forums/admincp/plugin.php
Referrer : http://www.decimators.net/forums/admincp/plugin.php?do=productadd
IP Address : ************
Username : ***********
Classname : *************

then i uninstalled it and ran the sql query to create the vbspell table, but it still happened... any help?

[aquariumpros]

i did everything the way the directions said... uploaded all the vbspell and dictionary.dic to the forums home directory then installed the product and got this error:


then i uninstalled it and ran the sql query to create the vbspell table, but it still happened... any help?

This version is for vB 3.6.2---

Per your SQL error - you're running vB 3.5.4

Try to install the version for vB 3.5.4 and you might have better luck.

[pewp]

well that's what i thought too, but i read this part of the description...

Background: This mod was originally developed by tamarian for vB 3.5.x. With the release of 3.6.x the installer stopped working for fresh installs and the template changes were considerably out of date, tamarian gave me permission to release a 3.6.x version with updates.
This version should work with both 3.5.x and 3.6.x series.


so i was under the assumption that it would work.

[aquariumpros]

I really don't know - as I was just browsing and saw the vB version at the top of the SQL error.

Did you run the x10 SQL Queries from the ALT file too?

[zetetic]

Sorry if this has been covered, but I've been through this thread and didn't find an answer. I'm getting ready to upgrade from vB 3.0.6 to vB 3.6.2, and I have Tamarian's spellcheck installed on 3.0.6. IIRC, the table in Tamarian's version is called spelling_words. Can I just rename it to vbspell and install this mod, or do I have to do anything else? TIA.

[r5e]

A bit late in my reply here, but thanks Baze22 - your code change works a treat, I now have working popups for the spell checker. :D

Finally, I can call this mod "working"!

I went back to revist this after leaving it not quite fixed for some time as I was motivated by the latest inbuilt spell checker in firefox 2 (http://www.mozilla.com/en-US/firefox/features.html#experience). There is a problem in the code of vbulletin that prevents the inbuilt firefox spell checker from working, but there is an easy hack here (https://vborg.vbsupport.ru/showthread.php?t=130392), which apparently will be implemented in the next revision of vbulletin.

So, once everyone kicks their dirty old Internet Explorer habit (or MS catches up and copies more Firefox features into their new version), eventually, we won't need a hack for spell checking.

I like the little red underline I get as I type, which is far more familiar than having to click on a button to do spell checking, so I'll not be using this hack anymore (though my users still will for a while).

[r5e]

Sorry, I spoke too soon.
I use Firefox, but unfortunately most of my users still rely on IE, the lowest common denominator.
Seems that in IE, the window does pop up, but if you try to change a word by clicking in the "change to" box, no selection/typing is possible. I'd guess that some method used to bring focus onto that window interferes with the ability to select anything inside it.
Any other ideas? I might go and see if I can learn about these properties and their behaviour in IE.

[perfphysio]

Does everyone having these popunder problems also use the advanced wysiwyg editor - or the standard editor? I've noted a lot of problems with the advanced and therefore don't use it - perhaps this might be a clue to the problem.I use the advanced and have the problem

[a squared]

For me the problem has been solved. The latest version of FF has a built in spell check. And if you have ieSpell (http://www.iespell.com/) installed in your IE it works flawlessly. I don't see any point in installing the mod anymore there doesn't seem to be any direct support and the dictionaries available from ieSpell and FF are much more vast than what is available here.

[Codeman05]

I keep getting the following error

Database error in vBulletin 3.6.3:

Invalid SQL:
SELECT word FROM vbspell WHERE word = 'ghj';

MySQL Error : Table 'vb_forum.vbspell' doesn't exist
Error Number : 1146

It was working fine when I was running VB3.6.0, however I upgraded over the weekend and uninstalled and reinstalled the addon.

I'd prefer to use the alternate method since the installer dosen't appear to be adding the vbspell table to the database, however, I do not know how to get it to quit looking at the database.

Any help would be appreciated

[Masters]

freezes on product import at third 90%

Processing: 175395... (90%)
Processing: 175988... (90%)
Processing: 176676... (90%)

[crashys]

Where or How can i arrange a Portuguese Dic to use with vb spell? :|

[vBulletin THEN DAYLIGHT]

Where or How can i arrange a Portuguese Dic to use with vb spell? :|
Unless someone makes you one, or you can find one, you would have to edit the DICTIONARY.DIC file with all the words in the Portuguese dictionary!

[vBulletin THEN DAYLIGHT]

The vbspell table in my database is 8MB containing the dictionary. I don't use the database dictionary so is it safe to remove the word table?

[snobird1211]

atabase error in vBulletin 3.6.3:

Invalid SQL:
SELECT word FROM vbspell WHERE word = 'dude';

MySQL Error : Table 'snobird_forums.vbspell' doesn't exist
Error Number : 1146
Date : Saturday, November 18th 2006 @ 05:05:32 AM
Script : http://www.iptourneys.com/forums/vbspell.php
Referrer : http://www.iptourneys.com/forums/newreply.php?do=newreply&noquote=1&p=633
IP Address

whats wrong with it

[SparKeh]

works perfectly here

[Codeman05]

atabase error in vBulletin 3.6.3:

Invalid SQL:
SELECT word FROM vbspell WHERE word = 'dude';

MySQL Error : Table 'snobird_forums.vbspell' doesn't exist
Error Number : 1146
Date : Saturday, November 18th 2006 @ 05:05:32 AM
Script : http://www.iptourneys.com/forums/vbspell.php
Referrer : http://www.iptourneys.com/forums/newreply.php?do=newreply&noquote=1&p=633
IP Address

whats wrong with it

same error but with 'nice' as the word. Uninstalled vbspell, reinstalled...no go

[Codeman05]

apparently the install script was never creating the vbspell table.
So I manually created it and imported the SQL files...works fine now

Probably the same thing you will need to do snobird1211

[da_judge]

If you get Maximum execution time of 30 seconds error to fix easy do this

Open .htaccess in public_html folder

Add this line

php_value max_execution_time 90

or

php_value max_execution_time 120

it will fix the time out problem

Also if you get data base error after.. copy attached to admincp folder and run..... www.yours.com/forum/admincp/vbspell_install.php... Uninstall old version... then delete attached from you folder... then try again... bet it works

Judge

[Thawcko]

If you get Maximum execution time of 30 seconds error to fix easy do this

Open .htaccess in public_html folder

Add this line

php_value max_execution_time 90

or

php_value max_execution_time 120

it will fix the time out problem

Also if you get data base error after.. copy attached to admincp folder and run..... www.yours.com/forum/admincp/vbspell_install.php... Uninstall old version... then delete attached from you folder... then try again... bet it works

Judge


I would find this where?? cant seem to locate public_html folder

[sross]

Has anyone gotten this working with 3.6.4? I upgraded from 3.6.1 to 3.6.4 and my spellcheck button has disappeared. I tried re-importing the product and still no luck :(

[perfphysio]

works ok for me in 3.6.4, but funny that the words are highlighted but the suggestions are not given. This was fine in 3.6.3 so it might need a tweak or two

[sross]

:(

oh well, I can't get it going in 3.6.4 so have told my users to use browser plugins for spellcheck..

[shep151]

Running 3.6.4, it wouldn't create the table in my database, but gave me no errors at installation.

After running the install, I manually created the table (I just cut and pasted the query out of the import file), imported the alternate dictionary files into the db, and it's working perfectly!

Thanks for the mod!

[tdbk]

This is not creating the table for me. However, I've never manually created a table, can someone give an idea of what I need to do to enter for fields when I create the table? Fields, length, values, collation, attributes, null, default, etc? What do I cut and paste out of which file to do this in phpmyadmin shep?

[shep151]

What do I cut and paste out of which file to do this in phpmyadmin shep?

Here's the code to create the table: CREATE TABLE IF NOT EXISTS vbspell (
word varchar(30) NOT NULL,
sound varchar(10) NOT NULL,
UNIQUE KEY word (word),
KEY sound (sound)
) TYPE=MyISAM
Go to the forum database, click the SQL tab, and paste that code into the field to run the query and it will create the table.

I'm not sure of the "best" order to do this in, but I did the import, then created the table, then imported the alternate dictionary files to the table, and everything works fine.

Hope this helps! :cool:

[tdbk]

Many thanks Shep! Works fine now.

*installed on 3.6.4

[Ben Wilkins]

Hey, how come i dont get any suggestions when i spell a word wrong?

[Goat Boy]

This posts explains how to get the database to load the table, the xml file has an error in it.

https://vborg.vbsupport.ru/showpost.php?p=1065574&postcount=96

[da_judge]

I would find this where?? cant seem to locate public_html folder

Look in public_html folder or www folder

ie public_html/forum

look for file called .htaccess

edit that m8

[clmazin]

Works just fine for me, although Pyrix' fix in the xml was necessary. Thanks to the mod author and to Pyrix.

Now I cen spel!

C.