Timeline for Re-indexing of site stalled, & running cron won't advance
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 19, 2015 at 22:58 | comment | added | rfay | Thanks so much for this help! For the list of bad comments, SELECT c1.cid FROM comment c1 WHERE c1.uid IN (SELECT DISTINCT c.uid FROM comment c LEFT JOIN users u ON c.uid = u.uid WHERE u.uid IS NULL); then to fix the bad comments take the list you just got back and issue something like this (put your own cids in there): UPDATE comment SET uid=0 WHERE cid in (25, 53, 115); | |
| Feb 2, 2015 at 22:37 | vote | accept | BHammond | ||
| Feb 2, 2015 at 22:36 | history | answered | BHammond | CC BY-SA 3.0 |