Duplicate Entries in Database

Old 02-07-2011, 12:08 AM
FitDay Member
Thread Starter
Join Date: Feb 2011
Posts: 2
Exclamation Duplicate Entries in Database

Within, if you search on "fennel bulb raw", you will find multiple entries for various forms of the food; however, up top, you will notice that there are two entries for "fennel bulb raw" specifically, both differing ONLY in a comma placement:

Fennel bulb, raw (1 oz = 4.5 calories)

Fennel, bulb, raw (1 oz = 8.8 calories)

It wouldn't be so bad and I wouldn't care so long as the calories matched up in the serving size, but they don't. That's problematic and makes me question the validity of other entries or more common things, like green beans or lettuce, which are both so varied.
wwcitizen is offline  
Old 02-07-2011, 12:38 AM
FitDay Premium Member
mecompco's Avatar
Join Date: May 2010
Posts: 2,621

Thank you for pointing that out. I'm sure in a database with thousands of records there are bound to be some inconsistancies. Even food nutritional lables have been found to be, in some cases, grossly inaccurate.

Unless there is a big difference, I don't lose much (any) sleep over it. I do, agree that it would be a good idea to clean up the database as much as possible and I will create a thread for the admins.

mecompco is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Contact Us - Manage Preferences - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service

Copyright © 2021 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.