• Registered: 11/24/2010
  • Posts: 4

Topic: update causes old code not to work

hello,
We recently upgraded a clients front accounting site from version 2.2.5 to 2.3 (RC3) and a page that was added to the old version is now coming up with an error,

The code that seems to be at fault is as follows:

$stockID = $rRow['stock_id'];
    $brStmt = "SELECT SUM(qty) FROM ".TB_PREF."stock_moves WHERE stock_id='$stockID'";
   
    $rbr = @mysqli_query($dbc, $brStmt);
   
    $Rrbr = mysqli_fetch_array($rbr);

and the error from the page is:

mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in file: /var/www/fa/inventory/inventory_overview.php at line 68

the result is mostly displayed correctly but the total quantity, which is derived from this query is 0 in all items.
Is there changes in the new version that would cause this?

Thank you.

  • Registered: 12/25/2007
  • Posts: 2,448

Re: update causes old code not to work

I' don't know what are you talking about. The code fragment you have attached make use of mysqli database API which is not used in FA distribution. And yes, there were huge changes throughout FA code between 2.2 and 2.3 releases.

Janusz