Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • Spell Checker Not Working ver 2.2

    Posted by mewilson

    The Spell Checker as the following error once the Spell Check check box is enabled and the Preview button selected:

    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 to
    1 to
    Message:
    Table 'pnr_wikidb.babl_words_en' doesn't exist
    Built query was probably:
    select `word` from `babl_words_en` where `word`='to' or `word`='to'

    The table exist and I can execute the query in phpmyadmin or the Gui Query tool from MySQL and they both work. Nothing wrong with the query although the code appears to believe so. I also don't get any red underline on misspelled words.

    I have read many post about this and all the documentation and have enabled the feature in the Wiki config, the table exist, it returns queries correctly when done from either phpmyadmin or the Gui Query tool.

    What is the potential problem, please help.....

    Note: For all the post I've seen around this topic I've not read many that read that they got it working for those that it was broken or they were missing something like the sql table.

    Reads: 1211

    Posted by mewilson

    Yes, I did download and install the language file. As I said in my post, the babl_words_en table exist in my database pnr_wikidb and I can perform SQL queries from within phpmyadmin and get successful returns without and issues. I have pasted the exact query from the error message to the SQL box in PHPmyAdmin and it works fine. It has to be something wrong with the actual code and how it is interacting with the MySQL database, etc.

    Please help.....