[esteeven]

Hello

Thanks for that. I thought I was going mad for a few minutes the other day. I simply couldn’t work out what was going wrong. A process of elimination led me to my conclusion in my earlier post. Your instructions have been really helpful : the problem is solved (for now) and I’ve gained a confidence in the power if phpMyAdmin.

(My)SQL is something I’ve always avoided direct contact with but this has made me realise that it’s time I at least dipped more than a toe in the water.

I will, in due course, update to master_2019.2.1_beta version (version 2019.2.4) Many thanks for that pointer too.

For the record, I set up SimpleInvoices for my client years ago and it has been happily chugging along without issues. I set it up as a favour : she was just starting out in her business and needed an accounts package that was low cost. The set up, though outside my normal business (IT support & repairs) was straightforward and, once running, rock solid. She had her first and only glitch with emails and export to PDF a few weeks ago. That’s kind of sorted now:thanks to you!!

The final issue is the back ups and restoration seems to have lost the invoice formatting I set up years ago. Can you point me in the right direction for the following?

1 how do I make the “notes” field from invoice creation appear on the actual PDF invoice?
2 how do I stop fields appearing on the PDF (or other export) if the field is blank ie customer fax?

Again, many many thanks.

ps I can start a new thread for the above request if you feel it is more helpful 🙂

[esteeven]

Odd. Odd. Odd. 🙂

I got frustrated and decided to restore a back up of everything that I had made earlier (before this process began) from within SI. I deleted the tables in tsp_invoices and then imported the back up. Suddenly, as if by magic, I can Manage Products in Version: 2019.1.1 . There’s still the issue with the currency symbols to deal with but I want to set up a database copy to test on.

The error occurred when I was importing the actual data. I suspect it may have been my dump of the data ie I think I left “structure” ticked (as well as data.) Do you think this may have caused the issue?

Once again, many thanks for your patience and help.

[esteeven]

I am following the steps exactly as outlined. The error message for si_biller remains the same.

Attachments:

1. 

   drop_biller.png
   

2. 

   no_tables.png
   

[esteeven]

Hello
When I import the data, I get the following error.

Attachments:

1. 

   latest_error.png
   

[esteeven]

Okay. I’ll try this tomorrow morning and report back. Fingers crossed 🙂

ps thanks for your time and effort!!

edit : Saturday@ 16:00 BST
I’m having some issues with my server so the procedure will have to wait until tomorrow 🙁

• This reply was modified 5 years, 2 months ago by esteeven.

[esteeven]

Brilliant. I hope you can find a solution 🙂

[esteeven]

Sorry. I’m a little out of my comfort zone 🙂

• This reply was modified 5 years, 2 months ago by esteeven.

Attachments:

1. tsp_invoices.zip

[esteeven]

Hello
Was the .sql dump okay? I hope so.
Many thanks

[esteeven]

I hope the attached is what you need.

• This reply was modified 5 years, 2 months ago by esteeven.

Attachments:

1. tsp_invoices1.zip

[esteeven]

We have an error.

ALTER TABLE si_expense ADD FOREIGN KEY (product_id) REFERENCES si_products (id) ON UPDATE CASCADE ON DELETE RESTRICT;

See screenshot.

Attachments:

1. 

   error.png
   

[esteeven]

Okay.Thanks for getting back to me. Do I do this in phpMyAdmin? I suppose I have to manually input each command? 🙂 I’m new to playing with database tables and patches.

[esteeven]

When I log in to an older version of SI, I get this on [manage products] :

DataTables warning: table id=si-data-table – Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1

[esteeven]

Logging in to the beta version gives this:

Attachments:

1. 

   foreign_keys.png
   

[esteeven]

Ahhhhhh. Wait. I hadn’t selected the database. Here’s part of the response : a success.

• This reply was modified 5 years, 2 months ago by esteeven.

Attachments:

1. 

   table_selected.png
   

[esteeven]

This is the error when logging in to the beta version.

Attachments:

1. 

   beta_login.png
   

[Author]

Posts