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