Предложения спонсоров «Капелланина»: |
debug info
/log/db.php.getRow: SELECT id FROM addr where ip='18.117.188.213'; result: OK
/login/db.php.getValue: SELECT mode FROM addr where id='1067541'; result: OK
User not logged in or cookies disabled
Addr_id: 1067541; Addr_mode: 1
case ADDR_TESTING
/login/db.php.getValue: SELECT time FROM addr where id='1067541'; result: OK
Cookies enabled. Creating new user
/login/db.php.getEmptyId: SELECT t1.id+1 AS Missing FROM user AS t1 LEFT JOIN user AS t2 ON t1.id+1 = t2.id WHERE t2.id IS NULL ORDER BY t1.id LIMIT 1; result: OK
emptyId=1953594
/login/db.php.newUser: insert into user values ('1953594','','','0','0','1725155214','i','65535'); result: OK
/login/db.php.setValue: UPDATE addr SET mode='0' WHERE id = 1067541; result: OK
/login/db.php.getRow: SELECT * FROM user where id=1953594; result: OK
URI: /id3051
Script: /names/index.php
Query: ID=3051
Referer:
/vk/model.php.getRow: SELECT `value` FROM `blob` WHERE `key` = 'vkAutoCache' result: OK
/vk/model.php.getRow: SELECT `value` FROM `blob` WHERE `key` = 'vkCache' result: OK
/vk/model.php.lockVkCache: INSERT INTO `blob` (`key`, `value`) VALUES ('vkCache', '1725155216.898707'); result: OK
/vk/model.php.getRow: SELECT userId FROM vkSources WHERE exclude=0 ORDER BY lastRead LIMIT 1; result: OK
Getting posts for user -58313928. vk.api method: wall.get
/log/db.php.getRow: SELECT `value` FROM `blob` WHERE `key` = 'vk' result: OK
Checking vk access token... Valid. Expires 2024-09-01 11:50:20
Got 10. /vk/model.php.getRow: SELECT id FROM vkCache WHERE userId='-58313928' AND postId='5030' result: OK
/vk/model.php.addUser: INSERT INTO vkSources (userId, lastRead, exclude) VALUES (-58313928, 1725155215, 0) ON DUPLICATE KEY UPDATE lastRead=1725155215; result: OK
/vk/model.php.getRow: SELECT id FROM vkCache WHERE userId='-58313928' AND postId='5026' result: OK
/vk/model.php.addUser: INSERT INTO vkSources (userId, lastRead, exclude) VALUES (-58313928, 1725155215, 0) ON DUPLICATE KEY UPDATE lastRead=1725155215; result: OK
/vk/model.php.updateUser: UPDATE vkSources SET lastRead=1725155215, state='no updates (10 old posts)', exclude=0 WHERE userId=-58313928; result: OK
/vk/model.php.lockVkCache: DELETE FROM `blob` WHERE `key` = 'vkCache'; result: OK
getQueryParam(): id=3051
/log/db.php.getRow: SELECT * FROM person WHERE id=3051 AND 0 >= person.rights; result: OK
/names/db.php.getRow: SELECT byear, ddate, dmonth, dyear FROM person WHERE id = 3051; result: OK
/names/db.php.getRow: SELECT * FROM person WHERE id = 3051 AND 0 >= rights; result: OK
/names/db.php.getAcademInfoNew: SELECT * FROM person2course WHERE person=3051; result: OK
/names/db.php.getRelatives4Person: SELECT id, lname, fname, mname, type FROM person, person2person WHERE id2=id AND id1=3051 AND 0 >= rights order by start; result: OK
/names/db.php.getActivities: SELECT * FROM activity WHERE person_id = 3051; result: OK
/names/db.php.getRelatives4Person: SELECT id, lname, fname, mname, type FROM person, person2person WHERE id1=id AND id2=3051 AND 0 >= rights order by lname, fname, mname; result: OK
/names/db.php.getEvents4Person: SELECT event.* FROM person2event, event WHERE person=3051 AND event.id=person2event.event AND sdate >= '2024-9-01' GROUP BY event.id ORDER BY sdate ASC; result: OK
/names/db.php.getEvents4Person: SELECT event.* FROM person2event, event WHERE person=3051 AND event.id=person2event.event AND sdate < '2024-9-01' GROUP BY event.id ORDER BY sdate DESC; result: OK
/misc/db.php.getList: SELECT material_id FROM person2material WHERE person2material.id=3051 ORDER BY type DESC; result: OK
/names/db.php.getSources: SELECT * FROM person2source WHERE id=3051; result: OK
/foto/db.php.getList: SELECT id FROM foto2person WHERE foto2person.person_id = 3051; result: OK
/names/db.php.getThumbnails4Person: SELECT * FROM foto WHERE id in ORDER BY sdate, id; result: 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
/names/db.php.getContacts: SELECT * FROM contacts4person WHERE id = 3051 ORDER BY type; result: OK
/log/db.php.getRow: SELECT * FROM person WHERE id=3051 AND 0 >= person.rights; result: OK
/log/db.php.getRow: SELECT id FROM uri where uri='/id3051'; result: OK
/counter.php.countUsers: SELECT COUNT(*) from user where creation_time > '1725068815'; result: OK
error log
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