Database Activity Types

haggispi · May 17, 2021, 8:44am

Can someone provide a list of ALL the activity_item_id’s that are recorded in the database “Activity” table. it is clear this table records everything that the system does and is much easier to read than the chaos laravel logs (which dont give any information when things are not working).

I am going round and round with the PDF generator in V5.1.61 and have followed EVERY troubleshooting hint with no change. Tried getting an API key from Phantom (doesnt work as i am sure it is because I do not have a Secret, which is also not listed in the documentation as to what this should be, tried everything i can think of), tried re-installing everything.

before someone replies that I should “php artisan optimize”, learnt that the hard way, so do that after every change of the env file and database records.

This is so frustrating on what otherwise is a great product.

hillel · May 17, 2021, 6:52pm

Hi,

You can see the activity ids here:

github.com

invoiceninja/invoiceninja/blob/v5-develop/app/Models/Activity.php#L20


*/


namespace App\Models;


use App\Utils\Traits\MakesHash;


class Activity extends StaticModel
{
   use MakesHash;


   const CREATE_CLIENT = 1; //
   const ARCHIVE_CLIENT = 2; //
   const DELETE_CLIENT = 3; //
   const CREATE_INVOICE = 4; //
   const UPDATE_INVOICE = 5; //
   const EMAIL_INVOICE = 6; //
   const VIEW_INVOICE = 7; //
   const ARCHIVE_INVOICE = 8; //
   const DELETE_INVOICE = 9; //
   const CREATE_PAYMENT = 10; //
   const UPDATE_PAYMENT = 11; //

What error are you seeing in the logs?

The secret an be any random value, we’ll clarify the docs.

haggispi · May 18, 2021, 8:20am

After all the stress of going round in circles, this helped as i could track what was happening in parallel with the laravel logs. I might have found a bug though. Once an invoice has been created when going to view the pdf, the loading ring spins for ever, however, whilst it is loading you click on the “delivery note”, then click on delivery note again, the loading stops and after about 2 seconds the PDF displays.

Tried to check the quote section, but that is broken and creates an invoice in the quote section.

hillel · May 18, 2021, 8:24am

These sound like two different problems:

Are there any errors in the logs?
If you can share a screencast it would be very helpful.

Note: v5.1.62 is the latest version.

haggispi · May 19, 2021, 2:55am

the quote section is broken again so i plan to completely reinstall. see the loom screen video of the invoice bug.

https://www.loom.com/share/b6dc227c2f614c5296ddf76301f8c30a

Will retry a GIT install instead of softaculous as i find they are behind on updates

hillel · May 19, 2021, 4:45am

Thanks for the video! Delivery notes aren’t supported with quotes, in the next version of the app the option will be hidden.

haggispi · May 22, 2021, 6:25am

the selecting the delivery note, then unselecting the delivery note made the PDF of the invoice or quotes visible. without checking and unchecking the box, the PDF would just continue to load.

As softaculous did not have the update to .62 yet, I just completely rebuilt the system from GIT and now all seems to be working relatively smoothly. Am now looking into the customisation of both invoices and email templates as this was a previous problem.