vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vB Spell :: Spell Checker in WYSIWYG and Standard Modes (https://vborg.vbsupport.ru/showthread.php?t=91850)

AtoZ 08-31-2005 05:13 AM

PLEASE correct the spelling of thesaurus on the vbspell screen... It is showing as thesarus. ;)

Edit: I discovered that this can be fixed in the "vbspell" template, but it would be nice to fix that since this is a spell checker.

Thanks for this mod - I hope it helps my members' spelling.

AtoZ 08-31-2005 06:10 AM

Is it okay to share my revised vbspell template? In addition to fixing the spelling error for Thesaurus, I made some other modifications. I found a way to add a description for what each button does when the user mouses over it. The description shows up in the status bar.

For example, here is the code for the "Change All" button:
HTML Code:

<input type="button" class="button" name="changeall" value="Change All" onClick="replaceAll()" ONMOUSEOVER="window.status='Change all instances of this word.';return true;" ONMOUSEOUT="window.status='';return true;">
When the user mouses over it, the status bar text says "Change all instances of this word."

P.S. Great mod! :)

zendiver 08-31-2005 05:44 PM

This is the error I get trying to install this on a FRESH vBullentin 3.08
There seems to have been a slight problem with the Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.8:

Invalid SQL: REPLACE INTO vb3_vbspell VALUES('divines', 'TFNS')
mysql error: User 'xxxxxxx' has exceeded the 'max_questions' resource (current value: 50000)

mysql error number: 1226

Date: Wednesday 31st of August 2005 11:43:03 AM
Script: http://www.divingandfitness.com/foru...install&step=5
Referer: http://www.divingandfitness.com/foru...install&step=4

tamarian 08-31-2005 06:43 PM

Quote:

Originally Posted by zendiver
Invalid SQL: REPLACE INTO vb3_vbspell VALUES('divines', 'TFNS')
mysql error: User xxxx has exceeded the 'max_questions' resource (current value: 50000)

mysql error number: 1226

This seems to be a limit set by your host on the number of queries your forum can run per hour. If this is a shared account, you'll probably need the host to install it for you, or adjust the limit.

P.S. You might want to edit your post to remove the username for the database.

zendiver 08-31-2005 07:34 PM

tamarian, thanks for the reply. I have checked with them, my hosting company, and they say that I don't have a limit. I have 4 domains with them and then was one is actually my testing site. I am going to completely delete EVERYTHING from this site, delete the database, do a fresh install of vBulletin and then try it again.

On my other sites, I have vBulletin, vbPortal, vbPhotoPost, a chat room, and quite a few other things installed and they all work without a glitch. *shrugs*

tamarian 08-31-2005 07:46 PM

Quote:

Originally Posted by zendiver
tamarian, thanks for the reply. I have checked with them, my hosting company, and they say that I don't have a limit.

The error message clearly indicates that there is a limit. If your host does not have a limit, then someone by mistake may have setup MySQL. Check your mysql settings and user priviliges. If this error happens again, send a copy of the error to your host, so they can see the 50,000 limit.

tamarian 09-01-2005 01:19 AM

Quote:

Originally Posted by AtoZ
Is it okay to share my revised vbspell template?

By all means, yes. Might include it on the next update :)

zendiver 09-01-2005 01:04 PM

Tamarian, I got a response from my hosting company and this what they had to say:
Quote:

The database you are using is asking too many questions within one hour (50,000). If you have the .sql file and the database created, please provide the database name and location of the .sql file and we can manaully import it for you on the server.
With the install that you have provided, there wasn't a .sql file BUT there was an additional file: dictionary.sql that I downloaded also. Is this the one that I should send to them? If so, I am a bit concerned with the format as it doesn't have the prefix on it:
Example:
Code:

REPLACE INTO `vbspell` VALUES ('a', 'A');
Shouldn't that be:
Code:

REPLACE INTO `vb3_vbspell` VALUES ('a', 'A');
And lastly, if they import it in, then what do I do about the rest of the installation as it seems that I can't get past Step 5?

Thanks for your time.

tamarian 09-01-2005 01:27 PM

Quote:

Originally Posted by zendiver
Tamarian, I got a response from my hosting company and this what they had to say:


With the install that you have provided, there wasn't a .sql file BUT there was an additional file: dictionary.sql that I downloaded also. Is this the one that I should send to them?

No, the first post states that file is for those in cgi mode, or those who want to import it without the install script.

The installation script comes with a dictionary text file IDCTIONARY.DIC

Quote:

If so, I am a bit concerned with the format as it doesn't have the prefix on it:
Example:
Code:

REPLACE INTO `vbspell` VALUES ('a', 'A');
Shouldn't that be:
Code:

REPLACE INTO `vb3_vbspell` VALUES ('a', 'A');

The installation script does handle text prefixes. The one you're using is a streight mysql dump, and you don't need it if you run the install script.

If you use the dump instead, then just rename the table when your done through mysql client, or phpmyadmin.

Quote:

And lastly, if they import it in, then what do I do about the rest of the installation as it seems that I can't get past Step 5?
If they import it, you don't need step 5, you're done. :)

zendiver 09-01-2005 01:58 PM

Ok, I can understand that, so this is what I plan to do.
Dump the dictionary.sql into my database.
Then, do I run the install program?

tamarian 09-01-2005 02:05 PM

Quote:

Originally Posted by zendiver
Ok, I can understand that, so this is what I plan to do.
Dump the dictionary.sql into my database.
Then, do I run the install program?

My preference would be to first get the host to fix the query limit, since this will solve any future problems with the database. Once that fixed, you can just use the nstall script as usual.

If they don't want to do that, then your above work-around would work, provided that you don't run step #5

zendiver 09-01-2005 02:15 PM

well, they will not up the max limit so the dump is the way I am going to have to go, but now I forsee another problem. Once the dump is made, it already has the table name etc....so I will more than likely get errors running the install program.

tamarian 09-01-2005 02:26 PM

Quote:

Originally Posted by zendiver
well, they will not up the max limit so the dump is the way I am going to have to go, but now I forsee another problem. Once the dump is made, it already has the table name etc....so I will more than likely get errors running the install program.

If you use phpMyAdmin, you can rename the table.

zendiver 09-01-2005 02:30 PM

I am doing that but won't it say that Table already exists when I run the installer, AFTER I complete the dump?

NWN 09-07-2005 06:33 AM

In newreply & newthread under 3.0.8

you need to look for this

PHP Code:

<input type="submit" class="button" name="sbutton" value="$vbphrase[submit_reply]accesskey="s" tabindex="1" />
        <
input type="submit" class="button" name="preview" value="$vbphrase[preview_post]accesskey="p" tabindex="1" /> 

And then add this below for it show the buttens in the right spots.

PHP Code:

<if condition="$show['wysiwyg']">
        <
input type="button" class="button" value="Spell Check" onClick="spellCheck('vbform', 'WYSIWYG_HTML', '2');">
<else />
        <
input type="button" class="button" value="Spell Check" onClick="spellCheck('vbform', 'message', '1');">
</if> 


tamarian 09-07-2005 11:28 AM

Quote:

Originally Posted by zendiver
I am doing that but won't it say that Table already exists when I run the installer, AFTER I complete the dump?

It's messy anyway, due to the host limit, but:

Quote:

Originally Posted by tamarian
provided that you don't run step #5


mustang_lex 09-07-2005 05:58 PM

This is a great feature.

One question. How do I change the text background to white? For some reason its defaulted to red. and I like black text (with red highlight) with a WHITE background. where do I change that?

UPDATE: I found a work around. I removed the link to my CSS file and copyed the CSS content into the vbspell_iframe.php and removed my background image which was causing the problem. :ermm:

Detomah 09-07-2005 11:15 PM

I've had this down as installed for ages, but every time I go to do it, I stall and hold back and keep meaning to ask...

So....

What's this like on the old server loads and queries? Does it add a lot or very little?

tamarian 09-08-2005 12:18 PM

Quote:

Originally Posted by Detomah
What's this like on the old server loads and queries? Does it add a lot or very little?

It's quite fast and light, but you might want to test on the server just to be sure.

It's optimized to ignore common words (any words excluded from your vB search indexing), and the dictionary is indexed, and the queries are indexed, so I haven't noticed any load issues.

You can convert the dictionary table to a HEAP/memory table, but it doesn't seem to be needed.

scoles15 09-13-2005 11:16 PM

It works great for regular posts and replies, but the spell check buttons shows an error and nothing happens

tamarian 09-14-2005 12:44 AM

Quote:

Originally Posted by scoles15
It works great for regular posts and replies, but the spell check buttons shows an error and nothing happens

This only happens in PM's? Might be an old template issue. Try reverting the template, then apply the changes.

scoles15 09-14-2005 03:13 PM

Quote:

Originally Posted by tamarian
This only happens in PM's? Might be an old template issue. Try reverting the template, then apply the changes.

Thanks, that did it. I must have soemthing stupid the first time.

