Database error when compiling lang

I have just upgraded to 702, and on 701 and 702 I am having issues with lang files. I am getting a database error.

I get this when i try to recompile languages in tools

INSERT INTO `sys_localization_keys`(`IDCategory`, `Key`) VALUES('2', '_bx_ads_added_spy')

this is the error I am getting on upgrade

it goes on longer

Array
(
    [1] => Array
        (
            [file] => /home/bykespac/public_html/upgrade/classes/BxDolUpgradeDb.php
            [line] => 215
            [function] => error
            [class] => BxDolUpgradeDb
            [type] => ->
            [object] => BxDolUpgradeDb Object

You have reached the limit of max field value. I suggest you to change the type of key id field for all these tables:

ALTER TABLE `sys_localization_string_params` CHANGE `IDKey` `IDKey` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `sys_localization_strings` CHANGE `IDKey` `IDKey` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `sys_localization_keys` CHANGE `ID` `ID` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;

Ticket is also created to avoid such problems in the future: http://www.boonex.com/trac/dolphin/ticket/2217

that did it, thanks, now if i could just find out why all my mods are still 1.0.0 when I am running 7.0.3

Module version is updated at the last stage. If it is not updated then some update instructions was not applied. Since it is still 1.0.0, then upgrade from 7.0.0 to 7.0.1 was not applied properly, or incomplete.

It is difficult to apply it now, because 2 more upgrades were applied after that. The only way is to try to do it manually - but you need good SQL experience to check all SQL modules (which still have 1.0.0 version number) queries from 7.0.1 upgrade patch  and compare them with database if they were applied, and if not - try to apply them manually.

Also if module data is not important - you can reinstall the module, it will recreate all SQL instructions from the scratch.

well, so far if I uninstall each mod, then reinstall it, they become 1.0.3, but I don't want to lose the content in the others, If I back them up then try it, will I be able to apply the content to the new mods? or will it only work for the old version?

I am not that good with sql, I can edit them, but I am not sure what you mean by comparing each

Then reinstall modules with not-important content and hire someone to apply SQL queries manually for the rest modules. It will require applying all the patches 7.0.1, 7.0.2, 7.0.3 for 1.0.0 modules manually.