{"action":"created","issue":{"url":"https://api.github.com/repos/AnatolyUss/FromMySqlToPostgreSql/issues/33","repository_url":"https://api.github.com/repos/AnatolyUss/FromMySqlToPostgreSql","labels_url":"https://api.github.com/repos/AnatolyUss/FromMySqlToPostgreSql/issues/33/labels{/name}","comments_url":"https://api.github.com/repos/AnatolyUss/FromMySqlToPostgreSql/issues/33/comments","events_url":"https://api.github.com/repos/AnatolyUss/FromMySqlToPostgreSql/issues/33/events","html_url":"https://github.com/AnatolyUss/FromMySqlToPostgreSql/issues/33","id":141142766,"number":33,"title":"Success is reported, but there are many PDO errors and no database is created","user":{"login":"agbodike","id":6569567,"avatar_url":"https://avatars.githubusercontent.com/u/6569567?v=3","gravatar_id":"","url":"https://api.github.com/users/agbodike","html_url":"https://github.com/agbodike","followers_url":"https://api.github.com/users/agbodike/followers","following_url":"https://api.github.com/users/agbodike/following{/other_user}","gists_url":"https://api.github.com/users/agbodike/gists{/gist_id}","starred_url":"https://api.github.com/users/agbodike/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agbodike/subscriptions","organizations_url":"https://api.github.com/users/agbodike/orgs","repos_url":"https://api.github.com/users/agbodike/repos","events_url":"https://api.github.com/users/agbodike/events{/privacy}","received_events_url":"https://api.github.com/users/agbodike/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-03-16T01:17:58Z","updated_at":"2016-03-17T05:24:29Z","closed_at":null,"body":"When running the script, it reports success, but I see a number of errors and no database is created. Each time I run it, the database name is incremented.\r\n\r\nMy relevant JSON config (everything else remains unchanged):\r\n\r\n```\r\n\"source\" : \"mysql:host=localhost;port=3306;charset=UTF8;dbname=development_db,root,\",\r\n\"target\" : \"pgsql:host=localhost;port=5432;dbname=mysql_import;options=--client_encoding=UTF8,agbodike,\",\r\n```\r\n\r\nall.log (some select errors):\r\n```\r\n\t\"FromMySqlToPostgreSql\" - the database migration tool\r\n\tCopyright 2015  Anatoly Khaytovich <anatolyuss@gmail.com>\r\n\t-- Migration began...\r\n-- New schema \"development_db_6\" was successfully created...\r\n-- 45 tables detected\r\n\r\n...\r\n\r\n\t-- PDOException code: 22P02\r\n\t-- File: /Users/agbodike/workspace/agbodike/FromMySqlToPostgreSql/migration/FromMySqlToPostgreSql/FromMySqlToPostgreSql.php\r\n\t-- Line: 800\r\n\t-- Message: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: \"''\"\r\nCONTEXT:  COPY baselines, line 1, column attachment_file_size: \"''\"\r\n\t-- SQL: COPY \"development_db_6\".\"baselines\" FROM '/Users/agbodike/workspace/agbodike/FromMySqlToPostgreSql/temporary_directory/baselines0.csv' DELIMITER ',' CSV;\r\n\r\n...\r\n\r\n\t-- PDOException code: 22007\r\n\t-- File: /Users/agbodike/workspace/agbodike/FromMySqlToPostgreSql/migration/FromMySqlToPostgreSql/FromMySqlToPostgreSql.php\r\n\t-- Line: 800\r\n\t-- Message: SQLSTATE[22007]: Invalid datetime format: 7 ERROR:  invalid input syntax for type timestamp: \"''\"\r\nCONTEXT:  COPY credit_cards, line 1, column deleted_at: \"''\"\r\n\t-- SQL: COPY \"development_db_6\".\"credit_cards\" FROM '/Users/agbodike/workspace/agbodike/FromMySqlToPostgreSql/temporary_directory/credit_cards0.csv' DELIMITER ',' CSV;\r\n\r\n...\r\n\r\n\t-- FromMySqlToPostgreSql::processForeignKey\r\n\t-- Error occurred when tried to create foreign key for table \"development_db_6\".\"baseline_users\"...\r\n\r\n\t-- PDOException code: 23503\r\n\t-- File: /Users/agbodike/workspace/agbodike/FromMySqlToPostgreSql/migration/FromMySqlToPostgreSql/FromMySqlToPostgreSql.php\r\n\t-- Line: 1361\r\n\t-- Message: SQLSTATE[23503]: Foreign key violation: 7 ERROR:  insert or update on table \"baseline_users\" violates foreign key constraint \"baseline_users_user_id_fkey\"\r\nDETAIL:  Key (user_id)=(8) is not present in table \"users\".\r\n\t-- SQL: ALTER TABLE \"development_db_6\".\"baseline_users\" ADD FOREIGN KEY (\"user_id\") REFERENCES \"development_db_6\".\"users\" (\"id\") ON UPDATE RESTRICT ON DELETE RESTRICT;\r\n\r\n...\r\n\r\n\t-- FromMySqlToPostgreSql::populateTableByPrepStmtWorker\r\n\r\n\t-- PDOException code: 22001\r\n\t-- File: /Users/agbodike/workspace/agbodike/FromMySqlToPostgreSql/migration/FromMySqlToPostgreSql/FromMySqlToPostgreSql.php\r\n\t-- Line: 680\r\n\t-- Message: SQLSTATE[22001]: String data, right truncated: 7 ERROR:  value too long for type character varying(255)\r\n\t-- SQL: INSERT INTO \"development_db_6\".\"users\" (\"id\",\"email\",\"encrypted_password\",\"reset_password_token\",\"reset_password_sent_at\",\"remember_created_at\",\"sign_in_count\",\"current_sign_in_at\",\"last_sign_in_at\",\"current_sign_in_ip\",\"last_sign_in_ip\",\"created_at\",\"updated_at\",\"company_id\",\"is_passcode\",\"first_name\",\"last_name\",\"phone\",\"is_primary\",\"deleted_at\",\"role_id\",\"activated\",\"avatar_file_name\",\"avatar_content_type\",\"avatar_file_size\",\"avatar_updated_at\",\"personal_website\",\"tour_visibility\")  VALUES(:0,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27);\r\n```\r\n\r\nThat last error looks like it is inserting totally wrong information as I would expect the VALUES to be very different."},"comment":{"url":"https://api.github.com/repos/AnatolyUss/FromMySqlToPostgreSql/issues/comments/197708373","html_url":"https://github.com/AnatolyUss/FromMySqlToPostgreSql/issues/33#issuecomment-197708373","issue_url":"https://api.github.com/repos/AnatolyUss/FromMySqlToPostgreSql/issues/33","id":197708373,"user":{"login":"agbodike","id":6569567,"avatar_url":"https://avatars.githubusercontent.com/u/6569567?v=3","gravatar_id":"","url":"https://api.github.com/users/agbodike","html_url":"https://github.com/agbodike","followers_url":"https://api.github.com/users/agbodike/followers","following_url":"https://api.github.com/users/agbodike/following{/other_user}","gists_url":"https://api.github.com/users/agbodike/gists{/gist_id}","starred_url":"https://api.github.com/users/agbodike/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agbodike/subscriptions","organizations_url":"https://api.github.com/users/agbodike/orgs","repos_url":"https://api.github.com/users/agbodike/repos","events_url":"https://api.github.com/users/agbodike/events{/privacy}","received_events_url":"https://api.github.com/users/agbodike/received_events","type":"User","site_admin":false},"created_at":"2016-03-17T05:24:29Z","updated_at":"2016-03-17T05:24:29Z","body":"yes, migration was successfully accomplished:\r\n\r\n```\r\n-- Migration was successfully accomplished!\r\n-- Total time: 00:00:05 (hours:minutes:seconds)\r\n```\r\n\r\nI put everything from the logs that looked interesting above, is there anything specific you are looking for?\r\n\r\nDo you want me to paste the entire logs here?"}}