Quillz 09-14-2005 03:19 PM

Interesting modification. I may install it on my board sometime in the future.

JJR512 09-14-2005 05:48 PM

Does the dictionary.dic file need to remain on the server or can it be removed after installation? I thought the dictionary was put into the database, which is why I think it can be deleted. Is that correct?

tamarian 09-14-2005 06:35 PM

Quote:

Originally Posted by JJR512
Does the dictionary.dic file need to remain on the server or can it be removed after installation? I thought the dictionary was put into the database, which is why I think it can be deleted. Is that correct?

Yes, it's no longer needed.

Aidden 09-16-2005 07:19 PM

Im curious as to if an upgrade to 3.09 should have caused this to stop working..

I installed this last night, and everything was working fine.

I just got done doing the upgrade to 3.09 a few minutes ago and I noticed that when you hti the spell check button, the window that pops up is a blank window.. Viewing source fomr within it shows nothign as well.

All files are still on server

and template modifications are still in place.

im baffled.

tamarian 09-17-2005 12:06 AM

Aidden, I have not tested on 3.0.9, as I'm working on 3.5, but I don't think there's any changes that might cause this. Try to reinstall vB Spell from scrach, something may have gone wrong with the upgrade.

Aidden 09-22-2005 02:08 PM

did that.. no go..
jsut cant understand why it would all of a sudden stop working.

blank windows, view source is 100% empty.

Aidden 09-22-2005 04:42 PM

had to run the install script again and now its working..

a squared 09-28-2005 02:58 AM

I would really like to use vB Spell. But, I've run into the same problem that Zendiver had; exceeded limit. The bigger problem is that I really don't know squat about mySQL. I can admire my database. But, as far as adding the needed file to it I'm lost. Is there an idiots guide on how to do this, or is there anyone willing to help an idiot?

bada_bing 09-28-2005 01:26 PM

Anyone have the code to insert the Spell Check button in the New PM and Reply to a pm menu. This hack works awesome when starting and replying to a thread but I want to also includ it in the PM.. I want to to also work the same was with the groups. Currently I have it set so that only Premium Paying Members can use spell check so I want to make sure that the spel check link only shows up in the "PM" memu only for my premium members.

ranger2kxlt 09-28-2005 04:22 PM

Interesting bug....

If you do a spell check and FONT COLOR or BBCODE COLOR a word, the spell the check thinks its miss spelled when its really not....Any ideas?

tamarian 10-01-2005 04:48 PM

Quote:

Originally Posted by ranger2kxlt
Interesting bug....

If you do a spell check and FONT COLOR or BBCODE COLOR a word, the spell the check thinks its miss spelled when its really not....Any ideas?

How is it coloured? I know that mixed format within the word would do this.

bada_bing 10-04-2005 11:35 AM

Quote:

Originally Posted by bada_bing
Anyone have the code to insert the Spell Check button in the New PM and Reply to a pm menu. This hack works awesome when starting and replying to a thread but I want to also includ it in the PM.. I want to to also work the same was with the groups. Currently I have it set so that only Premium Paying Members can use spell check so I want to make sure that the spel check link only shows up in the "PM" memu only for my premium members.

Does anyone or can anyone help me out here? Im sure someone know how to do this?

tamarian 10-04-2005 11:50 AM

Quote:

Originally Posted by bada_bing
Does anyone or can anyone help me out here? Im sure someone know how to do this?

I didn't understand what you mean. Have you tried the templated edits for PM's in the first post, and they didn't work?

bada_bing 10-04-2005 12:03 PM

Quote:

Originally Posted by tamarian
I didn't understand what you mean. Have you tried the templated edits for PM's in the first post, and they didn't work?

I dont see how to edit the PM template. do you have a step-by-step procedure?

tamarian 10-04-2005 12:33 PM

Quote:

Originally Posted by bada_bing
I dont see how to edit the PM template. do you have a step-by-step procedure?

It's listed in the first post of this thread.

GoTTi 10-09-2005 12:45 AM

how would i add words to the dictionary?

GoTTi 10-09-2005 12:48 AM

where would i get a updated .dic file?

tamarian 10-09-2005 01:06 AM

Quote:

Originally Posted by GoTTi
where would i get a updated .dic file?

Just click the "learn" button.


All times are GMT. The time now is 09:28 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.02939 seconds
  • Memory Usage 1,850KB
  • 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
  • (4)bbcode_code_printable
  • (1)bbcode_html_printable
  • (2)bbcode_php_printable
  • (21)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