Search options (Page 1 of 3)

Hello
Changing the PHP version doesn't make a difference. There are quite a few products. There aren't as many customers.
What I discovered is that the query is slow when the customer is already selected. For example, creating the following invoice or when I have looked at transactions for the respective customer before (then the customer is already selected by default when creating a new invoice).
And here is the difference - I have two customers who have a considerable number of invoices every day. These customers are extremely slow. If the preselected customer has had few transactions - there are no problems. But these two customers have had thousands of orders, and this problem occurs specifically with them.
Can I put some additional code somewhere to see the time of SQL queries, so I can figure out why it is slow for these customers - what query takes so long?

Still mystic - how before I have this total without taxes and now not. But quick fix - I added just before this line where You made one fix, following lines:
$rep->TextCol(3, 6, _("Total Tax Excluded"), -2);
$rep->TextCol(6, 7,    number_format2($sign*$tax_item['net_amount'], $dec), -2);
$rep->NewLine();
And now its prints out also Total Tax Excluded

Hi
Correct is Total Tax Excluded
But here are examples - the same customer - invoice total area before and now.
Before: [img]https://www.upload.ee/thumb/7432479/before.png[/img]
Now: [img]https://www.upload.ee/thumb/7432483/now.png[/img]
I need some how to show this Total Tax Excluded sum also in invoice.

Hi - I will test it at the end of the week.

Hi
I added this line to includes/db/connect_db_mysqli.inc - it looks now so:
$db = mysqli_connect($connection["host"], $connection["dbuser"], $connection["dbpassword"], "",
        !empty($connection["port"]) ? $connection["port"] : 3306); // default port in mysql is 3306
       
    mysqli_select_db($db, $connection["dbname"]);
    ///// From mysqli release 5.6.6 the sql_mode is no longer empty as it was prior to
    ///// this release. Just for safety we make it empty for all 5.6 release and higher.
    ///// This non empty sql_mode values can interphere with FA, so all is set empty during
    ///// our sessions.
    ///// We are, however, investigating the existing code to be compatible in the future.
    db_query("SET sql_mode = '".SQL_MODE."'");
    /////added fix
    db_query("SET @@collation_connection = @@collation_database");
    /////
    $SysPrefs->refresh();
    return $db;

But it doesn't help. Or I need something to change in customers_db.inc file also?
Collation - in config_db.php and also in database - all tables are utf8_unicode_ci

Is there any news?
When we can wait new version?

I am waiting it