Предложения спонсоров «Капелланина»: |
debug info
db_connect()
getRow(): SELECT id FROM addr where ip='3.239.59.31'; result: OK
getValue(): SELECT mode FROM addr where id='935013'; result: OK
User not logged in or cookies disabled
Addr_id: 935013; Addr_mode: 2
case ADDR_NOCOOKIES
getValue(): SELECT time FROM addr where id='935013'; result: OK
Time: 1695477026, Saved time: 1695476927
setValue(): UPDATE addr SET mode='1' WHERE id = 935013; result: OK
setValue(): UPDATE addr SET time='1695477026' WHERE id = 935013; result: OK
Redirecting
Redirected
URI: /id2102
Script: /names/index.php
Query: ID=2102
Referer:
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vkCache' result: OK
lockVkCache(1): INSERT INTO `blob` (`key`, `value`) VALUES ('vkCache', '1695477028.798437'); result: OK
getRow(): SELECT userId FROM vkSources WHERE exclude=0 ORDER BY lastRead LIMIT 1; result: OK
Getting posts for user 240542999. vk.api method: wall.get
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vk' result: OK
Checking vk access token... Valid. Expires 2023-09-24 11:41:21
Got 10. getRow(): SELECT id FROM vkCache WHERE userId='240542999' AND postId='338' result: OK
cacheVkPost(): INSERT INTO vkCache(userId, postId, postTimestamp, post, seen) VALUES( 240542999, 338, 1695476016, '{\"donut\":{\"is_donut\":false},\"comments\":{\"count\":0},\"marked_as_ads\":0,\"short_text_rate\":0.8,\"hash\":\"BT4lPVyfs_UGw5hFaOIbZBQy\",\"type\":\"post\",\"carousel_offset\":0,\"attachments\":[{\"type\":\"photo\",\"photo\":{\"album_id\":296631936,\"date\":1695476012,\"id\":457240364,\"owner_id\":240542999,\"access_key\":\"66ed5fb399ab5347ea\",\"sizes\":[{\"height\":75,\"type\":\"s\",\"width\":50,\"url\":\"https:\\/\\/sun9-77.userapi.com\\/impg\\/9CfltAZJkXVQbyh3qnvytew-aKcEy-mEFMd_Yg\\/ReC146OVvoM.jpg?size=50x75&quality=96&sign=29af513e6c78cbe74e797a758e108799&c_uniq_tag=KeKlOYxq_Eh1yTS1jDirxioF5PEhH9kHq46-8Mu09n0&type=album\"},{\"height\":130,\"type\":\"m\",\"width\":87,\"url\":\"https:\\/\\/sun9-77.userapi.com\\/impg\\/9CfltAZJkXVQbyh3qnvytew-aKcEy-mEFMd_Yg\\/ReC146OVvoM.jpg?size=87x130&quality=96&sign=3a52cb76aa58034f2c04246648f15a64&c_uniq_tag=vgzGOToemv7QcaYV0woE4X9w5oyNkzSEJrNg4khlaAc&type=album\"},{\"height\":604,\"type\":\"x\",\"width\":403,\"url\":\"https:\\/\\/sun9-77.userapi.com\\/impg\\/9CfltAZJkXVQbyh3qnvytew-aKcEy-mEFMd_Yg\\/ReC146OVvoM.jpg?size=403x604&quality=96&sign=ab2e0bbf3c590a5a911cd2e18961cf48&c_uniq_tag=ldm8QCyggehRiug_Y3D6MfKQACUWRKmD6xZg49WHPSA&type=album\"},{\"height\":195,\"type\":\"o\",\"width\":130,\"url\":\"https:\\/\\/sun9-77.userapi.com\\/impg\\/9CfltAZJkXVQbyh3qnvytew-aKcEy-mEFMd_Yg\\/ReC146OVvoM.jpg?size=130x195&quality=96&sign=4cd14152e288d560306c5de833ab9e75&c_uniq_tag=ycYLIVfg43F8avv5Ln4mhJXpHxDyjMSy2dBN9xF8FlI&type=album\"},{\"height\":300,\"type\":\"p\",\"width\":200,\"url\":\"https:\\/\\/sun9-77.userapi.com\\/impg\\/9CfltAZJkXVQbyh3qnvytew-aKcEy-mEFMd_Yg\\/ReC146OVvoM.jpg?size=200x300&quality=96&sign=17b1f04f748ae4b33d115f484860ff83&c_uniq_tag=2dBqmIqHRlv4ohfUowONiJbrvyusufa4uUv3piWVlxk&type=album\"},{\"height\":480,\"type\":\"q\",\"width\":320,\"url\":\"https:\\/\\/sun9-77.userapi.com\\/impg\\/9CfltAZJkXVQbyh3qnvytew-aKcEy-mEFMd_Yg\\/ReC146OVvoM.jpg?size=320x480&quality=96&sign=775c2e9ee875b7235f3488937fc5458b&c_uniq_tag=ZDmA2kvbmWniHsToeEBSj07pN_he8FPHUeBJILVPxFc&type=album\"},{\"height\":604,\"type\":\"r\",\"width\":403,\"url\":\"https:\\/\\/sun9-77.userapi.com\\/impg\\/9CfltAZJkXVQbyh3qnvytew-aKcEy-mEFMd_Yg\\/ReC146OVvoM.jpg?size=403x604&quality=96&sign=ab2e0bbf3c590a5a911cd2e18961cf48&c_uniq_tag=ldm8QCyggehRiug_Y3D6MfKQACUWRKmD6xZg49WHPSA&type=album\"}],\"text\":\"Я не верю своим глазам, этот образ мне создали тут 👉 https:\\/\\/vk.com\\/app51743062\",\"web_view_token\":\"513625e55e8dd2f60b\",\"has_tags\":false}},{\"type\":\"link\",\"link\":{\"url\":\"https:\\/\\/vk.com\\/app51743062\",\"description\":\"\",\"is_favorite\":false,\"title\":\"51743062\",\"target\":\"internal\"}}],\"date\":1695476016,\"from_id\":240542999,\"id\":338,\"is_favorite\":false,\"likes\":{\"can_like\":0,\"count\":0,\"user_likes\":0},\"owner_id\":240542999,\"post_type\":\"post\",\"reposts\":{\"count\":0},\"text\":\"Невероятный образ получила в приложении - https:\\/\\/vk.com\\/app51743062\",\"views\":{\"count\":7}}', 0); result: OK
addUser(): INSERT INTO vkSources VALUES (240542999, 1695477027, 0) ON DUPLICATE KEY UPDATE lastRead=1695477027; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (240542999, 1695477027, 0) ON DUPLICATE KEY UPDATE lastRead=1695477027; Column count doesn't match value count at row 1
getRow(): SELECT id FROM vkCache WHERE userId='240542999' AND postId='336' result: OK
addUser(): INSERT INTO vkSources VALUES (240542999, 1695477027, 0) ON DUPLICATE KEY UPDATE lastRead=1695477027; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (240542999, 1695477027, 0) ON DUPLICATE KEY UPDATE lastRead=1695477027; Column count doesn't match value count at row 1
getRow(): SELECT id FROM vkCache WHERE userId='240542999' AND postId='334' result: OK
addUser(): INSERT INTO vkSources VALUES (240542999, 1695477027, 0) ON DUPLICATE KEY UPDATE lastRead=1695477027; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (240542999, 1695477027, 0) ON DUPLICATE KEY UPDATE lastRead=1695477027; Column count doesn't match value count at row 1
getRow(): SELECT id FROM vkCache WHERE userId='240542999' AND postId='333' result: OK
addUser(): INSERT INTO vkSources VALUES (240542999, 1695477027, 0) ON DUPLICATE KEY UPDATE lastRead=1695477027; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (240542999, 1695477027, 0) ON DUPLICATE KEY UPDATE lastRead=1695477027; Column count doesn't match value count at row 1
cacheVkPost(): UPDATE vkSources SET lastRead=1695477027, state='new 1 posts', exclude=0 WHERE userId=240542999; result: OK
lockVkCache(): DELETE FROM `blob` WHERE `key` = 'vkCache'; result: OK
getQueryParam(): id=2102
getRow(): SELECT * FROM person WHERE id=2102 AND 0 >= person.rights; result: OK
getRow(): SELECT byear, ddate, dmonth, dyear FROM person WHERE id = 2102; result: OK
getRow(): SELECT * FROM person WHERE id = 2102 AND 0 >= rights; result: OK
getAcademInfo(): SELECT * FROM person2course WHERE person=2102; result: OK
getRelatives4Person: SELECT id, lname, fname, mname, type FROM person, person2person WHERE id2=id AND id1=2102 AND 0 >= rights order by start; result: OK
getActivities(): SELECT * FROM activity WHERE person_id = 2102; result: OK
getRelatives4Person: SELECT id, lname, fname, mname, type FROM person, person2person WHERE id1=id AND id2=2102 AND 0 >= rights order by lname, fname, mname; result: OK
getEvents4Person(): SELECT event.* FROM person2event, event WHERE person=2102 AND event.id=person2event.event AND sdate >= '2023-9-23' GROUP BY event.id ORDER BY sdate ASC; result: OK
getEvents4Person(): SELECT event.* FROM person2event, event WHERE person=2102 AND event.id=person2event.event AND sdate < '2023-9-23' GROUP BY event.id ORDER BY sdate DESC; result: OK
getMaterials4Person(): SELECT material_id FROM person2material WHERE person2material.id=2102 ORDER BY type DESC; result: OK
getSources(): SELECT * FROM person2source WHERE id=2102; result: OK
getThumbnails4Person(): SELECT id FROM foto2person WHERE foto2person.person_id = 2102; result: OK
getThumbnails4Person(): SELECT * FROM foto WHERE id in (2924, 2925, 2926) ORDER BY sdate, id; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 2924 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 = 2925 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 = 2926 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
printContactInfo(): SELECT * FROM contacts4person WHERE id = 2102 ORDER BY type; result: OK
getRow(): SELECT * FROM person WHERE id=2102 AND 0 >= person.rights; result: OK
getRow(): SELECT id FROM uri where uri='/id2102'; result: OK
getDateCounter(): SELECT COUNT(*) from user where creation_time > '1695390627'; result: OK
error log
addUser(): Error executing query INSERT INTO vkSources VALUES (240542999, 1695477027, 0) ON DUPLICATE KEY UPDATE lastRead=1695477027; Column count doesn't match value count at row 1
addUser(): Error executing query INSERT INTO vkSources VALUES (240542999, 1695477027, 0) ON DUPLICATE KEY UPDATE lastRead=1695477027; Column count doesn't match value count at row 1
addUser(): Error executing query INSERT INTO vkSources VALUES (240542999, 1695477027, 0) ON DUPLICATE KEY UPDATE lastRead=1695477027; Column count doesn't match value count at row 1
addUser(): Error executing query INSERT INTO vkSources VALUES (240542999, 1695477027, 0) ON DUPLICATE KEY UPDATE lastRead=1695477027; Column count doesn't match value count at row 1
98299516
