Deleting plates

Replies to This Discussion

Permalink Reply by Steven Stones-Havas on August 2, 2012 at 2:27am

Hi Dirk,

That looks like a bug - could you tell me what type of LIMS database you're using (local or remote).  It looks like the LIMS is having trouble deleting traces associated with the sequencing plate you're deleting - the only workaround that I could think of is to individually delete all plates, however if you are using a remote database then I should be able to give you a sql script to run that would fix the error.  For a local database I can make a change in the code.

PS- yes, I believe so.  I am just waiting on fixing one more thing before doing a release - should be happening very soon.

Permalink Reply by Dirk Erpenbeck on August 2, 2012 at 4:58am

Hi Steve,

that would be great! Our LIMS is on a remote MySQL database. Deleting the plates individually does not work either - I get the same error messages. 

Looking very forward to the new release! We have a lot of data piling up.

Best, Dirk

Permalink Reply by Steven Stones-Havas on August 2, 2012 at 6:44am

Thanks, Dirk.  I'll write you the script tomorrow.

Do you have any idea what version of the database script you used to create your remote database, and how many times (if any) it has been upgraded to a newer version?

thanks

Steve

Permalink Reply by Dirk Erpenbeck on August 2, 2012 at 9:30am

Great! We used v. 8 to create the database and recently upgraded to v. 9

I hope that helps,

Thanks a lot,

Dirk