Results as table and csv breaks with newer Mysql + PATCH

Brought to you by: jholmes763

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

Status: open

Owner: nobody

Labels: None

Priority: 5

Updated: 2008-05-15

Created: 2008-05-15

Creator: Peter Russ

Private: 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

Peter Russ - 2008-05-15

special_results.class.patch

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

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!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

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

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.