I'm getting the following error in my logs (ellipsis in place of directory names):
PHP Fatal error: 1146:Table '... .media_format' doesn't exist :: select format_id, format_name
from media_format order by format_name ==> (as called by) /home/.../public_html/.../.../includes/modules/product_music/collect_info.php on line 96 <== in /home/.../public_html/.../includes/classes/db/mysql/query_factory.php on line 171
However the table clearly exists in my database with both referenced fields (format_id and format_name) in it.
In my Admin Extras, the field also appears with all values present but the text "TABLE_HEADING_MEDIA_FORMAT" appears at the top of the field values list, and "TEXT_DISPLAY_NUMBER_OF_FORMAT" appears below the list. In addition, the new field appears twice in the Extras drop-down menu.
Store product pages show the error warning: WARNING: An Error occurred, please refresh the page and try again.

There is one place in the database where it appears to be missing. That is in Table: product_music_extra where I see:
Action Keyname Type Unique Packed Column Cardinality Collation Null Comment
Edit Edit Drop Drop PRIMARY BTREE Yes No products_id 604 A No
Edit Edit Drop Drop idx_music_genre_id_zen BTREE No No music_genre_id 20 A No
Edit Edit Drop Drop idx_artists_id_zen BTREE No No artists_id 120 A No
Edit Edit Drop Drop idx_record_company_id_zen BTREE No No record_company_id 46 A No

Had this working briefly, but messed it up somehow. It appears I may have dropped a column in another table. (?) But I can't be sure as I am relatively new to working with databases and phpMyAdmin. Is there a ZC or database expert here who can recognize this behavior and tell me what I may have deleted (or added) to cause this?