Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-754

businessAreas and businessCategories tables have blank status entries while expecting active

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 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

      -------------------------------------

        Attachments

          Activity

            People

            • Assignee:
              indika Indika Rajakaruna (Inactive)
              Reporter:
              jeff.brown Jeff Brown (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: