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.
****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.
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
It looks like you're new here. If you want to get involved, click one of these buttons!