1 Topic by poncho1234 (edited by poncho1234 10/14/2016 06:20:19 pm)

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

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

Up until last Saturday, FrontAccounting v2.3.25 worked perfectly, on Monday morning, whilst changing a customer in a new direct invoice a yellow triangle with an exclamation mark appeared. Also tried various other modules, sales and purchasing seemed to have the problem, (failed to add new customer did not work, etc) items & inventory seemed to work (added new item, edited item, no problem.)

Read through various forum posts here, but no solution found

I have made a 'clean' installation and the problem is exactly the same.

Has anyone else had a similar issue?

Is this a FrontAccounting problem or a server problem? (For me it is a server issue as the clean installation has exactly the same problem, the server techs are pushing me that it is a FA issue, but I'm struggling with their logic)

Any help much appreciated.

Edit, the following is from the console 

ReferenceError: reference to undefined property (intermediate value).description
    

throw new Error(msg);

    
JsHttpRequest.js (line 235, col 21)
Error: JsHttpRequest: JavaScript code generated by backend is invalid!
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<html>
 <head>
  <title>Index of /</title>
 </head>
 <body>
<h1>Index of /</h1>
  <table>
   <tr><th valign="top"><img src="/sharedApache2Icons/blank.gif" alt="[ICO]"></th><th><a href="?C=N;O=D">Name</a></th><th><a href="?C=M;O=A">Last modified</a></th><th><a href="?C=S;O=A">Size</a></th><th><a href="?C=D;O=A">Description</a></th></tr>
   <tr><th colspan="5"><hr></th></tr>
<tr><td valign="top"><img src="/sharedApache2Icons/folder.gif" alt="[DIR]"></td><td><a href="afroin/">afroin/</a>                </td><td align="right">2016-02-21 15:37  </td><td align="right">  - </td><td>&nbsp;</td></tr>
<tr><td valign="top"><img src="/sharedApache2Icons/folder.gif" alt="[DIR]"></td><td><a href="backup/">backup/</a>                </td><td align="right">2016-10-13 22:45  </td><td align="right">  - </td><td>&nbsp;</td></tr>
<tr><td valign="top"><img src="/sharedApache2Icons/folder.gif" alt="[DIR]"></td><td><a href="cgi-bin/">cgi-bin/</a>               </td><td align="right">2016-03-26 11:26  </td><td align="right">  - </td><td>&nbsp;</td></tr>
<tr><td valign="top"><img src="/sharedApache2Icons/folder.gif" alt="[DIR]"></td><td><a href="test/">test/</a>                  </td><td align="right">2016-02-21 15:37  </td><td align="right">  - </td><td>&nbsp;</td></tr>
<tr><td valign="top"><img src="/sharedApache2Icons/folder.gif" alt="[DIR]"></td><td><a href="tmvr/">tmvr/</a>                  </td><td align="right">2016-02-21 15:37  </td><td align="right">  - </td><td>&nbsp;</td></tr>
   <tr><th colspan="5"><hr></th></tr>
</table>
</body></html>
    

throw new Error(msg);

I have tried clearing the cache, still not working

I turned off javascript as suggested on https://frontaccounting.com/wbt/pages/faq.php, but no error messages appeared.

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/

2 Reply by apmuthu (edited by apmuthu 10/15/2016 12:24:25 pm)

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

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

What theme are you using? Revert to default theme and see what happens.
Can be a .htaccess or Apache config issue.

apmuthu's Website

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

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

Thanks for replying apmuthu...

I am using default theme.

I've tried various changes in htaccess, no change.

Any ideas for getting further info?

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: New Zealand, Wellington
  • Registered: 06/19/2014
  • Posts: 128

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

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.

Cambell https://github.com/cambell-prince

cambell's Website

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

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

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

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/

6 Reply by poncho1234 (edited by poncho1234 10/19/2016 12:05:59 am)

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

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

After turning javascript off in chrome everything works.

Apmuthu, any more details on apache config?

Could it be anything in php.ini?

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: New Zealand, Wellington
  • Registered: 06/19/2014
  • Posts: 128

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

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.

Cambell https://github.com/cambell-prince

cambell's Website

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

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

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.

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

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

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

apmuthu's Website

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

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

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

Hope you are using the FA git master code.

apmuthu's Website

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

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

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

login
apmuthu

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.

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/

12 Reply by apmuthu (edited by apmuthu 10/30/2016 07:07:01 am)

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

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

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?

apmuthu's Website

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

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

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

apmuthu's Website

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

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

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.

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/

15 Reply by poncho1234 (edited by poncho1234 11/01/2016 06:07:58 pm)

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

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

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

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/

16 Reply by cambell (edited by cambell 11/04/2016 06:09:16 pm)

  • From: New Zealand, Wellington
  • Registered: 06/19/2014
  • Posts: 128

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

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.

Cambell https://github.com/cambell-prince

cambell's Website

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

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

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.

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

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

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.

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/