power search fatal error

[vanessayr]

Hello, I would like to get some help I am getting this error:

Runtime error in /mm5/5.00/modules/util/powrsrch.mvc @ [0000001f:0000016c]: powrsrch.mv: Line 1740: MvQUERY: mysql_stmt_prepare: Table 'curtains_mm5.s01_PowerSearchProducts' doesn't exist Runtime error in /mm5/5.00/modules/util/powrsrch.mvc @ [0000001f:00000392]: powrsrch.mv: Line 1791: MvQUERY: mysql_stmt_prepare: Table 'curtains_mm5.s01_PowerSearchProducts' doesn't exist .text0 {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 9px;color: #333333;}.text1 {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 11px;color: #333333;}.text2 {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 12px;color: #333333;}.text3 {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 14px;color: #333333;}.text4 {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 16px;color: #333333;}.be_header {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 11px;font-weight: bold;color: #333333;background-color: #003399;background-image: url(graphics/en-US/admin/grad_head.gif);height: 35;}.be_row {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 11px;color: #333333;background-color: #ffffff;}.be_row_alt {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 11px;color: #333333;background-color: #003399;}.lnav {background-color: #eeeeee; font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 11px;color: #333333; }body {background-color: #ffffff; font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 11px;color: #333333; }A:link, A:visited, A:active, A:hover {color: #b20000;}A:hover {color: #999999;text-decoration: none;}td {font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 11px;color: #333333;}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 'curtains_mm5.s01_PowerSearchProducts' doesn't exist Other Information:


Whenever I try to update any product.

I already checked if it had to do with having product codes starting with the same letter but I changed them and still the same problem persists. I didn't do any changes on powersearch and I have done several updates and created new fields on the past day with no problems at all and I did a lot of updates after the last time I created the last field having no problems until now.

Thank you.

[leslienord]

Re: power search fatal error

Did you contact the module's developer?

[vanessayr]

Re: power search fatal error

No , I haven't but I am going to .

Thank you

[Vic - WolfPaw Computers]

Re: power search fatal error

Always best to contact module developers directly using their established support systems first.

You may also want to try re-installing the module.

[wcw]

Re: power search fatal error

There is a FAQ section in the install doc. The missing database is covered. This remedy requires the latest version of the power search module so an update of the module may be needed.

[vanessayr]

Re: power search fatal error

Thank you. I had to change the number of records at a time set to 567.

[wcw]

Re: power search fatal error

After running it and getting a successful build of the mirror, don't use the 567 feature. That is only for when the database is missing.

[vanessayr]

Re: power search fatal error

Oh yes I returned to a different number.

Thanks