1 Topic by dvarsani

(2 replies, posted in Report Bugs here)

Hi
I am getting this error when posting bank deposit.

DATABASE ERROR :
At file C:\www\favarsoni\gl\includes\db\gl_db_trans.inc:66:
The GL transaction could not be inserted
error code : 1366
error message : Incorrect string value: '\xA31 Eac...' for column 'memo_' at row 1
sql that failed was : INSERT INTO 0_gl_trans ( type, type_no, tran_date, account, dimension_id, dimension2_id, memo_, amount, person_type_id, person_id) VALUES ('2', '5', '2014-02-05', '18001', '0', '0', 'admin - D Varsani 500 Shares @ £1 Each.', '-500', '0', '')

Thanks

Go to forum: Report Bugs here

2 Reply by dvarsani

(4 replies, posted in Report Bugs here)

Hi

After executing update query on sqlyog, I see this "£" as current symbol.

Thanks

Go to forum: Report Bugs here

3 Reply by dvarsani

(4 replies, posted in Report Bugs here)

Hi

Currency symbol column is VARCHAR(10), Character set id utf8 and collation is utf8_general_ci. System is accepting $ sign. On using € sign, the system doesn't throw an error. The symbol remains "?"

I am using mysql version 5.6.16

Thanks

Go to forum: Report Bugs here

4 Topic by dvarsani

(4 replies, posted in Report Bugs here)

Hi

I am getting this error when I insert "£" in Currency Symbol field

DATABASE ERROR :
At file C:\www\fa\gl\includes\db\gl_db_currencies.inc:23:
could not update currency for GBP
error code : 1366
error message : Incorrect string value: '\xA3' for column 'curr_symbol' at row 1
sql that failed was : UPDATE 0_currencies SET currency='Pounds', curr_symbol='£',    country='England', hundreds_name='Pence',auto_update = '1' WHERE curr_abrev = 'GBP'

Thanks

Go to forum: Report Bugs here

5 Reply by dvarsani

(3 replies, posted in Report Bugs here)

Hi Joe

It works

Many thanks

Go to forum: Report Bugs here

6 Topic by dvarsani

(3 replies, posted in Report Bugs here)

Hi

I am getting this error on decimal setup in preference. When I set any of the four decimal to "0" and save, it saves without any error. What system is doing is it is saving as the field as blank. When I go back to preference page the field which I had set to "0" is blank. Now after changes to any other parameter on this page, when I save, it give this error. You have to again key in "0" where you have "0" decimals to save the settings.

DATABASE ERROR :
At file C:\www\fa\admin\db\users_db.inc:65:
could not update user display prefs for 1
error code : 1366
error message : Incorrect integer value: '' for column 'qty_dec' at row 1
sql that failed was : UPDATE 0_users SET prices_dec='2',qty_dec='',rates_dec='4',percent_dec='2',date_format='1',date_sep='0',tho_sep='0',dec_sep='0',print_profile='',theme='cool',page_size='A4',language='C',startup_tab='orders',show_gl='1',show_codes='1',show_hints='1',rep_popup='1',graphic_links='1',sticky_doc_date='1',query_size='125' WHERE id='1'

Thanks

Go to forum: Report Bugs here

7 Reply by dvarsani

(9 replies, posted in Announcements)

Hi

How do I download Diff files to upgrade me 2.3.19 version.

Thanks

Go to forum: Announcements

8 Topic by dvarsani

(1 replies, posted in Setup)

Hi

Can somebody help me with correct official links for FA stable release (currently 2.3.19) either Git or Mercurial.
Thanks

Go to forum: Setup

9 Reply by dvarsani

(12 replies, posted in Report Bugs here)

Hi
I sorted this issue with updating my column query_size to SMALLINT.
My users prefer viewing 200 lines per page (less pages to view) rather than clicking "Next" for 20/25 times. These days everybody uses mouse wheel to scroll up/down. I think we should change this in FA's new version.
Thanks

Go to forum: Report Bugs here

10 Reply by dvarsani

(12 replies, posted in Report Bugs here)

I think you have misunderstood my error. It is the field in preferences which takes number of rows value to displayed for on-screen transaction report ie custom transaction inquiry.

Go to forum: Report Bugs here

11 Topic by dvarsani

(12 replies, posted in Report Bugs here)

Hi
I am getting this error when I am trying update Query page size above 127.

DATABASE ERROR :
At file C:\Frontaccounting\admin\db\users_db.inc:65:
could not update user display prefs for 2
error code : 1264
error message : Out of range value for column 'query_size' at row 1
sql that failed was : UPDATE 0_users SET prices_dec='2',qty_dec='2',rates_dec='4',percent_dec='2',date_format='1',date_sep='0',tho_sep='0',dec_sep='0',print_profile='',theme='cool',page_size='A4',language='C',startup_tab='orders',show_gl='1',show_codes='1',show_hints='1',rep_popup='1',graphic_links='1',sticky_doc_date='0',query_size='200' WHERE id='2'

