5,626 Topic by apmuthu

(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.

Go to forum: Installation

5,627 Reply by apmuthu

(12 replies, posted in Translations)

Merge PO files with msgmerge

Go to forum: Translations

5,628 Reply by apmuthu

(2 replies, posted in Report Bugs here)

HG 3212 does the job. All line endings fixed as well. Thanks Janusz for the quick turnaround.

Go to forum: Report Bugs here

5,629 Topic by apmuthu

(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.....

Go to forum: Report Bugs here

5,630 Reply by apmuthu

(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.

Go to forum: Modules Add-on's

5,631 Reply by apmuthu

(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.

Go to forum: Modules Add-on's

5,632 Topic by apmuthu

(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");

Go to forum: Report Bugs here

5,633 Topic by apmuthu

(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.

Go to forum: Modules Add-on's

5,634 Reply by apmuthu

(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.

Go to forum: Items and Inventory

5,635 Reply by apmuthu

(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

Go to forum: Items and Inventory

5,636 Reply by apmuthu

(5 replies, posted in Translations)

For RTL languages must the underscore succeed the character?

Go to forum: Translations

5,637 Reply by apmuthu

(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.

Go to forum: Modules Add-on's

5,638 Topic by apmuthu

(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

Go to forum: Modules Add-on's

5,639 Reply by apmuthu

(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.

Go to forum: Announcements

5,640 Reply by apmuthu

(3 replies, posted in Accounts Receivable)

Thanks Janusz - Bug Fixed in HG 3206.

Go to forum: Accounts Receivable

5,641 Reply by apmuthu

(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.

Go to forum: Announcements

5,642 Reply by apmuthu

(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.

Go to forum: FA Modifications

5,643 Reply by apmuthu

(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

Go to forum: Accounts Payable

5,644 Reply by apmuthu

(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.

Go to forum: Items and Inventory

5,645 Reply by apmuthu

(1 replies, posted in Report Bugs here)

Duplicate Post. Follow other one.

Go to forum: Report Bugs here

5,646 Reply by apmuthu

(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/

Go to forum: Items and Inventory

5,647 Reply by apmuthu

(7 replies, posted in Installation)

disable the .htaccess file and try - if it works, then sort it out with your sysadmin.

Go to forum: Installation

5,648 Reply by apmuthu

(2 replies, posted in Setup)

The company folder number must match as well.

Go to forum: Setup

5,649 Reply by apmuthu

(26 replies, posted in FA Modifications)

Copy paste the full code in:
http://phpcodechecker.com/
and you might find syntax errors.

Go to forum: FA Modifications

5,650 Reply by apmuthu

(6 replies, posted in Installation)

The permission and ownership was stated to be for config.php file only and that too after the install was done - it gets created only during installation. This is mandatory to prevent getting hacked inadvertantly. The install folder should be zipped off and removed to prevent any over writes. The announcement link has been updated with changes till HG 3201.

In fact Debian is the platform of choice where a full OpenVZ VM build is available with PlaNetTel - no htaccess file complications and root-kit vulnerabilities on it's account. Full CUPS and multi font charting and SOAP API installed with FA pre-installed with DBs for 10 companies pre-created.

You're right that the folders should be 755 - stand corrected.

Go to forum: Installation