Search options (Page 143 of 247)

Checkout the reporting/includes/doctext.inc and reporting/includes/header2.inc files.

If it is just an issue of password, then reset it to "password" by using phpmyadmin or sqlyog or any other mysql client (even CLI) and execute the command for your company (assumed 0 here):

UPDATE 0_users SET 
  `password`=MD5("password")
, inactive=0
, role_id=2
, startup_tab='orders' 
WHERE user_id='admin';

When posting information on an error you should post the choices made in the preceeding form. Assuming you chose the en_US-new.sql Chart of Accounts in the previous form, line 42 in sql/en_US-new.sql is:

  `tran_date` date NOT NULL default '0000-00-00',

Some recent versions of MySQL do not allow '0000-00-00' as a valid date field value. Try removing all such constructs (default '0000-00-00') from the said sql file and re-try the installation after emptying the db. Alternatively set strict mode off in MySQL.

The following links provide further info:
https://dev.mysql.com/doc/refman/5.6/en/datetime.html
http://stackoverflow.com/questions/25349126/how-can-i-set-the-default-value-of-a-field-as-0000-00-00-000000
http://stackoverflow.com/questions/36374335/error-in-mysql-when-setting-default-value-for-date-or-datetime

There are a total of 31 places in the en_US-new.sql file where the said construct is there.

There are many places in the php codebase where the equivalent of the following constructs are available:

if ($date == 0) $date = '0000-00-00';

and

        $sql .= " tran_date > IF(ctype>0 AND ctype<".CL_INCOME.", '0000-00-00', '$from_date') AND";

Hence it is better to turn the strict mode off in the mysql and not tamper with the Charts sql.

You mentioned that you are a "experienced Front Accounting..... expert" .....

Kindly note that FA 2.3 is quite mature whilst it's CoAs in the official repo are not all of the "exact" schema. Since you are implementing FA for your clients, you will do well to check out the extensions development in the unofficial repo as well besides the FAMods.

Other than being free what made you choose FA after so much experience with "big ERPs"?

Cheers and good luck. Enjoy FA.

FA is really "Single User" as far as multiple simultaneous submits to a form are done at least in FA 2.3.x. Hence when 2 or more users open a new invoice form, all will have the same "next" reference number in it which tries to be posted and only one succeeds.

Put the phone number in the TaxID field.

Edit the file config_db.php and remove the offending entry in the $db_connections array.

Journal Entries.

I trust it is  a self join with:

0_debtor_trans_details.src_id = 0_debtor_trans_details.id

CAS (Central Authentication Service) like a Single Sign On is possible with FA. Check the login code and what values accrue in it's session and make sure the CAS replicates it on login.

Check the collation and charset of the old and new dbs.
Also check the PHP / MySQL / Apache versions of both installs.
There may be some missing php modules (php -m) in the new one.