Предложения спонсоров «Капелланина»: |
debug info
db_connect()
getRow(): SELECT id FROM addr where ip='3.239.6.58'; result: OK
getValue(): SELECT mode FROM addr where id='917538'; result: OK
getRow(): SELECT id FROM addr where ip='3.239.6.58'; result: OK
getValue(): SELECT mode FROM addr where id='917538'; result: OK
User not logged in or cookies disabled
Addr_id: 917538; Addr_mode: 1
case ADDR_TESTING
getValue(): SELECT time FROM addr where id='917538'; result: OK
Cookies disabled
setValue(): UPDATE addr SET mode='2' WHERE id = 917538; result: OK
getRow(): SELECT userId FROM vkSources WHERE exclude=0 ORDER BY lastRead LIMIT 1; result: OK
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vk' result: OK
getRow(): SELECT id FROM vkCache WHERE userId='18679682' AND postId='9344' result: OK
cacheVkPost(): INSERT INTO vkCache(userId, postId, postTimestamp, post, seen) VALUES( 18679682, 9344, 1680342472, '{\"copy_history\":[{\"type\":\"post\",\"attachments\":[{\"type\":\"photo\",\"photo\":{\"album_id\":-7,\"date\":1680339778,\"id\":457242931,\"owner_id\":-12090790,\"access_key\":\"93f64f08c3ab522f38\",\"post_id\":38003,\"sizes\":[{\"height\":42,\"type\":\"s\",\"width\":75,\"url\":\"https:\\/\\/sun1-94.userapi.com\\/impg\\/qQq6-wQkEpoecSpLiZuZzd8GC0OMGKgz39OfjA\\/mVyNdBqEJeY.jpg?size=75x42&quality=95&sign=3fda183c90736b23e75950427d324881&c_uniq_tag=alRAOJLNoQc4oNdGnjqm4yWDkAqHY3vqHVJt3FqbEyU&type=album\"},{\"height\":73,\"type\":\"m\",\"width\":130,\"url\":\"https:\\/\\/sun1-94.userapi.com\\/impg\\/qQq6-wQkEpoecSpLiZuZzd8GC0OMGKgz39OfjA\\/mVyNdBqEJeY.jpg?size=130x73&quality=95&sign=b89d3a36b26a3fcf62a2a2d6b5965842&c_uniq_tag=zQIK0WbGYmjj-3W1yAKyfLbqXMDBcKe5FS2cDSX43mM&type=album\"},{\"height\":340,\"type\":\"x\",\"width\":604,\"url\":\"https:\\/\\/sun1-94.userapi.com\\/impg\\/qQq6-wQkEpoecSpLiZuZzd8GC0OMGKgz39OfjA\\/mVyNdBqEJeY.jpg?size=604x340&quality=95&sign=c8d6513aaa2bacaf570bfd1f2239ddd6&c_uniq_tag=omwA1uQGJRPV4aBnn9NzYdKZex1rwpVDhb4V1VlMR0k&type=album\"},{\"height\":454,\"type\":\"y\",\"width\":807,\"url\":\"https:\\/\\/sun1-94.userapi.com\\/impg\\/qQq6-wQkEpoecSpLiZuZzd8GC0OMGKgz39OfjA\\/mVyNdBqEJeY.jpg?size=807x454&quality=95&sign=305d7bd9fbd42063826047c3b941ec5c&c_uniq_tag=PCWAocAa11V_EYZFBLVCiZWGLnTIykpAYhYB2nNQgSk&type=album\"},{\"height\":720,\"type\":\"z\",\"width\":1280,\"url\":\"https:\\/\\/sun1-94.userapi.com\\/impg\\/qQq6-wQkEpoecSpLiZuZzd8GC0OMGKgz39OfjA\\/mVyNdBqEJeY.jpg?size=1280x720&quality=95&sign=eafff801e1f1e2f0928498339de279d1&c_uniq_tag=TaEtU1WEdrzYDeeKJ4AgC4Fu0Kn0i5w-nZXlau7hTCc&type=album\"},{\"height\":1080,\"type\":\"w\",\"width\":1920,\"url\":\"https:\\/\\/sun1-94.userapi.com\\/impg\\/qQq6-wQkEpoecSpLiZuZzd8GC0OMGKgz39OfjA\\/mVyNdBqEJeY.jpg?size=1920x1080&quality=95&sign=591923f36be8ab403174078262ffab37&c_uniq_tag=_vzlvZSqicht8jhmh2NPAav3xLdi4junkizNfh8QWnQ&type=album\"},{\"height\":87,\"type\":\"o\",\"width\":130,\"url\":\"https:\\/\\/sun1-94.userapi.com\\/impg\\/qQq6-wQkEpoecSpLiZuZzd8GC0OMGKgz39OfjA\\/mVyNdBqEJeY.jpg?size=130x87&quality=95&crop=153,0,1614,1080&sign=ccd416b1bc3b1c322f12eae977e078fd&c_uniq_tag=dpkv8z-Dx3FfOkcmxV4L0CsmOeeVvktFLTlBjTkCbx4&type=album\"},{\"height\":133,\"type\":\"p\",\"width\":200,\"url\":\"https:\\/\\/sun1-94.userapi.com\\/impg\\/qQq6-wQkEpoecSpLiZuZzd8GC0OMGKgz39OfjA\\/mVyNdBqEJeY.jpg?size=200x133&quality=95&crop=148,0,1624,1080&sign=6d01e07bf3a806374bcc2f50f8d5202c&c_uniq_tag=BSvr_VCUG8NOdPJMYk6M9Ba4-A1MwFy87zUmLGO3weQ&type=album\"},{\"height\":213,\"type\":\"q\",\"width\":320,\"url\":\"https:\\/\\/sun1-94.userapi.com\\/impg\\/qQq6-wQkEpoecSpLiZuZzd8GC0OMGKgz39OfjA\\/mVyNdBqEJeY.jpg?size=320x213&quality=95&crop=148,0,1623,1080&sign=ac10a6fe708a983bad8b12ffab7d8d53&c_uniq_tag=yBeuK3cW79P--_KE4V6_QE8UQmiXt7uXTYiGvZwgHAY&type=album\"},{\"height\":340,\"type\":\"r\",\"width\":510,\"url\":\"https:\\/\\/sun1-94.userapi.com\\/impg\\/qQq6-wQkEpoecSpLiZuZzd8GC0OMGKgz39OfjA\\/mVyNdBqEJeY.jpg?size=510x340&quality=95&crop=150,0,1620,1080&sign=f59c63a02b5527a2b0f40288833a7483&c_uniq_tag=EnQnTFbad-LSuWBbd4xpBSeqBvJurWbh_5kraA07REQ&type=album\"}],\"text\":\"\",\"user_id\":100,\"has_tags\":false}},{\"type\":\"link\",\"link\":{\"url\":\"https:\\/\\/m.vk.com\\/audio?act=audio_playlist-2000077875_77875&access_hash=2552bbbef05fa9cf35&api_view=e263f37f1393063e232e96612a60fe\",\"description\":\"Плейлист\",\"photo\":{\"album_id\":235125454,\"date\":1490173981,\"id\":456239018,\"owner_id\":-127435785,\"sizes\":[{\"height\":130,\"type\":\"m\",\"width\":130,\"url\":\"https:\\/\\/sun1-85.userapi.com\\/impf\\/c637630\\/v637630075\\/3d839\\/QoS1sHwG3kY.jpg?size=130x130&quality=96&sign=18f00640921f2bb6498761821cd98756&c_uniq_tag=Jxn6n9IG2KdsSt4QCrBEw86tFlYifAV7zv3e5-Lpmq8&type=album\"},{\"height\":130,\"type\":\"o\",\"width\":130,\"url\":\"https:\\/\\/sun1-85.userapi.com\\/impf\\/c637630\\/v637630075\\/3d839\\/QoS1sHwG3kY.jpg?size=130x130&quality=96&sign=18f00640921f2bb6498761821cd98756&c_uniq_tag=Jxn6n9IG2KdsSt4QCrBEw86tFlYifAV7zv3e5-Lpmq8&type=album\"},{\"height\":200,\"type\":\"p\",\"width\":200,\"url\":\"https:\\/\\/sun1-85.userapi.com\\/impf\\/c637630\\/v637630075\\/3d839\\/QoS1sHwG3kY.jpg?size=200x200&quality=96&sign=d2a337b39046a7398ce3d7baa78312c2&c_uniq_tag=XsqMw7Pco-F3-3gDtU_GLTdQflzQPA5CloviTmlFXPc&type=album\"},{\"height\":320,\"type\":\"q\",\"width\":320,\"url\":\"https:\\/\\/sun1-85.userapi.com\\/impf\\/c637630\\/v637630075\\/3d839\\/QoS1sHwG3kY.jpg?size=320x320&quality=96&sign=f7d7b2f42537e9e1a21c8ac84984adc6&c_uniq_tag=AOAAAu1nAbsNDqaOZpc5T46IqcfnoLLrFKTvVCGy3Zo&type=album\"},{\"height\":510,\"type\":\"r\",\"width\":510,\"url\":\"https:\\/\\/sun1-85.userapi.com\\/impf\\/c637630\\/v637630075\\/3d839\\/QoS1sHwG3kY.jpg?size=510x510&quality=96&sign=a68b2d1dffb45153931bc3fd40087f5c&c_uniq_tag=H2E4jaYECm6llktL2T0NQK2uG6H79m5UHhy_NUvuB9I&type=album\"},{\"height\":75,\"type\":\"s\",\"width\":75,\"url\":\"https:\\/\\/sun1-85.userapi.com\\/impf\\/c637630\\/v637630075\\/3d839\\/QoS1sHwG3kY.jpg?size=75x75&quality=96&sign=ebad98a014e79e79aac737d4aafe39c2&c_uniq_tag=fmyil1AqaEaJljH8fwWJMDIGqQOIuZ1TfmYrldgUVDc&type=album\"},{\"height\":512,\"type\":\"x\",\"width\":512,\"url\":\"https:\\/\\/sun1-85.userapi.com\\/impf\\/c637630\\/v637630075\\/3d839\\/QoS1sHwG3kY.jpg?size=512x512&quality=96&sign=78f0106029e090c8282f188bbe1dea0a&c_uniq_tag=DWQlBPMdV7G6e1RMNqxkpsfBKDXbSPPbdWG3yity_dQ&type=album\"}],\"text\":\"\",\"user_id\":100,\"has_tags\":false},\"title\":\"Rachmaninov: Music for Two Pianos\",\"ref\":\"audio_playlist\"}}],\"date\":1680339778,\"from_id\":-12090790,\"id\":38003,\"owner_id\":-12090790,\"post_source\":{\"platform\":\"iphone\",\"type\":\"api\"},\"post_type\":\"post\",\"text\":\"🖤 Рахманинову 150. Музыка для двух фортепиано. Слушай в нашей подборке!\"}],\"donut\":{\"is_donut\":false},\"comments\":{\"count\":0},\"short_text_rate\":0.8,\"hash\":\"96VU_J4xZbBS_2DoTnwsSGeH\",\"type\":\"post\",\"attachments\":[],\"date\":1680342472,\"from_id\":18679682,\"id\":9344,\"is_favorite\":false,\"likes\":{\"can_like\":0,\"count\":4,\"user_likes\":0},\"owner_id\":18679682,\"post_type\":\"post\",\"reposts\":{\"count\":0},\"text\":\"🎼🎵🎶\",\"views\":{\"count\":56}}', 0); result: OK
cacheVkPost(): INSERT INTO vkSources VALUES (18679682, 1680370180, 0) ON DUPLICATE KEY UPDATE lastRead=1680370180; result: NOK
getRow(): SELECT id FROM vkCache WHERE userId='18679682' AND postId='9343' result: OK
cacheVkPost(): INSERT INTO vkSources VALUES (18679682, 1680370180, 0) ON DUPLICATE KEY UPDATE lastRead=1680370180; result: NOK
getQueryParam(): id=1026
getRow(): SELECT * FROM person WHERE id=1026 AND 0 >= person.rights; result: OK
getRow(): SELECT byear, ddate, dmonth, dyear FROM person WHERE id = 1026; result: OK
getRow(): SELECT * FROM person WHERE id = 1026 AND 0 >= rights; result: OK
getAcademInfo(): SELECT * FROM person2course WHERE person=1026; result: OK
getRelatives4Person: SELECT id, lname, fname, mname, type FROM person, person2person WHERE id2=id AND id1=1026 AND 0 >= rights order by start; result: OK
getActivities(): SELECT * FROM activity WHERE person_id = 1026; result: OK
getRelatives4Person: SELECT id, lname, fname, mname, type FROM person, person2person WHERE id1=id AND id2=1026 AND 0 >= rights order by lname, fname, mname; result: OK
getEvents4Person(): SELECT event.* FROM person2event, event WHERE person=1026 AND event.id=person2event.event AND sdate >= '2023-4-01' GROUP BY event.id ORDER BY sdate ASC; result: OK
getEvents4Person(): SELECT event.* FROM person2event, event WHERE person=1026 AND event.id=person2event.event AND sdate < '2023-4-01' GROUP BY event.id ORDER BY sdate DESC; result: OK
getMaterials4Person(): SELECT material_id FROM person2material WHERE person2material.id=1026 ORDER BY type DESC; result: OK
getSources(): SELECT * FROM person2source WHERE id=1026; result: OK
getThumbnails4Person(): SELECT id FROM foto2person WHERE foto2person.person_id = 1026; result: OK
getThumbnails4Person(): SELECT * FROM foto WHERE id in (384, 523, 582, 583, 1202) ORDER BY sdate, id; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 523 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 384 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 583 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 582 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 1202 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
printContactInfo(): SELECT * FROM contacts4person WHERE id = 1026 ORDER BY type; result: OK
getRow(): SELECT * FROM person WHERE id=1026 AND 0 >= person.rights; result: OK
getRow(): SELECT id FROM uri where uri='/id1026'; result: OK
getDateCounter(): SELECT COUNT(*) from user where creation_time > '1680283781'; result: OK
error log
cacheVkPost(): Error executing query INSERT INTO vkSources VALUES (18679682, 1680370180, 0) ON DUPLICATE KEY UPDATE lastRead=1680370180; Column count doesn't match value count at row 1
cacheVkPost(): Error executing query INSERT INTO vkSources VALUES (18679682, 1680370180, 0) ON DUPLICATE KEY UPDATE lastRead=1680370180; Column count doesn't match value count at row 1
