Menu

DB Error on Split Transactions

Help
musikia
2005-01-09
2013-03-27
  • musikia

    musikia - 2005-01-09

    I'll dig into debugging this, but thought I'd ask if anyone knew before I spend a lot of time.  In the Split Transactions IFrame, I'm getting "DB Error: syntax error".  A quick glance at the sql looks fine, so I'm wondering if there's a version issue with mySQL.  Is there anything in here that requires mySQL 4.1?

    It's mySQL 4.0.21, also PHP 4.3.10-2, and apache 1.3.33.

    I'll start debugging, checking the mySQL 4.0.21 -> 4.1 features list, etc.  Any ideas in the meantime?

    Thx,
    MusikIA

     
    • musikia

      musikia - 2005-01-10

      OK... a record is supposed to be created in tbl_split_transactions and it's not.  The SQL is indeed invalid, missing the would-be id of the would-be record in the table.  Are splits supposed to work in this release?

       
    • musikia

      musikia - 2005-01-10

      Found the spot in transactions.php that's supposed to be giving the id to the split_transactions_detail.php page.  Changed the GET to use the $unique_id variable instead.  This seemed to work, except, once I entered all of the details of my split transaction, there was no way to "save" it and make it show up in the account.

      I've likely headed down the wrong path.  I think I'll stop and wait for some input from some people who know this pkg better.  :-)

      MusikIA

       

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.