5,401 Reply by apmuthu

(6 replies, posted in Setup)

can be latin1_unicode_ci too or latin_swedish_ci - but keep all the string fields and db collations the same.

Go to forum: Setup

5,402 Reply by apmuthu

(4 replies, posted in FA Modifications)

Number of boxes would be useful for rough and ready administrative counting even if apples boxes are added to oranges boxes - they are still boxes at heart!

Go to forum: FA Modifications

5,403 Reply by apmuthu

(40 replies, posted in Modules Add-on's)

Check in Firefox browser with java plugin enabled.
Also some temp or cache folder may not have write access by the webserver user.

Unfortunately, despite my having put up the code both here and in my personal repo, the official repo does not want to get update the package as it is considered vulnerable.... The rationale here is possibly to retain a non working package for users to hack it themselves rather than a partially hacked version that will still require hacking albeit a lot less and yet usable.

Go to forum: Modules Add-on's

5,404 Reply by apmuthu

(4 replies, posted in Installation)

Check where the httpd.conf resides - in debian it is in /etc/apache2/sites-available/* from where it gets symlinked to /etc/apache2/sites-enabled/* when a2ensite sitename is executed or it can be manually done and apache2ctl restart issued.

Go to forum: Installation

5,405 Reply by apmuthu

(2 replies, posted in FA Modifications)

The following is declared inside the function set_global_connection($company=-1) in includes\db\connect_db.inc:

$db_duplicate_error_code = 1062;

The said error is triggered when the $db_error matches the above in function frindly_db_error($db_error) in includes/error.inc. The phrase frindly is used here instead of the more intuitive spelling friendly.

The function frindly_db_error is called in function check_db_error also in the same file includes/error.inc, which displays all other errors than this duplicate error.

Go to forum: FA Modifications

5,406 Reply by apmuthu

(3 replies, posted in Report Bugs here)

Thanks Joe for the fix.

Go to forum: Report Bugs here

5,407 Reply by apmuthu

(12 replies, posted in FA Modifications)

The textcart extension may be what you need.

Go to forum: FA Modifications

5,408 Reply by apmuthu

(4 replies, posted in Installation)

What OS?
What WebServer?
Since you used TAR, assuming linux (example Debian/Ubuntu) and that you already have your MySQL and PHP and Apache2 running and have created your FA database and user and assigned access of the database to the user.

wget https:/sourceforge.net/projects/frontaccounting/files/FrontAccounting-2.3/2.3.18/frontaccounting-2.3.18.tar.gz
tar -xzf frontaccounting-2.3.18.tar.gz -C /var/www
chown -R www-data:www-data /var/www/frontaccounting

Make sure that your apache server has it's root folder as /var/www/frontaccounting ( edit the file at /etc/apache2/sites-available/default and restart Apache with apache2ctl restart )

Now browse to http://IP.or.FQDN/ and start the web install. Have your FA Database name and user and password handy.

Go to forum: Installation

5,409 Reply by apmuthu

(6 replies, posted in Setup)

Make the database and tables latin1 and the columns default collation as latin1_general_ci or latin1_swedish_ci  but it should be uniform throughout. Alternatively, make everything utf8 and collation utf8_general_ci which is the default recommended type.

It might be easier to take a backup of the sql, edit the sql and then restore it. The database collation and charset must be done outside of FA.

Go to forum: Setup

5,410 Reply by apmuthu

(6 replies, posted in Setup)

If you are using only english, then it may be okay but make sure the collation is the same for all string fields.

Go to forum: Setup

5,411 Reply by apmuthu

(40 replies, posted in Modules Add-on's)

Yes, it is because your initial install may not have proceeded correctly. Manually create it from the sql in the extension.

Go to forum: Modules Add-on's

5,412 Reply by apmuthu

(8 replies, posted in Modules Add-on's)

Try to use the files from:
https://github.com/apmuthu/frontaccounting/tree/master/extensions/Extensions/repgen

Mainly the sql file will be different.

Go to forum: Modules Add-on's

5,413 Reply by apmuthu

(1 replies, posted in Report Bugs here)

check the error log and / or turn on $debug=1; in the config.php

Go to forum: Report Bugs here

5,414 Reply by apmuthu

(2 replies, posted in FA Modifications)

Which version of FA are you using?
What is the Host OS (Windows / Linux), WebServer (IIS/Apache) ?
Have you created your MySQL user, database and assigned appropriate privileges to the user for the database and flushed privileges to make the changes visible / usable?
Did you install any of the sqls for company 0 manually or did you go thru the full install with proper file and folder permissions?

Go to forum: FA Modifications

5,415 Reply by apmuthu

(13 replies, posted in Accounts Receivable)

https://frontaccounting.com/fawiki/index.php?n=Main.Usage

https://frontaccounting.com/fawiki/index.php?n=Main.ExtensionList

https://github.com/apmuthu/frontaccounting/tree/master/extensions

Joe, will need to clarify on the FA comment in:
http://wiki.xtronics.com/index.php/Linux_accounting

FrontAccounting

weberp fork via openaccounting LAMP GPL - Same kind of usability problems - If you go to enter a sales order, and you happen to have a new customer, there isn't even a navigation button to take the detour. Source forge rank = 356

Go to forum: Accounts Receivable

5,416 Reply by apmuthu

(19 replies, posted in Installation)

Just checked out your site and it appears some files (index.php, config_db.php, etc) are served from some other location and the database parameters too are taken from probably some default setting in the php.ini or from the host. Turned off the install folder and renamed the .htaccess file to be an invalid name. Now there is less of a time out occurring.

This is due to the fact that the site is in previewdns mode and probably, on proper hosting in the production environment (with proper dns assignment), this issue will vanish.

Go to forum: Installation

5,417 Reply by apmuthu

(13 replies, posted in Accounts Receivable)

Old Comparision 2008

Active Comparision

Multi Accounting Web Software comparision

Go to forum: Accounts Receivable

5,418 Reply by apmuthu

(3 replies, posted in Report Bugs here)

Info location:

The Wiki page has a screenshot link in the Procedure para.

Let me know where you searched and did not find - and where in the wiki you would like the info to be placed. The more intuitive the place, the less such questions for the forum.

Joe, must we just toggle the default?

Go to forum: Report Bugs here

5,419 Reply by apmuthu

(2 replies, posted in Report Bugs here)

The only changes done to the admin/backups.php file was in v2.3.15 (made the error string translatable)  and then earlier in v2.3.6.

Scrutinize the file change diffs from the Official Git repo for the said file and see if it affects your browser in any way - very little or no chance at all.

Go to forum: Report Bugs here

5,420 Reply by apmuthu

(18 replies, posted in Reporting)

Various Report Workarounds are Wiki-ed as well.

Go to forum: Reporting

5,421 Reply by apmuthu

(19 replies, posted in Installation)

Check your apache error logs possibly from your GoDaddy cPanel.
Try to craete a file say phpinfo.php in your webroot with the following:

<?php
echo phpinfo();
?>

and execute it from the browser and you will see a wealth of info like session path and then you can contact your GoDaddy support to fix any PHP.ini issues.

Please remove the phpinfo.php file after getting the browser output.

If you are still stuck, email / PM me with server access details after creating temporary access passwords that you can revert on completion of the troubleshooting.

Go to forum: Installation

5,422 Reply by apmuthu

(3 replies, posted in Setup)

Nice Fix.

Go to forum: Setup

5,423 Reply by apmuthu

(5 replies, posted in Misc. Charts of Accounts)

Translated and taken from the Colombian link above

CHAPTER II:
CATALOGUE OF ACCOUNTS

ARTICLE 14. Encoding the Chart of Accounts is structured on the basis of the following levels:

    Class: The first digit
    Group: The first two digits
    Account: The first four digits
    Sub: The first six digits

The classes that the first digit identifies are:

    Class 1: Active
    Class 2: Passive
    Class 3: Heritage
    Class 4: Income
    Class 5: Expenditures
    Class 6: Cost of sales
    Class 7: Costs of production or operation
    Class 8: Debit memorandum accounts
    Class 9: Credit memorandum accounts

Classes 1, 2 and 3 include the accounts comprising the balance sheet, the classes 4, 5, 6 and 7 correspond to the accounts of the state of gains or losses or income statement and Classes 8 and 9 detailed memorandum accounts .

Kindly note that the CoA given here will have variable length Account Codes which can be normalised to 6 digits by padding right with zeroes.

Class: 3 Heritage should be Share Capital or Stock Holders since Google translate of the Spanish patrimonio is poorer than Babylon's.

Go to forum: Misc. Charts of Accounts

5,424 Reply by apmuthu

(3 replies, posted in Setup)

Lines 1109-1123 of sql/en_US-new.sql:

CREATE TABLE IF NOT EXISTS `0_print_profiles` (
  `id` smallint(6) unsigned NOT NULL auto_increment,
  `profile` varchar(30) NOT NULL,
  `report` varchar(5) default NULL,
  `printer` tinyint(3) unsigned default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `profile` (`profile`,`report`)
) ENGINE=MyISAM  AUTO_INCREMENT=10 ;

--
-- Dumping data for table `0_print_profiles`
--

INSERT INTO `0_print_profiles` VALUES(1, 'Out of office', '', 0);
INSERT INTO `0_print_profiles` VALUES(2, 'Sales Department', '', 0);

Therefore an integer should be used and not a string. This was not an issue for older MySQL versions, but the later ones after Oracle took over seem to become more strict in such insert syntaxes. Wonder if NULL values would cause trouble (backward compatibility issues) or a mere 0 should suffice.

Lines 52-65 of admin/db/printers_db.inc:

function update_printer_profile($name, $dest)
{
    foreach( $dest as $rep => $printer) {
        if ($printer != '' || $rep == '') {
            $sql = "REPLACE INTO ".TB_PREF."print_profiles "
            ."(profile, report, printer) VALUES ("
            .db_escape($name).","
            .db_escape($rep).","
            .db_escape($printer).")";
        } else {
            $sql = "DELETE FROM ".TB_PREF."print_profiles WHERE ("
                ."report=" . db_escape($rep)
                ." AND profile=".db_escape($name).")";
        }

A prior integer cast for $printer may be in order here.

The offending line is line 60 in the above code:

            .db_escape($printer).")";

which may be replaced with:

            . ($printer + 0) .")";

Go to forum: Setup

5,425 Reply by apmuthu

(9 replies, posted in Accounts Payable)

Try to debug the portion that makes the mail content and see if it is delivering it to sendmail. Also check for errors in the apache error log.

Go to forum: Accounts Payable