@joe: is this the acceptable way to code the $path_to_root in all repXXX.php files?
2,651 10/05/2017 02:01:05 pm
Re: Recurring Invoices ... A Problem (35 replies, posted in Accounts Receivable)
2,652 10/05/2017 01:51:30 pm
Re: Add custom fields into item (24 replies, posted in FA Modifications)
These are product attributes. You can make one item for each combination of colour and width. That way you will be able to manage it's stock individually too.
2,653 10/05/2017 01:47:52 pm
Re: Login Timeout (3 replies, posted in Report Bugs here)
Upgrade to FA 2.3.26+ and see if the problem persists. There may be some random entropy issues / forced check or if your IP changes.
2,654 10/05/2017 01:46:26 pm
Re: Not working: Automatic Increase of reference number fields in FA 2.4.2 (67 replies, posted in Setup)
Just try to enter the form again and submit with the fresh reference. It is possible that more than one person attempted to use the same entry screen simultaneously and one got the next reference number whilst the other failed since there would now be a record already in the db with that reference number. The post referenced above explains the scenario and a possible solution using an auto check for a new reference number just before adding the record for a more reliable means but not notifying the user of the reference number change if any.
2,655 10/05/2017 01:41:47 pm
Re: front accounting database corruption? (6 replies, posted in Jobs wanted/offered, non-free offers)
Check the settings of the config_db.php file to see if the correct company and db name and db prefix match. It is possible you imported one company's backup into another company and the prefix may or may not have been the same.
2,656 10/05/2017 01:39:51 pm
Re: Sales Invoices and Credit Notes united reference counting (5 replies, posted in Installation)
No standard fix. Hack the Credit Note script and alter the way the new reference is generated to take it as the next one from the invoices series and then use that in the Credit Note set.
2,657 10/05/2017 01:37:38 pm
Re: Fresh install of FA 2.4.x in OpenVZ container running FA 2.3.x (2 replies, posted in Installation)
Those who had been using any FA earlier version in OpenVZ can upgrade using the bash code above. Those who are going to use it for a new FA 2.4.2 installation and want all my mods can modify the above bash scrip and add the apache/php/mysql dependencies in a standard install using a Debian Squeeze template possibly using a debian bootstrap.
2,658 10/05/2017 01:24:00 pm
Re: Release 2.4.2 (11 replies, posted in Announcements)
Do not install Fixed Assets extension for FA 2.4.2. It is a native application in FA 2.4.x series - there will be a tab for it. As the Company Admin, login and enable the permission for Fixed Asset Setup for the roles you want, logout and login as such a privileged user. You will see the Fixed Assets tab has the config menu options.
2,659 10/05/2017 01:19:02 pm
Re: Cannot Edit, Add or Save data (9 replies, posted in Installation)
You seem to be using a PHP v7+ which will not work with FA out of the box.
2,660 10/03/2017 01:04:28 pm
Topic: Fresh install of FA 2.4.x in OpenVZ container running FA 2.3.x (2 replies, posted in Installation)
To start with, a Debian Squeeze OpenVZ container running FA v2.3.26+ was used. The install of FA 2.4.2 was done in on it by purging the databse(s) and then using it's credentials in:
apt-get update
apt-get dist-upgrade
apt-get install rsync
== Install of new FA 2.4 ==
* Backup and empty the databases
cd /var/www
mv frontac frontac_bak
wget https://github.com/apmuthu/frontac24/archive/master.tar.gz -O fa24.tar.gz
tar -xzf fa24.tar.gz
mv frontac24* frontac
mv frontac/core/* frontac/
mv frontac/core/.htaccess frontac/x.htaccess
rm -rf frontac/core
rsync -a -v frontac/FA24Mods/* frontac/
rm -rf frontac/FA24Mods
wget https://frontaccounting.com/wbt/media/download_gallery/dejavu.zip
unzip -o dejavu.zip -d frontac/reporting/fonts
chown -R www-data:www-data frontac
find ./frontac -type f -exec chmod 644 \{\} \;
find ./frontac -type d -exec chmod 755 \{\} \;
sed -i -e 's/# hi_IN UTF-8/hi_IN UTF-8/' /etc/locale.gen
dpkg-reconfigure --frontend=noninteractive locales
update-locale en_US ISO-8859-1 en_US.UTF-8 UTF-8 ta_IN hi_IN ar_EG.UTF-8
service apache2 restart
# Session save path Info /var/lib/php5
# Install from Browser
tar -czpf install_fa24.tar.gz frontac/install
rm -rf frontac/installThe above will provide all FA24Mods from my repo as well.
2,661 10/03/2017 12:45:37 pm
Re: db_pager.inc and session.inc inclusion order (6 replies, posted in Report Bugs here)
That is indeed a good find.
The function display_db_pager() is defined in includes/ui/db_pager_view.inc which is "include"d in includes/db_pager.inc which is "include"d in each table display page. All such pages have your stated order of "include".
The pager routines have no need for page security which is used by the session file which needs to come in later. It is possible that some routines in the pager files may be needed by the session file.
There are functions, includes and code outside of the class definition in the session file. Such includes too may need functions available in the pager files that hence need to precede the session file in order of inclusion.
2,662 10/02/2017 01:16:36 pm
Re: After successful Backup, loader.gif still present (1 replies, posted in Report Bugs here)
The fix for this is lines 134-138 in admin/backups.php:
if (get_post('creat')) {
generate_backup($conn, get_post('comp'), get_post('comments'));
$Ajax->activate('backups');
};should be:
if (get_post('creat')) {
generate_backup($conn, get_post('comp'), get_post('comments'));
$Ajax->activate('backups');
$SysPrefs->refresh(); // re-read system setup
};@joe: can commit this.
Committed.
2,663 10/02/2017 12:57:40 pm
Topic: After successful Backup, loader.gif still present (1 replies, posted in Report Bugs here)
Setup => Backup/Restore => Backup successfully generated. ....
The themes/default/images/ajax-loader.gif image is still present. It needs to be removed during the ajax call that states the backup was successful.
2,664 10/02/2017 11:08:13 am
Topic: No need for charts in installed_extensions.php in company# (2 replies, posted in Modules Add-on's)
When charts are installed, they are made available in the installed_extensions.php file in the webroot and available to the default company to create new ones with them. There is no need for these to exist in the company/#/installed_extensions.php file.
2,665 10/02/2017 10:53:43 am
Re: Bug in includes\ui\ui_controls.inc (1 replies, posted in Report Bugs here)
This happened on 2015-02-18 when the file was edited.
@joe: can fix this.
Committed.
2,667 10/02/2017 09:04:18 am
Re: Installation problem (24 replies, posted in Installation)
@PaulShipley: Thanks. It has been Wiki-ed.
Although the last link in your post is correct, it may have been named wrongly: FA 2.4.25 ??
2,668 10/02/2017 08:19:33 am
Re: db_pager.inc and session.inc inclusion order (6 replies, posted in Report Bugs here)
Even providing the whole file here may not be useful. Check your functionality and provide feedback.
2,669 10/02/2017 03:38:48 am
Re: Optimise get_company_pref() (1 replies, posted in Report Bugs here)
@joe: can commit this.
Committed.
2,670 10/01/2017 03:49:09 pm
Topic: User repo and unsigned packages option mod (0 replies, posted in Modules Add-on's)
Using trusted unsigned packages possibly in the LAN is made possible by a $repo_sign flag placed in the config.php
Hosting one's own package repo is available in FA. The $repo_auth array in version.php can be overridden by one in the config.php file.
$SysPrefs array is not used in the includes/package.inc file (in FA 2.4) but the config variables are used from their global context.
Commits in my repos:
FA 2.4 commit as of today (Oct 2017).
FA 2.3 commit as of 2014.
2,671 10/01/2017 03:41:51 pm
Re: db_pager.inc and session.inc inclusion order (6 replies, posted in Report Bugs here)
Provide context. The standard FA works fine with db_pager. Hence it must be a $path_to_root or include_once issue.
2,672 10/01/2017 12:54:18 pm
Topic: Fix pre-login errors in windows (1 replies, posted in Report Bugs here)
The fix for FA 2.3 in my FAMods repo can be ported safely to FA 2.4 to avoid errors that fill up the tmp/errors.log file each time the login screen is accessed. At that time, there is no user available to the session and the $haystack will be a null resource instead of an array. It should degrade gracefully. This is observed in Windows XAMPP (1.7.3) installs.
@joe: the two functions affected are verbatim in both versions and hence they can be ported easily.
2,673 10/01/2017 12:18:46 pm
Re: Session errors (1 replies, posted in Installation)
Periodically purge the errors in the tmp/errors.log file.
Placing echo session_save_path(); just before the @session_destroy(); line in access/logout.php and checking the html source of the logged out page will show where the session files are stored - these too must be purged periodically - they will generally be beyond the webroot and possibly out of reach of the php's permissions to destroy them and hence the error. In linux systems I have not found this issue.
2,674 10/01/2017 10:12:30 am
Re: Forum Usage - best practices (5 replies, posted in Announcements)
Forum Usage Stats in the last 1 year is attached herewith.
Averaging a little over 1 new valid user every 2 days, ie., 17+ a month.
A little under a post a day, ie., 26+ a month.
A drastic dwindling of activity probably means that most FA users are now adept in using it and others get assistance offline or by searching the forum and the wiki.
2,675 10/01/2017 04:14:59 am
Topic: Optimise get_company_pref() (1 replies, posted in Report Bugs here)
The file admin/db/company_db.inc has the function get_company_pref($prefs = null):
function get_company_pref($prefs = null)
{
global $SysPrefs, $db_version;
if (!isset($SysPrefs->prefs)) // just after first login or reset
$SysPrefs->refresh();
$all = $SysPrefs->prefs;
if (!$prefs)
return $all;
elseif (is_string($prefs))
return @$all[$prefs];
$ret = array();
foreach($prefs as $name)
$ret[$name] = $all[$name];
return $ret;
}This can be simplified and made efficient by replacing it with:
function get_company_pref($prefs = null){
global $SysPrefs, $db_version;
if (!isset($SysPrefs->prefs)) // just after first login or reset
$SysPrefs->refresh();
$all = $SysPrefs->prefs;
if ($prefs && is_string($prefs))
return @$all[$prefs]; // silent on absent array element
if (!is_array($all))
$all = array();
return $all;}