dave, as a matter of fact the system does not remove and does not rewrite the key values during the update process. Because otherwise it will create confusion for existing sites as it may overwrite the changes have made by the administrator before.
Sometimes there may be some cases when the development team need to completely change the existing values for all already created sites and for the future installed sites. So in this case  they will  add a new language key and its value and the new key will be defined in the code instead the old one. In that way the old keys becomes a junk keys. Over time there could be accumulated a lot of such keys.  Once in a while, we do sweep the database but this is a resource intensive process because it does not automated and done rarely.

So the possible solution is to delete the missing keys manually. If you use only the English language pack and do not use any other,  then most likely the all missing keys you have are dead, and you can delete them. The only thing, that you have to remove them manually one by one. You can do it via dev-tools: domain.com/admin/dev-tools/languages .

Thanks so much Taissa :)  

Actually what i could do is just do a query and delete any lang key via phpMyadmin that is null and has no value, i really dont want to have to do 113 time button pushing lol... 

of course ill back it up first..   

Just curious how do you pronounce your name, is it  Ty eee sa, or Tessa

dave, I can not suggest forum users deleting empty values via database because it may break the software if you don't have sufficient knowledges and programming skills.
You will need to write a script to connect prefix, key and value tables and it's records in order to do that properly.

Concerning the name :) It pronounced as [təˈiːsə] .

well i have been a php programmer for 10 years and also know cobol, fortran, assembly from the old days as well as JCL from the IBM mainframe days.  And have been working with phpMyAdmin for 6 years now.   I have my own software developed as well as other projects so i think i might be qualified lol hee hee .... just being funny :) 

I did do a query and it found nothing so either my query is not picking up the null values or im not searching for the right data or the languages mod is wrong.   So ill have to look in files at the PDO i guess and see what it looks for.   

Do you happen to know where that is? what file? 

I am planning for my next project a language cleaner utility, which is one reason i ask i want to be sure i do it right. 

I know there are three tables   keys, value, prefix, language  

thanks 

ps i did find the rows in the db, i had to do a query as search would not find them. 

But before i dive into a project here, i need to know the Oxwall's position on the empty values.  Does Oxwall recommend keeping the lang tables clean or does Oxwall want users to just leave them alone and wait for Oxwall to provide a solution one day.  

I dont want to complete a utility project only to find out that Oxwall's position is to leave them alone, that would be a disaster lol. 

Thanks please advise

well its done, the project  Language Cleaner is in for moderation and its free folks... enjoy 

sweet

dave, as far as I know we do have plans to clean the language key table, but it won't happen soon, as you know Oxwall is a small team and we have more important cases to fix and develop.
And if you have developed the Language Cleaner plugin, then this is required functionality indeed.

Yes mam Taissa i agree...  but why wait, lets be proactive rather than reactive. :)   Thats why i did it for free. 

 Yes i have a Language Cleaner plugin in the store under moderation now. Take a peek and see what you think.  I think it works well and can be improved over time to meet the needs of everyone. 

Hope this helps... :)  I know your about out of there for the evening Taissa so have a great evening.