Announcement

Collapse
No announcement yet.

mysql anda miva

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

    mysql anda miva

    I'm getting into (finally) mysql and miva and I'm trying to figure out what the limitations are. For example, I'm trying to use the MATCH word while doing a text search and get

    MvOPENVIEW: Syntax Error: 'MATCH' unexpected.

    Is this because MATCH is not supported or is it because I'm not using it right?

    For example, on stackoverflow I found an example like this:

    SELECT id, description
    FROM table
    WHERE MATCH (description) AGAINST('keyword1 keyword2')

    so I try to emulate it like this (also tried putting g.sterm in the ? spot):

    <MvOPENVIEW NAME = "db"
    VIEW = "results"
    QUERY = "{ '
    SELECT id
    FROM sometable
    WHERE
    MATCH (title) AGAINST(?) '}"
    FIELDS = "g.sterm">



    Thanks in advance for any tips.
    M.A.D.* since 1997

    http://www.scotsscripts.com

    *miva application developers

    #2
    Re: mysql anda miva

    It sounds like you're trying to use MATCH with a MivaSQL database. MivaSQL does not support MySQL's MATCH ... AGAINST syntax or FULLTEXT indexing.

    Comment


      #3
      Re: mysql anda miva

      Yes, that's the situation.

      Can I use mysql in a miva mia environment?

      I've been pulling what's left of my hair out trying to get empressa to run in unbuntu so I can replicate a "real" miva setup, but so far I haven't been able to make that voodoo happen.
      M.A.D.* since 1997

      http://www.scotsscripts.com

      *miva application developers

      Comment


        #4
        Re: mysql anda miva

        As a side note on this thread, is there some kind of obvious fix for this kind of miva empressa error/misconfiguration? The diag5.mvc file is located in what is supposed to be the root script directory. Html files load up from the root script directory fine.

        The requested URL /cgi-bin/mivavm/diag5.mvc was not found on this server.
        M.A.D.* since 1997

        http://www.scotsscripts.com

        *miva application developers

        Comment


          #5
          Re: mysql anda miva

          Originally posted by Scot - ScotsScripts.com View Post
          Yes, that's the situation.

          Can I use mysql in a miva mia environment?

          I've been pulling what's left of my hair out trying to get empressa to run in unbuntu so I can replicate a "real" miva setup, but so far I haven't been able to make that voodoo happen.

          Yes, you can use a store with MySQL in Mia. You just have to have MySQL installed on the local machine. What error are you running into with Ubuntu? I've had it running on my Ubuntu machine for years.
          Jim McCormick
          Miva Merchant Support
          866-284-9812

          https://www.miva.com

          Comment


            #6
            Re: mysql anda miva

            Originally posted by Scot - ScotsScripts.com View Post
            As a side note on this thread, is there some kind of obvious fix for this kind of miva empressa error/misconfiguration? The diag5.mvc file is located in what is supposed to be the root script directory. Html files load up from the root script directory fine.

            The requested URL /cgi-bin/mivavm/diag5.mvc was not found on this server.
            You should be using diagtool.mvc that comes with Empresa in mivavm-5.xx/tools. That error is most likely an issue with your Empresa installation. What do you get if you use domain.com/cgi-bin/mivavm?diagtool.mvc?
            Jim McCormick
            Miva Merchant Support
            866-284-9812

            https://www.miva.com

            Comment


              #7
              Re: mysql anda miva

              Thanks for taking an interest in this. I brought up my unbuntu box and have evidently already forgotten everything- can't figure out how to get the local network running - so when I have some of the basics re-figured out I will put that file in the spot you mentioned and see what comes up.
              M.A.D.* since 1997

              http://www.scotsscripts.com

              *miva application developers

              Comment


                #8
                Re: mysql anda miva

                Ok, I was able to get back to being able to load the html file. I can't put the mivascript file into cgi-bin/mivavm because there is a mivavm file in that directory.

                I set this all up following Claudio's instructions ( http://mivascript.org/install_miva_e...on_ubuntu.html ) because it was all I could find that walked me through it step by step. If there is a better and/or more simple method I'll follow those instructions instead. I'd just like to get this working so I can test various mysql and .htaccess stuff without breaking anyone's site in the process.
                M.A.D.* since 1997

                http://www.scotsscripts.com

                *miva application developers

                Comment

                Working...
                X