Предложения спонсоров «Капелланина»: |
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: /id596
Script: /names/index.php
Query: ID=596
Referer:
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vkCache' result: OK
lockVkCache(1): INSERT INTO `blob` (`key`, `value`) VALUES ('vkCache', '250000'); result: NOK
lockVkCache(1): Error executing query INSERT INTO `blob` (`key`, `value`) VALUES ('vkCache', '250000'); Duplicate entry 'vkCache' for key 'PRIMARY'
getRow(): SELECT userId FROM vkSources WHERE exclude=0 ORDER BY lastRead LIMIT 1; result: OK
Getting posts for user 157066390. 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. cacheVkPost(): UPDATE vkSources SET lastRead=1685887587, state='no updates (10 old posts)', exclude=0 WHERE userId=157066390; result: OK
lockVkCache(): DELETE FROM `blob` WHERE `key` = 'vkCache'; result: OK
getQueryParam(): id=596
getRow(): SELECT * FROM person WHERE id=596 AND 0 >= person.rights; result: OK
getRow(): SELECT byear, ddate, dmonth, dyear FROM person WHERE id = 596; result: OK
getRow(): SELECT * FROM person WHERE id = 596 AND 0 >= rights; result: OK
getAcademInfo(): SELECT * FROM person2course WHERE person=596; result: OK
getRelatives4Person: SELECT id, lname, fname, mname, type FROM person, person2person WHERE id2=id AND id1=596 AND 0 >= rights order by start; result: OK
getActivities(): SELECT * FROM activity WHERE person_id = 596; result: OK
getRelatives4Person: SELECT id, lname, fname, mname, type FROM person, person2person WHERE id1=id AND id2=596 AND 0 >= rights order by lname, fname, mname; result: OK
getEvents4Person(): SELECT event.* FROM person2event, event WHERE person=596 AND event.id=person2event.event AND sdate >= '2023-6-04' GROUP BY event.id ORDER BY sdate ASC; result: OK
getEvents4Person(): SELECT event.* FROM person2event, event WHERE person=596 AND event.id=person2event.event AND sdate < '2023-6-04' GROUP BY event.id ORDER BY sdate DESC; result: OK
getMaterials4Person(): SELECT material_id FROM person2material WHERE person2material.id=596 ORDER BY type DESC; result: OK
getSources(): SELECT * FROM person2source WHERE id=596; result: OK
getThumbnails4Person(): SELECT id FROM foto2person WHERE foto2person.person_id = 596; result: OK
getThumbnails4Person(): SELECT * FROM foto WHERE id in (191, 193, 209, 210, 261, 390, 489, 584, 1620, 3987, 14033, 14032, 14116, 14117, 14118, 14120, 14121, 14122) ORDER BY sdate, id; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 1620 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 14116 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 14121 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 3987 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 390 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 14117 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 14118 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 584 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 209 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 210 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 191 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 261 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 193 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 489 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 14120 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 14032 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 14122 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 14033 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
printContactInfo(): SELECT * FROM contacts4person WHERE id = 596 ORDER BY type; result: OK
getRow(): SELECT * FROM person WHERE id=596 AND 0 >= person.rights; result: OK
getRow(): SELECT id FROM uri where uri='/id596'; result: OK
getDateCounter(): SELECT COUNT(*) from user where creation_time > '1685801188'; result: OK
error log
lockVkCache(1): Error executing query INSERT INTO `blob` (`key`, `value`) VALUES ('vkCache', '250000'); Duplicate entry 'vkCache' for key 'PRIMARY'