I installed the mod on a staging site and it appeared to install without errors. I did not install the extra fields mod initially. I added the extra fields mod and rebuilt the search database.
I added a static page and when I saved it I received 95 emails letting me know I had the following error...
[06-Mar-2010 22:30:55] (shop: 06-Mar-2010 22:30:55) SQL error:
Site :
https://www.mysite.com
Remote IP : xx.xxx.192.162
Logged as : admin
SQL query : INSERT INTO xcart_smart_search_pages_index (id, pageid, location) VALUES ('989', '6', '3')
Error code : 1146
Description : Table 'mydatabase.xcart_smart_search_pages_index' doesn't exist Request URI: /admin/pages.php
Backtrace:
/home/myfolder/public_html/include/func/func.db.php:186
/home/myfolder/public_html/include/func/func.db.php:112
/home/myfolder/public_html/modules/Smart_Search/Extra_Fields-News-Static_Pages/smart_search_extra_functions.php:0
/home/myfolder/public_html/modules/Smart_Search/Extra_Fields-News-Static_Pages/smart_search_extra_functions.php:0
/home/myfolder/public_html/modules/Smart_Search/Extra_Fields-News-Static_Pages/smart_search_pages_modify.php:22
/home/myfolder/public_html/admin/pages.php:186
-------------------------------------------------
Yikes. So I removed the extra fields mod and revised admin/pages.php back to the original state. Now I can add/update static pages without any errors.
However, I rebuilt the search database again, and noticed at the end of the rebuild process I get dbase errors. Unfortunately they flash so quick on the screen I cannot see what they are.
So, now, even without the extra fields module installed, I get errors when I rebuild the database. The search feature seems to work just fine, but, sql errors cannot be good.
Has anyone else seen this issue?
(BTW, the info below is from the Smart Search FAQ page at Altered Cart - I have rebuilt the search dbase numerous times, but I always get the sql error at the end of the query - disappears though before I can see what it says. Also, I no longer get the same "1146" error because I removed the Extra Fields add on option)
Question - I'm receiving an INVALID SQL: 1146 table doesn't exist error when searching or saving a static page in the admin.
Answer - An INVALID SQL: 1146 table doesn't exist error is caused when the proper Smart Search tables haven't been created. The search database/index will need to be rebuild on the admin/smart_search_admin.php page in your X-Cart admin section.