Instant Search

[NWCE]

Hi Steve...

I went into the includes\classes\ajax\zcAjaxInstantSearch.php file and added the single quotes to the INSTANT_SEARCH_MYSQL_USE_QUERY_EXPANSION to eliminate this error....it then through another Undefined Constant error in this file on another line....etc. Kept defining the constants by adding in the single quotes and it eliminated this error.

The error that I am now trying to fix in this plugin is:

PHP Warning: Undefined array key "INSTANT_SEARCH_PRODUCT_FIELDS_LIST" in C:\wamp64\www\plugin21\zc_plugins\InstantSearch\v4.0.3\classes\SearchEngineProvi ders\MysqlSearchEngineProvider.php on line 133

Would you be able to suggest the code to define this array?

Thanks!

[NWCE]

To add to my last post...

There was a second error on the Debug log along with the one I posted in Post #233 above.

It is:

PHP Warning: foreach() argument must be of type array|object, null given in C:\wamp64\www\new2121\zc_plugins\InstantSearch\v4.0.3\classes\SearchEngineProvid ers\MysqlSearchEngineProvider.php on line 133

Hopefully this gives the full picture of what I'm experiencing.

Not sure why the plugin worked well in the stock Zen Cart v.2.1 with demo info in the database, and when I then added my Zen Cart v.1.5.8 database (ran the zc_install after to update the database to v.2.1) the plugin doesn't work and it throws this error. Adding the database was the only change I made....just for full disclosure.

One thought....when installing the plugin, does it happen to automatically run some sort of SQL statement that now needs to be rerun somehow to incorporate it into this database??

[torvista]

After the import and running zc_install, in the admin plugin modules: does it shown instant search as installed?

Perhaps you should uninstall in zc158 before the initial export of the db.

[NWCE]

Hi Steve....thanks for your reply!

When I imported my zen 1.5.8 database, the Instant Search showed in the plugins module but was uninstalled. I installed v.4 using the Upgrade button and then did the clean up on v.3

If I'm understanding your last suggestion about "uninstall in zc_158 before export of db".....you are meaning in my live cart??

When I imported this db into my development site....it doesn't show this old version as Installed.....neither of the versions were Installed when in Admin->Modules->PluginMgr

Not sure but errors in the Debug log that I am getting seem to be related to coding of the arrays...would this be a PhP or SQL version issue???

Thanks for your help with this....much appreciated!!

[NWCE]

Hi Steve,

I have been working on my site testing now that its on my server under a subfolder. I have got this plugin working perfectly now!

What I have done to mitigate my problems from my previous posts is when I place in my live site database, I completely uninstalled the plug in removing all plugin files inside the Included folder and the entire zc_plugins folder files.

I signed into my Admin panel to insure it was removed.

I then reinstalled the plugin files, signed into Admin and Installed the plugin through Admin->Modules->Plugin Mgr. When pressing the Install I got the Admin white screen and had to alter the zc_plugins\InstantSearch\v4.0.3\Installer\ScriptedInstaller. php on line 27 by removing the entire coding.

I then ran the Install in Admin->Plugin Mgr and had success installing.

Went to my site, refreshed it, and tried searching....and presto....works perfectly! No errors in Debug Logs.

Wanted to update you....and if someone else has these problems or errors...

[NWCE]

After having this plugin working perfectly in my test site on my server....I ran the Database Converter Plugin....and it broke the Instant Search plugin where it threw an error in the Debug Log and it simply no longer Searched when testing on the site.

I tried uninstalling the plugin via removing all files (thinking that this worked when I dropped in my live site DB)....checking in Admin panel->Plugin Mgr to insure that it was removed and then reinstalling the files.

Now when going to Admin->Modules->Plugin Mgr, I see the plugin and when pressing Install I receive the error at the top of my Admin page of:

Duplicate key name 'idx_products_name'
Duplicate key name 'idx_products_description'

The plugin will not install.

Hoping this helps to decipher what took place when using the database converter tool...and how to fix it?

I had posted about this in the Database Converter plugin thread...and lat9 suggested I post in in here.

Thanks for your help!

[carlwhat]

After having this plugin working perfectly in my test site on my server....I ran the Database Converter Plugin....and it broke the Instant Search plugin where it threw an error in the Debug Log and it simply no longer Searched when testing on the site.

I tried uninstalling the plugin via removing all files (thinking that this worked when I dropped in my live site DB)....checking in Admin panel->Plugin Mgr to insure that it was removed and then reinstalling the files.

Now when going to Admin->Modules->Plugin Mgr, I see the plugin and when pressing Install I receive the error at the top of my Admin page of:

Duplicate key name 'idx_products_name'
Duplicate key name 'idx_products_description'

The plugin will not install.

Hoping this helps to decipher what took place when using the database converter tool...and how to fix it?

I had posted about this in the Database Converter plugin thread...and lat9 suggested I post in in here.

Thanks for your help!

do you have log files?

what version of this plugin are you running?

i would compare this file:

https://github.com/marco-pm/zencart_...dInstaller.php

with the one on your site.

it does seem that the scriptedInstaller checks for that index PRIOR to creating a new one with the same name. as to whether that code works, i can not say. but log files would help.

best.