search

solgenomics / sgn

The code behind the Sol Genomics Network, Cassavabase and other Breedbase websites
https://solgenomics.net
MIT License
66 stars 35 forks source link

delete_stocks.pl deletes plants but ids still in trial view #5030

Open ch728 opened 1 month ago

ch728 commented 1 month ago

I used delete_stocks.pl to delete the plants associated with a trial and yet the plants remain in the trial view. I updated the wizard to refresh mat view, but still the plant ids are there.

image

ch728 commented 1 month ago

to be more clear the script did delete the plants but the plants are still in the trial view.

lukasmueller commented 1 month ago

You need to click on the Trial Status section on the trial detail page, and open the Field Design section. That will regenerate a trial page cache.

cheers Lukas

From: Chris Hernandez @.> Sent: Monday, July 22, 2024 10:06 AM To: solgenomics/sgn @.> Cc: Subscribed @.***> Subject: [solgenomics/sgn] delete_stocks.pl not working for plants (Issue #5030)

I used delete_stocks.pl to delete the plants associated with a trial and yet the plants remain in the trial view. I updated the wizard to refresh mat view, but still the plant ids are there.

image.png (view on web)https://github.com/user-attachments/assets/61ba8c1b-dd62-49c6-a267-ce357bbb1879

— Reply to this email directly, view it on GitHubhttps://github.com/solgenomics/sgn/issues/5030, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AAAV7F32P42HJ5BDZQSVPSDZNUGWJAVCNFSM6AAAAABLIMY5U2VHI2DSMVQWIX3LMV43ASLTON2WKOZSGQZDEOJXGI3DQNQ. You are receiving this because you are subscribed to this thread.Message ID: @.***>

ch728 commented 1 month ago

Thanks Lukas, that worked. However, I was hoping that deleting the plants would make it so I could add new plant ids (messed up the first time I uploaded the plants) by restoring this menu: image

But now I just see this. You can see it still says I have 25 plants per plot rather than 0 now that I deleted them. The plant entry section is blank. image

Yet the Field Design section still says I have plants image

Is there a way I can fix this and reload new plant ids without deleting and reloading the trial?

lukasmueller commented 1 month ago

Ah good point. The script does not seem to remove the project_has_plant_entries flag in the project prop table for that trial.

Get Outlook for iOShttps://aka.ms/o0ukef

From: Chris Hernandez @.> Sent: Monday, July 22, 2024 2:51:21 PM To: solgenomics/sgn @.> Cc: Lukas A. Mueller @.>; Comment @.> Subject: Re: [solgenomics/sgn] delete_stocks.pl deletes plants but ids still in trial view (Issue #5030)

Thanks Lukas, that worked. However, I was hoping that deleting the plants would make it so I could add new plant ids (messed up the first time I uploaded the plants) by restoring this menu: image.png (view on web)https://github.com/user-attachments/assets/4650f095-5400-45a2-9ee1-5f5ff872eb58

But now I just see this. You can see it still says I have 25 plants per plot rather than 0 now that I deleted them. The plant entry section is blank. image.png (view on web)https://github.com/user-attachments/assets/322c3271-eca6-4bc4-9aca-17325b1a71ad

Yet the Field Design section still says I have plants image.png (view on web)https://github.com/user-attachments/assets/a30ba1c2-07ae-4424-9f65-656c500be9bf

Is there a way I can fix this and reload new plant ids without deleting and reloading the trial?

— Reply to this email directly, view it on GitHubhttps://github.com/solgenomics/sgn/issues/5030#issuecomment-2243700079, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AAAV7FZ7JLAJ7K45DGRTVX3ZNVPDTAVCNFSM6AAAAABLIMY5U2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENBTG4YDAMBXHE. You are receiving this because you commented.Message ID: @.***>

lukasmueller commented 1 month ago

It probably shouldn't, as it can remove only specific plants etc, so you may have to manually remove it. Maybe there should be a button "remove plant entries"

Get Outlook for iOShttps://aka.ms/o0ukef

From: Lukas A. Mueller @.> Sent: Tuesday, July 23, 2024 4:48:57 PM To: solgenomics/sgn @.>; solgenomics/sgn @.> Cc: Comment @.> Subject: Re: [solgenomics/sgn] delete_stocks.pl deletes plants but ids still in trial view (Issue #5030)

Ah good point. The script does not seem to remove the project_has_plant_entries flag in the project prop table for that trial.

Get Outlook for iOShttps://aka.ms/o0ukef

From: Chris Hernandez @.> Sent: Monday, July 22, 2024 2:51:21 PM To: solgenomics/sgn @.> Cc: Lukas A. Mueller @.>; Comment @.> Subject: Re: [solgenomics/sgn] delete_stocks.pl deletes plants but ids still in trial view (Issue #5030)

Thanks Lukas, that worked. However, I was hoping that deleting the plants would make it so I could add new plant ids (messed up the first time I uploaded the plants) by restoring this menu: image.png (view on web)https://github.com/user-attachments/assets/4650f095-5400-45a2-9ee1-5f5ff872eb58

But now I just see this. You can see it still says I have 25 plants per plot rather than 0 now that I deleted them. The plant entry section is blank. image.png (view on web)https://github.com/user-attachments/assets/322c3271-eca6-4bc4-9aca-17325b1a71ad

Yet the Field Design section still says I have plants image.png (view on web)https://github.com/user-attachments/assets/a30ba1c2-07ae-4424-9f65-656c500be9bf

Is there a way I can fix this and reload new plant ids without deleting and reloading the trial?

— Reply to this email directly, view it on GitHubhttps://github.com/solgenomics/sgn/issues/5030#issuecomment-2243700079, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AAAV7FZ7JLAJ7K45DGRTVX3ZNVPDTAVCNFSM6AAAAABLIMY5U2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENBTG4YDAMBXHE. You are receiving this because you commented.Message ID: @.***>