Tiki|bot: Recent Bug: - http://dev.tiki.org/item6567-Incorrect-permission-check-to-delete-freetags-from-objects
Recent Bug: - http://dev.tiki.org/item6568-tiki-tracker_view_history-php-throwing-SQL redflo: joined #tikiwiki zlinux: joined #tikiwiki juststrollingin: joined #tikiwiki chibaguy: joined #tikiwiki fabricius: joined #tikiwiki bm: joined #tikiwiki 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.
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.
Is there any option to get rid of such a zombie structure, probably by directly editing the database?
Or does any workaround exist? Deactivating and afterwards activating the structure feature again does not help, the structure is still there... zlinux: joined #tikiwiki RadoS: Guest52984, try giving it a name in the database.
Maybe it re-appears in tiki-gui.
Hmm... isn't the "structure name" the page name of the root-page? 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.
Doing that for a valid structure opens the page for editing the structure. fabricius: joined #tikiwiki Guest52984: Hi RadoS, sorry I overlooked your remark concerning giving the structure a name.
Can you tell me what exactly needs to be edited for that?
We already had a look at the database, but did not really get an idea where to change the name. RadoS: Just to exclude side effects, have you cleared all caches? Guest52984: At least we used the function "Clear all caches" in the Administration menu. If this clears all caches, then yes. 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?
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. Guest52984: I think the page has been deleted.
At least in the list of wiki pages there is no page marked "generated from structure" anymore except one for another valid structure. RadoS: Check in the DB.
You remember its name? Guest52984: Not exactly.
Do you know in which table of the DB we have to look. RadoS: You might even scan the logs for such a delete action.
tiki_pages afair.
You can filter all "deleted" ones (if there are only few). Guest52984: Moment... we are looking for that.
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? -: RadoS shrugs. 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? Guest52984: The problem is that in the list of structures the structure does not appear. RadoS: ehm, the "filter by deleted" was relating to the DB, not the logs. Guest52984: Yes, my colleague is searching in the DB for that, moment... RadoS: But you can use the ID for the view page php script. Guest52984: I get an error saying that the page was not found. RadoS: Then ... it might have gotten deleted. Guest52984: So maybe our problem is that the page was accidentally deleted before the structure was removed? RadoS: Maybe. -: RadoS never tried that. RadoS: But if you care to verify, you could try to reproduce in a demo. Guest52984: Can we somehow delete all references to the structure from the DB? RadoS: Certainly, I have no clue about DB deep internals. Guest52984: Ok, thanks for the moment. Telesight: joined #tikiwiki 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.
So if someone has an idea it would be interesting to know. Thanks again! fabricius: joined #tikiwiki jonnyb: joined #tikiwiki fabricius: joined #tikiwiki