#18 Results as table and csv breaks with newer Mysql + PATCH

open
nobody
None
5
2008-05-15
2008-05-15
Peter Russ
No

No output when showing results in table or trying to export to csv due to Mysql GREATEST function always returning NULL when one element is NULL.

To solve this problem replace GREATEST by an IF or use the attched patch for version 1.8.1 (!).

This solution was sponsored by ARJUNA,http://www.arjuna.eu

Discussion

  • unknown_girl
    unknown_girl
    2008-05-20

    Logged In: YES
    user_id=2093310
    Originator: NO

    Hi!

    Can you tell me how do I use the patch??

    Thanks a lot!

     
  • Adil Shahzad
    Adil Shahzad
    2010-05-31

    Hi,
    It's pretty easy to use the patch. Follow these steps to use it
    1) Open results_table.php file
    2) Backup results_table.php file before moving ahead.
    2) Reach to Line#82 or 85 i.e $query = "SELECT GREATEST(rt.qid, .....
    3) Comment out the above $query and copy/paste the first part of the patch.
    4) Repeat step 2 and 3 for the line # 181 or 185.

    Regards,
    Adil