Search options (Page 2 of 243)

File ownership to be checked for your company/0/attachments folder as it must be owned by the webserver process (www-data for Debian/Ubuntu).

What is your MySQL and PHP versions and which platform version are you on and which build version of FA v2.4 are you using?

WordPress does not have orders by default unless you installed a WP plugin.
In WP with your preferred eCommerce plugin installed, take a DB backup, then mane an order and then take another backup and compare the differences between the two backups and you will know which tables/records were affected and you can do the same for FA and hammer out a orders transfer script / sql.

Check out one of the first lines in includes/session.inc file for the SECURE_ONLY constant.

Try to do the same transaction in a fresh install of FA in PHP 5.x and MySQL 5.1 and you will note that NULL implementation and argument order may expose causes.

Lines 756-759 in reporting/includes/pdf_report.inc are:

    function TextCol($c, $n, $txt, $corr=0, $r=0, $border=0, $fill=0, $link=NULL, $stretch=1)
    {
        return $this->TextWrap($this->cols[$c], $this->row - $r, $this->cols[$n] - $this->cols[$c] + $corr, $txt, $this->aligns[$c], $border, $fill, $link, $stretch);
    }

The above function has not changed in 15 years.
However in 2 places in the said file certain PHP 8.1 issues caused a change 2 years ago for the likes of:

$str = ($str != NULL ? strtr($str, array("\r"=>'')) : "");

which may have to be revisited.

The function / method TextWrap is also defined in the same file (changed for PHP 8.1, 2 years ago) whilst the function / method addTextWrap called therefrom is defined in the file reporting/includes/class.pdf.inc.

Check if there are any PHP version related changes between PHP 5 and 8.1 that cause this situation.

@joe: any clues?

Which version of PHP and MySQL are you using? Looks like a PHP 8 issue where arguments for functions with default values are generally pushed to the end.

@joe: Should we allow 0 qty items in BOM to exist?

The said function is a built-in one:
https://www.php.net/manual/en/function.imageftbbox.php

The file manufacturing/includes/db/work_order_requirements_db.inc has the offending code at lines 66-*74:

function update_wo_requirement_issued($id, $quantity, $cost)
{
    $sql = "UPDATE ".TB_PREF."wo_requirements SET 
                unit_cost = (units_issued*unit_cost+".$quantity*$cost.")/(units_issued+".$quantity."),
                units_issued = units_issued + ".db_escape($quantity)."
            WHERE id = ".db_escape($id);

    db_query($sql, "The work requirements issued quantity couldn't be updated");
}

As 'unit_cost' is computed and assigned in the sql statement whilst being part of  the RHS as well kindly look at if it was available initially in the first place.

Sales Orders (#_sales_orders) have an attached Sales Details table (#_sales_order_details) for the line items.
Refer the Wiki for the ERD Diagram.

Very much so.
To run FA you only need a CLI install of Linux.
Later versions of Linux will help manage various cyphers for SSL TLS v1.3.
Debian 6 (Squeeze) runs FA very well when fully updated it is quite secure provided you have a good firewall - even PPTP VPN on pfSense 2.2.6 (since removed after NetGate took it over) would suffice.
It is however imperative that the access and error logs in the firewall and the FA PHP erro logs are regularly monitors - DDoS attacks have become very rampant and iptables manually monitored (fail2ban fails in many instances) will rener it safe albeit expensive in time and effort.