1 Reply by Yan Shuang

(4 replies, posted in Translations)

I am back to this issue again.
1. I tried to set it as default but it doesn't set as default.
2. It is written that the Chinese is not supported by server locales.
3.
What is your server platform - Linux
What are your FA version: 2.3.18, PHP: 5.4.31, Apache: 2.4.10
Are you using Simplified or Traditional Chinese? I need both
Do you have the necessary locales installed both in the OS and for your client browser? Yes

Do the weird strings when recalled in the Web UI appear as the correct characters? No

Go to forum: Translations

2 Reply by Yan Shuang

(11 replies, posted in Modules Add-on's)

Hi, I have create a link to trigger the automatically update exchange rates but i have no idea on how to set as cron job. Everytime i try to access the link from outside, it will bring me back to the login page.
Please provide detail guide is possible. Cuz i am total lost here!

Go to forum: Modules Add-on's

3 Topic by Yan Shuang

(4 replies, posted in Translations)

Hi, i have downloaded chinese language and set english as my primary language.

When i tried to create item with chinese character, it will save a string of weird characters instead... how do i solve this?

Go to forum: Translations

4 Topic by Yan Shuang

(1 replies, posted in Setup)

I copied the database and the source code from my working server to my localhost (xampp) but unexpectedly, it still give me the following error:

mysql_connect(): MySQL server has gone away in file: C:\xampp\htdocs\fa\includes\db\connect_db.inc at line 28
mysql_connect(): Error while reading greeting packet. PID=7496 in file: C:\xampp\htdocs\fa\includes\db\connect_db.inc at line 28
mysql_select_db() expects parameter 2 to be resource, boolean given in file: C:\xampp\htdocs\fa\includes\db\connect_db.inc at line 29
mysql_query() expects parameter 2 to be resource, boolean given in file: C:\xampp\htdocs\fa\includes\db\connect_db.inc at line 53
mysql_errno() expects parameter 1 to be resource, boolean given in file: C:\xampp\htdocs\fa\includes\db\connect_db.inc at line 147
mysql_num_rows() expects parameter 1 to be resource, null given in file: C:\xampp\htdocs\fa\includes\db\connect_db.inc at line 107



But when i tried to deploy to my local wamp server, it work alright but it will show me :
mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in file: C:\wamp64\www\fa\includes\db\connect_db.inc at line 27

and when change mysql to mysqli, it will show this:
mysql_connect(): MySQL server has gone away in file: C:\xampp\htdocs\fa\includes\db\connect_db.inc at line 28
mysql_connect(): Error while reading greeting packet. PID=7496 in file: C:\xampp\htdocs\fa\includes\db\connect_db.inc at line 28
mysql_select_db() expects parameter 2 to be resource, boolean given in file: C:\xampp\htdocs\fa\includes\db\connect_db.inc at line 29
mysql_query() expects parameter 2 to be resource, boolean given in file: C:\xampp\htdocs\fa\includes\db\connect_db.inc at line 53
mysql_errno() expects parameter 1 to be resource, boolean given in file: C:\xampp\htdocs\fa\includes\db\connect_db.inc at line 147
mysql_num_rows() expects parameter 1 to be resource, null given in file: C:\xampp\htdocs\fa\includes\db\connect_db.inc at line 107


Please help

Go to forum: Setup

5 Reply by Yan Shuang

(12 replies, posted in Accounts Payable)

Where is the checking done to know whether the PO is entirely invoice and GRN?

Go to forum: Accounts Payable

6 Reply by Yan Shuang

(12 replies, posted in Accounts Payable)

This is what i have found so far.

Once i received goods, and the quality_received field in the purch_order_details table is >0, i cant edit.

Go to forum: Accounts Payable

7 Reply by Yan Shuang

(12 replies, posted in Accounts Payable)

Yes i do get the edit button even after GRN, but when i try to edit the individual item, it wont allow me to edit the prices.

I cant post the image to show u.. how do i post image?

Go to forum: Accounts Payable

8 Reply by Yan Shuang

(12 replies, posted in Accounts Payable)

Yes, you are right that once GRN is made, the original PO should not be editable. But I need to customize for the PO to be editable regardless of whether the GRN is made for other reason.

The problem is how do i make it editable?

Go to forum: Accounts Payable

9 Reply by Yan Shuang

(12 replies, posted in Accounts Payable)

Hi, the DO i am referring to GRN in FA. You can create GRN from PO.

Go to forum: Accounts Payable

10 Reply by Yan Shuang

(12 replies, posted in Accounts Payable)

Let me rephrase my question.

I have a PO, then the PO is use to create DO then Invoice.
When the DO is created from the PO, the PO is not editable.

How do i make it editable?

Go to forum: Accounts Payable

11 Topic by Yan Shuang

(12 replies, posted in Accounts Payable)

When the purchase order is use for delivery order, the purchase order is "lock" and cannot be edited.

What can do to edit the purchase order?

Go to forum: Accounts Payable

12 Topic by Yan Shuang

(1 replies, posted in FA Modifications)

Hi I had created Purchase Return similar Purchase Order. Currently, it can add and save well.

But when it comes to edit, it only allow me to 'edit' the quantity field and it doesn't save and it prompt me 'The list price entered must be numeric and not less than zero.' when the list price is not less than zero and also numeric.

However, when i add a new line item, it can save successfully. When i tried to edit the new line item after saved, it allow me to edit price and quantity instead..


This is code is copied from the PO edit function.. Please help

Go to forum: FA Modifications

13 Reply by Yan Shuang

(15 replies, posted in Installation)

I had installation successfully. I had test out some of the functions and it look quite okay for now. I will do more testing to confirm that it is working as per normal.
Once again thank you for all your help.

Go to forum: Installation

14 Reply by Yan Shuang

(15 replies, posted in Installation)

Thank you for your reply. I will download it and try again

Go to forum: Installation

15 Reply by Yan Shuang

(15 replies, posted in Installation)

FA 2.3.25

I downloaded from the link from https://sourceforge.net/projects/frontaccounting/

Go to forum: Installation

16 Reply by Yan Shuang

(15 replies, posted in Installation)

I had disable the SQL strict setting via SET sql_mode = '' for the database I had created for this. And my error log has nothing,

Go to forum: Installation

17 Reply by Yan Shuang

(15 replies, posted in Installation)

Windows
PHP version: 5.6.25
SQL version: 5.7.14

Go to forum: Installation

18 Reply by Yan Shuang

(15 replies, posted in Installation)

May I know how do I check the web server logs? please provide details if possible

Go to forum: Installation

19 Reply by Yan Shuang

(15 replies, posted in Installation)

Eg. I tried to get currency exchange rate. When I click on "Get" , the warning sign above is shown and value is not shown.

/!\  PS. I cant attached the image here to descide my situation.
---

Go to forum: Installation

20 Reply by Yan Shuang

(15 replies, posted in Installation)

A yellow triangle with an exclamation mark in the centre.

Go to forum: Installation

21 Topic by Yan Shuang

(15 replies, posted in Installation)

I had install FA the local environment.
Every time when I tried to add records, no matter is need new invoice, new items or see exchange rates, after I check add/search it will load a while and then show the warning sign above.
Do I not install properly? or have I miss out something?
I had tried to reinstall once but the result is the same. Please help me.

Anyway my PHP version: 5.6.25

Go to forum: Installation