[01:38] Tiki|bot Recent Bug:  - http://dev.tiki.org/item6566-Semantic-Alias-creating-dead
[01:38] Tiki|bot Recent Bug:  - http://dev.tiki.org/item6567-Incorrect-permission-check-to-delete-freetags-from-objects
[01:38] Tiki|bot Recent Bug:  - http://dev.tiki.org/item6568-tiki-tracker_view_history-php-throwing-SQL
[10:50]  redflo joined #tikiwiki
[12:07]  zlinux joined #tikiwiki
[12:33]  juststrollingin joined #tikiwiki
[13:18]  chibaguy joined #tikiwiki
[14:09]  fabricius joined #tikiwiki
[15:51]  bm joined #tikiwiki
[15:55] Guest27865 Hi all, I hope this is the right place to ask for support. We are running an instance of TikiWiki 17.1 and now tried to put some of our wiki pages into a structure. We played around a bit and somehow it happened that we now have a "zombie" structure in our TikiWiki. The structure has an ID, but no name. It does not appear in the list of structures, however, some pages are obviously part of this structure.
[15:56] Guest27865 As the structure does not appear in the list of structures we cannot delete it. The pages belonging to that zombie structure are blocked for putting them in other structures.
[15:56] Guest27865 Is there any option to get rid of such a zombie structure, probably by directly editing the database?
[15:57] Guest27865 Or does any workaround exist? Deactivating and afterwards activating the structure feature again does not help, the structure is still there...
[16:59]  zlinux joined #tikiwiki
[17:20] RadoS Guest52984, try giving it a name in the database.
[17:20] RadoS Maybe it re-appears in tiki-gui.
[17:21] RadoS Hmm... isn't the "structure name" the page name of the root-page?
[17:29] Guest52984 Well, the structure page has a page_ref_id. I can enter that page address directly in the browser, .../tikiwiki/tiki-edit_structure.php?page_ref_id=29, but I get an error on that page: invalid structure_id or page_ref_id.
[17:30] Guest52984 Doing that for a valid structure opens the page for editing the structure.
[17:31]  fabricius joined #tikiwiki
[17:31] Guest52984 Hi RadoS, sorry I overlooked your remark concerning giving the structure a name.
[17:31] Guest52984 Can you tell me what exactly needs to be edited for that?
[17:32] Guest52984 We already had a look at the database, but did not really get an idea where to change the name.
[17:59] RadoS Just to exclude side effects, have you cleared all caches?
[18:03] Guest52984 At least we used the function "Clear all caches" in the Administration menu. If this clears all caches, then yes.
[18:05] RadoS Usually a page with the same name as the structure exists as "root" if you use "make structure" of that page. Have you done so? Does that page still exist?
[18:09] RadoS Maybe you deleted that page? If so, it should be marked deleted but still lingering around in the DB, so you could "undelete" it by changing its flag.
[18:10] Guest52984 I think the page has been deleted.
[18:10] Guest52984 At least in the list of wiki pages there is no page marked "generated from structure" anymore except one for another valid structure.
[18:11] RadoS Check in the DB.
[18:12] RadoS You remember its name?
[18:12] Guest52984 Not exactly.
[18:12] Guest52984 Do you know in which table of the DB we have to look.
[18:12] RadoS You might even scan the logs for such a delete action.
[18:12] RadoS tiki_pages afair.
[18:13] RadoS You can filter all "deleted" ones (if there are only few).
[18:16] Guest52984 Moment... we are looking for that.
[18:18] Guest52984 In the logs there is no delete action, but that's strange, because also other pages were deleted. Maybe delete actions are not visible in the logs by default?
[18:19] * RadoS shrugs.
[18:19] RadoS But, in the list of structures, you not only can edit the structure, you can view its associated page in the menu on the right, tried that?
[18:20] Guest52984 The problem is that in the list of structures the structure does not appear.
[18:20] RadoS ehm, the "filter by deleted" was relating to the DB, not the logs.
[18:21] Guest52984 Yes, my colleague is searching in the DB for that, moment...
[18:21] RadoS But you can use the ID for the view page php script.
[18:22] Guest52984 I get an error saying that the page was not found.
[18:23] RadoS Then ... it might have gotten deleted.
[18:23] Guest52984 So maybe our problem is that the page was accidentally deleted before the structure was removed?
[18:23] RadoS Maybe.
[18:24] * RadoS never tried that.
[18:24] RadoS But if you care to verify, you could try to reproduce in a demo.
[18:25] Guest52984 Can we somehow delete all references to the structure from the DB?
[18:25] RadoS Certainly, I have no clue about DB deep internals.
[18:39] Guest52984 Ok, thanks for the moment.
[18:55]  Telesight joined #tikiwiki
[19:29] Guest52984 For now, as we still have no idea how to "hack" the DB. Since not too much changes were made to the Wiki we will replay a backup of our TikiWiki made before we started with the structures. Anyway, for the future it is still interesting to know if there is any option to remove a structure from the DB by hand.
[19:30] Guest52984 So if someone has an idea it would be interesting to know. Thanks again!
[21:01]  fabricius joined #tikiwiki
[21:51]  jonnyb joined #tikiwiki
[22:59]  fabricius joined #tikiwiki