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?


All times are GMT. The time now is 11:37 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.01226 seconds
  • Memory Usage 1,752KB
  • 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
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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