It is more a system level db centric update. Rarely changes within a minor version - sometimes a force update may be in order when manually upgrading. If used, use with care after backup.
5,601 03/25/2013 02:50:48 pm
Re: Update to 2.3.15 in Setup Software update (4 replies, posted in Setup)
5,602 03/25/2013 02:46:52 pm
Re: FrontAccounting Source Mirrored on GitHub (3 replies, posted in Announcements)
Yes, let us wait for the official one - it will have all the incremental changes as well. The unofficial one I have put up has only release-to-release changesets.
Placed a caveat there as no one should be mislead.
This repo will be updated only when I have the time.
It is meant to enable easy localised forking on GitHub from any release.
It can be used to study differences for migration between versions where individual proficiency in using GIT is better than in using Mercurial
Like any development code repo, code here should be used with care.
Do not be fooled that any snapshot is well tested stable release, while in many times it is not.
Using full random snapshots of FA repo is officially unwelcome
FA Repo code is placed here for study, development and local deployment only especially where internet is not available
FA versions are not released too often in order to provide a minimal acceptable level of stability, which is important especially in accounting software
Very soon the FA project will establish an automatically updated GIT mirror repo that should have all the incremental HG changes
5,603 03/25/2013 01:35:25 am
Re: Update to 2.3.15 in Setup Software update (4 replies, posted in Setup)
This is meant for those upgrading from a lower database schema version from older versions of FA. It is not used in fresh installs.
5,604 03/25/2013 01:33:16 am
Topic: FrontAccounting Source Mirrored on GitHub (3 replies, posted in Announcements)
A manual GitHub Mirror of the SourceForge Mercurial repo and the FA PKG Repo is now available at:
http://github.com/apmuthu/frontaccounting
All FA Releases from v2.2.1 till v2.3.15 (HG 3184) and the latest as on date HG 3212 are available in the core folder. The extensions are available is fully expanded form ready for manual install / development.
5,605 03/24/2013 04:23:46 pm
Topic: Latest HG Updates (0 replies, posted in Installation)
The Announcements topic will have info on recent releases.
Release v2.3.15 Announcement Thread has it's latest HG Repo diff file set posted.
This will hopefully help debugging new issues without having to revisit old solved ones.
5,606 03/24/2013 02:07:47 pm
Re: Poedit msgid limitation (12 replies, posted in Translations)
5,607 03/24/2013 10:31:57 am
Re: $theme already found (2 replies, posted in Report Bugs here)
HG 3212 does the job. All line endings fixed as well. Thanks Janusz for the quick turnaround.
5,608 03/24/2013 04:50:59 am
Topic: Line Endings Fix (1 replies, posted in Report Bugs here)
Here is a oneliner to convert all the Windows / DOS CRLF to UNIX LF line endings:
find ./ -type f \( -name "*.php" -o -name "*.css" -o -name "*.js" -o -name "*.txt" -o -name "*.inc" \) | xargs dos2unix -U
Currently only 3 files seem affected as of FA v2.3.15:
sales/inquiry/sales_orders_view.php
purchasing/includes/db/grn_db.inc
manufacturing/includes/db/work_orders_db.inc
Wonder when it was introduced and by whom.....
5,609 03/23/2013 10:50:22 am
Re: Dashboard Theme / Module hooks issue (3 replies, posted in Modules Add-on's)
Thanks Janusz. Dashboard r5 along with HG 3207-3210 sets right the issue natively without resort to the patches in this thread since the js inclusion has been moved back to the theme's renderer.php back again from the module's hooks.php.
5,610 03/23/2013 09:37:55 am
Re: Dashboard Theme / Module hooks issue (3 replies, posted in Modules Add-on's)
Since the $path_to_root variable is hardcoded as "../../" in the dashboard setup and other php scripts in the modules/dashboard folder, it is necessary to see that the correct path is used to make sure that the install_tabs() in the hooks.php file works correctly for submenu clicks. This is ensured by patching the includes/page/header.inc till a proper alternate solution is found.
Also the FA-dashboard-r4/modules/dashboard/sql/update.sql file can have the AUTO_INCREMENT=6 phrase removed in both table creation statements.
Those who have already installed the dashboard can reset the AUTO_INCREMENT counter with:
ALTER TABLE `0_dashboard_reminders` AUTO_INCREMENT=1;
The id nos 4,5 and 8 are missing in the widgets table data.
Also the readme can list some means to populate the dashboard_setup.php and reminder_setup.php script links as a widget in the setup panel besides mentioning that the module must first be installed before the theme is installed and used.
The installed_extensions.php file in the company/# folder gets populated with "active=>false," instead of "active=>1," for the dashboard_theme v2.3.15-1 entry.
5,611 03/23/2013 06:04:16 am
Topic: $theme already found (2 replies, posted in Report Bugs here)
File: includes/page/header.inc
Line 85 already assigns $theme = user_theme();.
Hence line 139:
include_once($path_to_root . "/themes/".user_theme()."/renderer.php");
can become
include_once($path_to_root . "/themes/$theme/renderer.php");
5,612 03/23/2013 05:25:59 am
Topic: Dashboard Theme / Module hooks issue (3 replies, posted in Modules Add-on's)
Managed to make the dashboard module/theme work as it should by hardcoding the inclusion of jquery-1.3.2.js file and investigated it's cause.
modules/dashboard/hooks.php declares function install_tabs().
Function install_tabs() lists the js files to be included (array $js_userlib) by using the function add_js_ufile().
Function add_js_ufile() (uses full URI / local path and filename) is defined in includes/main.inc along with another function add_js_file().
Only the function add_js_file() (uses only filename) does a file exists check in the fixed webroot's js location as well, using the file include list in array $js_static.
Both add js functions make sure that each file/URI is included only once from their respective arrays.
The file includes/page/header.inc declares the function send_scripts() which includes the files in the $js_static array (from company/#/js_cache/*.js or js/*.js) first and then includes the files from the $js_userlib array with no checks (neither existence nor once only inclusion)
The renderer class is instantiated in both the page_header() and page_footer() functions with the same name $rend.
Another function add_js_source() is also defined in includes/main.inc where the js to be included is in $text variable sent as an argument but is used in the function page_footer() defined in includes/page/footer.inc and is not used here.
The way out here would be to include the jquery scripts int the main webrootjsfolder itself and switch theadd_js_ufile()function to theadd_js_file()function for the said files in the themodules/dashboard/hooks.phpfile. The main menu click determines the $path_to_root as "./" but the submenu click sees it as "../../" though the global one is "../" for it, which confounds the js inclusion function.
It is possible that many extensions will use the jquery function and this will avoid duplicate files - versions of the jquery will however have to be taken into account for the specific extension concerned.
5,613 03/23/2013 02:00:28 am
Re: Wrong Inventory Costing (3 replies, posted in Items and Inventory)
What was the sequence of operations that led to this state of the db?
Please make a fresh test instance of FA (take the latest patches on board) and make a set of operations that will result in one set of negative values. Then we can decipher what went wrong.
Also, make a comparison between a backup sql (where the entries were positive) and a current (negative) sql dump and see what tables and records are affected.
5,614 03/22/2013 03:57:54 pm
Re: Wrong Inventory Costing (3 replies, posted in Items and Inventory)
Items and Inventory -> Standard Costs
1. select item
2. Standard Material Cost Per Unit is shown
3. if you want to adjust the standard cost enter it in the field and click Update
5,615 03/21/2013 05:17:52 am
Re: Menu Shortcuts in other languages (5 replies, posted in Translations)
For RTL languages must the underscore succeed the character?
5,616 03/21/2013 05:15:42 am
Re: Dashboard Theme / Module External Files (2 replies, posted in Modules Add-on's)
A nice caveat to it's use but when secure FA is run in an offline environment, this might be the only solution. If being online is necessary for other aspects of google charts then it would be of no use in this situation.
Thanks @AlastairR for the note and it's potential pitfalls.
5,617 03/20/2013 12:24:41 pm
Topic: Dashboard Theme / Module External Files (2 replies, posted in Modules Add-on's)
The dashboard_theme v2.3.15-1/renderer.php line 42:
echo "<script type='text/javascript' src='https://www.google.com/jsapi'></script>\n";
refers to an external javascript file than can be internalised.
Also line 10 of js/jquery-ui-1.7.2.custom.min.js in the same theme refers to:
http://www.w3.org/2005/07/aaa
If there are any files included from external sites, addon authors are advised to state them.
This code has since been moved to line 25 of hooks.php in the google code svn:
add_js_ufile("https://www.google.com/jsapi");
which can now become:
add_js_ufile("$path_to_root/themes/dashboard/js/jsapi.js");
after uploading the jsapi file as js/jsapi.js
5,618 03/20/2013 10:58:31 am
Re: Dashboard Theme and Module (44 replies, posted in Announcements)
The problem exists in MSIE v8.0 / WinXP SP3 as well.
Located the issue as something to do with javascript error Line 18 Char 1 that is explained in this page. The solution to fix by resetting MSIE does not work.
The comparative portions of the html source of the working and non-working pages are attached herein.
5,619 03/20/2013 04:22:35 am
Re: undefined variable: _SESSION (3 replies, posted in Accounts Receivable)
Thanks Janusz - Bug Fixed in HG 3206.
5,620 03/19/2013 06:44:12 pm
Re: Dashboard Theme and Module (44 replies, posted in Announcements)
In FireFox v19.0.2, in a Dashboard theme, on clicking a left menu entry, the resulting page has clickable menus on the left but they cannot be clicked.
Updated the 3 files (attached) from the googlecode svn - no luck yet.
5,621 03/19/2013 06:11:15 pm
Re: Customize Sales Invoice (1 replies, posted in FA Modifications)
Try to put all the actual values for highest amount and there will be no more columns left and data will be truncated. Maybe possible if the invoice was in landscape format.
5,622 03/16/2013 04:33:21 pm
Re: Unable to create Supplier Invoices (7 replies, posted in Accounts Payable)
http://anothersysadmin.wordpress.com/2012/02/16/php-5-3-max_input_vars-and-big-forms/
max_input_vars = 3000
suhosin.post.max_vars = 3000
suhosin.request.max_vars = 3000
5,623 03/15/2013 02:27:53 pm
Re: Asset Extension Reports (12 replies, posted in Items and Inventory)
The URL:
http://website/accounts/reporting/reports_main.php?Class=2&REP_ID=_assets_list
is malformed.
It should be ending in an integer like say:
http://website/accounts/reporting/reports_main.php?Class=2&REP_ID=609
Hence trace where in the extension, the "_asset_list " string occurs and see if a "$" prefixed php variable is missing in the context.
All your errors are a consequence of the URL PARAMETER type being violated.
5,624 03/15/2013 02:12:06 pm
Re: Enter another customer payment (1 replies, posted in Report Bugs here)
Duplicate Post. Follow other one.
5,625 03/14/2013 03:45:09 pm
Re: Asset Extension Reports (12 replies, posted in Items and Inventory)
Please study the url format for any other working report and you will find that the REP_ID=integer value which is not the case above.
File upload rights are controlled by the forum moderator.
Upload the screenshot to your public website and place the link here.
The following sites among others make a living by advertising on the public's need for free image hosting:
http://troll.ws/
http://beta.photobucket.com/images/pastebin/
http://derp.co.uk/
http://inky.ws/