Announcement

Collapse
No announcement yet.

Power Search error

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

    Power Search error

    Hi,

    I am currently getting this error message on my site from Power Search. Anyone know what this means?

    Runtime error in mm5/5.00/modules/util/powrsrch.mvc @ [00000015:000048da]: powrsrch.mv: Line 2496: MvOPENVIEW: mysql_execute: Error writing file '/tmp/MYALGqwY' (Errcode: 28)

    Thanks

    #2
    Re: Power Search error

    Unless there is a storage space issue, typically that error means the query you are running generated such a huge temporary table that the file necessary to run it was larger than the server's /tmp directory.
    David Hubbard
    CIO
    Miva
    [email protected]
    http://www.miva.com

    Comment


      #3
      Re: Power Search error

      David,

      Thanks for the response but how do I go about fixing this? Would clearing the log in Power Search admin do the job?
      Last edited by kitdang; 10-13-14, 06:47 PM.

      Comment


        #4
        Re: Power Search error

        Try emptying the s01_PowerSearchSearched database table; that's typically the issue with that mod, that table just grows indefinitely and slows the store down, sometimes considerably. Might consider purging Pulse data too from your Viking mod; it's massive.
        David Hubbard
        CIO
        Miva
        [email protected]
        http://www.miva.com

        Comment


          #5
          Re: Power Search error

          Per the docs you need to cleanup the search log periodically. Certainly once a month as a minimum. Don't forget to also pack the datafiles.
          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

          Working...
          X