sgn icon indicating copy to clipboard operation
sgn copied to clipboard

Published 20 hours ago • verified publisher icon solgenomics

Genotyping protocol: delete not working

Open isaak opened this issue 3 years ago • 1 comments

[error] SGN::Controller::AJAX::GenotypingProtocol::genotyping_protocol_delete_GET(): DBI Exception: DBD::Pg::st execute failed: ERROR: permission denied for table genotype [for Statement "DELETE from genotype WHERE genotype_id IN (148887,148888,148889,148890,148891,148892,148893,148894,148895,148896,148897,...

isaak avatar Nov 29 '21 09:11 isaak

Need to give the table the delete permission for web_usr... does this need a dbpatch?

lukasmueller avatar Nov 29 '21 16:11 lukasmueller

Hi Titima, would you like to take a look at this one? It might just be a permission issue, in that case it could be closed as we should just assign correct permissions (it doesn't seem to be wrong in most databases)

lukasmueller avatar Jun 06 '23 12:06 lukasmueller

@lukasmueller I don't think this issue is caused by any bug in the codes. I have been using this deletion function a few times during these past few days. It works fine.

titima15 avatar Jun 06 '23 13:06 titima15

This issue is database specific

titima15 avatar Jul 12 '23 19:07 titima15