1 Reply by pdevulder

(4 replies, posted in Items and Inventory)

SELECT 0_item_codes.stock_id, 0_item_codes.description, item_moves.sum_qty, 0_loc_stock.reorder_level
FROM 0_loc_stock
INNER
JOIN 0_item_codes ON 0_item_codes.stock_id = 0_loc_stock.stock_id
AND 0_item_codes.inactive =0
INNER
JOIN (

SELECT stock_id, SUM( qty ) AS sum_qty
FROM 0_stock_moves
WHERE loc_code = 'CC'
GROUP
BY stock_id
) AS item_moves ON item_moves.stock_id = 0_item_codes.stock_id
WHERE 0_loc_stock.loc_code = 'CC'
AND item_moves.sum_qty <= 0_loc_stock.reorder_level

Go to forum: Items and Inventory

2 Reply by pdevulder

(3 replies, posted in Installation)

Hello again,

I just installed PHP 5.2.6 and all is perfect! Without any manipulation on fa files.
Then... I think fa 2.3.4 don't like PHP 5.1.2....

Rgs
Pascal

Go to forum: Installation

3 Reply by pdevulder

(3 replies, posted in Installation)

Hello

Thanks for reply.

I don't modified or edited this file...
This is very strange because, i have copy frontaccounting (exactly the same files!) to an another hosting company, and the installation is well done.

I think problem is more to PHP side? Maybe the version? Frontaccouting is compatabile with 5.1.2? Or maybe some parameters?
With 5.2.13, I have no problem.

Well, I don't understand where the problem is, but I'm sure it's a PHP problem

Rgs

Pascal

Go to forum: Installation

4 Topic by pdevulder

(3 replies, posted in Installation)

Hello,

I have a problem when i try to install FA on my web server.

Version : 2.3.4
PHP : 5.1.2

I copy all files on web server, and i receive the following message, and the install page don't appear:

Fatal error: Call to undefined function user_company() in /var/www/html/frontaccounting/includes/current_user.inc on line 21

I've no problem on my local server, installation is ok, and FA is running correctly.

Any ideas about this?

I've seen this post, this is exactly my problem, I ve try to reinstall all files but without any success...

https://frontaccounting.com/punbb/viewtopic.php?id=1838

Thanks for your support

Pascal

Go to forum: Installation