Announcement

Collapse
No announcement yet.

Power Search ERROR

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Power Search ERROR

    I miss Bill...
    Power Search error when trying to rebuild mirror.
    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-00026
    Description: mysql_stmt_prepare: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
    Other Information:

    Open Ticket ID: FXI-109-74710
    Mark Hood
    Vermont Gear

    #2
    Re: Power Search ERROR

    List the custom product field codes in your store and let's see if any violate the guidelines.

    Another thing to check. In the power search setup screen there is an input for the fields to use in the FULLTEXT. What exactly do you have in that input?
    Last edited by wcw; 02-26-15, 09:03 AM.
    Bill Weiland - Emporium Plus http://www.emporiumplus.com/store.mvc
    Online Documentation http://www.emporiumplus.com/tk3/v3/doc.htm
    Question http://www.emporiumplus.com/mivamodu...vc?Screen=SPTS
    Facebook http://www.facebook.com/EmporiumPlus
    Twitter http://twitter.com/emporiumplus

    Comment


      #3
      Re: Power Search ERROR

      Originally posted by wcw View Post
      List the custom product field codes in your store and let's see if any violate the guidelines.

      Another thing to check. In the power search setup screen there is an input for the fields to use in the FULLTEXT. What exactly do you have in that input?
      Stupid freaking typo... Thank you very much

      Full Text was name.descrip

      It's all fixed!
      Last edited by Mark Hood; 02-26-15, 10:22 AM.
      Mark Hood
      Vermont Gear

      Comment

      Working...
      X