wxr file error importing (sql issue [#1254396]

It might be a Postgresql thing, but when importing a site, the following error appears:

PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "1313765754943.5" LINE 1: ...ighwater) VALUES ('JonGriffinsBlogCategory', '1', '131376575... ^: INSERT INTO migrate_log (machine_name, process_type, starttime, initialHighwater) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( ) in MigrationBase->beginProcess() (line 700 of /var/www/sites/jongriffin.com/drupal-7/sites/all/modules/migrate/includes/base.inc).

The problem is that unlike MySQL, Postgres actually checks types. You are sending a float to an integer for starttime.

I will try for a patch, but I don't have a lot of time to test it.

Comments

Comment #1

tresero commented 19 August 2011 at 15:09

Changing the field types to real fixes the problem. I will let a dev create a patch.

microtime returns a decimal point, hence postgresql will not accept that in a bigint field.

Comment #2

melinda.jackson commented 10 November 2011 at 18:45

I'm having the same issue.

PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "1320700018188.2" LINE 1: ...itialHighwater) VALUES ('AllyStyleGuideTag', '1', '132070001... ^: INSERT INTO styleguidemigrate_log (machine_name, process_type, starttime, initialHighwater) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( ) in MigrationBase->beginProcess() (line 738 of /Library/Server/Web/Data/Sites/drupal/sites/all/modules/migrate/includes/base.inc)