Hi,
I have the following situation:
I want to change a description's slug and then it says the slug is already in use.
If I enter the slug in the browser, the page does not exist.
I did some research in the database:
Result:
+---------+-------------------+---------------+------+-------+-----------+-----------+
| SLUG_ID | SLUG | SLUG_OBJECTID | O_ID | IO_ID | IO_IDENTI | IOI_TITLE |
+---------+-------------------+---------------+------+-------+-----------+-----------+
| 3191 | bib-avlp-204-1848 | 3331 | 3331 | NULL | NULL | NULL |
+---------+-------------------+---------------+------+-------+-----------+-----------+
So we have the connections between slug, object, and information_object(_i18n).
My questions are:
- how can it be that there is an object but no corresponding entry in information_object?
- What exactly happens in the background if you delete a description in the GUI - does it delete the entry in the object table and also in the slug table? Because it seems here that an information object was not deleted completely, just from the information_object table.
- in order to cleanup : should I create a query that deletes all entries in the objects table that have
a) a slug in the slug table
b) no corresponding entry in the information_objects table?
Cheers, Roger