relation "locales_source" does not exist

1. create postgres db

  createuser --pwprompt --encrypted --no-adduser --no-createdb drupaladm
  createdb --encoding=UNICODE --owner=drupaladm drupal

2. add it to settings.php

$databases['default']['default'] = array (
      'driver' => 'mysql',
      'database' => 'drupal',
      'username' => 'drupaladm',
      'password' => 'secret',
      'host' => 'localhost',
      'port' => '',
      'prefix' => '',
);
$databases['postgres']['default'] = array (
      'driver' => 'pgsql',
      'database' => 'drupal',
      'username' => 'drupaladm',
      'password' => 'secret',
      'host' => 'localhost',
      'port' => '',
      'prefix' => '',
);

(this is different from your blog post, where $databases['default']['default'] and $databases['default']['pgsql'] was used, which I tried first, but with this, the second database entry did not show up in the Migrator database list)

3. several attempts with the gui (resetting the postgres db with dropdb/createdb after each)

4. run the drush command as given above to get a better readable output

(Perhaps I should mention that some days ago I migrated the mysql database from a host with 5.0 to the current with 5.1. With this I had an issue (http://drupal.org/node/998474), which I solved by truncating search_index and search_total tables.)

Additional info: Drupal version is 7.4. Enabled modules are:

default # drush pm-list|grep Enabled
 Core         Block (block)                  Module  Enabled        7.4
 Core         Book (book)                    Module  Enabled        7.4
 Core         Color (color)                  Module  Enabled        7.4
 Core         Comment (comment)              Module  Enabled        7.4
 Core         Contextual links (contextual)  Module  Enabled        7.4
 Core         Dashboard (dashboard)          Module  Enabled        7.4
 Core         Database logging (dblog)       Module  Enabled        7.4
 Core         Field (field)                  Module  Enabled        7.4
 Core         Field SQL storage              Module  Enabled        7.4
 Core         Field UI (field_ui)            Module  Enabled        7.4
 Core         File (file)                    Module  Enabled        7.4
 Core         Filter (filter)                Module  Enabled        7.4
 Core         Help (help)                    Module  Enabled        7.4
 Core         Image (image)                  Module  Enabled        7.4
 Core         List (list)                    Module  Enabled        7.4
 Core         Locale (locale)                Module  Enabled        7.4
 Core         Menu (menu)                    Module  Enabled        7.4
 Core         Node (node)                    Module  Enabled        7.4
 Core         Number (number)                Module  Enabled        7.4
 Core         Options (options)              Module  Enabled        7.4
 Core         Path (path)                    Module  Enabled        7.4
 Core         RDF (rdf)                      Module  Enabled        7.4
 Core         Search (search)                Module  Enabled        7.4
 Core         Shortcut (shortcut)            Module  Enabled        7.4
 Core         System (system)                Module  Enabled        7.4
 Core         Taxonomy (taxonomy)            Module  Enabled        7.4
 Core         Text (text)                    Module  Enabled        7.4
 Core         Toolbar (toolbar)              Module  Enabled        7.4
 Core         Update manager (update)        Module  Enabled        7.4
 Core         User (user)                    Module  Enabled        7.4
 DBTNG        DBTNG Migrator                 Module  Enabled        7.x-1.x-dev
 Lightweight  LDAP Authentication            Module  Enabled        7.x-1.0-bet
 Lightweight  LDAP Servers (ldap_servers)    Module  Enabled        7.x-1.0-bet
 Multilingua  Localization update            Module  Enabled        7.x-1.x-dev
 Other        Diff (diff)                    Module  Enabled        7.x-2.0-bet
 Other        Node to alternate formats      Module  Enabled        7.x
 Printer,     Printer-friendly pages         Module  Enabled        7.x-1.x-dev
 User         ak_cleanup (ak_cleanup)        Module  Enabled        7.x
 User         ak_editor (ak_editor)          Module  Enabled        7.x
 User         Wysiwyg (wysiwyg)              Module  Enabled        7.x-2.1
 Core         Bartik (bartik)                Theme   Enabled        7.4
 Core         Seven (seven)                  Theme   Enabled        7.4
 Sonstige     Zen (zen)                      Theme   Enabled        7.x-3.1

After recreating the database with "encoding=UTF-8", I executed Migrator in GUI and got the errors below.

Again, only block and block_bid_seq where created. Maybe there occurs a problem after adding the sequence?

The postgres version is postgresql-8.4.7-1.el6_0.1.x86_64 on centos 6.0

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /cms/?q=batch&id=31&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "locales_source" does not exist LINE 1: SELECT s.lid, t.translation, s.version FROM locales_source s... ^: SELECT s.lid, t.translation, s.version FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = :language WHERE s.source = :source AND s.context = :context AND s.textgroup = 'default'; Array ( [:language] => de [:source] => @table was successfully created. [:context] => ) in locale() (Zeile 676 von /opt/cms/modules/locale/locale.module).Uncaught exception thrown in shutdown function.PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "semaphore" does not exist LINE 1: DELETE FROM semaphore ^: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 2175106754e3078d0638e87.84210880 ) in lock_release_all() (line 266 of /opt/cms/includes/lock.inc).Uncaught exception thrown in session handler.PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "sessions" does not exist LINE 3: sessions sessions ^: SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ) FOR UPDATE; Array ( [:db_condition_placeholder_0] => ghssICYUU_FdNR8sc5NKJWsID9NGuIRQIV8DkNdzpGw [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 203 of /opt/cms/includes/session.inc).

sorry for the stupid question - I don't know where to find git repository and the updated file (quit new to drupal, and to git, too).

ok - figured it out (I really had to learn it).

The GUI migration went to 100%, and a lists of successfully updated modules was displayed, but at the end an error message occurs:

SQLSTATE[42703]: Undefined column: 7 ERROR: column "l10n_status" of relation "locales_target" does not exist LINE 1: ...target (lid, translation, language, plid, plural, l10n_statu... ^

With drush dbtng-replicate default postgres, the error message cited above comes first, and then the list of successfully created tables/modules.

locales_target.l10n_status is indeed missing in the newly created postgres database. However, Drupal seems to work already fine with it - I can navigate, add new content, etc.!

I have gone through some database migrations, and it's unbelievable, that this one worked just on a mouse click!!

It is in the mysql database:

mysql> describe locales_target;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| lid         | int(11)     | NO   | PRI | 0       |       |
| translation | blob        | NO   |     | NULL    |       |
| language    | varchar(12) | NO   | PRI |         |       |
| plid        | int(11)     | NO   | MUL | 0       |       |
| plural      | int(11)     | NO   | PRI | 0       |       |
| l10n_status | int(11)     | NO   |     | 0       |       |
+-------------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

Perhaps it was added by the l10n_update module.

Ok, I see. Uninstalling and reinstalling l10n_update fixed the missing column.

Thank you so much for your kind and immediate help. It's really amazing to work togesther across so many time zones.

And thanks again you for this uncredible module!

Unfortunately, the error described above shows up again.

As I could verify, the field locales_target.l10n_status is added by the current 7.x-1.0-beta2 version of Localization update module during l10n_update.install.

As a result of the error, the column is not copied.

Hi Josh,

Thank you for looking into this once again!

I tried it today on a completely different Drupal installation (different purpose, different machines, different modules installed, different database server - so also postgresql, German as second language and l10n_update installed). To clear the schema cache, before "drush dbtng-replicate" I executed

drush php-eval "cache_clear_all('schema', 'cache');"

on the source (and also on the target) machine, but again got

SQLSTATE[42703]: Undefined column: 7 ERROR: column "l10n_status" of relation "locales_target" does not exist at character 71

I have no idea if this was caused by a flaw in l10n_upate (7.x-1.0-beta2), in dbtng_migrator (7.x-1.0) or drupal core (7.10) itself, or most likely by some mistake on my side (given my weak experience with drupal and php). Is there something I could do to make the problem reproduceable?

Neither
drush php-eval "print_r(drupal_get_schema('l10n_update'));"
nor
drush php-eval "print_r(drupal_get_schema('l10n_update', TRUE));"
give any results (drush php-eval "print_r(drupal_get_schema('node', TRUE));" does).

The database definitions in the source database are:

  # drush php-eval "print_r(drupal_get_schema('l10n_update', TRUE));"
  # drush sqlc
  psql (8.4.9)
  Type "help" for help.

  drupal_labs=> \d l10n*
                          Table "public.l10n_update_file"
      Column    |          Type          |               Modifiers
  --------------+------------------------+----------------------------------------
   project      | character varying(50)  | not null
   language     | character varying(12)  | not null
   type         | character varying(50)  | not null default ''::character varying
   filename     | character varying(255) | not null default ''::character varying
   fileurl      | character varying(255) | not null default ''::character varying
   uri          | character varying(255) | not null default ''::character varying
   timestamp    | integer                | default 0
   version      | character varying(128) | not null default ''::character varying
   status       | integer                | not null default 1
   last_updated | integer                | default 0
   last_checked | integer                | default 0
   import_date  | integer                | default 0
  Indexes:
      "l10n_update_file_pkey" PRIMARY KEY, btree (project, language)

  Index "public.l10n_update_file_pkey"
    Column  |         Type
  ----------+-----------------------
   project  | character varying(50)
   language | character varying(12)
  primary key, btree, for table "public.l10n_update_file"

                         Table "public.l10n_update_project"
      Column    |          Type          |               Modifiers
  --------------+------------------------+----------------------------------------
   name         | character varying(50)  | not null
   project_type | character varying(50)  | not null
   core         | character varying(128) | not null default ''::character varying
   version      | character varying(128) | not null default ''::character varying
   l10n_server  | character varying(255) | not null default ''::character varying
   l10n_path    | character varying(255) | not null default ''::character varying
   status       | integer                | not null default 1
  Indexes:
      "l10n_update_project_pkey" PRIMARY KEY, btree (name)

  Index "public.l10n_update_project_pkey"
   Column |         Type
  --------+-----------------------
   name   | character varying(50)
  primary key, btree, for table "public.l10n_update_project"


  drupal_labs=> \d locales_target
                          Table "public.locales_target"
     Column    |         Type          |               Modifiers
  -------------+-----------------------+----------------------------------------
   lid         | integer               | not null default 0
   translation | text                  | not null
   language    | character varying(12) | not null default ''::character varying
   plid        | integer               | not null default 0
   plural      | integer               | not null default 0
   l10n_status | integer               | not null default 0
   i18n_status | integer               | not null default 0
  Indexes:
      "locales_target_pkey" PRIMARY KEY, btree (language, lid, plural)
      "locales_target_lid_idx" btree (lid)
      "locales_target_plid_idx" btree (plid)
      "locales_target_plural_idx" btree (plural)

  drupal_labs=> \q
  #

comment deleted (subject was i18n_status)

Workarround:

drush -y pm-disable l10n_update
drush -y pm-uninstall l10n_update
drush -y en l10n_update

(recreates the required field)