Hello Group, We have an application that is running on IIS 6.0 with Perl (v5.6.1) as front end and SQL 2000 as back end. DB is located in another server.
Now we are migrating this application to a new server (to improve performance etc). In new server, customer wants to use latest verstions of softwares. So they had opted for IIS 7.0, Perl (v5.12.3). Now we are facing wierd issues: Most of the pages were working fine, but in one of the page we were getting the error message stating: "Can't call method "prepare" on an undefined value at lib/Session.pm line 519 during global destruction" This is happening in one of the DESTROY method while we are trying capture some user data in to DB. After so much of searching in web, somewhere I read that using tied() will solve the issue. We have tried the same and the error was gone. However, now in few screens, data is not being updated in DB. But when I remove tied(), everything else work fine apart from above mentioned undefined value error. Our DBI and DBD versions in old server are 1.48 and 1.06 where in new server it is 1.616 and 1.24 respectively. I tried all possible ways to my knowledge but in vain. Could anybody please throw some light on this issue. Any help on this would be very grateful. Thanks, Vinay On Tue, Apr 5, 2011 at 9:16 PM, Bob McGowan <bob_mcgo...@symantec.com>wrote: > Vinay, you need to be sending these questions to the dbi user list, not > just to me. > > Based on the version number you supplied for the DBD you're using and > that it does not match the value I mentioned suggests that you are not > using Oracle. Also, you didn't mention if it was the most recent DBD > version or whether it was built against the current DB or the old one. > > My suggestion was a long shot, based solely on some similarities with > errors I had seen. > > You need to mention what database you're using, the version, and if you > can, a short code example illustrating the problem. > > And send it to the list, there's a much better chance of getting helpful > advice when many people can see the question. > > Thank you, > > Bob > > On 04/05/2011 06:03 AM, vinay parakoti wrote: > > Hi Bob, > > > > I am dead again. tied has solved the issue. But in few places of code DB > > insert/update statements are not working properly. But if I remove tied > > they work fine but I get the undefined value issue. > > > > Could you please suggest on this. Thanks in advance. > > > > Thanks, > > Vinay > > > > On Wed, Mar 30, 2011 at 1:35 PM, vinay parakoti <vinayja...@gmail.com > > <mailto:vinayja...@gmail.com>> wrote: > > > > Hi Bob, > > > > Thanks a lot for the reply. > > > > DBD version that we are using is 1.65 > > > > I have tried command tied in my destroy function which had solved > > the issue. > > > > Hope this is a correct fix for it. > > > > Please let me know otherwise. > > Cheers, > > Vinay > > On Mon, Mar 28, 2011 at 11:05 PM, Bob McGowan > > <bob_mcgo...@symantec.com <mailto:bob_mcgo...@symantec.com>> wrote: > > > > On 03/28/2011 04:37 AM, vinay parakoti wrote: > > > Hi Tim, > > > > > > > <<--deleted intro--> > > > > > It works fine in older version, but it throws below error in > > new server: > > > > > > "Can't call method "prepare" on an undefined value at > > lib/Session.pm line > > > 519 during global destruction" > > > > > > I tried to create a DB connection instead of using existing > > one, but didn't > > > help. > > > > > > I am completely clueless on how it is working in old server > > but not in new > > > one. > > > > > > Any help on this would be highly appreaciated and I would be > > very grateful. > > > > > > PS: DBI version in old server is 1.48 where in new server it > > is 1.616 > > > > > > Cheers, > > > Vinay > > > > > > > I've had/seen similar issues, they are all related to the DBD > > version, > > not the DBI. > > > > I'm using the Oracle database and it looks like DBD::Oracle 1.27 > has > > fixed most, if not all, of these issues, for Oracle. > > > > I would suggest you get the latest DBD for your database. > > > > -- > > Bob McGowan > > > > > > > > -- > Bob McGowan > Principal Software Engineer, SES Software Engineering > Shared Engineering Services > Symantec Corporation >
