I dont see a problem with the two files you provided. Are you sure you have specified a gender ratio value for your adoptables already? Please show me the contents in your prefix_adoptables and prefix_owned_adoptables so we can work this out. Also make sure the new row genderratio looks like this:
If you somehow have 'latin1_general_ci' in it, please leave that part blank since it may convert your integer values into a string or unrecognizable characters.