Предложения спонсоров «Капелланина»: |
debug info
db_connect()
getRow(): SELECT id FROM addr where ip='34.239.173.144'; result: OK
getValue(): SELECT mode FROM addr where id='916777'; result: OK
getRow(): SELECT id FROM addr where ip='34.239.173.144'; result: OK
getValue(): SELECT mode FROM addr where id='916777'; result: OK
User not logged in or cookies disabled
Addr_id: 916777; Addr_mode: 1
case ADDR_TESTING
getValue(): SELECT time FROM addr where id='916777'; result: OK
Cookies disabled
setValue(): UPDATE addr SET mode='2' WHERE id = 916777; 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='87765' AND postId='4463' result: OK
cacheVkPost(): INSERT INTO vkCache(userId, postId, postTimestamp, post, seen) VALUES( 87765, 4463, 1679643592, '{\"donut\":{\"is_donut\":false},\"comments\":{\"count\":0},\"short_text_rate\":0.8,\"hash\":\"GcyaCW3nGrXhJM7SBATgpbxE\",\"type\":\"post\",\"carousel_offset\":0,\"attachments\":[{\"type\":\"photo\",\"photo\":{\"album_id\":-7,\"date\":1679643564,\"id\":457248554,\"owner_id\":87765,\"access_key\":\"b7baf1ac90c01dd66c\",\"sizes\":[{\"height\":130,\"type\":\"m\",\"width\":97,\"url\":\"https:\\/\\/sun9-32.userapi.com\\/impg\\/OL3aQq-_lMF4Dj7WJkWi593ts6UzkM-BTszuCQ\\/R98tr4_Mo5I.jpg?size=97x130&quality=96&sign=270befefb95e5a324b92091d31e06d64&c_uniq_tag=5vpTcdPTWC4lY_AqFD9EzKBwUUx9cqKdV5fXNLclxwA&type=album\"},{\"height\":173,\"type\":\"o\",\"width\":130,\"url\":\"https:\\/\\/sun9-32.userapi.com\\/impg\\/OL3aQq-_lMF4Dj7WJkWi593ts6UzkM-BTszuCQ\\/R98tr4_Mo5I.jpg?size=130x173&quality=96&sign=616e7ef1585a88c54d34ce60dacd45ab&c_uniq_tag=CxSyR8pYAqfoa6ZYalJuxOSiG0ePr_ALNpNJqQmb19U&type=album\"},{\"height\":267,\"type\":\"p\",\"width\":200,\"url\":\"https:\\/\\/sun9-32.userapi.com\\/impg\\/OL3aQq-_lMF4Dj7WJkWi593ts6UzkM-BTszuCQ\\/R98tr4_Mo5I.jpg?size=200x267&quality=96&sign=743f86066290dbb54a07ed2a2e24179a&c_uniq_tag=NJpb1SoG-ntKHn0MrVeLqG_Nr7m-4Fz1ekt_7LTbSpY&type=album\"},{\"height\":427,\"type\":\"q\",\"width\":320,\"url\":\"https:\\/\\/sun9-32.userapi.com\\/impg\\/OL3aQq-_lMF4Dj7WJkWi593ts6UzkM-BTszuCQ\\/R98tr4_Mo5I.jpg?size=320x427&quality=96&sign=4950464b3535ec6787e0ee0c8c264c06&c_uniq_tag=aaObqHkyW4kSAZPt-AOpwkWL77g9tC6tatukXw7H16w&type=album\"},{\"height\":680,\"type\":\"r\",\"width\":510,\"url\":\"https:\\/\\/sun9-32.userapi.com\\/impg\\/OL3aQq-_lMF4Dj7WJkWi593ts6UzkM-BTszuCQ\\/R98tr4_Mo5I.jpg?size=510x680&quality=96&sign=0286a9c0978c3281055eef3ff4cd1244&c_uniq_tag=SClkUogvTGKKgB2p6FvNCaMwN7R8OxDDAwwmPf5q5Wg&type=album\"},{\"height\":75,\"type\":\"s\",\"width\":56,\"url\":\"https:\\/\\/sun9-32.userapi.com\\/impg\\/OL3aQq-_lMF4Dj7WJkWi593ts6UzkM-BTszuCQ\\/R98tr4_Mo5I.jpg?size=56x75&quality=96&sign=520286b78d1dada1dac15ced050c18b4&c_uniq_tag=tsj6vfG3njaNdaySTm82fko-LgLYPdaXROsMdmj7kwA&type=album\"},{\"height\":1920,\"type\":\"w\",\"width\":1440,\"url\":\"https:\\/\\/sun9-32.userapi.com\\/impg\\/OL3aQq-_lMF4Dj7WJkWi593ts6UzkM-BTszuCQ\\/R98tr4_Mo5I.jpg?size=1440x1920&quality=96&sign=6b5cbc29f769c1befb98e283cbc6b808&c_uniq_tag=lcYkhUtULCJnxg7Jsps2TFCRPvuydAwf1v3HF4lOL4A&type=album\"},{\"height\":604,\"type\":\"x\",\"width\":453,\"url\":\"https:\\/\\/sun9-32.userapi.com\\/impg\\/OL3aQq-_lMF4Dj7WJkWi593ts6UzkM-BTszuCQ\\/R98tr4_Mo5I.jpg?size=453x604&quality=96&sign=9bb546bfce89240c74b17406cea23c60&c_uniq_tag=7Pk2j7qA5MYB1-mA6AnSyk6qA1M-Bcx7WqttFHsZYHU&type=album\"},{\"height\":807,\"type\":\"y\",\"width\":605,\"url\":\"https:\\/\\/sun9-32.userapi.com\\/impg\\/OL3aQq-_lMF4Dj7WJkWi593ts6UzkM-BTszuCQ\\/R98tr4_Mo5I.jpg?size=605x807&quality=96&sign=26b3c5dcebcb705ec80d49bbe49e27f4&c_uniq_tag=37eFpEVHGrTWmiZt4HfHdXw-yh_ovBbh5YKZoynpY0I&type=album\"},{\"height\":1080,\"type\":\"z\",\"width\":810,\"url\":\"https:\\/\\/sun9-32.userapi.com\\/impg\\/OL3aQq-_lMF4Dj7WJkWi593ts6UzkM-BTszuCQ\\/R98tr4_Mo5I.jpg?size=810x1080&quality=96&sign=bd27dd8c1dacd575cc36e3516cc4b14b&c_uniq_tag=YTUKk7fa1XxrRIh1Eq8WteMahV5_CVQ6UwR4MelvMO4&type=album\"}],\"text\":\"\",\"has_tags\":false}},{\"type\":\"photo\",\"photo\":{\"album_id\":-7,\"date\":1679643578,\"id\":457248555,\"owner_id\":87765,\"access_key\":\"a31c5bb7e9dbbd5e91\",\"sizes\":[{\"height\":130,\"type\":\"m\",\"width\":97,\"url\":\"https:\\/\\/sun9-23.userapi.com\\/impg\\/2KEqLHsamfbGuM3Pk3SZvPPjg1vcxrtvjgRENA\\/lQj7g9h7lAU.jpg?size=97x130&quality=96&sign=45ee121954b92d355196f62d5e2b4071&c_uniq_tag=2f_V1fDExfuaAnvjCmBQDvqpwKBEbXBjNJv9UFya1Qo&type=album\"},{\"height\":173,\"type\":\"o\",\"width\":130,\"url\":\"https:\\/\\/sun9-23.userapi.com\\/impg\\/2KEqLHsamfbGuM3Pk3SZvPPjg1vcxrtvjgRENA\\/lQj7g9h7lAU.jpg?size=130x173&quality=96&sign=4a0efc4535793fc42ec6a49cc7157666&c_uniq_tag=LeMtliGbyjNyRVzH1QJ4Bk7lQ2HWw3ei4nckG-6vOr4&type=album\"},{\"height\":267,\"type\":\"p\",\"width\":200,\"url\":\"https:\\/\\/sun9-23.userapi.com\\/impg\\/2KEqLHsamfbGuM3Pk3SZvPPjg1vcxrtvjgRENA\\/lQj7g9h7lAU.jpg?size=200x267&quality=96&sign=0420ffb2723276f31311f32cef86591e&c_uniq_tag=e9T_o0TFK01JDJO8eZmeONydcet8hAvVvKT1tPSfbQ0&type=album\"},{\"height\":427,\"type\":\"q\",\"width\":320,\"url\":\"https:\\/\\/sun9-23.userapi.com\\/impg\\/2KEqLHsamfbGuM3Pk3SZvPPjg1vcxrtvjgRENA\\/lQj7g9h7lAU.jpg?size=320x427&quality=96&sign=788afc703d3f34c172d6644988e110db&c_uniq_tag=TCwM9XUr2oDC0NpjfrUHb1R71SLcfEkt8cvuLaMvXXc&type=album\"},{\"height\":680,\"type\":\"r\",\"width\":510,\"url\":\"https:\\/\\/sun9-23.userapi.com\\/impg\\/2KEqLHsamfbGuM3Pk3SZvPPjg1vcxrtvjgRENA\\/lQj7g9h7lAU.jpg?size=510x680&quality=96&sign=2d3fa6e940d52b0aaee3c82dee58fb6c&c_uniq_tag=bm8g_5M1eApSzpp_rImT-Zmpyr9s0b3wiKGsgtLhuec&type=album\"},{\"height\":75,\"type\":\"s\",\"width\":56,\"url\":\"https:\\/\\/sun9-23.userapi.com\\/impg\\/2KEqLHsamfbGuM3Pk3SZvPPjg1vcxrtvjgRENA\\/lQj7g9h7lAU.jpg?size=56x75&quality=96&sign=6b820ccd14dfb05994ef22f59af2dadf&c_uniq_tag=0OWC6rmOvUoPekDfp0hEfy5uQJdlAOxCGPkTdqn8Be8&type=album\"},{\"height\":1920,\"type\":\"w\",\"width\":1440,\"url\":\"https:\\/\\/sun9-23.userapi.com\\/impg\\/2KEqLHsamfbGuM3Pk3SZvPPjg1vcxrtvjgRENA\\/lQj7g9h7lAU.jpg?size=1440x1920&quality=96&sign=b0f9bf664048bdee4e7d411137049bb3&c_uniq_tag=Eks_fJaRMAHXqOrne6YSv2zXWa28ktBc3mFEK0wlk5w&type=album\"},{\"height\":604,\"type\":\"x\",\"width\":453,\"url\":\"https:\\/\\/sun9-23.userapi.com\\/impg\\/2KEqLHsamfbGuM3Pk3SZvPPjg1vcxrtvjgRENA\\/lQj7g9h7lAU.jpg?size=453x604&quality=96&sign=b1794c27adbb2d677a29e0895869dfe8&c_uniq_tag=D9z4fCZJ_axCO9XG8dqrzvtQl2TEzhDgnrojGXjPg6I&type=album\"},{\"height\":807,\"type\":\"y\",\"width\":605,\"url\":\"https:\\/\\/sun9-23.userapi.com\\/impg\\/2KEqLHsamfbGuM3Pk3SZvPPjg1vcxrtvjgRENA\\/lQj7g9h7lAU.jpg?size=605x807&quality=96&sign=50cdbf0f554dec381ea86b09550933a4&c_uniq_tag=nCwTce_QcLo66o_b6TzykkK0Gq74KXA80TfONedJiKM&type=album\"},{\"height\":1080,\"type\":\"z\",\"width\":810,\"url\":\"https:\\/\\/sun9-23.userapi.com\\/impg\\/2KEqLHsamfbGuM3Pk3SZvPPjg1vcxrtvjgRENA\\/lQj7g9h7lAU.jpg?size=810x1080&quality=96&sign=6e258b0a05b808c9c18c26525965ead6&c_uniq_tag=n0yiH2JXQLQyMmR_orrHVQyl2ZJB_fog56zupP6ickE&type=album\"}],\"text\":\"\",\"has_tags\":false}}],\"date\":1679643592,\"edited\":1679643689,\"from_id\":87765,\"id\":4463,\"is_favorite\":false,\"likes\":{\"can_like\":0,\"count\":4,\"user_likes\":0},\"owner_id\":87765,\"post_type\":\"post\",\"reposts\":{\"count\":0},\"text\":\"Воемя здесь застыло.Архангельск.\",\"views\":{\"count\":171}}', 0); result: OK
cacheVkPost(): INSERT INTO vkSources VALUES (87765, 1679677132, 0) ON DUPLICATE KEY UPDATE lastRead=1679677132; result: NOK
getQueryParam(): course=1984
getRow(): SELECT id FROM course where end='1983'; result: OK
getRow(): SELECT id FROM course where end='1985'; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1984 AND type <> 't' AND org='' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (531,532,533,534,535,536,537,538,860,1092,1093,1094,1095,1096,1097,1098,1314,1315,1316,1317,1318,1859,1860,1861,1862,1920,2789) AND 0 >= rights ORDER BY lname, fname, mname; result: OK
getTeachers4Course(): SELECT person.id, lname, fname, mname, parallel FROM person, person2course WHERE person.id = person2course.person AND person2course.course = 1984 AND type = 't' AND 0 >= rights AND org='' ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1984; result: OK
getRow(): SELECT id FROM uri where uri='/course1984'; result: OK
getDateCounter(): SELECT COUNT(*) from user where creation_time > '1679590733'; result: OK
error log
cacheVkPost(): Error executing query INSERT INTO vkSources VALUES (87765, 1679677132, 0) ON DUPLICATE KEY UPDATE lastRead=1679677132; Column count doesn't match value count at row 1