• Registered: 11/28/2012
  • Posts: 6

Topic: Data does not change despite changed and saved

Setup->Company Setup

already key in and saved company address etc etc

but go back to see... the data never change

Why like that?

Not only Company setup

but other screen as well, after hit save mesg show save successful, soon as I navigate away and navigate back, the data remain same as BEOFRE update. y??

  • Registered: 11/28/2012
  • Posts: 6

Re: Data does not change despite changed and saved

actually, the data did save, but when navigate away and navigate back it is showing chached old data

so i tested by adding some random characters at the end of the "?"

like so;
.../admin/company_preferences.php?94596856

and then it only show up the real data

so the problem is cashing issue

how to resolve?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Data does not change despite changed and saved

Check Update/Insert permission availability for MySQL user in company used. Make sure that the 

FLUSH PRIVILEGES;

was done after user rights changes are done.

Do not use the Browser Back Button, instead use the Back link on the web page.

apmuthu's Website

4 Reply by echpoh (edited by echpoh 11/28/2012 01:38:40 pm)

  • Registered: 11/28/2012
  • Posts: 6

Re: Data does not change despite changed and saved

apmuthu wrote:

Check Update/Insert permission availability for MySQL user in company used. Make sure that the 

FLUSH PRIVILEGES;

was done after user rights changes are done.

Do not use the Browser Back Button, instead use the Back link on the web page.


I dont understand, your reply, from what context are you speaking from?

"Check Update/Insert permission availability for MySQL user in company used"
Where? which screen? folder? FTP?

"Make sure that the FLUSH PRIVILEGES; was done after user rights changes are done."
Again, Where? which screen are you talking about?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Data does not change despite changed and saved

How did you create the FrontAccounting Company database user? If it is from phpMyAdmin, then check the user privileges there.

apmuthu's Website

  • flort
  • New member
  • Offline
  • Registered: 12/02/2012
  • Posts: 6

Re: Data does not change despite changed and saved

I have also just installed FrontAccounting on my webhosting service and have the same issue. The data is written to the database but the old values are stored in cache and will not display the new values in the web browser.

My database is accessed through phpMyAdmin but the database was created using MySQL Databases in cPanel. The privileges are also set through here and this is set to "All Priveleges" although there is no mention of the FLUSH privilege.

I have also updated .htaccess to include the following as this was mentioned in another post -

<IfModule mod_security.c>
    SecFilterEngine Off
    SecFilterScanPOST Off
</IfModule>

Any assistance you can give would be greatly appreciated as I really like the look of the software and am very keen to try it out.

7 Reply by apmuthu (edited by apmuthu 12/03/2012 04:04:00 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Data does not change despite changed and saved

Clear Browser Cache. Don't use the browser back button - use the "back" link on the web page.

apmuthu's Website

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Data does not change despite changed and saved

Try change line 363 in inlcudes/session.inc to:

ini_set('session.cache_limiter', 'nocache');

This line was changed recently to avoid unexpected page expiration after login.
Janusz

  • flort
  • New member
  • Offline
  • Registered: 12/02/2012
  • Posts: 6

Re: Data does not change despite changed and saved

Thank you so much. I changed that one line of code and everything works perfectly.

By the way, I evaluated the software by manually clearing the cache after every transaction and I think the package is excellent. Keep up the good work.

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Data does not change despite changed and saved

Ok, thank you for update. I guess your browser has badly implemented page caching. Isn't it IE :S ?
Anyway we will fix this problem in next release.
Janusz

  • flort
  • New member
  • Offline
  • Registered: 12/02/2012
  • Posts: 6

Re: Data does not change despite changed and saved

For your reference I'm using the latest version of Google Chrome for my browser so I wouldn't have expected any problems with page caching.

12 Reply by apmuthu (edited by apmuthu 12/13/2012 04:22:02 am)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Data does not change despite changed and saved

@Janusz:

Ref: PHP header() / Http Header and the php.ini setting session.cache_limiter

In Mercurial Build 3122, the file includes/session.inc currently has:
Line 357: ini_set('session.cache_limiter', 'private'); // prevent 'page expired' errors
Line 363: header("Cache-control: private");

We may need to set it to nocache from private in both lines.

Must this change be propagated to pages that do not come in thru index.php directly as well if any?

Any reason why repo is not updated quickly as before?

apmuthu's Website

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Data does not change despite changed and saved

Strange, I have not encountered any caching problems using Chrome on Linux. Anyway I have fixed it to avoid caching problems. Will be available in next minor FA version.
Janusz