FrontAccounting forum — slash marks in memo field

Re: slash marks in memo field

2008-09-11T22:07:32Z

Hi Alvin.
This bug finally have been fixed. CVS updated.

Janusz

Re: slash marks in memo field

2008-09-09T17:07:27Z

OK, Janusz

I went to the test folder of almacennaval, and got a blank page, (whatever), So...

I put the updated scripts in a subdomain for both systems that I use, fatest.aljo2.com, and fatest.almacennaval.com, Using phpmyadmin I added your user name and password to fatest.aljo2.com, should work?

Here is the funny part, scripts are the same, only database is diff,

This small problem occurs on fatest.aljo2.com, but not on fatest.almacennaval.com

When you get time, it is not that big of a deal?

Re: slash marks in memo field

2008-09-09T04:29:45Z

This happens at > Banking and General Ledger > Bank Account Payment Entry, I went to your demo site and tried it with the name Mount's in the memo field, got this error (below), I will get my test system updated so you can see, more later,

DATABASE ERROR : The GL transaction could not be inserted
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's')' at line 3
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 (1, 26, '2008/09/09', '1705', 0, 0, '', -25, 0, 'mount's')

Re: slash marks in memo field

2008-09-08T21:00:05Z

Could you point out the page where did you find the issue?
Janusz

Re: slash marks in memo field

2008-09-07T19:59:50Z

This has something to do with the spam injection avoidance we did a while ago. We had to escape all the database entry fields for html to avoid injections from spammers. Maybe Janusz can comment more on that.

/Joe

slash marks in memo field

2008-09-07T18:53:54Z

When I enter a name with an apostrophe (') like Lowe's in the memo field, it comes back as Lowe\'s

Not a big deal, but...