We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

NewsPublisher error with clear cache enabled

    • 18397
    • 3,250 Posts
    MARKSVIRTUALDESK Reply #1, 20 years, 10 months ago
    After you submit the form generated by the snippet with clearcache set to 1, this error message appears:


    « MODx Parse Error »
    MODx encountered the following error while attempting to parse the requested resource:
    « PHP Parse Error »

    PHP error debug
    Error: mysql_num_rows(): supplied argument is not a valid MySQL result resource
    Error type/ Nr.: Warning - 2
    File: /usr/local/psa/home/vhosts/ecrbaseball.com/httpdocs/manager/processors/cache_sync.class.processor.php
    Line: 78
    Line 78 source: $limit_tmp = mysql_num_rows($rs);

    Parser timing
    MySQL: 0.2982 s s (70 Requests)
    PHP: 2.5852 s s
    Total: 2.8834 s s
      • 18397
      • 3,250 Posts
      MARKSVIRTUALDESK Reply #2, 20 years, 10 months ago
      New x9 release with updated snippet
        • 25663 MODX Staff
        • 12,272 Posts
        Ryan Thrash Reply #3, 20 years, 10 months ago
        What’s happenning? I’m kinda confused...
          Ryan Thrash, MODX Co-Founder
          Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
          • 18397
          • 3,250 Posts
          MARKSVIRTUALDESK Reply #4, 20 years, 10 months ago
          After you submit the form generated by the snippet with clearcache set to 1, this error message appears.
            • 18397
            • 3,250 Posts
            MARKSVIRTUALDESK Reply #5, 20 years, 10 months ago
            Raymond?
              • 32963
              • 1,732 Posts
              xwisdom Reply #6, 20 years, 10 months ago
              Hi

              I think there is a problem with the cache_sync file. Try print out the SQL statement at line 76 of the cache_sync file to see if the syntax is ok.

              I’ll have to look at it later.

                xWisdom
                www.xwisdomhtml.com
                The fear of the Lord is the beginning of wisdom:
                MODx Co-Founder - Create and do more with less.
                • 18397
                • 3,250 Posts
                MARKSVIRTUALDESK Reply #7, 20 years, 10 months ago
                Here you go:

                		$sql = "SELECT * FROM $dbase.".$table_prefix."system_settings";


                Attached is the full file.



                Att
                  • 32963
                  • 1,732 Posts
                  xwisdom Reply #8, 20 years, 10 months ago

                  I meant something like:

                  echo $sql;


                  :)
                    xWisdom
                    www.xwisdomhtml.com
                    The fear of the Lord is the beginning of wisdom:
                    MODx Co-Founder - Create and do more with less.
                    • 18397
                    • 3,250 Posts
                    MARKSVIRTUALDESK Reply #9, 20 years, 10 months ago
                    Ok, I’ll try and do that.
                      • 18397
                      • 3,250 Posts
                      MARKSVIRTUALDESK Reply #10, 20 years, 10 months ago 
                      SELECT * FROM `site`.modx_system_settings