On dim, 2002-05-12 at 12:09, Magnus Manske wrote:
Jimbo: The scipt that rebuilds the links is in the CVS. You probably checked it out already. I think it is called "rebuildLinks.php" or something similar... This will run several minutes! *Maybe* you should take the site offline for that, so the database doesn't get cunfused between user edits and that script.
Note also that it probably will fail, since there seems to be some actual trouble accessing the "unlinked" table in the database, so the script will just be pumping links into a black hole. :(
Unfortunately, I don't know what's really wrong there or how to fix it; the most descriptive error message I've managed to get claims "cannot open file: 'unlinked.MYD'"; Jason says the file does in fact exist, which implies that it is likely corrupted. Error logs on the server may be more helpful in diagnosing the problemo; also try "myisamchk" or other tools for possible recovery.
However, the data in the "linked" and "unlinked" tables can, if need be, be tossed away and regenerated via the script if the tables are recreated successfully. (See the table setup commands in wikipedia.sql.)
-- brion vibber (brion @ pobox.com)