[fixed 1.0pre2] A couple things in the tech preview

• • 
  • 29 Posts
  reportra Reply #11, 19 years ago

  Ok, I've found the problem.
  
  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 ";
• • 
  • 2,204 Posts
  Dimmy Reply #12, 19 years ago

  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
• • 
  • 29 Posts
  reportra Reply #13, 19 years ago

  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?
• • 
  • 1,732 Posts
  xwisdom Reply #14, 19 years ago

  Ok, I've found the problem.
  
  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
  
  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.
• • 
  • 2,204 Posts
  Dimmy Reply #15, 19 years ago

  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.