|
By mc9ag - Wed 18 Jul 2012
|
A search from the main header or the search page enters the following in the log:
System.Data.SqlClient.SqlException
Database Error: invalid object.
>> NUMBER:2812
>> MESSAGE:
Could not find stored procedure 'spKartrisDB_SearchFTS'.
The full error is attached.
Not sure how I've managed this - a fresh working installation doesn't seem to have this particular stored procedure in the database.
Any help appreciated. Colin
|
|
By Paul - Fri 3 Aug 2012
|
This indicates the site is trying to use FTS - full text search. This is an MSSQL feature that can improve the searching speed, and is especially useful on large sites with thousands, or hundres of thousands of products.
The FTS feature can be enabled from the back end of Kartris - Configuration > Database Admin > FTS. It is activation from here which creates the extra stored procedures necessary.
So I think in your case, it seems to be trying to use FTS, but the sprocs required aren't there (and quite possibly your database doesn't support FTS).
Are you positive you didn't try to activate this in the back end?
Also, which exact version of Kartris are you using? I think in newer ones, it should recognize if no FTS catalogues and switch the general.fts.enabled config setting back to 'n' automatically so it doesn't try to use FTS.
|
|