Something spoopy was going on in my database. All was working fine, but it kept spewing out the following error:
Cannot load from mysql.proc. The table is probably corrupted
So this was fixed by going into the database terminal and entering:
mysql_upgrade -u root -p
Make sure you have the root/privileged password ready. Depending on how many databases you have and how large they are; it can take a bit of time. Have patience.
mysql -u root -p
Create a user:
create user 'newuser'@'localhost' IDENTIFIED BY 'password';
Give them all the power:
grant all privileges on * . * TO 'newuser'@'localhost';
Ditch a user: (Optional)
drop user 'newuser'@'localhost';
mysql -u newuser -p
Create a database for the user:
create database db_name;
List databases: (Optional)
Ditch database: (Optional)
drop database db_name;
Probably caused by utilizing the wrong method in an older version, where one had to manually enter the paid amount instead of selecting “mark invoice paid”
Step 1. Check the affected clients and make sure that the actual paid sum is correct, regardless what the “minus” amount says.
Step 2. Make a backup, or find a proper host where you can do an easy roll-back in case you mess up.
Step 3. Open the database of Invoice Ninja and find the “clients” table
Step 4. In the column “Balance” you will see a negative amount. Double-click in that field, enter 0.00 (zero-point-zero-zero) and press enter.