• From: Netherlands, Dieren
  • Registered: 03/10/2021
  • Posts: 2

Topic: Cannot create new company FA 2.4.9

Hello,

I recently installed FrontAccounting 2.4.9 on a dedicated Ubuntu machine running Apache, MySQL and PHP 7.2. Everything is working out great, except now I'm trying to add a new company from the Setup tab. When submitting the form, I get the folowing error:

SQL script execution failed in line 16:
Cannot create new company due to bugs in sql file.

I'm running version 2.4.9 of FrontAccounting which I downloaded from Sourceforge. Does anyone have a suggestion on how to fix this issue so I can add my second company?

Yours sincerely,
Jochem

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,195

Re: Cannot create new company FA 2.4.9

This is sql file error.  Check your apache error log as well as FA's error log.  With that we will get to know which query failed to work.

Or you can goto sql directory and open the en_US-demo or new sql files. Directly import them in a phpmyadmin  by creating a database. It will show you the error. With that error if you know MySql query you can fix it.  Or you can post your query here. We will provide you fix

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • From: Netherlands, Dieren
  • Registered: 03/10/2021
  • Posts: 2

Re: Cannot create new company FA 2.4.9

Oops, seems like there was a permissions problem with my MySQL user. Fixed it and now I can create a new company!

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,195

Re: Cannot create new company FA 2.4.9

Great to hear. Sometimes a tiny mistake will us made

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website