FrontAccounting forum — Yellow warning sign & certain aspects of application cease functioning

Re: Yellow warning sign & certain aspects of application cease functioning

2016-11-11T14:58:06Z

There was an issue with mod-security, hosting company refuse to tell me exactly what the issue was; so I think it's time to find a new hosting company, maybe semi dedicated to..

Many thanks to apmuthu and cambell for your help, time and suggestions.

Re: Yellow warning sign & certain aspects of application cease functioning

2016-11-09T14:47:04Z

Hi cambell, I tried changing / deleting .htaccess - no change

Temporary disabled mod-security this cured the problem...!!!!

I now have something to give to hosting techs....

Will let you know how this ends.

Re: Yellow warning sign & certain aspects of application cease functioning

2016-11-04T18:08:32Z

I had a look at your test site. The ajax request does result in a 302 redirect to the root '/' which returns a standard apache indexes page. This isn't javascript, so causes the error.

Do you have a .htaccess somewhere in the tree / or /apmuthu or /apmuthu/sales?

Do you or your host have a misconfigured location or directory directive in your apache config.

Does your host use mod-security or something similar?

I can't be sure without actually investigating your server, but I think this is a server configuration issue.

Re: Yellow warning sign & certain aspects of application cease functioning

2016-11-01T17:43:35Z

I cannot print anything either, with or without java similar to this post https://frontaccounting.com/punbb/viewtopic.php?id=6199 I have tried V2.3.24 but this does not work for me.

Just to eliminate this I rolled back to 2.3.15 and still it has the same problem

Re: Yellow warning sign & certain aspects of application cease functioning

2016-11-01T16:50:06Z

Hi Apmuthu, thanks for your time in looking at the problem.
In same order as your posts

I confirm that the mysql user had full permissions, I have noticed that turning java off in the browser allows the restore function to work.

I'm a bit confused by this one, (i think...) To run win xp would require me to set up a VM and I do not have a copy of SP3 (or even XP..I have to look) .. How does this help the diagnosis? The same issue is seen on multiple pc, win 7, 8 & 10. If you could explain the reasoning behind this please.

MySQL version 5.6.33
PHP version 5.6.27

You had accessibility problems? Do have this intermittently as is shared hosted, but not had recently.

Updated mysql with above values, no change in problem.

Re: Yellow warning sign & certain aspects of application cease functioning

2016-10-30T08:16:57Z

Site accessible only intermittently.
The sql dump works okay on both my Debian 6 public IP and XAMPP v1.7.3 on localhost as expected.

Try to make the following changes to your sql and see if on a fresh login the problem persists:

UPDATE `cafcolom_apmu`.`0_users` SET `language`='C' WHERE `id`='1';
UPDATE `cafcolom_apmu`.`0_sys_prefs` SET `value`='3600' WHERE `name`='login_tout';
INSERT INTO `cafcolom_apmu`.`0_sys_prefs`(`name`,`category`,`type`,`length`,`value`) VALUES ( 'default_quote_valid_days','glsetup.sales','smallint','6','30'); 

-- Check the 0_security_roles table's records

Re: Yellow warning sign & certain aspects of application cease functioning

2016-10-30T06:58:23Z

Tested a db backup and then restore which failed possibly due to lack of sufficient db permissions for the mysql user used by FA.

Can confirm your yellow triangle on Ajax change of customer in new direct invoice in WinXPSP3 / FF 37.0.2. This is specific to your install and you would need to access your apache error log and php error log in FA to see what gives.

Even changing to the current fiscal year and attempting the above results in the same error.

What is the version of PHP / MySQL you are using?

Re: Yellow warning sign & certain aspects of application cease functioning

2016-10-28T20:07:27Z

Hi apmuthu, I've set up a new installation for you here.. http://www.colombiaonline.net.co/apmuthu/index.php

password
12345678

I confirm I used FA git master code. The previous installations I have used softaculous apps installer.

The problem still occurs in the FA git master code as you will see.

Hope you can diagnose this for me.

Re: Yellow warning sign & certain aspects of application cease functioning

2016-10-28T04:25:06Z

Place a link to a demo install and let us see what breaks.

Hope you are using the FA git master code.

Re: Yellow warning sign & certain aspects of application cease functioning

2016-10-24T13:25:05Z

Try an older version of FireFox from the portable Apps site. The SF site too has them.

Re: Yellow warning sign & certain aspects of application cease functioning

2016-10-19T15:13:16Z

Hi cambell, the problem occurs on latest versions of chrome, firefox and opera, also ie 11.
I have disabled all plug-ins / extensions as you have suggested, no change.
The problem also occurs on 3 other pc's and laptops / phones.

I still think its something serverside, but finding it very hard to diagnose as shared hosting.

Re: Yellow warning sign & certain aspects of application cease functioning

2016-10-19T07:10:05Z

You could check your chrome plugins. Disable them all then re-enable one by one. Maybe you have a plugin that is interfering with the Javascript on the page.

Re: Yellow warning sign & certain aspects of application cease functioning

2016-10-18T19:30:04Z

After turning javascript off in chrome everything works.

Apmuthu, any more details on apache config?

Could it be anything in php.ini?

Re: Yellow warning sign & certain aspects of application cease functioning

2016-10-15T15:44:42Z

Thanks for replying cambell...

Yes the session timed out after approx 10 secs...which corresponds with js/utils line I think its 39 =10000.

I am not redirected to login, please read 1st post...the installation has been running perfectly since march, so seems unlikely to be installation + I have done done 2 clean installations with v2.3.25 and have exactly the same issue.

Ctrl-R just takes the page back to original custom (1st customer in list). The part I find strange is that i can add/ change in items & inventory

Re: Yellow warning sign & certain aspects of application cease functioning

2016-10-15T15:14:51Z

As a bit of a guess, I'd say that your session timed out. i.e. you tried to do something on a page that uses ajax to do the save, however the session was timed out, so you should've been redirected to the login. It seems that / on your installation isn't where FA is, so you got a standard index page which couldn't be parsed by the JsHTTPRequest javascript code - hence this error.

Try Ctrl-R to reload the page and see if it comes right from there.