On March 26, 2019 we launched new MODX Forums. Please join us at the new MODX Community Forums.
Subscribe: RSS
  • Ok, I've found the problem. laugh

    The SQL query in question had a ; at the end it - I removed it and everything was fine. All other queries don't have ; in the end, so there was only a problem with this specific one.

    Maybe you can remove this in the next release?


    file: manager/processors/cache_sync.class.processor.php

    141 WHERE plugs.disabled=0
    142 ORDER BY sysevt.name;
    143 ";

    CHANGE TO

    141 WHERE plugs.disabled=0
    142 ORDER BY sysevt.name
    143 ";
    • same thing again, the error throws up the first time in the installer and then when working on the site...

      Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /<path>/manager/processors/cache_sync.class.processor.php on line 146

      However I tried it also on a different system with Apach2, MySQL 4.1 and PHP5 and everything works like a charm, so my guess this error must be related to the specific system configuration (Apache 1.3.27, MySQL 3.23.58 and PHP 4.3.3).

      When I manually execute the SQL statement which causes the error in phpmyadmin I'll don't get a warning but everything's executed proberly (0 rows returned)!?

      I have the same problems on my server
      started a treat did not saw this before sorry
      but is there already a solution?

      using php 4.3.2
        follow me on twitter: @dimmy01
      • but is there already a solution?
        see above
        edit manager/processors/cache_sync.class.processor.php and remove the ; in line 142

        dimmy, what php & mysql versions do you use?
        • Ok, I've found the problem. laugh

          The SQL query in question had a ; at the end it - I removed it and everything was fine. All other queries don't have ; in the end, so there was only a problem with this specific one.

          Maybe you can remove this in the next release?


          Many thanks reportra. Good catch smiley

          It will be added to the next release

          Keep up the good work.

          PS. What version MySQL are you using btw?

          Best regards,
            xWisdom
            www.xwisdomhtml.com
            The fear of the Lord is the beginning of wisdom:
            MODx Co-Founder - Create and do more with less.
          • using php 4.3.2

            mysql 3.23.58

            Apache 2.0.46 (Red Hat)
              follow me on twitter: @dimmy01

            This discussion is closed to further replies. Keep calm and carry on.