FrontAccounting forum — Install Errors

Re: Install Errors

null@example.com (apmuthu) — Thu, 25 Aug 2016 09:30:07 +0000

@sheik_salman: Thanks for the feedback.

The attachment in the 8th post in this thread suggests:

SET @@global.sql_mode= 'TRADITIONAL';

Re: Install Errors

null@example.com (sheikh_salman) — Wed, 24 Aug 2016 14:52:20 +0000

yes for disabling strict mode i run just this command

SET @@global.sql_mode= '';

and it worked for me ..

Thanks.

Re: Install Errors

null@example.com (apmuthu) — Wed, 24 Aug 2016 14:02:17 +0000

You are using a newer version of MySQL where the 0000-00-00 (and it's timestamp equivalent) is not considered as valid anymore by default. Run MySQL with strict mode turned off and all will be well. This issue has been discussed in the forum more than once if I remember right.

Alternatively, edit your chart of accounts to replace all instances of "0000-00-00" to "0001-01-01" and then install your company.

Re: Install Errors

null@example.com (sheikh_salman) — Wed, 24 Aug 2016 10:59:49 +0000

SQL script execution failed in line 42: Invalid default value for 'tran_date'

i have this message on Step 5: Company Settings
I am a beginner please help me with this i tried everything.

Re: Install Errors

null@example.com (crspencer@sol-tech.co) — Sun, 04 May 2014 01:52:06 +0000

Tried the install a few more times, it worked on the 3rd try. No clue why.

Re: Install Errors

null@example.com (joe) — Sat, 03 May 2014 22:43:15 +0000

I am sorry, I cannot help you any more. I don't know where to go from here.
Have you tried to make a fresh install from the download Place at sourceforge?

Have any other had a similar problem?

/Joe

Re: Install Errors

null@example.com (crspencer@sol-tech.co) — Sat, 03 May 2014 21:43:57 +0000

It creates all the tables in the database, but ends with a blank white screen in IE.

Re: Install Errors

null@example.com (joe) — Sat, 03 May 2014 09:20:21 +0000

Hello again.

I have now created a new test Environment

MySql 5.6.17
PHP 5.5.11
Server Type Microsoft-IIS/8.5
Server System WINNT
Frontaccounting 2.3.20

I have tested around and I found no problems at all. Especially your issues Went without problems.

/Joe

Re: Install Errors

null@example.com (joe) — Sat, 03 May 2014 04:50:24 +0000

Please try to help a little more. Look into your /tmp/error.log.
Also look into the mysql server log.

There must be something else wrong in your setup.

Joe

Re: Install Errors

null@example.com (crspencer@sol-tech.co) — Fri, 02 May 2014 19:58:50 +0000

Now when I install, it finishes with a blank blue screen.

Re: Install Errors

null@example.com (joe) — Fri, 02 May 2014 11:04:23 +0000

@crspenser

Please download the file, /includes/db/connect_db.inc and replace this file on your FA installation.
After doing that, you should do your operations without problems.
Please report back.

/Joe

Re: Install Errors

null@example.com (joe) — Thu, 01 May 2014 18:08:28 +0000

I guess you are using a MySql release greater than 5.6. These versions have been more restrict in handling SQL.
Please try to downgrade your MySql to 5.5 or less.

We are investigating this in the meantime.

Joe

Re: Install Errors

null@example.com (crspencer@sol-tech.co) — Thu, 01 May 2014 17:36:23 +0000

after using the two SQL Queries I get:

Number of rows: 2550100250500

+ Options

@@sql_mode

STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_...

Re: Install Errors

null@example.com (joe) — Thu, 01 May 2014 05:49:03 +0000

It seemed not to be a good idea to change the '0000-00-00' to '1001-01-01'. Please replace the value back to '0000-00-00' again.

Then go into phpMyAdmin for your database and enter (in the SQL form):

SET sql_mode = '';

using SELECT @@sql_mode; should report an empty value.

Then retry your operation and see if this helps.

Please report back. Thanks in advance.

/Joe

Re: Install Errors

null@example.com (crspencer@sol-tech.co) — Thu, 01 May 2014 00:26:18 +0000

I edited the en_us-demo.sql and en_us-new.sql and now I'm getting this result:

Debug mode database warning:
error code : 1067
error message : Invalid default value for 'last_reconciled_date'
sql that failed was : CREATE TABLE `0_bank_accounts` ( `account_code` varchar(15) NOT NULL default '', `account_type` smallint(6) NOT NULL default '0', `bank_account_name` varchar(60) NOT NULL default '', `bank_account_number` varchar(100) NOT NULL default '', `bank_name` varchar(60) NOT NULL default '', `bank_address` tinytext, `bank_curr_code` char(3) NOT NULL default '', `dflt_curr_act` tinyint(1) NOT NULL default '0', `id` smallint(6) NOT NULL auto_increment, `last_reconciled_date` timestamp NOT NULL default '1001-01-01 01:01:01', `ending_reconcile_balance` double NOT NULL default '0', `inactive` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `bank_account_name` (`bank_account_name`), KEY `bank_account_number` (`bank_account_number`), KEY `account_code` (`account_code`) ) ENGINE=MyISAM AUTO_INCREMENT=3

Debug mode database warning:
error code : 1146
error message : Table 'acct.0_bank_accounts' doesn't exist
sql that failed was : INSERT INTO `0_bank_accounts` VALUES ('11000', '0', 'Current account', 'N/A', 'N/A', NULL, 'USD', '0', '1', '1001-01-01 01:01:01', '0', '0')

Debug mode database warning:
error code : 1146
error message : Table 'acct.0_bank_accounts' doesn't exist
sql that failed was : INSERT INTO `0_bank_accounts` VALUES ('10200', '0', 'Petty Cash account', 'N/A', 'N/A', NULL, 'USD', '0', '2', '1001-01-01 01:01:01', '0', '0')

SQL script execution failed in line 79: