I've been looking most of the day for a script like the one in Example 1 (converting adjacency list to nested set) to fix a mysql table that I fubared this morning.
Fortunately, I had the foresight to track parent id's as well as record left and right id's thinking I might need to repair a mistake sometime. Unfortunately, I can't get the script in Example 1 to run correctly.
The error I get is:
DBD::mysql::st fetchrow_array failed: fetch() without execute() at ./fixnest line 33.
I have determined error occurs once the script begins to process a leaf node -- one that does not have any children. After that, I confess I am stumped, this being my first exposure to the DBI module.
Has anyone else encountered this problem? If so, is there a workaround to suggest? At the very least, is there a confirmed case of the script above working (perhaps there is a line left out in the published version)?
Thanks in advance for any help -- feel free to write direct to geestarr at the domain geedev dot com. I'll summarize any solutions here.