SQLSTATE[HY093]: Invalid parameter number:

[todenvolkov]

-- FromMySqlToPostgreSql::populateTableByPrepStmtWorker

-- PDOException code: HY093
-- File: /home/www/FromMySqlToPostgreSql-master/migration/FromMySqlToPostgreSql/FromMySqlToPostgreSql.php
-- Line: 642
-- Message: SQLSTATE[HY093]: Invalid parameter number: :Хуясе_колонка9
-- SQL:

 INSERT INTO "mobsted_2"."objects" ("id","PIN","Phone","untitled22","untitled229","untitled230","untitled231","untitled232","untitled233","untitled235","un
titled236","untitled237","untitled238","untitled239","untitled240","mycol00","Хуясе_колонка9","Organization","Device","Model","Expenditure","Photo","Manual","Video","unti
tled242","untitled243","untitled244","untitled246","Fuck_Taht_Columnd","untitled249dd00","untitled250","untitled251","untitled252","untitled253","untitled254","untitled25
50","jj","Denis99","untitled25512","NameAZS","AddressAZS","untitled25513","untitled25514","untitled25515ррр","Колонка_1","untitled25516","Name","untitled25517fgdfg","unti
tled25518dfgdfgdfg","untitled25519334","ФИО","Номер_водительского","Адрес","Дом","Улица","New_column","gfdhhgfdhfghfd","tryeyreyeryrety","ColdCounter1Serial","ColdCounter
2Serial","HotCounter1Serial","HotCounter2Serial","Квартира","PrinterName","Office","untitled2551935","Room_Number","Address","FIO","Contacts","RoomNumber","ClassOfService
","FirstLastName","sduntitled2551936sdf","HelloDenisMuyName","untitled2551937df","untitled2551938d","AZSAdrees","AZSNumber","untitled2551939","untitled2551940hh","Вода1",
"untitled2551941g","untitled2551942","House","CounterHot","CounterCold","BranchOfficeNumber","BranchOfficeCity","TotalRating","untitled2551943","surname","Personnel_Numbe
r","DateOfBirth","Модель","Производитель","Серийный_номер","Модель_картриджа","Организация","Ответственный_сотрудник_от_организации","Контакты_огранизации","Enabled","Tra
nsport","LastLogin","InviteStatus","untitled2551944","Тип_устройства","фыфы","untitled2551945","Last_Name","Surname2","DateOfOrder","untitled2551946","untitled2551947","P
hone2","Лицевой_счет","Email","sdgsdgsdgsdg","untitled25519335","untitled25519336","ident","Куда","Откуда","От_кого","Местонахождение_посылки","untitled25519337авп","unti
tled25519338","untitled25519339f","Объем_материала","Номер_АЗС","Адрес_АЗС","Контактные_данные","Город","untitled25519340d","untitled25519341xfg","Email1","untitled255193
42","Files","Наименование_Организации","ИНН","КПП","Телефон","Email_для_связи","Баланс","Задолженность","Контактное_лицо","untitled25519343","untitled25519344d","img","bo
ld","FileId","File5","untitled25519345","File3","asd","deded","1212","untitled25519348","untitled25519350sdfsdf","untitled25519351","untitled25519352","untitled25519353",
"untitled25519354","ываываыва","Selfie","Ебать_Ту_Люсю","untitled25519355","untitled25519356","untitled25519357","Tenant","Depends","untitled25519358","untitled25519359",
"untitled25519360","Тестируем_и_Яшеем_2","Depend","superColumn","mob","Sted","untitled25519363","Модель_фильтра","MAS_S","MAS_C","MAS_M","Mas_Z","Информация_о_минералах",
"Фото_места_установки","Дата_установки","Отзыв","untitled25519364","sexybaba","hhh","ebaka","untitled25519365","untitled25519366ываываываываываываываываываываываыва","unt
itled25519367","NameThisColumn2","NameThisColumn3","NameThisColumn4","NameThisColumn5","untitled25519368","NameThisColumn6","NameThisColumn7","NameThisColumn9","Customer"
,"NameThisColumn10","NameThisColumn11","NameThisColumn12","NameThisColumn13m","DateCreate","NameThisColumn14","Номер_кабинета","NameThisColumn16","NameThisColumn17","Name
ThisColumn18","NameThisColumn19","NameThisColumn20","NameThisColumn21","NameThisColumn22","NameThisColumn23","NameThisColumn24","NameThisColumn25","NameThisColumn26","Nam
eThisColumn27","NameThisColumn28","NameThisColumn30","NameThisColumn31","NameThisColumn32","NameThisColumn33","NameThisColumn34","Language","gorod","хим_адрес","хим_тел",
"html_pay","studio_phone","Fullname","html_zakaz","UID","NameThisColumn36","Demo","Номер_кабиента","Время_работы","Врач1","Врач2","Врач3","ОбслуживающийОфис","Адрес_офиса
","ТелефонОфиса","Лечащий_Врач","Телефон_Лечащего_врача","Возраст","отзыв777","отзыв999","варвар","StartScreen","sum","NameThisColumn37","NameThisColumn38","NameThisColum
n39","NameThisColumn40","NameThisColumn41","NameThisColumn42","NameThisColumn43","Город2ewr","Модель_домофона","Статус","УК","Фото_Домофон","Инструкция_Домофон","Подъезд"
,"Телефон_УК","apiPa","Test","Изображение_Устройства","Имя_Отчество","Видео_Инструкция","Инструкция_для_абонентского_устройства","Характеристики_устройства","Модель_абоне
нтского_устройства_","Адрес_установки","ЛС","NameThisColumn44","NameThisColumn45","NameThisColumn46","NameThisColumn47","Имя","Фамилия","Отчество","Модель_АУ","apiInfo","
Инструкция_для_АУ","Фото_АУ","Уведомление","Информирование","Микрорайон","Корпус","Счетчик_ГВ","Счетчик_ХВ","Счетчик_ЭЭ","Дата_ЭЭ","Дата_ХВ","Дата_ГВ","Картинка","Видео",
"PayOnline","Карта","Контактный_телефон","Логотип_организации","Адрес_доставки","Status777","newcolumn","хим_название","Cert_pay","NameThisColumn48","AutomaticalTimezone"
,"Timezone","NameThisColumn49","City","current_order","NewColonka","Kol1","Kol2")  VALUES( :id, :PIN, :Phone, :untitled22, :untitled229, :untitled230, :untitled231, :unti
tled232, :untitled233, :untitled235, :untitled236, :untitled237, :untitled238, :untitled239, :untitled240, :mycol00, :Хуясе_колонка9, :Organization, :Device, :Model, :Exp
enditure, :Photo, :Manual, :Video, :untitled242, :untitled243, :untitled244, :untitled246, :Fuck_Taht_Columnd, :untitled249dd00, :untitled250, :untitled251, :untitled252,
 :untitled253, :untitled254, :untitled2550, :jj, :Denis99, :untitled25512, :NameAZS, :AddressAZS, :untitled25513, :untitled25514, :untitled25515ррр, :Колонка_1, :untitled
25516, :Name, :untitled25517fgdfg, :untitled25518dfgdfgdfg, :untitled25519334, :ФИО, :Номер_водительского, :Адрес, :Дом, :Улица, :New_column, :gfdhhgfdhfghfd, :tryeyreyer
yrety, :ColdCounter1Serial, :ColdCounter2Serial, :HotCounter1Serial, :HotCounter2Serial, :Квартира, :PrinterName, :Office, :untitled2551935, :Room_Number, :Address, :FIO,
 :Contacts, :RoomNumber, :ClassOfService, :FirstLastName, :sduntitled2551936sdf, :HelloDenisMuyName, :untitled2551937df, :untitled2551938d, :AZSAdrees, :AZSNumber, :untit
led2551939, :untitled2551940hh, :Вода1, :untitled2551941g, :untitled2551942, :House, :CounterHot, :CounterCold, :BranchOfficeNumber, :BranchOfficeCity, :TotalRating, :unt
itled2551943, :surname, :Personnel_Number, :DateOfBirth, :Модель, :Производитель, :Серийный_номер, :Модель_картриджа, :Организация, :Ответственный_сотрудник_от_организаци
и, :Контакты_огранизации, :Enabled, :Transport, :LastLogin, :InviteStatus, :untitled2551944, :Тип_устройства, :фыфы, :untitled2551945, :Last_Name, :Surname2, :DateOfOrder
, :untitled2551946, :untitled2551947, :Phone2, :Лицевой_счет, :Email, :sdgsdgsdgsdg, :untitled25519335, :untitled25519336, :ident, :Куда, :Откуда, :От_кого, :Местонахожде
ние_посылки, :untitled25519337авп, :untitled25519338, :untitled25519339f, :Объем_материала, :Номер_АЗС, :Адрес_АЗС, :Контактные_данные, :Город, :untitled25519340d, :untit
led25519341xfg, :Email1, :untitled25519342, :Files, :Наименование_Организации, :ИНН, :КПП, :Телефон, :Email_для_связи, :Баланс, :Задолженность, :Контактное_лицо, :untitle
d25519343, :untitled25519344d, :img, :bold, :FileId, :File5, :untitled25519345, :File3, :asd, :deded, :1212, :untitled25519348, :untitled25519350sdfsdf, :untitled25519351
, :untitled25519352, :untitled25519353, :untitled25519354, :ываываыва, :Selfie, :Ебать_Ту_Люсю, :untitled25519355, :untitled25519356, :untitled25519357, :Tenant, :Depends
, :untitled25519358, :untitled25519359, :untitled25519360, :Тестируем_и_Яшеем_2, :Depend, :superColumn, :mob, :Sted, :untitled25519363, :Модель_фильтра, :MAS_S, :MAS_C, :
MAS_M, :Mas_Z, :Информация_о_минералах, :Фото_места_установки, :Дата_установки, :Отзыв, :untitled25519364, :sexybaba, :hhh, :ebaka, :untitled25519365, :untitled25519366ыв
аываываываываываываываываываываыва, :untitled25519367, :NameThisColumn2, :NameThisColumn3, :NameThisColumn4, :NameThisColumn5, :untitled25519368, :NameThisColumn6, :NameT
hisColumn7, :NameThisColumn9, :Customer, :NameThisColumn10, :NameThisColumn11, :NameThisColumn12, :NameThisColumn13m, :DateCreate, :NameThisColumn14, :Номер_кабинета, :Na
meThisColumn16, :NameThisColumn17, :NameThisColumn18, :NameThisColumn19, :NameThisColumn20, :NameThisColumn21, :NameThisColumn22, :NameThisColumn23, :NameThisColumn24, :N
ameThisColumn25, :NameThisColumn26, :NameThisColumn27, :NameThisColumn28, :NameThisColumn30, :NameThisColumn31, :NameThisColumn32, :NameThisColumn33, :NameThisColumn34, :
Language, :gorod, :хим_адрес, :хим_тел, :html_pay, :studio_phone, :Fullname, :html_zakaz, :UID, :NameThisColumn36, :Demo, :Номер_кабиента, :Время_работы, :Врач1, :Врач2, 
:Врач3, :ОбслуживающийОфис, :Адрес_офиса, :ТелефонОфиса, :Лечащий_Врач, :Телефон_Лечащего_врача, :Возраст, :отзыв777, :отзыв999, :варвар, :StartScreen, :sum, :NameThisCol
umn37, :NameThisColumn38, :NameThisColumn39, :NameThisColumn40, :NameThisColumn41, :NameThisColumn42, :NameThisColumn43, :Город2ewr, :Модель_домофона, :Статус, :УК, :Фото
_Домофон, :Инструкция_Домофон, :Подъезд, :Телефон_УК, :apiPa, :Test, :Изображение_Устройства, :Имя_Отчество, :Видео_Инструкция, :Инструкция_для_абонентского_устройства, :
Характеристики_устройства, :Модель_абонентского_устройства_, :Адрес_установки, :ЛС, :NameThisColumn44, :NameThisColumn45, :NameThisColumn46, :NameThisColumn47, :Имя, :Фам
илия, :Отчество, :Модель_АУ, :apiInfo, :Инструкция_для_АУ, :Фото_АУ, :Уведомление, :Информирование, :Микрорайон, :Корпус, :Счетчик_ГВ, :Счетчик_ХВ, :Счетчик_ЭЭ, :Дата_ЭЭ,
 :Дата_ХВ, :Дата_ГВ, :Картинка, :Видео, :PayOnline, :Карта, :Контактный_телефон, :Логотип_организации, :Адрес_доставки, :Status777, :newcolumn, :хим_название, :Cert_pay, 
:NameThisColumn48, :AutomaticalTimezone, :Timezone, :NameThisColumn49, :City, :current_order, :NewColonka, :Kol1, :Kol2);

