vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   New Posting Features - vB Spell (https://vborg.vbsupport.ru/showthread.php?t=124578)

perfphysio 11-29-2006 07:54 PM

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 11-30-2006 08:31 PM

:(

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

shep151 12-05-2006 04:18 PM

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 12-07-2006 01:02 AM

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 12-07-2006 08:30 PM

Quote:

Originally Posted by tdbk (Post 1133579)
What do I cut and paste out of which file to do this in phpmyadmin shep?

Here's the code to create the table:
Code:

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 12-07-2006 10:21 PM

Many thanks Shep! Works fine now.

*installed on 3.6.4

Ben Wilkins 12-08-2006 11:11 AM

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

Goat Boy 12-13-2006 01:20 AM

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....4&postcount=96

da_judge 12-14-2006 10:23 PM

Quote:

Originally Posted by Thawcko (Post 1126106)
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 12-17-2006 09:23 PM

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.

Tabasco 12-19-2006 12:08 PM

So which version is best to use with 3.6.4?

Regular Install:

* Unzip dictionary-reg.zip.
* Upload DICTIONARY.DIC to your forum home directory.

or

Alternate Install

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

Has the XML template or the MySQL issue been fixed? or do I need to follow change instructions?

Thanks

HAVOK USA 12-19-2006 04:43 PM

Installed without problems - set permissions - the icon shows in the post box, when I press it, nothing happens (no pop up box)

I have pop ups cleared for the website. Any ideas? I's love to use this hack.

NeoGTavern 12-22-2006 01:49 PM

Okay I go it installed and it is catching misspelled words, however it will offer no suggestions. When I click on the "suggestions" box I get the error

Line: 397
Char: 1
Error: Object does not support this property or method
Code:0

I am using vB 3.6.4

zetetic 12-31-2006 05:14 PM

Quote:

Originally Posted by Tabasco (Post 1141546)
So which version is best to use with 3.6.4?
Regular Install:
or
Alternate Install

The regular install is much easier. Only use the alternate if the regular fails.

Quote:

Has the XML template or the MySQL issue been fixed? or do I need to follow change instructions?

Thanks
As of today (version 0.10.2b), the XML file has not been updated.

Before you attempt to install this product, you should open the product-spellvb.xml file and...

find:
HTML Code:

// 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");

and replace with:
HTML Code:

// 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");

Otherwise it will drop the vbspell table right after it creates it, before importing the dictionary!

Big Kahuna 01-04-2007 06:47 PM

I had everything set up and was one click away from installing product -- and then read all of this.

I've got very cold feet now and won't do it.

I have MKPortal, Photopostphp, Photopost Classifieds, and a large forum. I can't afford the problems.

That said -- what irritates me is that Vbulletin doesn't have a spell check integrated in the product. I have one Vbulletin board at www.moparstyle.com and two FREE SMF forums at www.oldhippie.com and www.forums.diamondbackengines.com -- and amazingly, the free forums have a INCLUDED spell check that you can either use or disable. I've paid five years of dues at vBulletin after buying a perpetual license and don't have that benefit.

I'd spell check this post -- but there isn't one installed here lol

Ski-Whiz 01-08-2007 12:35 PM

Is it me, but in the product you tell it to create "vbspell" tables, and you next tell it to remove the old "vbspell" tables?

PHP Code:

// 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"); 

They are the same tables. I was wondering why I first got an error saying this table was already there.. So I removed it. Then when it installed, it never created it. Also the alternate way didn't install for me either at the time, as those SQL files insert data into the table it removed.

Not a biggie. I have it working now. Just a heads up. :D

Ski-Whiz 01-08-2007 12:38 PM

^^^^^^Never mind, I see this was already notice..

Goat Boy 01-14-2007 11:08 PM

Quote:

Originally Posted by Pyrix (Post 1065575)
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:

Code:

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

Code:

}
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


I did this mod and Photopost Reply works but in the forums I get a Pop Up message about ieSpell is a spell checking tool for Internet Explorer and gives me a link to download it now?


Any Idea how to overcome that?
I am running 3.6.4

bada_bing 01-15-2007 08:04 PM

Ok getting a bit peeed off here.. I am trying to install this hack and I have tried to import the plugin using method 1 by uploading the dictinary file then installing the plugin and I got an error. Then I imported the dictinary files into the database then imported the plugin and still get the same error.. What is going on here is the error.
Fatal error: Maximum execution time of 60 seconds exceeded in c:\domains\mysite.com\wwwroot\forums\includes\clas s_core.php on line 363

Replicators 01-19-2007 11:15 PM

Quote:

Originally Posted by Ski-Whiz (Post 1153551)
Is it me, but in the product you tell it to create "vbspell" tables, and you next tell it to remove the old "vbspell" tables?

PHP Code:

// 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"); 

They are the same tables. I was wondering why I first got an error saying this table was already there.. So I removed it. Then when it installed, it never created it. Also the alternate way didn't install for me either at the time, as those SQL files insert data into the table it removed.

Not a biggie. I have it working now. Just a heads up. :D

ROFL, i don't know who made this error, whether it was me or cynix2. What it was meant to do, was removed the old table, then create the new one, instead it went opposite!

B3y0nd 01-20-2007 03:00 AM

This is a mod that I would love to have on my boards, but it STILL seems to have major issues. Too bad. :(

I'll keep checkin' in from time to time to see if it ever becomes a reliable hack.

bada_bing 01-21-2007 02:29 AM

Quote:

Originally Posted by bada_bing (Post 1160119)
Ok getting a bit peeed off here.. I am trying to install this hack and I have tried to import the plugin using method 1 by uploading the dictinary file then installing the plugin and I got an error. Then I imported the dictinary files into the database then imported the plugin and still get the same error.. What is going on here is the error.
Fatal error: Maximum execution time of 60 seconds exceeded in c:\domains\mysite.com\wwwroot\forums\includes\clas s_core.php on line 363

Can someone help me PLEASE.. .Author where are you man?

bada_bing 01-22-2007 04:53 PM

Boy for this to be a 3.6.0 hack the support sucks!!! Can someone assist on getting around the errors im having

bada_bing 01-25-2007 05:51 PM

Never mind got it working.. For anyone else having problems running the plugin, I would right off the bat import the dictonary queries manually then run the plugin. VERY IMPORTANT & NOT DOCUMENTED. If you manually run the database queries you MUST remove the DOCTONARY file you originally uploaded to the Forums directory so that the plugin does not detect this file and try to run the queries again..

lazserus 01-29-2007 04:11 PM

I've followed the instructions and installed this mod but I am not seeing a vBSpell option in my AdminCP, nor does it show on my forums.
  1. I've imported the xml file using vBulletin's "Add Products" option.
  2. I've uploaded the vbspell files.
  3. I've uploaded the DICTIONARY.DIC file

I received no errors when importing this mod, yet it does not show anywhere on my forums. Any suggestions?

Knightmane 01-31-2007 01:48 AM

I am a little leery to install this hack, but I wanted to mention that Mozilla Seamonkey Suite version 1.1 has a built in spell checking dictionary that checks your spelling as you type in posting fields. You can even add words to the browser's dictionary... this is very handy for getting around words that are used in TV shows that simply do not appear in the dictionary (i.e. zords, etc.)

melbo 01-31-2007 04:35 AM

Quote:

Originally Posted by zetetic (Post 1148164)
The regular install is much easier. Only use the alternate if the regular fails.


As of today (version 0.10.2b), the XML file has not been updated.

Before you attempt to install this product, you should open the product-spellvb.xml file and...

find:
HTML Code:

// 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");

and replace with:
HTML Code:

// 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");

Otherwise it will drop the vbspell table right after it creates it, before importing the dictionary!

That should be bumped to the first post in this thread. After a few pages, we new installers try all the junk that is reccomended post by post. Was just about to toss this laptop out the sunroof when I read this one. THanks!!!

parabat 03-08-2007 07:35 PM

Is it at all possible to select your language of choice, dictionary you want to spell check with?
My board has multiple languages and it would be ideal if the users could select the dictionary of choice when they doing the spell check.
Is that possible, or do I have to integrate the various language dictionaries into one??

-PB

valdet 03-09-2007 10:50 AM

Before we try this , can anyone please confirm that this spellchecker works on 3.6.5 and it won't crash your database..

perfphysio 03-09-2007 10:54 AM

Quote:

Originally Posted by valdet (Post 1199438)
Before we try this , can anyone please confirm that this spellchecker works on 3.6.5 and it won't crash your database..

Works on my 3.6.5 fine :)

Fungsten 03-09-2007 06:55 PM

I got a DB error when entering a word. Here's the error:

Database error in vBulletin 3.6.5:

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

MySQL Error : Table 'Blah bla.vbspell' doesn't exist
Error Number : 1146
Date : Friday, March 9th 2007 @ 01:05:44 PM
Script : http://Blah blah/testvb/forum/vbspell.php
Referrer : http://www.blah blah/testvb/forum/showthread.php?p=107
IP Address : xxx.xx.xxx.xx
Username : [Username]
Classname : vb_database

Elenna 03-11-2007 07:06 AM

I am receiving the same error as Fungsten. If you get it fixed, please report back!

Elenna 03-11-2007 07:11 AM

Fungsten,

Never mind, I found the following post, and followed the instructions, and now it works! Silly me.

https://vborg.vbsupport.ru/showpost....&postcount=267

Fungsten 03-11-2007 03:31 PM

And a thank you to Melbo!

Quote:

Originally Posted by Elenna (Post 1200671)
Fungsten,

Never mind, I found the following post, and followed the instructions, and now it works! Silly me.

https://vborg.vbsupport.ru/showpost....&postcount=267


bacanze 03-11-2007 05:07 PM

Cool plugin, thanks.

Gene Steinberg 03-12-2007 06:47 PM

Quote:

Originally Posted by bacanze (Post 1200965)
Cool plugin, thanks.


The problem I ran into is that, under my vBulletin 3.6.5 installation, it stalled when I tried to Import the Product .xml file. Does this require doing that hack on it first or what?

Please let me know before I make another attempt.

Peace,
Gene Steinberg

valdet 03-13-2007 11:01 AM

I think that alt install should be safer, because regular install may cause timeouts during product import..

But I would like to be sure before i Install this.

Is it OK to run the SQL queries, and then import the product, so the product will already have the necessary tables set?

Thanks.

SloppyGoat 03-24-2007 06:08 AM

Ok, I give up. Maybe better instructions are in order? It tells me there is no vbspell table. I guess I'm supposed to know how to create it and the number of fields? Not everyone knows how to create tables and import SQL files, and it sure didn't work the "regular" way. In fact, I don't think it did anything. I'm hoping it didn't now.

After modifying the xml file, I tried this again. The last thing it says is "Processing: 54249... (28%)", then the horizontal scroll just keeps growing for eternity. I'm not sure it's even doing anything. However, it did appear to create the table this time.

[edit] I managed to get it installed, and added the quick_edit changes, but in either edit mode it does not offer any suggestions, ever. What's wrong? Sure the box pops up, but it never has any suggestions, no matter how badly you misspell.

How would I change the grey color in this, without messing with all my other settings?

mbkerk 03-31-2007 04:24 AM

Install goes well until I try to import "product-spellvb.xml" from my computer. I did edit the HTML code as specified in post 267 ... but when it is importing I get up to between 66% and 69% (many attempts) and the install just stalls... no messages what so ever.

Please advise.

ams3521 03-31-2007 03:20 PM

Quote:

Fungsten,

Never mind, I found the following post, and followed the instructions, and now it works! Silly me.

https://vborg.vbsupport.ru/showp...&postcount=267
Excellent as that also solved my database error on 3.6.5


All times are GMT. The time now is 10:51 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01560 seconds
  • Memory Usage 1,852KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (4)bbcode_html_printable
  • (2)bbcode_php_printable
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete