#22 Treatments are not displayed (or saved).

[Tom]

I created a new ICeE site. With the administrator account I create a new experiment called test.
I add a strain (any strain will reproduce the bug), I add a treatment for the strain (any treatment reproduces this bug). I save the experiment.
The strain is saved, but the treatment is not (or at least not displayed anywhere, including when I add it).

[CIML /CNRS - INSERM]

Dear Tom,
I will have a look at it as soon as my timetable permits, i.e. around
mid-november at the earliest.

Best regards,
Laurent

Le 21/10/2014 18:55, Tom a écrit :

---

[bugs:#22] http://sourceforge.net/p/icee/bugs/22 Treatments are not
displayed (or saved).

Status: open
Group: 2.4
Created: Tue Oct 21, 2014 04:55 PM UTC by Tom
Last Updated: Tue Oct 21, 2014 04:55 PM UTC
Owner: nobody

I created a new ICeE site. With the administrator account I create a
new experiment called test.
I add a strain (any strain will reproduce the bug), I add a treatment
for the strain (any treatment reproduces this bug). I save the experiment.
The strain is saved, but the treatment is not (or at least not
displayed anywhere, including when I add it).

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/icee/bugs/22/
https://sourceforge.net/p/icee/bugs/22

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/
https://sourceforge.net/auth/subscriptions

[Tom]

Dear Laurent,

I've fixed the bug myself. It was caused by line 18/19 in manage_treatment.php:

The empty string inserted as primary key does not reliably convert to int, the empty string should be NULL instead or better yet, the key should be omitted, giving this:

$requete_add_treat = "INSERT INTO treatment (treatment_type_id , conditions_id , expiration , validate)
VALUES ('".$treatment_type."', '".$condition_id."', ADDDATE(SYSDATE(),1), '0')" ;

For more info see here:
http://stackoverflow.com/questions/7492145/php-mysql-insert-new-record-into-table-with-auto-increment-on-primary-key

[CIML /CNRS - INSERM]

Great. I'll update the source tree accordingly in a few days.

Thank you very much for the patch.

Laurent

Le 22/10/2014 15:04, Tom a écrit :

Dear Laurent,

I've fixed the bug myself. It was caused by line 18/19 in
manage_treatment.php:

The empty string inserted as primary key does not reliably convert to
int, the empty string should be NULL instead or better yet, the key
should be omitted, giving this:

$requete_add_treat = "INSERT INTO |treatment| (|treatment_type_id| ,
|conditions_id| , |expiration| , |validate|)
VALUES ('".$treatment_type."', '".$condition_id."',
ADDDATE(SYSDATE(),1), '0')" ;

For more info see here:
http://stackoverflow.com/questions/7492145/php-mysql-insert-new-record-into-table-with-auto-increment-on-primary-key

---

[bugs:#22] http://sourceforge.net/p/icee/bugs/22 Treatments are not
displayed (or saved).

Status: open
Group: 2.10
Created: Tue Oct 21, 2014 04:55 PM UTC by Tom
Last Updated: Tue Oct 21, 2014 08:53 PM UTC
Owner: Laurent Tichit

I created a new ICeE site. With the administrator account I create a
new experiment called test.
I add a strain (any strain will reproduce the bug), I add a treatment
for the strain (any treatment reproduces this bug). I save the experiment.
The strain is saved, but the treatment is not (or at least not
displayed anywhere, including when I add it).

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/icee/bugs/22/
https://sourceforge.net/p/icee/bugs/22

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/
https://sourceforge.net/auth/subscriptions

[CIML /CNRS - INSERM]

Fixed in version 2.10