1 Topic by kvvaradha (edited by kvvaradha 12/25/2015 11:07:01 am)

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

Topic: Company Creation gives me the following error.

Hi,

When i am trying to create new company in " create new company " page. it throughs me an error like this.

    

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

I tried  with demo and without demo. both gives me the same error.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Company Creation gives me the following error.

Do you mean release 2.3.24 or 2.4 Beta? And Maybe som more details please, if you can.

/Joe

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

Re: Company Creation gives me the following error.

Version  2.3.2

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

4 Reply by kvvaradha (edited by kvvaradha 12/25/2015 12:30:39 pm)

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

Re: Company Creation gives me the following error.

and line number 12 is 
   

 
DROP TABLE IF EXISTS `0_areas`;

if i remove this line. it goes to line no:29 again.   That's also the same code.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

5 Reply by apmuthu (edited by apmuthu 12/25/2015 06:06:47 pm)

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

Re: Company Creation gives me the following error.

FA v2.3.2 is very old.
Use v2.3.24+ or v2.4rc1.

What version of PHP/MySQL are you using.
Are you using it in Windows?
What are the DB storage engine and collation used?

The said SQL line is at line 20 in the sql/en_US-new.sql file.

Since the comments are hyphens in the sql file, make sure your MySQL recognizes it or strip it of all comments and create a company with it.

apmuthu's Website

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

Re: Company Creation gives me the following error.

It's $db variable is not globally accessed. Now I solved the problem. It's working now.

Thank you for both of your responses

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

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

Re: Company Creation gives me the following error.

Please state where you find $db not globally accessible as your instance is not replicable. Responses such yours should be fully qualified and not plant apprehensions especially in new user's  minds in using FA.

apmuthu's Website