Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Aquidneck
-
Fix Version/s: 2.0.0, sprint 13: 11-28-2012, Aquidneck
-
Component/s: None
-
Labels:None
-
Sprint:Sprint 12, Sprint 13
Description
I have updated the business areas and categories on the QA environment and noticed that the sql tables have a blank entry for each row that was supposed to be active. The csv tables indicate these should be set to active. The load_business_areas.sql and load_business_categories.sql is doing something incorrectly with the active status entries.
Here's a sample of the loaded BAs (note the shorter IDs):
mysql> select * from businessAreas limit 10;
---------------------------------
| id | description | status |
---------------------------------
| 10001 | Spa Resorts | |
| 10002 | Hotels | |
| 10003 | Motels | |
| 10004 | Bed & Breakfasts | |
| 10005 | Resorts | |
| 10006 | Campgrounds | |
| 10007 | Vacation Rentals | |
| 10008 | Hostels | |
| 10009 | Forensic Accountants | |
| 10010 | Business Accountants |
---------------------------------
Here's a sample of the loaded BCs (note that I see all of these even though some are deprecated):
mysql> select * from businessCategories limit 10;
-------------------------------------
| id | description | status |
-------------------------------------
| 1 | Accommodation | |
| 2 | Accountants | deprecated |
| 3 | Addiction Treatment | |
| 4 | Adhesives & Sealants | deprecated |
| 5 | Administrative Services | |
| 6 | Adoption Services | deprecated |
| 7 | Advertising Agencies | |
| 8 | Air Conditioning | deprecated |
| 9 | Airports | |
| 10 | Amusement Parks | deprecated |
-------------------------------------