1 Topic by nickMolhoek

(1 replies, posted in Items and Inventory)

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.

Go to forum: Items and Inventory

2 Topic by nickMolhoek

(4 replies, posted in Installation)

A client was using front accounting 2.2.5 but several bugs were causing problems, so we attempted to update to the latest version "2.3 RC3". This has apparently partially worked, but failed on the database update step. On the "software update" page next to 2.3 it says:

    Upgrade from version 2.2 to 2.3    alter2.3.sql    Partially installed (3/4)

and then underneath the table:   

    Database upgrades marked as partially installed cannot be installed automatically. You have to clean database manually to enable them, or try to perform forced upgrade.

I don't know where to start manually cleaning the database, what elements would cause problems for this updated version?

Any help would be greatly appreciated.

Go to forum: Installation

3 Reply by nickMolhoek

(2 replies, posted in Accounts Receivable)

Version 2.2.5 Build 18.10.2010.
I was under the impression that they had recently switched to one of the latest versions. We will try using the latest release.

Go to forum: Accounts Receivable

4 Topic by nickMolhoek

(2 replies, posted in Accounts Receivable)

Hello,
I'm a programmer and a client that uses front accounting for their CRM recently noticed a problem with the invoicing section of 'Sales'.
It seems any item added, that has a value over $1000, is divided by 1000 in the total column so $1000 becomes $1 and $2000 becomes $2.
More precisely it seems to be the actual total modulus 1000, since $1,000,000 also produces a $1 total.
I realize the problem is likely with the file /sales/sales_order_entry.php and or the cart it uses, but I don't really know where to start.
Any help would be greatly appreciated.

Go to forum: Accounts Receivable