Missing Invoices

a2zcomputing · January 29, 2020, 8:16am

Hello All

I’m using 1.4.8 and noticed some invoices are missing from the system when you "View Invoices " also if you search not there. if you use the settings and goto invoice Archive they are there.

We are about to upgrade to 1.5.2 : don’t want to pull faulty info accross…

any ideas? i did notice another topic which had the same issues but no answer and it was closed.

Hope someone can help

M4rt1n · January 29, 2020, 11:33am

Actually I do not have any v1.4.8 running anywhere. v1.4.8 anyway is pretty old, so pls update much faster in the future as a lot of bugs/issues are getting fixed.

So I can not say exactly what is going wrong here. But maybe its a permission Error? Anyway pls update to the newest versions (as we do not support outdated versions) and report back if this issue may is fixed. If not pls open a Bugreport here: https://development.invoiceplane.com/

But pls follow these instructions and report back.

Backup (FTP & DB!)
save the Backup external
update to v1.5.0 with this instructions upgrade-from-previous
now update to v1.5.10 with the general update instructions (or even better the instructions I give you below)
clear all Caches (also hardreload in the Backend)
change your PHP version to PHP 7.0-7.3
report back if the issue is solved in the new versions

.

Your Update to v1.5.10 (from v1.5.0!) should be “clean”.
To make it sure, pls follow this instructions:

Backup backup backup
Delete the following things:
delete these folders (in rootdirectory) if you do not have installed any other themes:

vendor
assets

delete all files (in rootdirectory) but not :

.htaccess
ipconfig.php

Then go into the folder “application” and delete everything but not “views”
Then go into the folder “views” and delete everything but not “invoice_templates” and “quote_templates”
3. copy over all the content from v1.5.10 and overwrite existing files.
4. set (in “ipconfig.php”) DISABLE_SETUP to false
5. open /index.php/setup (or /setup) and follow the update instructions.
6. report back if everything was going well and if the missing invoices are getting shown.

a2zcomputing · January 31, 2020, 12:32pm

Hi @M4rt1n

No this did not solve it … We now on 1.5.10 still missing?

a2zcomputing · January 31, 2020, 12:35pm

Bug report https://development.invoiceplane.com/ link does not work!!

M4rt1n · January 31, 2020, 12:52pm

This tells me that php’s mysql (mysqli) extension is not installed or not activated!
Pls always check if your system meets all the requirements.

v1.5.9 => PHP 7.0-7.2 (plus all the needed PHP extensions)
v1.5.10 => PHP 7.0-7.3 (plus all the needed PHP extensions)

If you think your Server does already meet all required requirements I would have to have a look at your Server/Applikation and login to debug it more. Otherwise its hard to help.

But before this pls make sure you install all needed PHP extensions.

M4rt1n · January 31, 2020, 12:54pm

Yes … sometimes it does, sometimes not we are currently a bit short of ressources. We will get things back running the next days.

a2zcomputing · February 1, 2020, 10:46am

Hello @M4rt1n

Thank you for the install guidance … that all upgraded to 1.5.10
Now need to find out why we have missing invoices in the Invoice view - Just waiting for your dev. link to start working

M4rt1n · February 1, 2020, 2:19pm

Could you pls post a screenshot where you mark what is missing?
And where (in which view/page) do you see the missing invoices?

If the screenshot contains sensible informations you can send me a PM

a2zcomputing · February 3, 2020, 7:51am

Here you go

M4rt1n · February 3, 2020, 10:25am

Well I also need a proof there have to be a invoice…
Pls do this:

Show me the generated Invoice PDF (which should belomg to there) does exist on your server.
Then show it does exist in the DB!

The reason for this is the following:
Its possible to set a setting in your ipconfig.php and beeing able to delete the Invoice. Deletimg invoices is also possible in the DB itself.

So if the Invoice does not exist in the DB it should not show up anyway.

a2zcomputing · February 3, 2020, 11:10am

Hello @M4rt1n

It’s in the Archive there are several like this completely random

a2zcomputing · February 3, 2020, 11:14am

No they don’t have access to the DB to delete anything. as i mentioned there are a Few missing
20159 -
20139 -
Invoice 20176
Invoice 20169 -
Invoice 20151 -
Invoice 20140 -
Invoice 20138 -
Invoice 20130

M4rt1n · February 3, 2020, 11:28am

Ok so it seems they exist on the Fileserver.
But do these Invoices exist in your DB in the ip_invoices table aswell?
Or are they missing there?

By setting ENABLE_INVOICE_DELETION to true in the ipconfig.php you can delete Invoices within the Dashboard, so pls check if the DB does contain the missing Invoices or not.

It all just works if they are in the DB, generated PDF-Files does not mean the invoice exists, its probably just the file that still exists (due to not getting deleted)

a2zcomputing · February 3, 2020, 3:26pm

Hi @M4rt1n

Yes they are in the table

a2zcomputing · February 3, 2020, 3:27pm

Just some other info - these invoices would not have been deleted.

M4rt1n · February 3, 2020, 3:41pm

For further inspections I would need to inspect your Installation from within the application & server.
Can you pls do these steps:

Backup you FTP & DB
duplicate your application to another domain
change credentials for duplicated installation to duplicated DB
change the Login
PM me with the login data

I then will have a look if I may find the issue

This is responsible for the page/view which is (at your installation) not displaying some invoices

github.com

InvoicePlane/InvoicePlane/blob/master/application/modules/invoices/views/partial_invoice_table.php

<div class="table-responsive">
    <table class="table table-hover table-striped">

        <thead>
        <tr>
            <th><?php _trans('status'); ?></th>
            <th><?php _trans('invoice'); ?></th>
            <th><?php _trans('created'); ?></th>
            <th><?php _trans('due_date'); ?></th>
            <th><?php _trans('client_name'); ?></th>
            <th style="text-align: right;"><?php _trans('amount'); ?></th>
            <th style="text-align: right;"><?php _trans('balance'); ?></th>
            <th><?php _trans('options'); ?></th>
        </tr>
        </thead>

        <tbody>
        <?php
        $invoice_idx = 1;
        $invoice_count = count($invoices);

This file has been truncated. show original

UnderDog · February 3, 2020, 6:24pm

@a2zcomputing thank you for being so patient while we get this resolved.
In the database, the second column from the left I see the number 4 for the missing invoice.
For existing invoices the number is 2.
I forgot the column name, but if the column is ‘status’ it makes sense.
Before you change the status to ‘2’ figure out why the status ended up at ‘4’. Then backup your database and change the status to ‘2’. Does the invoice show up?

M4rt1n · February 3, 2020, 7:15pm

Its not status but user_id, but you are right.
Means this Invoice was generated by another InvoicePlane User and should not show up at other users dashboard.

Think the mystery is solved now.

a2zcomputing · February 3, 2020, 11:16pm

Thank Both.

Little confused, why can’t the main user(administrator) see all the invoices? there are only two users both as Administrators. several invoices as user_id 2 they can see so can user_id 4 by the other user?

I just created myself as another user I can see the invoices but still but not the missing ones.

do you guys want me to replace the code @Kovah ?

Again thanks for the help

a2zcomputing · February 3, 2020, 11:33pm

Hi All

Done some more check I can see that user_id 4 invoices are not showing, but also noticed their is a User_id 5 ? they are showing fine?

changing the invoice 20159 user_id to 2 shows fine …do i change all of them ? what about user_id 5 ?

Again super thanks for you help team