disable the .htaccess file and try - if it works, then sort it out with your sysadmin.
5,627 03/13/2013 08:19:20 pm
Re: Making a copy (2 replies, posted in Setup)
The company folder number must match as well.
5,628 03/13/2013 08:13:08 pm
Re: How to Add Column in Direct Invoice (26 replies, posted in FA Modifications)
Copy paste the full code in:
http://phpcodechecker.com/
and you might find syntax errors.
5,629 03/11/2013 04:59:26 am
Re: Problems completing installation due to user/group/permission issues (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.
5,630 03/10/2013 04:31:25 pm
Re: EU VAT from jan 2013 (21 replies, posted in Banking and General Ledger)
Please synch the v2.4 with v2.3 for common file changes and gettext so we can now start dev 2.4 in right earnest.
5,631 03/08/2013 12:23:52 pm
Re: Dashboard Theme and Module (44 replies, posted in Announcements)
Updated the wiki with the info herein.
5,632 03/08/2013 11:59:03 am
Re: dynamic IP vs Fixed Ip (8 replies, posted in Installation)
Stolen cookies in a financial package wouldn't augur well.
Besides, the session holds a lot of form, state and authentication data that the server needs control and knowledge of and a broken browser session will put in an unknown state confusing and confounding FA. Best to break the session and start afresh.
Yes, tough when a lot of data is held in the session and the IP goes fishing!
5,633 03/08/2013 11:43:08 am
Re: Poedit msgid limitation (12 replies, posted in Translations)
Thanks for the info @Berctain.
Others in this genre are:
Multi Po-edit A Java swing .po file editor that displays comments, ids, and translations in a JTable. Multiple files can be compared and IDs can be looked up to see what files will be affected by the change.
and
Massively Parallel PO Editor for editing multiple language files in parallel. Corresponding translations are automatically highlighted in order to aid reviewing against multiple sources.
Wiki-ed it.
5,634 03/07/2013 04:51:25 pm
Re: dynamic IP vs Fixed Ip (8 replies, posted in Installation)
If the client PC is connected to one IP at the ISP and when that IP changes, chances are that the ISP knows where to send the DNS requests and the client PC may have the external DNS cached to the extent of it's current use (WinXP - ipconfig /flushdns). But the FA Server expects the current session to be mapped to the original IP and construes a change in client IP as an intrusion of sorts and terminates the session.
5,635 03/07/2013 04:33:28 pm
Re: Template invoice (7 replies, posted in Accounts Receivable)
HG Changeset 3200 fixes this. Thanks Joe.
5,636 03/07/2013 04:26:06 pm
Re: dynamic IP vs Fixed Ip (8 replies, posted in Installation)
The session will be lost if IP changes in the client and / or host.
5,637 03/07/2013 04:24:40 pm
Re: Problems completing installation due to user/group/permission issues (6 replies, posted in Installation)
Make all files in /var/www/frontaccounting owned by www-data (user and group) 644.
Make all the folders in /var/www/frontaccounting owned by www-data (user and group) 755.
Install FA from browser.
Make the config.php owned and writeable by root user (644) only.
Remove the install folder.
Your version is too old and may have issues with Ubuntu's PHP 5.3.x
Use the latest v2.3.15 + fixes. Get it from SourceForge and the post release updates from the release forum post
5,638 03/07/2013 04:17:04 pm
Re: When purchasing an item, how to choose the cheapest supplier? (9 replies, posted in Accounts Payable)
Probably what he means is that when ordering, we may not know which supplier has the cheapest price (or whatever criterion).
A page where an item can be selected and a list of suppliers with their prices can popup and one can be chosen. Many such line item pairs with respective quantities can be entered and then all the purchase orders can be generated in one stroke!
Item1 Supplier1(with Price) Qty1
Item2 Supplier1(with Price) Qty2
Item3 Supplier3(with Price) Qty3
Item4 Suppier1(With Price) Qty4
etc.,
Generate All PO.
5,639 03/07/2013 04:09:42 pm
Re: Poedit msgid limitation (12 replies, posted in Translations)
CLI - Command Line Interface (DOS Prompt in Windows, Terminal in Linux)
Yu can have as many characters as you want in a line and compile ith .po file to .mo using the msgfmt command in the PoEdit install folder. I trust you are using Windows (possibly XP):
C:\Program Files\Poedit\bin\msgfmt.exe
Place your mylang.po file in the folder: C:\Program Files\Poedit\bin
Start -> Run -> cmd
cd C:\Program Files\Poedit\bin\
msgfmt mylang.po
Take the mylang.mo file from the same folder.
5,640 03/06/2013 03:23:59 pm
Re: Poedit msgid limitation (12 replies, posted in Translations)
Manual Edit using Notepad++ and compile using msgfmt in CLI.
Quote from Mercurial Mercurial Formatting Translations:
short description, starting with lowercase
Larger description of the command. Each paragraph should be word-wrapped
at 70 characters and indented with 4 spaces.Paragraphs are separated by a single empty line. Use a single space
between sentences.
5,641 03/06/2013 03:15:00 pm
Topic: FA Repo Updates (0 replies, posted in Modules Add-on's)
Since the FA Extension Repo gets updated once in a way, it is useful to have some announcements about such releases and updates.
Attached is the list of updates monitored for just over a month.
5,642 03/06/2013 12:02:49 pm
Re: Release 2.3.15 (3 replies, posted in Announcements)
The 32 files fixed upto HG 3218 since the release of FA v2.3.15 is zipped and attached to this post. No DB changes. Just overwrite existing files in webroot down.
The patch set is necessary to partake of the latest dashboard module and theme.
5,643 03/06/2013 11:22:49 am
Re: Active/Inactive bank (8 replies, posted in Report Bugs here)
Thanks Joe. HG 3196 fixes it. Your cast fix is elegant:
$sql = "UPDATE ".TB_PREF.$table." SET inactive = "
. ((int)$status)." WHERE $key=".db_escape($id);
The list of tables and fields that have a non integer primary key or multiple keys and having field name "inactive" are:
Table Name Primary Key Field Type
chart_class cid varchar(3)
chart_master account_code varchar(15)
chart_types id varchar(10)
currencies curr_abbrev char(3)
item_units abbr varchar(20)
locations loc_code varchar(5)
stock_master stock_id varchar(20)cust_branch branch_code, debtor_no int(11), int(11)
It is the last one above that is worrisome as the function used assumes a single primary key only. Kindly test what happens when same debtor is in multiple branches (or multiple debtors for same branch) and it is sought to make inactive a certain branch_code/debtor_no combination only.
5,644 03/05/2013 03:09:59 pm
Re: Active/Inactive bank (8 replies, posted in Report Bugs here)
Roles and Permissions issue?
Should the statement be to set inactive=0 instead of inactive=''?
Offending code is at lines 56-61 in includes/db/sql_functions.inc:
function update_record_status($id, $status, $table, $key) {
$sql = "UPDATE ".TB_PREF.$table." SET inactive = "
. db_escape($status)." WHERE $key=".db_escape($id);
db_query($sql, "Can't update record status");
}
Beware of legacy issues of if and when the column changed to be integer and whether all such tables have the same field type for field name inactive.
There are a total of 31 tables having inactive tinyint(1) and none having a field name of inactive with any other field type. Extensions are another matter though and whether they use this function here is also to be checked especially if they are not tinyint(1) or any int() for that matter.
Therefore it can be safely be changed to:
function update_record_status($id, $status, $table, $key) {
$sql = "UPDATE ".TB_PREF.$table." SET inactive = " . $status+0
. " WHERE $key=".db_escape($id);
db_query($sql, "Can't update record status");
}
5,645 03/05/2013 03:08:58 pm
Re: Report of sales orders by salesman (5 replies, posted in Reporting)
Mockup of desired report would be useful along with name of report that nearly fits the bill.
5,646 03/05/2013 03:07:14 pm
Re: Auto-generate "Reminder" if order below reorder-level (4 replies, posted in Wish List)
Extensions cannot have their variables in the config.php.
It should be a flag in the extension itself that probably gets into the sysprefs table or extension's table.
5,647 03/05/2013 03:05:46 pm
Re: Report for items purchased (sorted/totaled by supplier) (32 replies, posted in Reporting)
Make sure that there is enough space in the reports (forced / default landscape?) and what fields can be dispensed with and list the mockup screenshot.
5,648 03/05/2013 02:58:22 pm
Re: Emailing invoices- How to change the text of the email (8 replies, posted in Accounts Receivable)
Lines 100 - 117 in sales/includes/db/sales_order_db.inc
if ($loc_notification == 1 && count($st_ids) > 0)
{
require_once($path_to_root . "/reporting/includes/class.mail.inc");
$company = get_company_prefs();
$mail = new email($company['coy_name'], $company['email']);
$from = $company['coy_name'] . " <" . $company['email'] . ">";
$to = $loc['location_name'] . " <" . $loc['email'] . ">";
$subject = _("Stocks below Re-Order Level at " . $loc['location_name']);
$msg = "\n";
for ($i = 0; $i < count($st_ids); $i++)
$msg .= $st_ids[$i] . " " . $st_names[$i] . ", " . _("Re-Order Level") . ": " . $st_reorder[$i] . ", " . _("Below") . ": " . $st_num[$i] . "\n";
$msg .= "\n" . _("Please reorder") . "\n\n";
$msg .= $company['coy_name'];
$mail->to($to);
$mail->subject($subject);
$mail->text($msg);
$ret = $mail->send();
}
The file class.mail.inc is included in only 2 files, one above and the other is reporting/includes/pdf_report.inc where mail sending code is present.
Implementation of the phpmailer class would require the patching of the said class.mail.inc file.
5,649 03/05/2013 02:32:15 pm
Re: Release 2.3 - Creating Extensions and Modules. How to? (16 replies, posted in Modules Add-on's)
You can create the modules/_cache/extn-extver-extbuild/_init/config file along with a list of files in the extension and their sha1sums in modules/_cache/extn-extver-extbuild/_init/files and see if it shows up.
Alternatively create your own repo and place your packages in it and change the repo access details in version.php. It hasn't been made easy to get all the files from the repo as the scripts were not deemed ready for distribution yet.
Contact me offline if you want it.
Possibly a GitHub repo may be the answer for manual extension installs. The Linux ar command is used to create the pkg and possibly sign them and hence the ~data file is not extractable in Windows using 7-Zip.
5,650 03/05/2013 02:22:14 pm
Re: purchasing/includes/po_class.inc patch (2 replies, posted in Report Bugs here)
Thanks Joe. HG Changeset 3195 does the job.