Предложения спонсоров «Капелланина»: |
debug info
db_connect()
mysql_query: SELECT id FROM addr where ip='3.145.74.54';
getRow(): SELECT id FROM addr where ip='3.145.74.54'; result: OK
mysql_query: SELECT mode FROM addr where id='1020236';
getValue(): SELECT mode FROM addr where id='1020236'; result: OK
User not logged in or cookies disabled
Addr_id: 1020236; Addr_mode: 1
case ADDR_TESTING
mysql_query: SELECT time FROM addr where id='1020236';
getValue(): SELECT time FROM addr where id='1020236'; result: OK
Cookies disabled
mysql_query: UPDATE addr SET mode='2' WHERE id = 1020236;
setValue(): UPDATE addr SET mode='2' WHERE id = 1020236; result: OK
URI: /id4133
Script: /names/index.php
Query: ID=4133
Referer:
mysql_query: SELECT `value` FROM `blob` WHERE `key` = 'vkAutoCache'
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vkAutoCache' result: OK
mysql_query: SELECT `value` FROM `blob` WHERE `key` = 'vkCache'
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vkCache' result: OK
mysql_query: INSERT INTO `blob` (`key`, `value`) VALUES ('vkCache', '1713444046.978811');
lockVkCache(1): INSERT INTO `blob` (`key`, `value`) VALUES ('vkCache', '1713444046.978811'); result: OK
mysql_query: SELECT userId FROM vkSources WHERE exclude=0 ORDER BY lastRead LIMIT 1;
getRow(): SELECT userId FROM vkSources WHERE exclude=0 ORDER BY lastRead LIMIT 1; result: OK
Getting posts for user 85464202. vk.api method: wall.get
mysql_query: SELECT `value` FROM `blob` WHERE `key` = 'vk'
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vk' result: OK
Checking vk access token... Valid. Expires 2024-04-19 08:53:30
Got 10. mysql_query: SELECT id FROM vkCache WHERE userId='85464202' AND postId='1075'
getRow(): SELECT id FROM vkCache WHERE userId='85464202' AND postId='1075' result: OK
mysql_query: INSERT INTO vkSources (userId, lastRead, exclude) VALUES (85464202, 1713444045, 0) ON DUPLICATE KEY UPDATE lastRead=1713444045;
addUser(): INSERT INTO vkSources (userId, lastRead, exclude) VALUES (85464202, 1713444045, 0) ON DUPLICATE KEY UPDATE lastRead=1713444045; result: OK
mysql_query: UPDATE vkSources SET lastRead=1713444045, state='no updates (10 old posts)', exclude=0 WHERE userId=85464202;
cacheVkPost(): UPDATE vkSources SET lastRead=1713444045, state='no updates (10 old posts)', exclude=0 WHERE userId=85464202; result: OK
mysql_query: DELETE FROM `blob` WHERE `key` = 'vkCache';
lockVkCache(): DELETE FROM `blob` WHERE `key` = 'vkCache'; result: OK
getQueryParam(): id=4133
mysql_query: SELECT * FROM person WHERE id=4133 AND 0 >= person.rights;
getRow(): SELECT * FROM person WHERE id=4133 AND 0 >= person.rights; result: OK
mysql_query: SELECT byear, ddate, dmonth, dyear FROM person WHERE id = 4133;
getRow(): SELECT byear, ddate, dmonth, dyear FROM person WHERE id = 4133; result: OK
mysql_query: SELECT * FROM person WHERE id = 4133 AND 0 >= rights;
getRow(): SELECT * FROM person WHERE id = 4133 AND 0 >= rights; result: OK
mysql_query: SELECT * FROM person2course WHERE person=4133;
getAcademInfo(): SELECT * FROM person2course WHERE person=4133; result: OK
mysql_query: SELECT id, lname, fname, mname, type FROM person, person2person WHERE id2=id AND id1=4133 AND 0 >= rights order by start;
getRelatives4Person: SELECT id, lname, fname, mname, type FROM person, person2person WHERE id2=id AND id1=4133 AND 0 >= rights order by start; result: OK
mysql_query: SELECT * FROM activity WHERE person_id = 4133;
getActivities(): SELECT * FROM activity WHERE person_id = 4133; result: OK
mysql_query: SELECT id, lname, fname, mname, type FROM person, person2person WHERE id1=id AND id2=4133 AND 0 >= rights order by lname, fname, mname;
getRelatives4Person: SELECT id, lname, fname, mname, type FROM person, person2person WHERE id1=id AND id2=4133 AND 0 >= rights order by lname, fname, mname; result: OK
mysql_query: SELECT event.* FROM person2event, event WHERE person=4133 AND event.id=person2event.event AND sdate >= '2024-4-18' GROUP BY event.id ORDER BY sdate ASC;
getEvents4Person(): SELECT event.* FROM person2event, event WHERE person=4133 AND event.id=person2event.event AND sdate >= '2024-4-18' GROUP BY event.id ORDER BY sdate ASC; result: OK
mysql_query: SELECT event.* FROM person2event, event WHERE person=4133 AND event.id=person2event.event AND sdate < '2024-4-18' GROUP BY event.id ORDER BY sdate DESC;
getEvents4Person(): SELECT event.* FROM person2event, event WHERE person=4133 AND event.id=person2event.event AND sdate < '2024-4-18' GROUP BY event.id ORDER BY sdate DESC; result: OK
mysql_query: SELECT material_id FROM person2material WHERE person2material.id=4133 ORDER BY type DESC;
getMaterials4Person(): SELECT material_id FROM person2material WHERE person2material.id=4133 ORDER BY type DESC; result: OK
mysql_query: SELECT * FROM person2source WHERE id=4133;
getSources(): SELECT * FROM person2source WHERE id=4133; result: OK
mysql_query: SELECT id FROM foto2person WHERE foto2person.person_id = 4133;
getThumbnails4Person(): SELECT id FROM foto2person WHERE foto2person.person_id = 4133; result: OK
mysql_query: SELECT * FROM foto WHERE id in ORDER BY sdate, id;
getThumbnails4Person(): SELECT * FROM foto WHERE id in ORDER BY sdate, id; result: NOK
getThumbnails4Person(): Error executing query SELECT * FROM foto WHERE id in ORDER BY sdate, id; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY sdate, id' at line 1
mysql_query: SELECT * FROM contacts4person WHERE id = 4133 ORDER BY type;
printContactInfo(): SELECT * FROM contacts4person WHERE id = 4133 ORDER BY type; result: OK
mysql_query: SELECT * FROM person WHERE id=4133 AND 0 >= person.rights;
getRow(): SELECT * FROM person WHERE id=4133 AND 0 >= person.rights; result: OK
mysql_query: SELECT id FROM uri where uri='/id4133';
getRow(): SELECT id FROM uri where uri='/id4133'; result: OK
mysql_query: SELECT COUNT(*) from user where creation_time > '1713357645';
getDateCounter(): SELECT COUNT(*) from user where creation_time > '1713357645'; result: OK
error log
getThumbnails4Person(): Error executing query SELECT * FROM foto WHERE id in ORDER BY sdate, id; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY sdate, id' at line 1
