adding selectvendor=1 to the mix fixed the issue.

Charley

Charley Tiggs wrote:
> Okay, I got obsessive about this (plus I'm sick and don't really want to 
> work on the pieces I should be working on :)).
> 
> Using the trick Chris mentioned and $form->error(), I tracked down the 
> problem...
> 
> Line 87 of branches/1.2/bin/arap.pl
> 
> I'm passing in the form params:
> 
> vendor=K-L MANUFACTURING--10349&
> oldvendor=K-L MANUFACTURING--10349&
> 
> But on the above mentioned lines, '--$form->{"${name}_id"}' is added on 
> during the comparison of oldvendor and vendor.  Was that intentional? 
> If it was, then the following is out of whack as well.  At line 97, you 
> get the name.  You pass in the value of $name which goes to the following:
> 
> Line 1698 of branches/1.2/LedgerSMB/Form.pm
> 
> Here, the query attempts to do compare "lower(name)" from db against 
> essentially $self->{$table}, which has a value of "k-l 
> manufacturing--10349", which will fail every time, unless I change the 
> value of vendor to include just the name.  In which case, I get a 
> different error.  Including the very large selectvendor form param also 
> solves the problem because it causes the first conditional within sub 
> check_name of arap.pl to execute.  Since the two values are the same, 
> the conditional fails.
> 
> I'm sure this is pretty incoherent but I'm proud of myself for tracking 
> this one down.  So, what's the fix?  :)
> 
> Charley
> 
> Chris Travers wrote:
>> On 1/2/07, Charley Tiggs <[EMAIL PROTECTED]> wrote:
>>> I did before and just tried it again.  Here's the result:
>>>
>>> Error: menu.pl:108: Error: menu.pl:108: Error: Vendor not on file!
>>>
>>> Compilation failed in require at ./oe.pl line 2.
>> One neat trick is to add something to the menu.pl after the form is
>> instantiated (i.e. after $form = new Form) that says:
>>
>> $form->debug();
>>
>> This will let you see what the form is grabbing from your input.  It
>> might be helpful.
>>
>> Best Wishes,
>> Chris
>>
>>> Charley
>>>
>>> Chris Travers wrote:
>>>> Try changing the space to %20.
>>>>
>>>> On 1/2/07, Charley Tiggs <[EMAIL PROTECTED]> wrote:
>>>>> I'm trying to create a PO in the cli and am getting hung up.  Here's the
>>>>> script:
>>>>>
>>>>> ./oe.pl "path=bin/mozilla&
>>>>> login=me&
>>>>> password=geekygeek&
>>>>> action=save&
>>>>> type=purchase_order&
>>>>> vc=vendor&
>>>>> vendor=K-L MANUFACTURING--10349&
>>>>> oldvendor=K-L MANUFACTURING--10349&
>>>>> vendor_id=10349&
>>>>> currency=USD&
>>>>> defaultcurrency=USD&
>>>>> employee=me--10157&
>>>>> ordnumber=88123&
>>>>> transdate=2007-01-02&
>>>>> reqdate=2007-02-02&
>>>>> partnumber_1=1823100&
>>>>> description_1=Black X-Small Pro Racer Skort&
>>>>> qty_1=10&
>>>>> sellprice_1=24.58&
>>>>> id_1=397139&
>>>>> taxaccounts_1=&
>>>>> notes=order saved from the command line&
>>>>> rowcount=2"
>>>>>
>>>>> Every time I run the above, I get the following error:
>>>>>
>>>>> Error: menu.pl:108: Error: menu.pl:108: Error: Vendor not on file!
>>>>>
>>>>> I know the vendor exists because I went into the db to pull it up.  So
>>>>> far as I can see, everything that's needed is there.  On the offchance
>>>>> that I was missing something, I went into the GUI and viewed the source
>>>>> code, copied out all of the variables there and tried each one,
>>>>> eliminating the ones that clearly weren't needed.  And I still got the
>>>>> above error.  What am I missing?
>>>>>
>>>>> Charley


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Reply via email to