[denis-cto]

So with another database

    -- FromMySqlToPostgreSql::populateTableByPrepStmtWorker

    -- PDOException code: HY093
    -- File: /root/FromMySqlToPostgreSql-master/migration/FromMySqlToPostgreSql/FromMySqlToPostgreSql.php
    -- Line: 654
    -- Message: SQLSTATE[HY093]: Invalid parameter number: :Имя_Отчество
    -- SQL: INSERT INTO "arierra"."objects" ("id","Enabled","Transport","LastLogin","InviteStatus","Phone","Email","PIN","StartScreen","Имя_Отчество","Контактный_телефон","Адрес","Наименование_ор
ганизации","AutomaticalTimezone","Timezone")  VALUES( :id, :Enabled, :Transport, :LastLogin, :InviteStatus, :Phone, :Email, :PIN, :StartScreen, :Имя_Отчество, :Контактный_телефон, :Адрес, :Наименован
ие_организации, :AutomaticalTimezone, :Timezone);

[AnatolyUss]

Hi,
Could you send me your config file?
Is this the only error you've got?
If not - please, send me "errors-only.log" file.

[denis-cto]

I found, that the problem exists only when there're Russian named columns like "Имя_Отчество" - when i remove that columns - everything works fine. Before there was the problem with creating table, but you have fixed that, after that - this error occured.

