FW: Re: 100 levels deep in subroutine calls!

2001-06-15 Thread Scott T. Hildreth

 

It is updating data, the duplicates come from running again.
Will get so far then it dies.  When I took out the eval from
the one function, it stopped dieing there.  He has numerous code
changes/fixes to make.  He was reusing a global $sth for every 
handle, preparing everytime in a loop...etc.  I have him changing
all the code.  I just wanted know where or why the recursive call
was comming from, he is not making recursive calls, I checked that
right away.  Anyway, my quess is when he is done cleaning up the
code the errors will disappearI hope :)

  Thanks,

 STH

On 15-Jun-01 MikeBlezien wrote:
> On Fri, 15 Jun 2001 14:20:28 -0500 (CDT), "Scott T. Hildreth"
> <[EMAIL PROTECTED]>   wrote:
> 
> It appears that you are attempting to enter data to a column that has
> possible
> reached it's max size. What type of column type is the duplicate entry
> referring
> too??
> 
>>>Sorry I should have mentioned that I did Trace it,
>>>
>>>I traced one of the Statement Handles as well as the
>>>Db Handle, it shows the Duplicate Error being returned
>>>but nothing else, 
>>>
>>>   ERROR EVENT 5 'Duplicate entry '2067258104' for key 1' on
>>>DBI::st=HASH(0x14037fa50)
>>>Duplicate entry '2067258104' for key 1 error 5 recorded: Duplicate entry
>>>'2067258104' for key 1
>>><- dbd_st_execute -2 rows
>>>!! ERROR: 5 'Duplicate entry '2067258104' for key 1'
>>><- execute= undef at qwl_newcust.pl line 374.
>>>-> DESTROY for DBD::mysql::st (DBI::st=HASH(0x14037fa50)~INNER)
>>><- DESTROY= undef during global destruction.
>>>
>>>..the dups are there, that is why we catch with a eval.  
>>>
>>>The $dbh trace shows the same thing, 
> 
> Mike(mickalo)Blezien
> 
> Thunder Rain Internet Publishing
> Providing Internet Solutions that work!
> http://www.thunder-rain.com
> Tel: 1(225) 686-2002
> =
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 

--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 15-Jun-01
Time: 14:42:22
--

--End of forwarded message-

--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 15-Jun-01
Time: 14:53:14
--



Re: FW: Re: 100 levels deep in subroutine calls!

2001-06-18 Thread Ronald J Kimball

On Fri, Jun 15, 2001 at 02:56:49PM -0500, Scott T. Hildreth wrote:
>  
> I just wanted know where or why the recursive call was comming from, he
> is not making recursive calls, I checked that right away.  Anyway, my
> quess is when he is done cleaning up the code the errors will
> disappearI hope :)

After he gets the "100 levels deep in subroutine calls" in the Perl
debugger, he should use the T command to view the call stack.


Ronald