If all the *.inc files are renamed to be *.inc.php and the code altered to use such extensions, then the inability to use the .htaccess file would not be a security issue.
6,001 10/17/2012 02:57:02 pm
Topic: file extension .inc to inc.php (2 replies, posted in FA Modifications)
6,002 10/17/2012 02:38:34 pm
Topic: Exchange Rate Buy / Sell Fields (2 replies, posted in Setup)
Clarifications on currency fields:
currencies.auto_update -> what is it's purpose?
exchange_rates.rate_buy
exchange_rates.rate_sell
Both the above fields are populated with the same value obtained from the web rate service provider into a common form field. Which is the actual field used in FA for computation? What happens if the rates are different or need to be set different - any form is available in FA for it?
There are many fields named `date_` -> expect it is by design.
Any exhaustive set of sys_prefs ?
6,003 10/17/2012 10:21:46 am
Re: Nu SOAP beware (2 replies, posted in Modules Add-on's)
Over a period of time, no one will have any time to maintain what they may have started and code projects are no exception. Maybe, GitHub is the way to go. The interested members of the community at any given point in time will take the baton along. Some corporates may wipe out all traces of it's origin and start selling it as their own..... -the price to pay will be to maintain it alone. Ultimately the only currency in one's life is the time available and what you choose to do with it and not what your Agong or any bank issues!
Thankyou for your valuable contributions to the FA project.
6,004 10/17/2012 06:39:07 am
Re: Simple REST API (45 replies, posted in Modules Add-on's)
SimpleAPI - can synch different FA instances as well - looking at High Availability clusters across data centres and local power outages!
6,005 10/17/2012 04:20:20 am
Topic: Nu SOAP beware (2 replies, posted in Modules Add-on's)
Analysing the fa_soap_web_services.zip addon (AntERP - Lim Tee Chert), we see that tempuri.org is being the default namespace in line 7314 of api/lib/nusoap.php
The said domain is registered by Domainamania.com only in June 2012, by one Janis von Bleichert, Germany.
Please check all standard libraries for malicious URLs - some versions of nusoap v1.63 have malicious URLs with devious get parameters.
6,006 10/17/2012 04:10:41 am
Re: DB Error while Placing a Direct Invoice with no customer selected. (7 replies, posted in Report Bugs here)
Thanks Joe. Maybe in v2.4, if the said field is not used, it can be removed.
Mercurial Changeset 3084.
6,007 10/16/2012 02:41:27 pm
Re: Private Messages (16 replies, posted in Announcements)
Welcome change indeed! Thanks Joe.
6,008 10/16/2012 02:31:55 pm
Re: DB Error while Placing a Direct Invoice with no customer selected. (7 replies, posted in Report Bugs here)
Is this fix needed in Line 460 in the current version of the said file purchasing/po_entry_items.php ?
The field ov_discount in the table supp_trans is set to be NOT NULL for good reason - arithmetic cannot be done on NULL values. Hence setting it to 0.0 is correct. If it is not used as stated in the comments, then the field should be removed.
The same field name and NOT NULL state is observed in the debtor_trans table as well. Any similar inserts failing on it?
6,009 10/16/2012 02:26:25 pm
Re: Attachments to topics/posts (18 replies, posted in Announcements)
Thanks Joe, what a godsend!
6,010 10/16/2012 02:25:06 pm
Re: chinese characters (11 replies, posted in Translations)
Check includes/page/header.inc file if any hardcoded changes might be a temporary workaround.
6,011 10/16/2012 02:21:43 pm
Re: Frontaccounting Upgrade Error! (25 replies, posted in Installation)
This was done by comparing the latest db structure to the clients failed state existing one. The FA project can by no means even attempt to provide a one size fits all solution in this case. This method was a last case best effort basis attempt that actually succeeded according to popsicles12.
SQLyog Ultimate has a DB Synch Wizard that compares 2 databases and spits out the one way sync SQL statements needed. Default core data can also be compared using the Data Synch Wizard and a similar SQL delete / update / insert set needed would be output.
In short, it is an unsupported case. The actual lessons from the initial failure were not captured by popsicles12 from his Mysql error logs and hence cannot enlighten us on the exact cause of failure.
6,012 10/16/2012 02:10:58 pm
Re: Simple REST API (45 replies, posted in Modules Add-on's)
Thanks Janusz, Wikied that link as well.
6,013 10/16/2012 04:30:50 am
Re: Vtiger Integration (38 replies, posted in Modules Add-on's)
Now that the RESTful SimpleAPI has been made for FrontAccounting, and maybe one exists for vTigerCRM as well, it should be a simple matter of JSON exchanges......
Currently vTiger Wiki for the modules list does not show any API.
6,014 10/16/2012 04:24:10 am
Re: Simple REST API (45 replies, posted in Modules Add-on's)
Thanks a lot!
Wikied it.
It now places FA on par with webERP in one critical aspect. It also paves the way for POS connector, etc.,.
6,015 10/16/2012 04:03:59 am
Re: how to change the COA for the training co (5 replies, posted in Banking and General Ledger)
Place the resultant sql file with a "0_" prefix for the tables in the frontaccounting/sql folder and see that it is included in the installed_extensions.php file along with a meaningfull name, whilst incrementing the array index variable in the said file.
When creating a new company, you will now find it available in the dropdown list for the COA.
6,016 10/16/2012 03:58:28 am
Re: Frontaccounting Upgrade Error! (25 replies, posted in Installation)
Actually, what happens is when even one SQL statement of the alter*.sql files fail or are executed external to the attendant alter*.php files, the rest of the SQL statements are not executed and the successive dependant statements in later files too would fail.
Appended (no allowed attachments here) below is the contents of the upgrade sql file that popsicles12 used:
==============
ALTER TABLE `4_audit_trail`
DROP KEY `fiscal_year`,
ADD KEY `Seq`(`fiscal_year`,`gl_date`,`gl_seq`),
ADD KEY `Type_and_Number`(`type`,`trans_no`);
ALTER TABLE `4_bank_accounts`
CHANGE `account_code` `account_code` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' first,
ADD KEY `account_code`(`account_code`);
ALTER TABLE `4_bank_trans`
CHANGE `bank_act` `bank_act` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `trans_no`,
ADD KEY `bank_act_2`(`bank_act`,`reconciled`),
ADD KEY `bank_act_3`(`bank_act`,`trans_date`);
ALTER TABLE `4_bom`
DROP KEY `Parent_2`;
ALTER TABLE `4_budget_trans`
CHANGE `account` `account` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `tran_date`,
ADD KEY `Account`(`account`,`tran_date`,`dimension_id`,`dimension2_id`);
ALTER TABLE `4_chart_class`
CHANGE `cid` `cid` varchar(3) COLLATE latin1_swedish_ci NOT NULL first;
ALTER TABLE `4_chart_master`
CHANGE `account_code` `account_code` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' first,
CHANGE `account_code2` `account_code2` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `account_code`,
CHANGE `account_type` `account_type` varchar(10) COLLATE latin1_swedish_ci NOT NULL DEFAULT '0' after `account_name`,
DROP KEY `account_code`,
ADD KEY `accounts_by_type`(`account_type`,`account_code`);
ALTER TABLE `4_chart_types`
CHANGE `id` `id` varchar(10) COLLATE latin1_swedish_ci NOT NULL first,
CHANGE `class_id` `class_id` varchar(3) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `name`,
CHANGE `parent` `parent` varchar(10) COLLATE latin1_swedish_ci NOT NULL DEFAULT '-1' after `class_id`,
ADD KEY `class_id`(`class_id`);
ALTER TABLE `4_comments`
ADD KEY `type_and_id`(`type`,`id`);
CREATE TABLE `4_crm_categories`(
`id` int(11) NOT NULL auto_increment COMMENT 'pure technical key' ,
`type` varchar(20) COLLATE latin1_swedish_ci NOT NULL COMMENT 'contact type e.g. customer' ,
`action` varchar(20) COLLATE latin1_swedish_ci NOT NULL COMMENT 'detailed usage e.g. department' ,
`name` varchar(30) COLLATE latin1_swedish_ci NOT NULL COMMENT 'for category selector' ,
`description` tinytext COLLATE latin1_swedish_ci NOT NULL COMMENT 'usage description' ,
`system` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'nonzero for core system usage' ,
`inactive` tinyint(1) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`) ,
UNIQUE KEY `type`(`type`,`action`) ,
UNIQUE KEY `type_2`(`type`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET='latin1';
CREATE TABLE `4_crm_contacts`(
`id` int(11) NOT NULL auto_increment ,
`person_id` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key to crm_contacts' ,
`type` varchar(20) COLLATE latin1_swedish_ci NOT NULL COMMENT 'foreign key to crm_categories' ,
`action` varchar(20) COLLATE latin1_swedish_ci NOT NULL COMMENT 'foreign key to crm_categories' ,
`entity_id` varchar(11) COLLATE latin1_swedish_ci NULL COMMENT 'entity id in related class table' ,
PRIMARY KEY (`id`) ,
KEY `type`(`type`,`action`)
) ENGINE=InnoDB DEFAULT CHARSET='latin1';
CREATE TABLE `4_crm_persons`(
`id` int(11) NOT NULL auto_increment ,
`ref` varchar(30) COLLATE latin1_swedish_ci NOT NULL ,
`name` varchar(60) COLLATE latin1_swedish_ci NOT NULL ,
`name2` varchar(60) COLLATE latin1_swedish_ci NULL ,
`address` tinytext COLLATE latin1_swedish_ci NULL ,
`phone` varchar(30) COLLATE latin1_swedish_ci NULL ,
`phone2` varchar(30) COLLATE latin1_swedish_ci NULL ,
`fax` varchar(30) COLLATE latin1_swedish_ci NULL ,
`email` varchar(100) COLLATE latin1_swedish_ci NULL ,
`lang` char(5) COLLATE latin1_swedish_ci NULL ,
`notes` tinytext COLLATE latin1_swedish_ci NOT NULL ,
`inactive` tinyint(1) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`) ,
KEY `ref`(`ref`)
) ENGINE=InnoDB DEFAULT CHARSET='latin1';
ALTER TABLE `4_cust_allocations`
ADD KEY `From`(`trans_type_from`,`trans_no_from`),
ADD KEY `To`(`trans_type_to`,`trans_no_to`);
ALTER TABLE `4_cust_branch`
CHANGE `contact_name` `contact_name` varchar(60) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `salesman`,
CHANGE `default_location` `default_location` varchar(5) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `contact_name`,
CHANGE `tax_group_id` `tax_group_id` int(11) NULL after `default_location`,
CHANGE `sales_account` `sales_account` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `tax_group_id`,
CHANGE `sales_discount_account` `sales_discount_account` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `sales_account`,
CHANGE `receivables_account` `receivables_account` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `sales_discount_account`,
CHANGE `payment_discount_account` `payment_discount_account` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `receivables_account`,
CHANGE `default_ship_via` `default_ship_via` int(11) NOT NULL DEFAULT 1 after `payment_discount_account`,
CHANGE `disable_trans` `disable_trans` tinyint(4) NOT NULL DEFAULT 0 after `default_ship_via`,
CHANGE `br_post_address` `br_post_address` tinytext COLLATE latin1_swedish_ci NOT NULL after `disable_trans`,
CHANGE `group_no` `group_no` int(11) NOT NULL DEFAULT 0 after `br_post_address`,
CHANGE `notes` `notes` tinytext COLLATE latin1_swedish_ci NOT NULL after `group_no`,
CHANGE `inactive` `inactive` tinyint(1) NOT NULL DEFAULT 0 after `notes`,
DROP COLUMN `phone`,
DROP COLUMN `phone2`,
DROP COLUMN `fax`,
DROP COLUMN `email`,
DROP KEY `br_name`,
ADD KEY `branch_ref`(`branch_ref`),
ADD KEY `group_no`(`group_no`);
ALTER TABLE `4_debtor_trans`
CHANGE `dimension_id` `dimension_id` int(11) NOT NULL DEFAULT 0 after `ship_via`,
CHANGE `dimension2_id` `dimension2_id` int(11) NOT NULL DEFAULT 0 after `dimension_id`,
ADD COLUMN `payment_terms` int(11) NULL after `dimension2_id`,
DROP COLUMN `trans_link`,
DROP KEY `PRIMARY`, add PRIMARY KEY(`type`,`trans_no`),
ADD KEY `tran_date`(`tran_date`);
ALTER TABLE `4_debtor_trans_details`
ADD COLUMN `src_id` int(11) NOT NULL after `qty_done`,
ADD KEY `src_id`(`src_id`),
ADD KEY `Transaction`(`debtor_trans_type`,`debtor_trans_no`);
ALTER TABLE `4_debtors_master`
CHANGE `tax_id` `tax_id` varchar(55) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `address`,
CHANGE `curr_code` `curr_code` char(3) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `tax_id`,
CHANGE `sales_type` `sales_type` int(11) NOT NULL DEFAULT 1 after `curr_code`,
CHANGE `dimension_id` `dimension_id` int(11) NOT NULL DEFAULT 0 after `sales_type`,
CHANGE `dimension2_id` `dimension2_id` int(11) NOT NULL DEFAULT 0 after `dimension_id`,
CHANGE `credit_status` `credit_status` int(11) NOT NULL DEFAULT 0 after `dimension2_id`,
CHANGE `payment_terms` `payment_terms` int(11) NULL after `credit_status`,
CHANGE `discount` `discount` double NOT NULL DEFAULT 0 after `payment_terms`,
CHANGE `pymt_discount` `pymt_discount` double NOT NULL DEFAULT 0 after `discount`,
CHANGE `credit_limit` `credit_limit` float NOT NULL DEFAULT 1000 after `pymt_discount`,
CHANGE `notes` `notes` tinytext COLLATE latin1_swedish_ci NOT NULL after `credit_limit`,
CHANGE `inactive` `inactive` tinyint(1) NOT NULL DEFAULT 0 after `notes`,
DROP COLUMN `email`,
ADD UNIQUE KEY `debtor_ref`(`debtor_ref`),
DROP KEY `name`, add KEY `name`(`name`);
ALTER TABLE `4_dimensions`
ADD KEY `date_`(`date_`),
ADD KEY `due_date`(`due_date`),
ADD KEY `type_`(`type_`);
ALTER TABLE `4_fiscal_year`
ADD UNIQUE KEY `begin`(`begin`),
ADD UNIQUE KEY `end`(`end`);
ALTER TABLE `4_gl_trans`
CHANGE `account` `account` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `tran_date`,
ADD KEY `account_and_tran_date`(`account`,`tran_date`),
ADD KEY `dimension2_id`(`dimension2_id`),
ADD KEY `dimension_id`(`dimension_id`),
ADD KEY `tran_date`(`tran_date`);
ALTER TABLE `4_grn_batch`
ADD KEY `delivery_date`(`delivery_date`),
ADD KEY `purch_order_no`(`purch_order_no`);
ALTER TABLE `4_grn_items`
ADD KEY `grn_batch_id`(`grn_batch_id`);
ALTER TABLE `4_item_codes`
ADD KEY `item_code`(`item_code`);
ALTER TABLE `4_purch_order_details`
ADD KEY `order`(`order_no`,`po_detail_item`);
ALTER TABLE `4_purch_orders`
ADD COLUMN `total` double NOT NULL DEFAULT 0 after `delivery_address`,
ADD COLUMN `tax_included` tinyint(1) NOT NULL DEFAULT 0 after `total`,
ADD KEY `ord_date`(`ord_date`);
ALTER TABLE `4_quick_entries`
ADD COLUMN `bal_type` tinyint(1) NOT NULL DEFAULT 0 after `base_desc`;
ALTER TABLE `4_quick_entry_lines`
CHANGE `dest_id` `dest_id` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `action`;
ALTER TABLE `4_refs`
ADD KEY `Type_and_Reference`(`type`,`reference`);
ALTER TABLE `4_sales_order_details`
ADD KEY `sorder`(`trans_type`,`order_no`);
ALTER TABLE `4_sales_orders`
ADD COLUMN `payment_terms` int(11) NULL after `delivery_date`,
ADD COLUMN `total` double NOT NULL DEFAULT 0 after `payment_terms`;
ALTER TABLE `4_stock_category`
CHANGE `dflt_sales_act` `dflt_sales_act` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `dflt_mb_flag`,
CHANGE `dflt_cogs_act` `dflt_cogs_act` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `dflt_sales_act`,
CHANGE `dflt_inventory_act` `dflt_inventory_act` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `dflt_cogs_act`,
CHANGE `dflt_adjustment_act` `dflt_adjustment_act` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `dflt_inventory_act`,
CHANGE `dflt_assembly_act` `dflt_assembly_act` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `dflt_adjustment_act`;
ALTER TABLE `4_stock_master`
CHANGE `sales_account` `sales_account` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `mb_flag`,
CHANGE `cogs_account` `cogs_account` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `sales_account`,
CHANGE `inventory_account` `inventory_account` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `cogs_account`,
CHANGE `adjustment_account` `adjustment_account` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `inventory_account`,
CHANGE `assembly_account` `assembly_account` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `adjustment_account`,
ADD COLUMN `editable` tinyint(1) NOT NULL DEFAULT 0 after `no_sale`;
ALTER TABLE `4_stock_moves`
ADD KEY `Move`(`stock_id`,`loc_code`,`tran_date`);
ALTER TABLE `4_supp_allocations`
ADD KEY `From`(`trans_type_from`,`trans_no_from`),
ADD KEY `To`(`trans_type_to`,`trans_no_to`);
ALTER TABLE `4_supp_invoice_items`
CHANGE `gl_code` `gl_code` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `supp_trans_type`,
ADD KEY `Transaction`(`supp_trans_type`,`supp_trans_no`,`stock_id`);
ALTER TABLE `4_supp_trans`
ADD COLUMN `tax_included` tinyint(1) NOT NULL DEFAULT 0 after `alloc`,
DROP KEY `PRIMARY`, add PRIMARY KEY(`type`,`trans_no`),
ADD KEY `tran_date`(`tran_date`);
ALTER TABLE `4_suppliers`
CHANGE `gst_no` `gst_no` varchar(25) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `supp_address`,
CHANGE `contact` `contact` varchar(60) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `gst_no`,
CHANGE `supp_account_no` `supp_account_no` varchar(40) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `contact`,
CHANGE `website` `website` varchar(100) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `supp_account_no`,
CHANGE `bank_account` `bank_account` varchar(60) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `website`,
CHANGE `curr_code` `curr_code` char(3) COLLATE latin1_swedish_ci NULL after `bank_account`,
CHANGE `payment_terms` `payment_terms` int(11) NULL after `curr_code`,
ADD COLUMN `tax_included` tinyint(1) NOT NULL DEFAULT 0 after `payment_terms`,
CHANGE `dimension_id` `dimension_id` int(11) NULL DEFAULT 0 after `tax_included`,
CHANGE `dimension2_id` `dimension2_id` int(11) NULL DEFAULT 0 after `dimension_id`,
CHANGE `tax_group_id` `tax_group_id` int(11) NULL after `dimension2_id`,
CHANGE `credit_limit` `credit_limit` double NOT NULL DEFAULT 0 after `tax_group_id`,
CHANGE `purchase_account` `purchase_account` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `credit_limit`,
CHANGE `payable_account` `payable_account` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `purchase_account`,
CHANGE `payment_discount_account` `payment_discount_account` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `payable_account`,
CHANGE `notes` `notes` tinytext COLLATE latin1_swedish_ci NOT NULL after `payment_discount_account`,
CHANGE `inactive` `inactive` tinyint(1) NOT NULL DEFAULT 0 after `notes`,
DROP COLUMN `phone`,
DROP COLUMN `phone2`,
DROP COLUMN `fax`,
DROP COLUMN `email`,
ADD KEY `supp_ref`(`supp_ref`);
CREATE TABLE `4_sys_prefs`(
`name` varchar(35) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' ,
`category` varchar(30) COLLATE latin1_swedish_ci NULL ,
`type` varchar(20) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' ,
`length` smallint(6) NULL ,
`value` tinytext COLLATE latin1_swedish_ci NULL ,
PRIMARY KEY (`name`) ,
KEY `category`(`category`)
) ENGINE=MyISAM DEFAULT CHARSET='latin1';
ALTER TABLE `4_tag_associations`
CHANGE `record_id` `record_id` varchar(15) COLLATE latin1_swedish_ci NOT NULL first;
ALTER TABLE `4_tax_types`
CHANGE `sales_gl_code` `sales_gl_code` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `rate`,
CHANGE `purchasing_gl_code` `purchasing_gl_code` varchar(15) COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `sales_gl_code`;
ALTER TABLE `4_trans_tax_details`
ADD KEY `tran_date`(`tran_date`),
ADD KEY `Type_and_Number`(`trans_type`,`trans_no`);
ALTER TABLE `4_useronline`
ADD KEY `ip`(`ip`);
ALTER TABLE `4_wo_issues`
ADD KEY `workorder_id`(`workorder_id`);
ALTER TABLE `4_wo_manufacture`
ADD KEY `workorder_id`(`workorder_id`);
ALTER TABLE `4_wo_requirements`
ADD KEY `workorder_id`(`workorder_id`);
=============
6,017 10/16/2012 03:50:36 am
Topic: FA <--> webERP Migration (0 replies, posted in Setup)
If you are migrating between FA and webERP or intending to choose between them, please read the Wiki article on it.
6,018 10/15/2012 08:36:43 am
Re: Frontaccounting Upgrade Error! (25 replies, posted in Installation)
Epilogue: popsicles12 contacted me offiline sending me the sql dump on one database and I found that many tables had to be altered for field types / sizes.
Free Advice and Free Diff File Sent:
Use the upgrade sql that I sent you in phpMyAdmin on the specific database (after taking a backup) and you will find the database upgraded correctly.
popsicles12 then did so appropriately and had this to say:
Thanks you so very much. The upgrade is done. I had to use the content of the table sys_pref in the 2.3 sql script that came with the 2.3.11 to fill in the data for the newly created table and then change the version number to 2.3rc, then I could login. It is working now.
Thanks so much, I really appreciate your contribution.
I do hope this will serve to assist others in a similar throe. popsicles12 bravado and persistence saw him thru.
6,019 10/15/2012 08:23:48 am
Re: Item and Category (5 replies, posted in Items and Inventory)
The following should be your categories if only one category is allowed:
Oil
Wine French White
Wine French Red
Wine Italian Piedmont Red
Wine Italian Piedmont White
Wine Italian Tuscany Red
Wine Italian Tuscany White
Wine Italian Sparkling
6,020 10/10/2012 01:48:51 am
Re: contact_email in sales_orders table (16 replies, posted in Accounts Receivable)
6,021 10/10/2012 01:16:01 am
Re: contact_email in sales_orders table (16 replies, posted in Accounts Receivable)
Debian Squeeze cups-bsd package (1.4.4-7+squeeze1) can provide for lpd on the server only. In the scenario where FA is a hosted service and the Printer is in another location (office) behind a NAT, would this work without VPN-ing to reside on the same lan?
Also, lpd does not work (?) outside of the LAN.
As for ipp://, it is more of a URI and port (631 instead of 515 for lpd) difference.
6,022 10/09/2012 01:17:15 pm
Re: Assets Management (8 replies, posted in Wish List)
WebERP has an extensive Asset Register module - check out their project page.
6,023 10/09/2012 01:14:14 pm
Re: Frontaccounting Upgrade Error! (25 replies, posted in Installation)
Contact me offline if you are still stuck - will need schema dump of all databases - zipped. Later will need data dump of standard data tables alone - zipped. Also see if you are using legacy roles or not.
6,024 10/09/2012 01:08:20 pm
Re: contact_email in sales_orders table (16 replies, posted in Accounts Receivable)
Now this thread has got hijacked into a different topic - Sorry.
The demo sql file has the LPD host name as server. Must it be merely a domain, ip or URI? The newer ipp (internet Printing Protocol) supports Port 631. Used to print from one Ubuntu 12.04 to another behind a NAT (opening TCP and UDP ports 2207/8 and 631) and uses http://ip/printers/[print-queue-name] and it does not work on FA.
6,025 10/09/2012 02:22:13 am
Re: spotmouth provides free FA hosting (1 replies, posted in Jobs wanted/offered, non-free offers)
Please have a look at the www.owncloud.org stackato branch repo for the file:
owncloud/config/autoconfig.php - Ref
It illustrates how data from such a file can be injected into the last page of the install process and have the application setup easily - no needless checks at all - for standard same type installs.
This might be a useful addon for FA as well.