1 Topic by timelyfiasco (edited by timelyfiasco 12/21/2017 03:59:40 pm)

  • From: Philippines
  • Registered: 03/14/2015
  • Posts: 25

Topic: Load Error of Items in Items Tab

I encountered a problem with debian 9, mariadb 10, php 7 in VM. I have about 5000+ items and it works fine in ubuntu 16. With the same database and FA 2.4.3, I get a load error when I go to items and try to search for any items. Foreign codes, sales and purchase orders all output a list of items. I only get the error when in items page. Does anyone know the cause of this? php maybe?

Update
I restored a snapshot with only the following installed.
Debian9, apache,  Mariadb server 10.2.1, php7.0 libapache2-mod-php7.0 php7.0-mysql php7.0-gd php7.0-opcache
I was able to successfully install a new FA2.4.3 but the same problem arose. The items page loads for about 10 sec and shows the exclamation mark error. But it adds the new item after a refresh as it appears in the droplist. But I cant load the new item to the page for an edit.
Am I missing a php connector or is the settings at default causing limitations? It is working well with my desktop OS in Ubuntu 16.

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

Re: Load Error of Items in Items Tab

Compare your php.ini and my.cnf / my.ini files between the ubuntu 16 and debian 9 installs. Timeouts may be an issue with php.ini settings. MySQL sql mode strict settings too can be an issue.

apmuthu's Website

3 Reply by timelyfiasco (edited by timelyfiasco 12/22/2017 09:48:46 am)

  • From: Philippines
  • Registered: 03/14/2015
  • Posts: 25

Re: Load Error of Items in Items Tab

Hi apmuthu, thanks for the help. I finally figured it out. I forgot to mention I tried adding ssl and it is what is causing the problem.
I followed this guide for a ssl certificate. Do you possibly know what is causing a problem?
https://www.digitalocean.com/community/ … untu-16-04

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

Re: Load Error of Items in Items Tab

Hi, I think the problem I had was similar to yours, please read this post https://frontaccounting.com/punbb/viewtopic.php?id=6516

If your on a VM try turning off mod-security to see if it resolves?

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: Philippines
  • Registered: 03/14/2015
  • Posts: 25

Re: Load Error of Items in Items Tab

Hi poncho, I have no clue with java. I dont understand that post. I am using virtualbox, I think there is no mod-security or any firewall enabled. I tried to disable javascript in firefox to look for error. I enabled debug mode, but there was none. 
The problem is with adding an ssl certificate. I guess the redirect page is causing problems? I removed it until I know how to install it properly.