On Friday 15 July 2011 02:55:55 Mr. Puneet Kishor wrote:
Here is the interesting thing -- if I add the -D switch to the second app as well, it fails to return the polys and the points. It fails with the error
{"error":"Warning caught during route execution: DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at <path/to>/macrostrat.pm line 79.\n"}
The offending lines are
71> my $sql = qq{ 72> .. 73> 74> 75> }; 76> 77> my $sth = $dbh->prepare($sql); 78> $sth->execute(); 79> my $res = $sth->fetchall_arrayref({});
The above could be just correlation rather than causal, but it definitely seems to be a pattern. First, this is bizarre, and why so? And, two... this is totally bogus... how can execute() not take place above? Perl doesn't have a habit of jumping over lines, does it?
You haven't actually performed any error checking; either make sure RaiseError is enabled on your database handle, or check for errors, e.g.: $sth->execute() or die "Failed to execute query - " . $dbh->errstr; As for why the behaviour changed when you selected the production environment, perhaps it's down to differing settings in enviroments/development.yml and environments/production.yml ? -- David Precious ("bigpresh") http://www.preshweb.co.uk/ "Programming is like sex. One mistake and you have to support it for the rest of your life". (Michael Sinz)