Announcement

Collapse
No announcement yet.

Suggested feature> reserved word check

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

    Suggested feature> reserved word check

    Well my Power Search is broken and it seems that some code or perhaps a custom field (?) may be using a reserved word. I have no idea how to identify this short of checking each product and manually comparing the list of words which is really no small task.

    I'd like to suggest a few possible feature/solutions

    1-a module or feature that checked the 'reserved words list' at the time you create the code (or any other field that this is an issue.

    or

    2-a simple popup window you could paste your code or text into (again, not sure what fields this is an issue on) and click submit to run a test. This wouldn't even have to be in the admin I guess as an unofficial community tool that you could bookmark would be enough - but I lack the programming chops to do this.

    and finally

    3-some way to identify the problem product if this does happen - feature, separate module -whatever.


    Is Power Search the only or official search for Miva by the way? I added it on but it seems odd that Miva wouldn't have a native search. It's worked fine but I think this is the second time this happened. The first time there was only two dozen products with no custom fields - now there is a heck of a lot more to sort through.
    Last edited by habreu; 03-02-15, 07:57 AM.

    #2
    Re: Suggested feature> reserved word check

    Originally posted by habreu View Post
    Well my Power Search is broken and it seems that some code or perhaps a custom field (?) may be using a reserved word. I have no idea how to identify this short of checking each product and manually comparing the list of words which is really no small task.

    I'd like to suggest a few possible feature/solutions

    1-a module or feature that checked the 'reserved words list' at the time you create the code (or any other field that this is an issue.

    or

    2-a simple popup window you could paste your code or text into (again, not sure what fields this is an issue on) and click submit to run a test. This wouldn't even have to be in the admin I guess as an unofficial community tool that you could bookmark would be enough - but I lack the programming chops to do this.

    and finally

    3-some way to identify the problem product if this does happen - feature, separate module -whatever.


    Is Power Search the only or official search for Miva by the way? I added it on but it seems odd that Miva wouldn't have a native search. It's worked fine but I think this is the second time this happened. The first time there was only two dozen products with no custom fields - now there is a heck of a lot more to sort through.
    The problem with custom fields in power search is the custom field code itself (Not the value entered per product)

    How is it broken? did you get any error messages?
    Last edited by Mark Hood; 03-02-15, 08:03 AM.
    Mark Hood
    Vermont Gear

    Comment


      #3
      Re: Suggested feature> reserved word check

      Originally posted by Mark Hood View Post
      The problem with custom fields in power search is the custom field code itself (Not the value entered per product)

      How is it broken? did you get any error messages?
      Yes. I did contact support and they told me it was a Reserve Word in one or more of your custom product fields and to refer to the PowerSearch documentation about Reserve Words. So if what you are saying is that it is the custom field code name that is a problem then that is a more manegable list. Will look at that now as we did add some codes last week.



      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 MySQL server version
      Other Information:

      Comment


        #4
        Re: Suggested feature> reserved word check

        http://extranet.miva.com/forums/show...-UTL-POW-00007
        Mark Hood
        Vermont Gear

        Comment


          #5
          Re: Suggested feature> reserved word check

          feel free to list your custom product field codes
          Mark Hood
          Vermont Gear

          Comment


            #6
            Re: Suggested feature> reserved word check

            It says CODE in the documentation that support pointed to but somehow I read and missed that - sheesh.

            Thanks for the offer on the codes but I'll sort through them I probably only added a dozen or so since the last build so should be able to sort them out.

            I guess I'll just make a note to check the list if we make any more. Thanks again.

            Comment


              #7
              Re: Suggested feature> reserved word check

              Well, maybe I will accept the help after all. I went through and checked each.
              alsobought
              brand
              cathaschild
              cat_summary
              cat_vndr_lnk_0_title
              cat_vndr_lnk_1_alt
              cat_vndr_lnk_1_img
              cat_vndr_lnk_1_url
              cat_vndr_lnk_2_alt
              cat_vndr_lnk_2_img
              cat_vndr_lnk_2_url
              cat_vndr_lnk_3_alt
              cat_vndr_lnk_3_img
              cat_vndr_lnk_3_url
              cat_vndr_lnk_4_alt
              cat_vndr_lnk_4_img
              cat_vndr_lnk_4_url
              cat_vndr_lnk_5_alt
              cat_vndr_lnk_5_img
              cat_vndr_lnk_5_url
              cat_vndr_lnk_99_enable
              CollapsibleFooter
              CollapsibleFooter
              ctkey
              cust_property_id
              Document1Title
              Document1Title
              Document1URL
              Document1URL
              Document2Title
              Document2Title
              Document2URL
              Document2URL
              Document3Title
              Document3Title
              Document3URL
              Document3URL
              Document4Title
              Document4Title
              Document4URL
              Document4URL
              Document5Title
              Document5Title
              Document5URL
              Document5URL
              Document6Title
              Document6Title
              Document6URL
              Document6URL
              Document7Title
              Document7Title
              Document7URL
              Document7URL
              Document8Title
              Document8Title
              Document8URL
              Document8URL
              gd_pdesc
              gd_pimage
              gtin
              hdrg1
              hdrg1cap
              hdrg2
              hdrg2cap
              InfoSoldBy
              InfoUnitMeasure
              md_y
              mpn
              productcount
              ptkey
              QB-CUST-ID
              qb-itemnumber
              qb-vendor
              shortdesc
              shortprodinfo
              ShowDocumentBlock
              ShowDocumentBlock
              spcl_ADA
              spcl_BRAND
              spcl_LEED
              StaticSqFt
              SurveyID
              Tagline1
              Tagline2
              TilePerCase
              TileShowCalc
              TileSqFtCase
              useinfeed
              vendorsku
              xg1cap
              xg1URL
              xg2cap
              xg2URL
              xgshow
              xgtitle

              Comment


                #8
                Re: Suggested feature> reserved word check

                Originally posted by habreu View Post
                Well, maybe I will accept the help after all. I went through and checked each.
                alsobought
                brand
                cathaschild
                cat_summary
                cat_vndr_lnk_0_title
                cat_vndr_lnk_1_alt
                cat_vndr_lnk_1_img
                cat_vndr_lnk_1_url
                cat_vndr_lnk_2_alt
                cat_vndr_lnk_2_img
                cat_vndr_lnk_2_url
                cat_vndr_lnk_3_alt
                cat_vndr_lnk_3_img
                cat_vndr_lnk_3_url
                cat_vndr_lnk_4_alt
                cat_vndr_lnk_4_img
                cat_vndr_lnk_4_url
                cat_vndr_lnk_5_alt
                cat_vndr_lnk_5_img
                cat_vndr_lnk_5_url
                cat_vndr_lnk_99_enable
                CollapsibleFooter
                CollapsibleFooter
                ctkey
                cust_property_id
                Document1Title
                Document1Title
                Document1URL
                Document1URL
                Document2Title
                Document2Title
                Document2URL
                Document2URL
                Document3Title
                Document3Title
                Document3URL
                Document3URL
                Document4Title
                Document4Title
                Document4URL
                Document4URL
                Document5Title
                Document5Title
                Document5URL
                Document5URL
                Document6Title
                Document6Title
                Document6URL
                Document6URL
                Document7Title
                Document7Title
                Document7URL
                Document7URL
                Document8Title
                Document8Title
                Document8URL
                Document8URL
                gd_pdesc
                gd_pimage
                gtin
                hdrg1
                hdrg1cap
                hdrg2
                hdrg2cap
                InfoSoldBy
                InfoUnitMeasure
                md_y
                mpn
                productcount
                ptkey
                QB-CUST-ID
                qb-itemnumber
                qb-vendor
                shortdesc
                shortprodinfo
                ShowDocumentBlock
                ShowDocumentBlock
                spcl_ADA
                spcl_BRAND
                spcl_LEED
                StaticSqFt
                SurveyID
                Tagline1
                Tagline2
                TilePerCase
                TileShowCalc
                TileSqFtCase
                useinfeed
                vendorsku
                xg1cap
                xg1URL
                xg2cap
                xg2URL
                xgshow
                xgtitle
                I would question if the long ones that have the same first 10 characters could cause a problem because power search thinks they are the same. What were the new ones that were added?
                Last edited by Mark Hood; 03-02-15, 11:21 AM.
                Mark Hood
                Vermont Gear

                Comment


                  #9
                  Re: Suggested feature> reserved word check

                  The new ones are the 3 that start with QB-

                  The search was sucessful updated last on 1-15-2015 and all those longer ones have been working for the past year or two.

                  Comment


                    #10
                    Re: Suggested feature> reserved word check

                    sorry didnt see that from the power search docs

                    custom fields codes can only be 10 characters long (no spaces or hyphens; only letters, numbers, or underline characters allowed).

                    QB-CUST-ID must be QB_CUST_ID
                    Last edited by Mark Hood; 03-02-15, 11:32 AM.
                    Mark Hood
                    Vermont Gear

                    Comment


                      #11
                      Re: Suggested feature> reserved word check

                      Oops. Well I just deleted the three QB- fields and it worked. Wish I had waited a second to see your response. I'll recreate without the hyphens. Thanks for taking the time.

                      Comment

                      Working...
                      X