Предложения спонсоров «Капелланина»: |
debug info
db_connect()
getRow(): SELECT id FROM addr where ip='18.207.240.77'; result: OK
getValue(): SELECT mode FROM addr where id='923536'; result: OK
User not logged in or cookies disabled
Addr_id: 923536; Addr_mode: 1
case ADDR_TESTING
getValue(): SELECT time FROM addr where id='923536'; result: OK
Cookies disabled
setValue(): UPDATE addr SET mode='2' WHERE id = 923536; result: OK
URI: /course1959
Script: /names/index.php
Query: COURSE=1959
Referer:
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vkCache' result: OK
lockVkCache(1): INSERT INTO `blob` (`key`, `value`) VALUES ('vkCache', '250000'); result: OK
getRow(): SELECT userId FROM vkSources WHERE exclude=0 ORDER BY lastRead LIMIT 1; result: OK
Getting posts for user -72342. vk.api method: wall.get
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vk' result: OK
Checking vk access token... Valid. Expires 2023-06-05 07:37:53
Got 10. getRow(): SELECT id FROM vkCache WHERE userId='-72342' AND postId='2814' result: OK
addUser(): INSERT INTO vkSources VALUES (-72342, 1685886322, 0) ON DUPLICATE KEY UPDATE lastRead=1685886322; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (-72342, 1685886322, 0) ON DUPLICATE KEY UPDATE lastRead=1685886322; Column count doesn't match value count at row 1
getRow(): SELECT id FROM vkCache WHERE userId='-72342' AND postId='2810' result: OK
addUser(): INSERT INTO vkSources VALUES (-72342, 1685886322, 0) ON DUPLICATE KEY UPDATE lastRead=1685886322; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (-72342, 1685886322, 0) ON DUPLICATE KEY UPDATE lastRead=1685886322; Column count doesn't match value count at row 1
cacheVkPost(): UPDATE vkSources SET lastRead=1685886322, state='no updates (10 old posts)', exclude=0 WHERE userId=-72342; result: OK
lockVkCache(): DELETE FROM `blob` WHERE `key` = 'vkCache'; result: OK
getQueryParam(): course=1959
getRow(): SELECT id FROM course where end='1958'; result: OK
getRow(): SELECT id FROM course where end='1960'; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1959 AND type <> 't' AND org='' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (213,214,215,216,217,218,219,220,221,222,223,224,225,4197,4202,4203,4211,4212,4214,4217,4229,4232) 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 = 1959 AND type = 't' AND 0 >= rights AND org='' ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1959; result: OK
getRow(): SELECT id FROM uri where uri='/course1959'; result: OK
getDateCounter(): SELECT COUNT(*) from user where creation_time > '1685799922'; result: OK
error log
addUser(): Error executing query INSERT INTO vkSources VALUES (-72342, 1685886322, 0) ON DUPLICATE KEY UPDATE lastRead=1685886322; Column count doesn't match value count at row 1
addUser(): Error executing query INSERT INTO vkSources VALUES (-72342, 1685886322, 0) ON DUPLICATE KEY UPDATE lastRead=1685886322; Column count doesn't match value count at row 1