Предложения спонсоров «Капелланина»: |
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: /course1987
Script: /names/index.php
Query: COURSE=1987
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 697629. 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='697629' AND postId='592' result: OK
addUser(): INSERT INTO vkSources VALUES (697629, 1685884921, 0) ON DUPLICATE KEY UPDATE lastRead=1685884921; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (697629, 1685884921, 0) ON DUPLICATE KEY UPDATE lastRead=1685884921; Column count doesn't match value count at row 1
cacheVkPost(): UPDATE vkSources SET lastRead=1685884921, state='no updates (10 old posts)', exclude=0 WHERE userId=697629; result: OK
lockVkCache(): DELETE FROM `blob` WHERE `key` = 'vkCache'; result: OK
getQueryParam(): course=1987
getRow(): SELECT id FROM course where end='1986'; result: OK
getRow(): SELECT id FROM course where end='1988'; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1987 AND type <> 't' AND org='' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (561,562,563,564,565,566,567,568,569,570,787,887,985,1007,1008,1009,1053,1189,1191,1192,1193,1194,1195,1196,1213) 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 = 1987 AND type = 't' AND 0 >= rights AND org='' ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1987; result: OK
getRow(): SELECT id FROM uri where uri='/course1987'; result: OK
getDateCounter(): SELECT COUNT(*) from user where creation_time > '1685798522'; result: OK
error log
addUser(): Error executing query INSERT INTO vkSources VALUES (697629, 1685884921, 0) ON DUPLICATE KEY UPDATE lastRead=1685884921; Column count doesn't match value count at row 1