Details
-
Bug
-
Resolution: Fixed
-
Medium
-
3.10.0, 4.0.0beta1
-
None
Description
The new table ezurlalias_ml in 3.10 and 4.0 contains an entry in cleandata.sql which lacks its parent entry.
The cleandata.sql (and share/db_data.dba) file should be fixed by removing all entries in ezurlalias_ml, then re-importing all the old urls and remake the new ones (by using updateniceurls.php).
Steps to reproduce
Insert cleandata.sql in a database and do:
SELECT * FROM ezurlalias_ml WHERE parent = 23;
and then do:
SELECT * FROM ezurlalias_ml WHERE id = 23;
Alternatively run this to find all missing parents:
select a1.*, a2.link from ezurlalias_ml a1 left join ezurlalias_ml a2 on a1.parent=a2.id where a1.parent != 0 having a2.link is null;