debug info
db_connect()
getRow(): SELECT id FROM addr where ip='3.235.60.197'; result: OK
getValue(): SELECT mode FROM addr where id='973970'; result: OK
User not logged in or cookies disabled
Addr_id: 973970; Addr_mode: 1
case ADDR_TESTING
getValue(): SELECT time FROM addr where id='973970'; result: OK
Cookies disabled
setValue(): UPDATE addr SET mode='2' WHERE id = 973970; result: OK
URI: /course1992
Script: /names/index.php
Query: COURSE=1992
Referer:
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vkCache' result: OK
lockVkCache(1): INSERT INTO `blob` (`key`, `value`) VALUES ('vkCache', '1702100772.779591'); result: OK
getRow(): SELECT userId FROM vkSources WHERE exclude=0 ORDER BY lastRead LIMIT 1; result: OK
Getting posts for user -122236125. vk.api method: wall.get
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vk' result: OK
Checking vk access token... Valid. Expires 2023-12-09 09:53:37
Got 10. getRow(): SELECT id FROM vkCache WHERE userId='-122236125' AND postId='8123' result: OK
addUser(): INSERT INTO vkSources VALUES (-122236125, 1702100770, 0) ON DUPLICATE KEY UPDATE lastRead=1702100770; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (-122236125, 1702100770, 0) ON DUPLICATE KEY UPDATE lastRead=1702100770; Column count doesn't match value count at row 1
getRow(): SELECT id FROM vkCache WHERE userId='-122236125' AND postId='8122' result: OK
addUser(): INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; Column count doesn't match value count at row 1
getRow(): SELECT id FROM vkCache WHERE userId='-122236125' AND postId='8121' result: OK
addUser(): INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; Column count doesn't match value count at row 1
getRow(): SELECT id FROM vkCache WHERE userId='-122236125' AND postId='8120' result: OK
addUser(): INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; Column count doesn't match value count at row 1
getRow(): SELECT id FROM vkCache WHERE userId='-122236125' AND postId='8118' result: OK
addUser(): INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; Column count doesn't match value count at row 1
getRow(): SELECT id FROM vkCache WHERE userId='-122236125' AND postId='8117' result: OK
addUser(): INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; Column count doesn't match value count at row 1
getRow(): SELECT id FROM vkCache WHERE userId='-122236125' AND postId='8116' result: OK
addUser(): INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; result: NOK
addUser(): Error executing query INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; Column count doesn't match value count at row 1
cacheVkPost(): UPDATE vkSources SET lastRead=1702100771, state='no updates (10 old posts)', exclude=0 WHERE userId=-122236125; result: OK
lockVkCache(): DELETE FROM `blob` WHERE `key` = 'vkCache'; result: OK
getQueryParam(): course=1992
getRow(): SELECT id FROM course where end='1991'; result: OK
getRow(): SELECT id FROM course where end='1993'; result: OK
printCourseList(): SELECT * FROM (SELECT * FROM person2course WHERE course = 1992 AND type <> 't' AND org='' ORDER by type, end) t1 GROUP BY t1.person; result: OK
printCourseList(): SELECT * FROM person WHERE id in (86,608,620,621,622,623,624,625,626,627,628,629,631,632,636,725,726,727,728,729,732,733,734,735,736,737,738,739,740,741,742,743,751,786,956,957,980,1505,1506,1507,2326,2614,3201,4101) 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 = 1992 AND type = 't' AND 0 >= rights AND org='' ORDER BY person2course.start; result: OK
getFotos4Course(): SELECT * FROM series WHERE course = 1992; result: OK
getRow(): SELECT id FROM uri where uri='/course1992'; result: OK
getDateCounter(): SELECT COUNT(*) from user where creation_time > '1702014371'; result: OK
error log
addUser(): Error executing query INSERT INTO vkSources VALUES (-122236125, 1702100770, 0) ON DUPLICATE KEY UPDATE lastRead=1702100770; Column count doesn't match value count at row 1
addUser(): Error executing query INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; Column count doesn't match value count at row 1
addUser(): Error executing query INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; Column count doesn't match value count at row 1
addUser(): Error executing query INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; Column count doesn't match value count at row 1
addUser(): Error executing query INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; Column count doesn't match value count at row 1
addUser(): Error executing query INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; Column count doesn't match value count at row 1
addUser(): Error executing query INSERT INTO vkSources VALUES (-122236125, 1702100771, 0) ON DUPLICATE KEY UPDATE lastRead=1702100771; Column count doesn't match value count at row 1