Data too long for column 'language'

This looks like your PO file is broken. Can you post the first 30 lines of your de.po file for the theme here?

Ah, I see. This might have something to do with how the language code is computed there, which looks quite interesting.

Hm, this is the code which tried to find out the language code from the filename:

function _locale_batch_import($filepath, &$context) {
  include_once 'includes/locale.inc';
  // The filename is either {langcode}.po or {prefix}.{langcode}.po, so
  // we can extract the language code to use for the import from the end.
  if (preg_match('!(/|\.)([^\.]+)\.po$!', $filepath, $langcode)) {
    $file = (object) array('filename' => basename($filepath), 'filepath' => $filepath);
    _locale_import_read_po('db-store', $file, LOCALE_IMPORT_KEEP, $langcode[2]);
    $context['results'][] = $filepath;
  }
}

This matches file path endings like "/de.po" or "something.de.po". Seems like the ([^\.]+) part is a bit too greedy here, and it should also exclude slashes. Please try to use the '!(/|\.)([^\./]+)\.po$!' pattern (so we exclude / from the language code we match against), and report results.

Thanks, patch committed.

The idea of course is that every module would have a translations subfolder with files *for that module* per language. This allows us to only load what's really required, and not load extra stuff, which would be unused and would slow down your site. Example tarball: http://drupal.org/node/176141 Now extractor.php / potx-cli.php generated files can be automatically packaged to this kind of tarballs with po-packager: http://cvs.drupal.org/viewvc.py/drupal/contributions/tricks/po-packager/ Although this is just a dirty trick for now, and there supposed to be a better solution for translators which will autogenerate tarballs in this format. See http://hojtsy.hu/drop/LocalizationServer.swf This is still in the works, but it accessible and possible to try out: http://drupal.org/project/l10n_server A copy of this will be hosted at drupal.org to provide a central collaboration interface for translations.