[ckan-dev] Delete draft package :(still no solution)

Mon Jan 9 16:20:41 UTC 2017

 Dear all

Does any of you know where the draft datasets are stored in the DB?
I am trying since moths to get rid of some test ones that cannot be deleted by usual means (UI).

Any hint will be appreciated.

Best,
Lucia

_________________________________________________________
Dr. Lucia Espona Pernas

Swiss Federal Institute for Forest, Snow and Landscape Research WSL
Hauptgebäaude Labortrakt (HL C21)
Zürcherstrasse 111
8903 Birmensdorf
Switzerland

+41 44 739 28 71 phone direct
+41 44 739 21 11 reception

www.wsl.ch

-----"ckan-dev" <ckan-dev-bounces at lists.okfn.org> wrote: -----
To: CKAN Development Discussions <ckan-dev at lists.okfn.org>
From: lucia.espona at wsl.ch
Sent by: "ckan-dev" 
Date: 05.12.2016 16:19
Subject: Re: [ckan-dev] Delete draft package

Thanks Tim

Everything else works fine, I rebuilded the indexes with no sucess already as I said in my first mail. 
I think I did a real mess creating datasets with the same name, deleting the finished and leaving the drafts somehow.
It is not an usual case, therefore I am happy with any hack-type solution to get them removed just once, I cannot even find them in the database.

Best,
Lucia

_________________________________________________________
Dr. Lucia Espona Pernas

Swiss Federal Institute for Forest, Snow and Landscape Research WSL
Hauptgebäaude Labortrakt (HL C21)
Zürcherstrasse 111
8903 Birmensdorf
Switzerland

+41 44 739 28 71 phone direct
+41 44 739 21 11 reception

www.wsl.ch

-----"ckan-dev" <ckan-dev-bounces at lists.okfn.org> wrote: -----
To: CKAN Development Discussions <ckan-dev at lists.okfn.org>
From: Timothy Giles 
Sent by: "ckan-dev" 
Date: 05.12.2016 15:41
Subject: Re: [ckan-dev] Delete draft package

 Hi Lucia,

 If you delete and purge an active package does it disappear?

 I have had issues with SOLR not refreshing the index and needed to get it to reindex in the past. There is a paster command you can  run, don’t have it to hand but it is documented in the Documentation paster scripts page.

 Regards Tim

 From: ckan-dev [mailto:ckan-dev-bounces at lists.okfn.org] On Behalf Of lucia.espona at wsl.ch
 Sent: den 5 december 2016 14:00
 To: CKAN Development Discussions <ckan-dev at lists.okfn.org>
 Subject: Re: [ckan-dev] Delete draft package

 Dear Matthew

 Yes, I did purge everything but still they keep appearing...
 I attached a screenshot.

 Thanks anyway,
 Lucia

 _________________________________________________________
 Dr. Lucia Espona Pernas

 Swiss Federal Institute for Forest, Snow and Landscape Research WSL
 Hauptgebäaude Labortrakt (HL C21)
 Zürcherstrasse 111
 8903 Birmensdorf
 Switzerland

 +41 44 739 28 71 phone direct
 +41 44 739 21 11 reception

 www.wsl.ch

 -----"ckan-dev" <ckan-dev-bounces at lists.okfn.org>  wrote: -----

 To: CKAN Development Discussions <ckan-dev at lists.okfn.org>
 From: Matthew Fullerton 
 Sent by: "ckan-dev" 
 Date: 05.12.2016 11:34
 Subject: Re: [ckan-dev] Delete draft package

 Just checking, but have you done the "purge datasets" step in the admin area to permanently remove deleted datasets?

 On 28 November 2016 at 12:05, <lucia.espona at wsl.ch> wrote:
  Dear all

 I got no answer so far for my mail below :(
 ... does anyone know where the draft datasets are stored? in the database?

 Any help is appreciated.

 Best,
 Lucia

 Dear all

 On my list of datasets in the dashboard two datasets appear that are drafts. I cannot access them (I get 404 Not Found) in order to delete them.
 I think there was some mess because I created many drafts and one finalized dataset with same package name while testing, then I deleted the finalized package.

 This two draf datasets do not appear in the package table in the database.
 I rebuild the indexes in case that may help but no success.

 Any idea how can I delete them?

 Thanks,
 Lucia
 _________________________________________________________
 Dr. Lucia Espona Pernas

 Swiss Federal Institute for Forest, Snow and Landscape Research WSL
 Hauptgebäaude Labortrakt (HL C21)
 Zürcherstrasse 111
 8903 Birmensdorf
 Switzerland

 +41 44 739 28 71 phone direct
 +41 44 739 21 11 reception

 www.wsl.ch 

 _______________________________________________
 ckan-dev mailing list
 ckan-dev at lists.okfn.org
 https://lists.okfn.org/mailman/listinfo/ckan-dev
 Unsubscribe:  https://lists.okfn.org/mailman/options/ckan-dev

 _______________________________________________
 ckan-dev mailing list
 ckan-dev at lists.okfn.org
 https://lists.okfn.org/mailman/listinfo/ckan-dev
 Unsubscribe:  https://lists.okfn.org/mailman/options/ckan-dev

 _______________________________________________
 ckan-dev mailing list
 ckan-dev at lists.okfn.org
 https://lists.okfn.org/mailman/listinfo/ckan-dev
 Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev

_______________________________________________
ckan-dev mailing list
ckan-dev at lists.okfn.org
https://lists.okfn.org/mailman/listinfo/ckan-dev
Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev

_______________________________________________
ckan-dev mailing list
ckan-dev at lists.okfn.org
https://lists.okfn.org/mailman/listinfo/ckan-dev
Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20170109/8d63dc5f/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Image.image001.png at 01D24F0E.00EBDE40.png
Type: image/png
Size: 140673 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20170109/8d63dc5f/attachment-0002.png>