severity 506455 normal thanks On 21 November 2008 at 09:10, Troy Heber wrote: | | Package: beancounter | Version: 0.8.8 | Severity: grave
Not grave -- setup_beancounter is just a helper. Beancounter will still work. That said, the helper should not fail but you also misdiagnosed the problem. | setup_beancounter fails with: | | ERROR: syntax error at or near "," | LINE 1: ..._ratio, avg_volume, active) values('','', '', , , , ,... | | | [EMAIL PROTECTED]:~$ setup_beancounter | Creating beancounter database | ** Running: createdb beancounter | | | Creating beancounter database tables | Verifying database access from Perl | Config file /home/troyhebe/.beancounterrc not found, ignored. | Filling beancounter database tables with DJIA stocks | ** Running: beancounter --dbsystem PostgreSQL --dbname beancounter addindex DJIA AA AXP T BA CAT C KO DIS DD EK XOM GE GM HPQ HD HON INTC IBM IP JNJ MCD MRK MSFT MMM JPM MO PG T UTX WMT | Config file /home/troyhebe/.beancounterrc not found, ignored. | | Filling beancounter (sample) portfolio | ** Running: beancounter --dbsystem PostgreSQL --dbname beancounter addportfolio IBM:50:USD XOM:75:USD C:100:USD GOOG:25:USD | Config file /home/troyhebe/.beancounterrc not found, ignored. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1477. | Use of uninitialized value $txt in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1547. | Use of uninitialized value $txt in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1547. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1478. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1479. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1480. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1481. | Use of uninitialized value $key in concatenation (.) or string at /usr/share/perl5/Finance/BeanCounter.pm line 1482. | Ignoring symbol with unparseable date This means that the symbols didn't come in. Which is odd because the preceding command word. What happens when you run this: [EMAIL PROTECTED]:~$ yahooquote IBM XOM C GOOG IBM INTL BUSINESS MAC 71.13 11/21/2008 NYSE XOM EXXON MOBIL CP 70.24 11/21/2008 NYSE C CITIGROUP INC 3.87 11/21/2008 NYSE GOOG Google Inc. 255.741 11/21/2008 NasdaqNM [EMAIL PROTECTED]:~$ If you have connectivity, the next step it to run _one_ symbol in addportfolio with --verbose enabled: $ beancounter --verbose --dbsystem PostgreSQL --dbname beancounter addportfolio IBM:50:USD That would help to see where this broke down. I expect the issue to be transient. Perl hasn't changed, and Yahoo hasn't changed the format. I run beancounter daily (on testing) and had no issues. Dirk | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1484. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1485. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1486. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1487. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1488. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1489. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1490. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1491. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1492. | Use of uninitialized value in split at /usr/share/perl5/Finance/BeanCounter.pm line 1493. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1494. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1495. | Use of uninitialized value in split at /usr/share/perl5/Finance/BeanCounter.pm line 1496. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1497. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $v in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1525. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1498. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1499. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1500. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1501. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1502. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1503. | Use of uninitialized value in pattern match (m//) at /usr/share/perl5/Finance/BeanCounter.pm line 1504. | Use of uninitialized value in pattern match (m//) at /usr/share/perl5/Finance/BeanCounter.pm line 1504. | Use of uninitialized value in pattern match (m//) at /usr/share/perl5/Finance/BeanCounter.pm line 1504. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1515. | Use of uninitialized value $txt in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1547. | Use of uninitialized value $txt in substitution (s///) at /usr/share/perl5/Finance/BeanCounter.pm line 1547. | Use of uninitialized value $key in hash element at /usr/share/perl5/Finance/BeanCounter.pm line 1517. | Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/Finance/BeanCounter.pm line 1386. | Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/Finance/BeanCounter.pm line 1386. | Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/Finance/BeanCounter.pm line 1386. | Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/Finance/BeanCounter.pm line 1386. | Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/Finance/BeanCounter.pm line 1386. | ERROR: syntax error at or near "," | LINE 1: ..._ratio, avg_volume, active) values('','', '', , , , ,... | ^ at /usr/share/perl5/Finance/BeanCounter.pm line 1404. -- Three out of two people have difficulties with fractions. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]