ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  Relational Modeling of Biological Data: Trees and Graphs
Subject:   fetch() without execute() error in Example 1
Date:   2003-06-14 16:24:32
From:   gee
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.


1 to 1 of 1
  1. fetch() without execute() error in Example 1
    2003-06-15 11:49:37  anonymous2 [View]

    • fetch() without execute() error in Example 1
      2004-01-11 11:31:44  anonymous2 [View]

      • fetch() without execute() error in Example 1
        2006-02-06 10:55:01  Aaron Mackey | [View]

1 to 1 of 1