Database error when updating more than one item row in Sales Orders.
[fa-stable.git] / CHANGELOG.txt
1 /**
2 * @version $Id$
3 * @package FrontAccounting
4 * @copyright (C) 2005 - 2007 FrontAccounting
5 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
6 * FrontAccounting is Free Software
7 */
8
9 1. Changelog
10 ------------
11 This is a changelog for FrontAccounting All releases.
12
13 Legend:
14
15 # -> Bug Fix
16 + -> Addition
17 ! -> Change
18 - -> Removed
19 ! -> Note
20 $ -> Affected files
21
22 04-May-2007 Joe Hunt
23  # Database error when updating more than one item row in Sales Orders.
24  $ /sales/includes/db/sales_order_db.inc
25  # Database error when inserting work order issues. Fixed.
26  $ /manufacturing/includes/db/work_order_issues_db.inc
27  
28 03-May-2007 Joe Hunt
29  # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses.
30  $ /includes/db/manufacturing_db.inc
31    /manufacturing/includes/db/work_order_requirements_db.inc
32
33
34 02-May-2007 Joe Hunt
35  # Missing details on Purchase Order when emailing and printing
36  $ /reporting/rep209.php
37  
38 -------------------- 1.1 Stable Released ----------------------
39 02-May-2007 Joe Hunt
40  + Enabled module addons and all the below bugfixes. No changes in database structure.
41  - Removed /sql/basic.sql (included in the other sql files)
42  - Removed /themes/default/images/left.gif and /themes/default/images/right.gif 
43    (not needed anymore).
44  + Addition of update.html  
45  $ /admin/inst_module.php (New file!)
46    /applications/customers.php
47    /applications/dimensions.php
48    /applications/generalledger.php
49    /applications/inventory.php
50    /applications/manufacturing.php
51    /applications/setup.php
52    /applications/suppliers.php
53    /install/index.php
54    /install/save.php
55    /modules/inst_modules.php (New folder and new file!)
56    /modules/index.php (New file!)
57    /sql/en_US-demo.sql
58    /sql/en_US-new.sql
59    install.html
60    update.html (New file!)
61    
62
63 01-May-2007 Joe Hunt
64  # Missing measure of units when printing sales orders
65  # Update of Sales People caused a database error
66  $ /sales/manage/sales_people.php
67    /reporting/rep109.php
68  
69 30-Apr-2007 Joe Hunt
70  + The selected menu tab is now shown with same background as hover color.
71  $ config.php (default tab line 77. Change if you want)
72    /includes/page/header.inc
73    
74 28-Apr-2007 Joe Hunt
75  # When saving work order entries a lot of debug boxes appeared. Fixed
76  # When clicking on the link, Issue, on work order inquires an empty screen appeared. Fixed
77  # When retrieving work centres id's there was a database error. Fixed by casting string to unsigned
78  $ /includes/db/manufacturing_db.inc
79    /manufacturing/work_order_entry.php
80    /manufacturing/includes/work_order_issue_ui.inc
81    /manufacturing/includes/db/work_order_requirements_db.inc
82    /manufacturing/includes/db/work_orders_quick_db.inc
83    /manufacturing/inquiry/where_used_inquiry.php
84    
85 25-Apr-2007 Joe Hunt
86  # Missing Date Picker
87  $ /sales/customer_invoice.php
88  # No JS popup window
89  $ /sales/view/view_invoice.php
90  
91 24-Apr-2007 Joe Hunt
92  ! New and better Date Picker, better cool theme.
93  $ /includes/ui/ui_input.inc
94    /includes/ui/ui_view.inc
95    /reporting/includes/reports_classes.inc
96    /themes/cool/default.css
97
98 -------------------- 1.0.1 Stable Released ----------------------
99 23-Apr-2007 Joe Hunt
100  ! Release 1.0.1 established on SourceForge, fixing the bugs and including a Date Picker,
101    the changes for selection lists customers/suppliers and the Audit Trail.
102
103 22-Apr-2007 Joe Hunt
104  ! Changed the two selection lists for customers/suppliers in reports to a single one with
105    No Filter
106  ! Changed the sort order in these selection lists from id to name.
107  + Added Audit Trail in GL trans. A switch in config.php, $use_audit_trail, must be set to 1.
108  $ /reporting/reports_main.php
109    /reporting/rep101.php
110    /reporting/rep102.php
111    /reporting/rep201.php
112    /reporting/rep202.php
113    /reporting/rep203.php
114    /reporting/rep204.php
115    /reporting/includes/reports_classes.inc
116    /includes/ui/ui_lists.inc
117    /gl/includes/db/gl_db_trans.inc
118    config.php
119    
120 22-Apr-2007 Joe Hunt
121  + Date Picker for all date fields.
122  $ config.php
123    /admin/fiscalyears.php
124    /admin/void_transaction.php
125    /includes/ui/ui_view.inc
126    /includes/ui/ui_input.inc
127    /dimensions/dimension_entry.php
128    /dimensions/inquiry/search_dimensions.php
129    /gl/gl_journal.php
130    /gl/gl_deposit.php
131    /gl/gl_payment.php
132    /gl/bank_transfer.php
133    /gl/inquiry/bank_inquiry.php
134    /gl/inquiry/gl_account_inquiry.php
135    /gl/inquiry/gl_trial_balance.php
136    /gl/manage/exchange_rates.php
137    /inventory/adjustments.php
138    /inventory/transfers.php
139    /inventory/inquiry/stock_movements.php
140    /inventory/manage/items.php
141    /manufacturing/work_order_add_finished.php
142    /manufacturing/work_order_entry.php
143    /manufacturing/work_order_issue.php
144    /manufacturing/work_order_release.php
145    /purchasing/supplier_payment.php
146    /purchasing/po_entry_items.php
147    /purchasing/po_receive_items.php
148    /purchasing/supplier_credit.php
149    /purchasing/supplier_credit_grns.php
150    /purchasing/supplier_invoice.php
151    /purchasing/supplier_invoice_grns.php
152    /purchasing/supplier_trans_gl.php
153    /purchasing/includes/ui/po_ui.inc
154    /purchasing/inquity/po_search.php
155    /purchasing/inquiry/po_search_completed.php
156    /purchasing/inquiry/supplier_allocation_inquiry.php
157    /purchasing/inquiry/supplier_inquiry.php
158    /reporting/reports_main.php
159    /reporting/includes/reports_classes.inc
160    /sales/credit_note_entry.php
161    /sales/customer_credit_invoice.php
162    /sales/customer_payments.php
163    /sales/sales_order_entry.php
164    /sales/includes/ui/sales_order_ui.inc
165    /sales/inquiry/customer_allocation_inquiry.php
166    /sales/inquiry/customer_inquiry.php
167    /sales/inquiry/sales_orders_view.php
168    New image files:
169    /themes/default/images/cal.gif
170    /themes/default/images/next.gif
171    /themes/default/images/prev.gif
172
173 19-Apr-2007 Joe Hunt
174  # Bug no 1703895, Account numbers are varchars, need quotes, fixed
175  # Bug no 1703891, Reserved MySQL words used as column names, fixed
176  $ /taxes/db/tax_types_db.inc
177
178  # Bug no 1703888, Apostrophes and other unescaped characters, fixed
179  $ /gl/manage/gl_accounts.php
180    /gl/includes/db/gl_db_accounts.inc
181    /includes/ui/ui_input.inc
182
183 18-Apr-2007 Joe Hunt
184  # Bug no 1702594, Logon Loop, fixed
185  $ config.php
186
187 -------------------- 1.0a Stable Released ----------------------
188 10-Apr-2007 Joe Hunt
189  ! Release 1.0a established on SourceForge, fixing the bugs.
190
191 11-Apr-2007 Joe Hunt
192  # Bug No 1698214, Creating Items, fixed
193  $ /includes/ui/ui_lists.inc
194  # Bug no 1698216, Item Movements, fixed
195  $ /inventory/manage/items.php
196
197 -------------------- 1.0 Stable Released ----------------------
198 10-Apr-2007 Joe Hunt
199  ! Release 1.0 established on SourceForge.
200
201 2. Copyright and disclaimer
202 ---------------------------
203 This application is opensource software released under the GPL.  Please
204 see source code and the LICENSE file