pdo to postgresql unique violation (Also dba_pdo.php logs with dba_mysqli prefix)
Created by: fsteinel
2016-10-27 05:46:16:LOG_ERR::dba_driver.php:459:db_logger: dba_mysqli: ERROR: insert into xchan ( xchan_hash, xchan_guid, xchan_guid_sig, xchan_pubkey, xchan_photo_mimetype,
xchan_photo_l, xchan_addr, xchan_url, xchan_connurl, xchan_follow, xchan_connpage, xchan_name, xchan_network, xchan_photo_date, xchan_name_date, xchan_hidden, xchan_selfcensored, xchan_deleted, xchan_pubforum ) values ( 'aXlfoj6bBogB1eeNsqh6OWLMZumGr2BAXxEMb2Bi9j4vPYU1z5wPX_j8yDts4fdbGia2FN7tF90Tkz5YcZijsA', 'qyxzGtEoc5wOKyonNYebu4DUKmJzVnN_5B-TVY9-lUnNgA6O8Xg2AD0y6wAwjDTpnpr_y2ADtSvRK4UT1Nc1vA', 'DFmx5Ega9v7xcm6l5fsO4W93rlgi4VmPSIC1hy-lgw8Ex7M2Q-_EWQpKMzgqMtc7cORkBuDonqN6HJmJlG7Bm1xJbdvhkfhNwuoW5T2bVEgagnGah3eljRvz7eLQYD5KN6iDzio64XRS0OPFEs1pLPgu7JJd2eaFuqFLQnwj69ffkO74niJ69SxbSXf858vVydgi5pbWEy7M8ktwP5AkeXkc1bJomqi2ScVnbbnJYX5hWJI2y9FtaBdRW6QSnbeNaxYU2qCmrrK6eFhqEBNy2BgpyrgIultsp1IZXkos6mckrIH_OlmTNjBjE9axg0tYLMZ-9Rjki05HYPTehcE8Kf6H1_dCgi5ojSsKEeSj0qF1LsNsdSGcFf1Z89MvuZ24MZZmtwBo-NqmfayvfrV8FvYuWNfwlsuW6WNMIGmTNUhWyqhvMprP99OhdxMA7kz4oxlkGDOCHT01S3kDvTYbDt8UqJHo8Rvu7FjZJbvQ-74vgBipIzGsw6tiObSFp3PPOxWyNRZd64xW653kUYeQUSMTXfU5AVhP_jyj1Jhahep9J_qiIdqmVw7pMFEpRxrMJbdb0wETPnR_cMo0XgaRkzXKea8U0nnzBh0Ia1QwGMG9iIBjq-Xo5SFQR6hmh808WvwBIhCXhNun6zoa3z6YapsTFOVF-WgJOeOxVD2g3NI', '-----BEGIN PUBLIC KEY----- MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEA5Do8wdvBVlF/dQbk3TXO 2SB3q86TeSR147H+CRmPnyrmv8cLqyBRIWa4dllbLc+MsE4Q8Xe9OttrjBrTFQYR LqmdEr3NI7sJIGXr+ZexuhofT/Ah7j4jD+XFQlGWPSJ2sCfExDe5nNviEx0zGAJ0
xNR/+Os7RbAQ/5I7lXhg3XC7tcNtwL5w0yCoHmCE3zF9bUobG3BuuRnUH/GRiho6
i3dVEzC1AjxN2hwtCP5Rg+7caNKDNAcFwCyKAO3EZb0kYrHzpXAZiDsEX7rICZqv
EJ8uCmE7lShdCzn4TqSIhARwyQF7Hb4s14L4Kw5u/OTcwmNSw3lr1koEtSSIKlTs
2XamM7WyZzO1hfhRHeytgvtQ3d7ow56A4AvTGME+T7G59LX83IGe4TsWCwftL+YW
AGZ2YuHacgvZZF5Il2lPXFtu9Eg5wv15ZqfDaQ8OeM4s8exzQzTbt4YRQGxDbPbC
kboalED31JErBii5iHr4G2j3f4dBPbJviMDwdh/AZca8ROK7ocIwdp1SumtVN3X3
Y7aGcLld2DtKp5XLfVWfj3hPsBofr7Xld7wbq0DM1GBdS/1XKYiDLxxhKxXgg5E1
YxLGPuAfEg3QlcfJqZOag6/Cy0PF48eNE3v3IxqeuYMBH+lHV9RBAqqSA1H7XeUc
mJ8Ja4G9yQBpn1EwTxn4TMcCAwEAAQ==
-----END PUBLIC KEY-----
' , 'image/jpeg', 'https://nostupid.zone/photo/profile/l/3', 'letterbomber@nostupid.zone', 'https://nostupid.zone/channel/letterbomber', 'https://nostupid.zone/poco/letterbomber', 'https://nostupid.zone/follow?f=&url=%s', '', 'Letter Bomber', 'zot', '2014-10-13 15:59:28', '2014-09-14 21:34:39', 0, 0, 0, 0) ;
SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "xchan_pkey"
DETAIL: Key (xchan_hash)=(aXlfoj6bBogB1eeNsqh6OWLMZumGr2BAXxEMb2Bi9j4vPYU1z5wPX_j8yDts4fdbGia2FN7tF90Tkz5YcZijsA) already exists.
...
2016-10-27 05:46:19:LOG_INFO::zot.php:971:import_xchan: import_xchan: changed: new_xchanphoto newhub site
2016-10-27 05:46:20:LOG_ERR::dba_driver.php:459:db_logger: dba_mysqli: ERROR: insert into site ( site_location, site_url, site_access, site_flags, site_update, site_directory, site_register, site_sellpage, site_realm, site_type, site_project, site_version ) values ( '', 'https://nostupid.zone', 3, 2, '2016-10-27 05:46:20', 'https://nostupid.zone/dirsearch', 2, '', 'RED_GLOBAL', 0, 'redmatrix', 'redmatrix 2016-03-17.1340R[1160]' );
SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "site_pkey"
DETAIL: Key (site_url)=(https://nostupid.zone) already exists.
2016-10-27 05:46:20:LOG_INFO::zot.php:2929:import_site: import_site: record create failed. Array
(
[url] => https://nostupid.zone
[url_sig] => TGapXs9CbVbC39UBKne7XILM-O3MprutoYNDdHK3Dqr6_-WPbN6mCsjnWFh5_VSavNXlKiIPbGpvSmNiHPOuZGd09cN42kKmoGshoTMECt6kMWpWwuyqH8t162Rmp4BFEClgathWYUnSr4AYHSoLiDx2YFXFBinuXCIUKJZUOLMF9eZTKt_gsjmDwKFhZNwTSgCWGO6SgONH-ArsUoAQYrHAwZMAVUoYhbSRrndGxGC4A2ALgPxxe1lKDMXe1bbU6NmPAKrui7rtfURSz2-XinnXL88ja5wAEMDrdR9Ei1cFUqvdhp-l81gLDDOEugeFJSMtEx09WbByHnnGEZl-QFdpltZOKMHFgjW35GgR3REfnWoz_V16EjwogJTwbgxfFG3-qmyUK-S9yrbI2S6FWY9xFULUH2texwQNHyKYH7tc62xvEqSFQKoDbkS7_QbNBu1dSoRwoeisIQixYoNiZf5azJqiR8C_n_gTjWPuyV2pMNXLDZK0KAJv_xGQIXonu88VIcd-xxCRe65dyAAQBsInmHgINN9ekOYg924AwEJSZY5RrdbHH_4KTBRicYJhlBBLipKxZlVt2lYcQszr17eaHHXU31dh9IV5BwzZdcy65hf_Va2be8W2T58C-M7mEbnIVaKxvR111kli1iAVwNZOiRE7ieZjDgqDM_xupcE [directory_mode] => secondary
[directory_url] => https://nostupid.zone/dirsearch
[project] => redmatrix
[register_policy] => open
[access_policy] => tiered
[accounts] => 47
[channels] => 39
[version] => redmatrix 2016-03-17.1340R[1160]
[admin] => webmaster@nostupid.zone
[plugins] => Array
(
[0] => calc
[1] => fortunate
[2] => hexit
[3] => moremoods
[4] => qrator
[5] => bbmath
[6] => openstreetmap
[7] => smiley_pack
[8] => frphotos
[9] => likebanner
[10] => statistics_json
[11] => openclipatar
[12] => diaspora
[13] => buglink
[14] => irc
[15] => jappixmini
[16] => nsfw
[17] => redred
[18] => smileybutton
[19] => startpage
[20] => twitter
[21] => superblock
[22] => visage
[23] => ljpost
[24] => pumpio
)
[sitehash] => 3ce3e66115ec87b60fde49f836e68e121f56560598f9718b4054b5cde9fd8e3c
[sitename] => NoStupid.Zone Social Net
[sellpage] =>
[location] =>
[realm] => RED_GLOBAL
)
2016-10-27 05:46:20:LOG_INFO::zot.php:971:import_xchan: import_xchan: changed: new_xchanphoto newhub site
...
2016-10-27 05:47:36:LOG_ERR::dba_driver.php:459:db_logger: dba_mysqli: ERROR: insert into xchan ( xchan_hash, xchan_guid, xchan_pubkey, xchan_addr, xchan_url, xchan_name, xchan_network, xchan_name_date ) values ('ricinza@joindiaspora.com', '79ae8301a8c54017', '-----BEGIN PUBLIC KEY-----
MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEA4BzLdQTO5RMBge44hnpSr
veJxmOkDGpEwGurlMC2jl0iJTOZ0AQcmkuB0ATFiHRj+RwzSgDUmYDHSCN6E5amjL
Go9jykLj9+Qi2RT8fkzYZM/qxVgkgmOfaqX487q/C9Fzza66Zgj5tw7Qcy/a6+Utg
4bTPzKowSoKXXlBIf8V4Rh6TVd+5o/2oaUSYhu1yraBm35C5KDFe1lrOnID2H2XjQ
lA1bhkMb19FRyaEv6zS8/8ArMexkJBXwZxh9rYJgyVP5hbtki+bABVMgIx9gfNJB/
bMbAV4vbPOYf48oEBo6NB0obEiwSvk5dAHQW5rKYtEhavAgoqEbi7kC5bZ+TQGzIJ
7dhoaDjpXkwvJC6bGUHQOYimHroygT3R3ztsOq4y8LM9wUIgq5t2qHf9QU0UiRr4i
6MIDstcUs1fGkwBc58j9IkAhkbqXj3/ImMLTxMUv8dGrtm4HgBx41Z2UvDMl5gJu5
qSQC1FrbCdICkqYgb6qCldpCOTmMlH6civRYTrTeo0CzcGEKfSywqccDktsjhl+zi
8G9dWEAbz7G4pRTcDVGQ1gL/YF549EUMtSJmGYBINqHrNyxFONYdRFUjGOx4SBILa
olsMOtKFQwJ1Ddb4jVSKUd29tZbisPyV1JjVH9iUvgUzdLIZUVlOgW5l77Ynag4Xe
5gBzkt0NadNUCAwEAAQ==
-----END PUBLIC KEY-----
', 'ricinza@joindiaspora.com', 'https://joindiaspora.com/u/ricinza', 'tange rina', 'diaspora', '2016-10-27 05:47:36') ;
SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "xchan_pkey"
DETAIL: Key (xchan_hash)=(ricinza@joindiaspora.com) already exists.
The file include/dba/dba_pdo.php logs with prefix dba_mysqli:
and not dba_pdo
....