[AnatolyUss]

Please, send me following params from your config:

1. source
2. target
3. encoding
   Thanks

[denis-cto]

{
"source_description" : [
"Connection string to your MySql database",
"Please ensure, that you have defined your connection string properly.",
"Ensure, that details like 'charset=UTF8' are included in your connection string (if necessary)."
],
"source" : "mysql:host=localhost;port=3306;charset=UTF8;dbname=arierra,root,gbp13ltw",

"target_description" : [
    "Connection string to your PostgreSql database",
    "Please ensure, that you have defined your connection string properly.",
    "Ensure, that details like options='[double dash]client_encoding=UTF8' are included in your connection string (if necessary)."
],
"target" : "pgsql:host=localhost;port=5432;dbname=mobsted_postgres;options=--client_encoding=UTF8,postgres,gbp13ltw",

"encoding_description" : [
    "PHP encoding type.",
    "If not supplied, then UTF-8 will be used as a default."
],
"encoding" : "UTF-8",

"schema_description" : [
    "schema - a name of the schema, that will contain all migrated tables.",
    "If not supplied, then a new schema will be created automatically."
],
"schema" : "",

"data_chunk_size_description" : [
    "During migration each table's data will be split into chunks of data_chunk_size (in MB).",
    "If not supplied, then 10 MB will be used as a default."
],
"data_chunk_size" : 10

}

27 февр. 2016 г., в 17:53, Anatoly Khaytovich notifications@github.com написал(а):

Please, send me following params from your config:

1. source
2. target
3. encoding
   Thanks

—
Reply to this email directly or view it on GitHub #26 (comment).

Специализируемся на разработке программного обеспечения.

С уважением, генеральный директор ООО "Н-Системс"

Волков Денис Андреевич
Круглосуточный многоканальный телефон: (3452) 500-348
www.neo-systems.ru
director@neo-systems.ru

[denis-cto]

What's with this issue? Are you going to fix it?

[AnatolyUss]

Sorry for the delay.
What is your PostgreSQL server encoding type?

In order to check - please, run:
SHOW SERVER_ENCODING;

[denis-cto]

UTF8 everywhere.

[denis-cto]

I thinks this is the same problem with column names quoting, as you have fixed in previous commit.

[AnatolyUss]

I've just committed the patch.
Please, let me know if it helped.

[todenvolkov]

Thank you! We'll try it today