Payment Types not showing up
  • magic1984magic1984 February 2010

    I recently updated Simple Invoices to the latest version and when I go to pay invoices it says that my payment types have not been set up. When i go into the settings and then payment types there are none listed there as well. I tried to add a new one and it tells me that I successfully added a payment type and then it refreshes and says that there are no payment types created. I then went into the database to see if there are in fact payment types in the database so I checked the si_payment_types table and there are in fact 3 listed (Not the one I added by the way). Is the file calling the database wrong? Did something not get updated like it should have properly? Any help would be appreciated. Thanks.

  • magic1984magic1984 February 2010

    ****UPDATE****

    Problem Solved!!!

    It seems that when I was upgrading from the previous version there was 1 table that did not get updated correctly. The "si_payment_types" table originally had 3 colums, "pt_id" - "pt_description" - "pt_enabled".

    It seems that after the update and with the current version that your "si_payment_types" table should now have 4 columns. "pt_id" - "domain_id" - "pt_description" - "pt_enabled". As soon as I added in the "domain_id" column into that table then everything is working as planned. I am now able to add new payment types and delete them as well as choose the payment types when applying money to invoices. This could be a bug that probably should be fixed so that when other people update that it gets fixed properly.

  • justinjustin February 2010

    hey magic

    thanks for finding this!!

    can you let us know which version you upgraded from and to
    - that way we can have a look at the ./include/sql_patches.php file to see where the problems lays

    cheers

    justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories