Category: Spellcheck

Hello,

Remark : The editing current page seems to crash if to many changes by cut are made (my page lost).

Object :

Change of option "check orthography" lead to system error when you save the page :

__SYSTEM ERROR

La table 'teawik-ld8-50s-new1.babl_words_fr' n'existe pas
__
The query was :
select `word` from `babl_words_fr` where `word`=? or `word`=?

Valeurs :

1. Table
2. table

The built query was likely :
select `word` from `babl_words_fr` where `word`='Table' or `word`='table'

Stacktrace :
* tiki-editpage.php : 0 -> {main}(array ( ))
*tiki-editpage.php : 853 -> spellcheckreplace(array ( ))
*lib\tikilib.php : 1659 -> spellcheckword(array ( ))
* lib\tikilib.php : 1704 -> spellcheck_word(array ( ))
* lib\bablotron.php : 44 -> word_exists(array ( ))
*lib\bablotron.php : 104 -> query(array ( ))
* lib\core\lib\TikiDb\Bridge.php : 29 -> query(array ( ))
*lib\core\lib\TikiDb\Pdo.php : 119 -> handleQueryError(array ( ))
*lib\core\lib\TikiDb.php : 150 -> handle(array ( ))

The following message occurs if you ask for a spell check without even knowing you need to load the Dictionary file.
Which most new users would NOT know.... Certainly I didn't know...

Can I suggest that the error message be more descriptive and contain a link to SourceForge to down load the dictionary.
Perhaps the error message could be "You are missing the dictionary - please down load from ......" <grin>

Would it be possible to have this downloaded and installed from the MODS in Tiki????

Thank you!
=====================================================================
Error
An error occured in a database query!

Context:
File tiki-editpage.php
Url tiki-editpage.php?
Query:
select `word` from `babl_words_en` where `word`=? or `word`=?
Values:
0 Tombstone
1 tombstone
Message:
Error Message Table 'tikiwiki.babl_words_en' doesn't exist

Go back

Return to home page

This is a perfect use for mods.

words_en.sql weighs 7.5 Megs. This is not super easy to upload via phpmyadmin.

Hi:

I just tried spellcheck, with the provided english dictionary at sf.net (words_en.sql, etc.). And also added another one as a trial (words_ca.sql, with 15 catalan words, etc.), coded words with utf-8.

Enabled feature, Created a new page with some words:
^
abaconarà
Abaconarà
abaconará
Abaconarà
Abaconara
abaconara
perquè així però vinyals calçador
howto
howtee
yeouhooo
spellchek
^

The only one shown in red at preview state is "~~red:vinyals~~", having interface either in English or Catalan.
There must be something wrong in the feature.

The only word included in words_ca.sql is abaconarà (non of the others is)

And in words_en.sql, non of the catalan words are, and I guess yeouhooo is not either...

spellcheck should get lang from wiki page lang, not from users' interface language, or elsewhere.

For instance, I have firefox in catalan, tiki lang pref. in catalan. If I edit an English page in doc.tw.o site, and I clikc on spellcheck, Tiki should search for dictionary tables of English lang, and nowadays it searches for Catalan tables on db.

----
Update: I confirm this is still happening. On doc.tw.o, for instance...

---------------------------
Context:
File /tiki-editpage.php
Url /tiki-editpage.php
Query:
select `word` from `babl_words_ca` where `word`=?
Values:
0 Tiki
Message:
Error Message Table 'doctwo_doctwo.babl_words_ca' doesn't exist
---------------------------

As of today (pre 1.9.8), if I activate the Spellcheck, I get:

{img src=images/code.png}%%% {CODE()}
An error occured in a database query!

Context:
File php.cgi
Url tiki-editpage.php
Query:
select `word` from `babl_words_fr` where `word`=? or `word`=?
Values:
0 test
1 test
Message:
Error Message
{CODE}


I need to know from:
http://doc.tikiwiki.org/Spellcheck

That I need to install the word dictionary database separately from the rest of Tiki.


Tiki should check that the table exists and return a nicer error message.


And why is Tiki searching for "babl_words_fr"? My browser and Tiki are in English...