PowerSearch Error

[delcorsets]

I just received a fatal error while trying to rebuild my PowerSearch database. I do know that Miva is suggesting migrating all search to native features, but I have a site that relies on PowerSearch for lots of custom functionality so I'm trying to use PowerSearch for just those features if I still can.

I usually use the "Turbo Rebuild" and have not had any problem until this morning. Today the Turbo Rebuild just brought up a white screen without the usual list of rebuilt file messages.

I then tried the rebuild without using the "turbo" option and got a Fatal Error:

Fatal Error

Miva Merchant has encountered a fatal error and is unable to continue. The following information may assist you in determining the cause of the error: Error Code: MER-UTL-POW-00007 Description: mysql_stmt_prepare: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server versi Other Information:

Any suggestions?

[delcorsets]

Just received this error

Runtime error in mm5/5.00/modules/util/powrsrch.mvc @ [00000029:00000040]: powrsrch.mv: Line 5081: MvQUERY: mysql_stmt_prepare: Table 'delcors_devmiva5.s02_PowerSearchProducts' doesn't exist Runtime error in mm5/5.00/modules/util/powrsrch.mvc @ [00000029:00000470]: powrsrch.mv: Line 5136: MvQUERY: mysql_stmt_prepare: Table 'delcors_devmiva5.s02_PowerSearchProducts' doesn't exist

Fatal Error

Miva Merchant has encountered a fatal error and is unable to continue. The following information may assist you in determining the cause of the error: Error Code: MER-UTL-POW-00016 Description: mysql_stmt_prepare: Table 'delcors_devmiva5.s02_PowerSearchProducts' doesn't exist Other Information:

[delcorsets]

SOLVED: With the help of Cory at support I was able to easily fix this problem. I had created a new custom field the other day and mistakenly put a dash in the code rather than an underscore. After changing the code to remove the dash and replace with an underscore the rebuild worked again.

[William Davis]

Is there a reason while you are still using Power Search vs native solution that has been updated?

I am just wondering what could I possibly be missing out on (pros vs cons)?

[delcorsets]

William Davis I have a lot of custom search functionality on one of my sites that was originally created using PowerSearch. Really cool Tag search and Designer search from my product pages and some customized "smart" searches from landing pages / NavBar for things that require multiple search criteria like "masculine jewelry from designer xxx" or "mens clothing with skulls under $100". It's possible that some of this could now be rewritten using native Miva search, but the original project was costly and unfortunately I don't currently have the budget to R&D / re-write the customizations (if it's even possible.)

If I could figure out to make these changes myself I would try it.. my available time to experiment with things like this however is very tight. I would like to be on Miva native functionality wherever possible just to get rid of some of the older 3rd party modules I'm still using - but in many cases Miva's solutions end up missing one or two critical features that I use from the modules that I currently have in use.

I am actually using some of Miva' s search features in tandem with the PowerSearch custom features, so I do have faceted search in use as well.

[William Davis]

William Davis I have a lot of custom search functionality on one of my sites that was originally created using PowerSearch. Really cool Tag search and Designer search from my product pages and some customized "smart" searches from landing pages / NavBar for things that require multiple search criteria like "masculine jewelry from designer xxx" or "mens clothing with skulls under $100". It's possible that some of this could now be rewritten using native Miva search, but the original project was costly and unfortunately I don't currently have the budget to R&D / re-write the customizations (if it's even possible.)

If I could figure out to make these changes myself I would try it.. my available time to experiment with things like this however is very tight. I would like to be on Miva native functionality wherever possible just to get rid of some of the older 3rd party modules I'm still using - but in many cases Miva's solutions end up missing one or two critical features that I use from the modules that I currently have in use.

I am actually using some of Miva' s search features in tandem with the PowerSearch custom features, so I do have faceted search in use as well.

Hmm, I am not able to follow all your reasoning, but I do understand your predicament having been there myself on more than one occasion.

I will take a peak at your site at some time when I have more time on my hands due to curiosity.

[Rick Wilson]

No one should still be using Power Search, it's on the short list of modules we will at some point in the future fully prohibit it's usage due to a variety of performance and other issues.

[lesliekirk]

No one should still be using Power Search, it's on the short list of modules we will at some point in the future fully prohibit it's usage due to a variety of performance and other issues.

Has that day come? I just had a site with very complex Power Search functionalities pretty much quit functioning. Their site pretty much relies on PowerSearch and I'm still not sure that the built-in search can do everything their site needs.

[lesliekirk]

delcorsets Psydde, have you replaced PowerSearch? If not, have you updated to 10.06? And if so, are you having any issues?

[delcorsets]

delcorsets Psydde, have you replaced PowerSearch? If not, have you updated to 10.06? And if so, are you having any issues?

lesliekirk What specifically has happened, or is no longer happening, on that specific site? Was the updated ShipStation module installed?

[lesliekirk]

lesliekirk What specifically has happened, or is no longer happening, on that specific site? Was the updated ShipStation module installed?

I'm getting an Application Timed Out error here. The ShipStation Integration Script is inactive but the store owner just informed me they do use ShipStation.

[delcorsets]

Sorry, I've not experienced any behavior like that.. the only place Power Search is still being used on my site is for my custom Tag Clouds, Designer links, and "dynamic" category links. I'm hoping to find a way to start doing all these things with Miva native search soon.

[lesliekirk]

Sorry, I've not experienced any behavior like that.. the only place Power Search is still being used on my site is for my custom Tag Clouds, Designer links, and "dynamic" category links. I'm hoping to find a way to start doing all these things with Miva native search soon.

Glad to hear that the update didn't impact your store. This store relies heavily on PowerSearch. Now I'm trying to remember who did all the heavy lifting type coding. I think I know who did it.

[William Davis]

Sorry, I've not experienced any behavior like that.. the only place Power Search is still being used on my site is for my custom Tag Clouds, Designer links, and "dynamic" category links. I'm hoping to find a way to start doing all these things with Miva native search soon.

delcorsets, like your extra search options on your site, your tags search is a nice idea. Could you not do the same with Miva faceted search? Its not difficult to implement unless I am missing something.

[lesliekirk]

Sorry, I've not experienced any behavior like that.. the only place Power Search is still being used on my site is for my custom Tag Clouds, Designer links, and "dynamic" category links. I'm hoping to find a way to start doing all these things with Miva native search soon.

Update to this - the store owner got the same Fatal Error you reported. Now to ask if they might have added any new custom fields or changes period.