Go to forum: Report Bugs here

12 Reply by dvarsani

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

Elax

Could you please guide me how to set up Git or Mercurial (Hg)?

Thanks

Go to forum: Modules Add-on's

13 Topic by dvarsani

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

Hi

I have many FA files which are customised to my requirement. On every upgrade, I have to manually copy and paste those files which have been upgraded in the mew version. Can somebody suggest me a tool or any other way by which I can easily implement my customisation after upgrade?

Thanks

Go to forum: Modules Add-on's

14 Reply by dvarsani

(5 replies, posted in Report Bugs here)

Thanks

Go to forum: Report Bugs here

15 Reply by dvarsani

(5 replies, posted in Report Bugs here)

Hi

Thanks for looking at this issue. Is debugged version of file suppalloc_db.inc downloadable?

Go to forum: Report Bugs here

16 Reply by dvarsani

(5 replies, posted in Report Bugs here)

Have tried using the same procedure on using version 2.3.18 and it works fine. the update in suppalloc_db.inc in version 2.3.19  has some bug.

Go to forum: Report Bugs here

17 Topic by dvarsani

(5 replies, posted in Report Bugs here)

I am getting this error when making supplier payment after upgrading from version 2.3.18 to 2.3.19. After coming out of the payment page I went to supplier transaction page and found that payment has actually been posted. I tried another payment on my test database and had the same error on the payment page but the payment went through.

DATABASE ERROR :
At file C:\Frontaccounting\purchasing\includes\db\suppalloc_db.inc:25:
A supplier allocation could not be added to the database
error code : 1292
error message : Incorrect date value: '' for column 'date_alloc' at row 1
sql that failed was : INSERT INTO 0_supp_allocations ( amt, date_alloc, trans_type_from, trans_no_from, trans_no_to, trans_type_to) VALUES ('100', '', '22', '791', '861', '20')

Go to forum: Report Bugs here

18 Reply by dvarsani

(10 replies, posted in Report Bugs here)

Hi Janusz

Today I got this error while trying to install an extension.

Fatal error: Maximum execution time of 30 seconds exceeded in C:\Frontaccounting\includes\session.inc on line 29


Call Stack


#

Time

Memory

Function

Location

1 0.0024 332768 {main}( ) ..\inst_module.php:0
2 0.0049 446712 include_once( 'C:\Frontaccounting\includes\session.inc' ) ..\inst_module.php:14
3 0.0319 1694688 SessionManager->sessionStart( ) ..\session.inc:363

Go to forum: Report Bugs here

19 Reply by dvarsani

(10 replies, posted in Report Bugs here)

Check the folder properties. it is writable. It is still something else.

Go to forum: Report Bugs here

20 Topic by dvarsani

(0 replies, posted in Report Bugs here)

Hi

There is a bug in sales direct invoice item drop-down list. After adding a line,when you shift focus to next and open the drop-down list and then decide to change the item you have just selected, it looses the drop-down list icon.

Also there is a bug in sales direct invoice when you use F4 key you are able to see items which you have marked as "exclude from Sales". From this window you can select and insert items which are marked as excluded from sales. These items should be filtered out in sales direct invoice F4 key function.

Go to forum: Report Bugs here

21 Reply by dvarsani

(10 replies, posted in Report Bugs here)

Hi

On Version 2.3.18, sometimes I am getting message "Could not Open" & sometimes hazard triangle on top middle of the screen.

Go to forum: Report Bugs here

22 Reply by dvarsani

(10 replies, posted in Report Bugs here)

Hi

I'm now having same problem on version 2.3.18. It was fine on this version few days back.

Go to forum: Report Bugs here

23 Topic by dvarsani

(10 replies, posted in Report Bugs here)

Hi

I am getting is message after installing fresh new version 2.3.19 when I try to install Language, Theme, Extensions & Chart of accounts.

"Cannot download repo index file."

Go to forum: Report Bugs here

24 Topic by dvarsani

(1 replies, posted in Report Bugs here)

I am getting this error when posting amortisation

DATABASE ERROR :
At file C:\Frontaccounting\modules\asset_register\includes\db\amortisation_post_db.inc:32:
could not post amortise
error code : 1366
error message : Incorrect decimal value: '' for column '' at row -1
sql that failed was : SELECT 0_amortise_post(2013)

Go to forum: Report Bugs here

25 Topic by dvarsani

(1 replies, posted in Report Bugs here)

I'm getting this error when setting up dashboard

At file C:\frontaccounting\modules\dashboard\includes\dashboard_db.inc:52:
The widget could not be updated
error code : 1366
error message : Incorrect integer value: '' for column 'collapsed' at row 1
sql that failed was : UPDATE 0_dashboard_widgets SET user_id='1',app='orders',column_id='1',sort_no='1',collapsed='',widget='customers',description='test',param='{"top":"10","data_filter":"","graph_type":"ColumnChart"}' WHERE id = '40'

Go to forum: Report Bugs here