Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Fix weird db query error #138

Open
voxpelli opened this issue Nov 9, 2020 · 3 comments
Open

Fix weird db query error #138

voxpelli opened this issue Nov 9, 2020 · 3 comments
Assignees
@voxpelli
Labels
bug

Comments

@voxpelli
Copy link
Owner

voxpelli commented Nov 9, 2020

Skärmavbild 2020-11-09 kl 21 15 15

Apparently happens here:

webpage-webmentions/lib/classes/entries.js

Line 296 in 3ec2e8a

const fullQuery = knex.raw('WITH RECURSIVE "allmentions"("eid", "parent", "normalizedUrl", "url") AS (' + query + ') ' + entryQuery + '');

@voxpelli voxpelli added the bug label Nov 9, 2020
@voxpelli voxpelli self-assigned this Nov 9, 2020
@voxpelli voxpelli mentioned this issue Nov 9, 2020
Open
@voxpelli
Copy link
Owner Author

voxpelli commented Nov 9, 2020

Skärmavbild 2020-11-09 kl 21 59 47

Maybe caused by this ☝️

@voxpelli
Copy link
Owner Author

Still happening, no service updates now

Skärmavbild 2020-12-30 kl 19 25 59

@voxpelli
Copy link
Owner Author

Still happens, seems to be caused by an URL like:

https://webmention.herokuapp.com/api/mentions?site=ihrkammerjaeger24.de%2Fkammerjaeger%2Fbayern%2Funterhinterhof%2F&format=html

Skärmavbild 2021-08-24 kl 10 43 40

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@voxpelli voxpelli

Labels
bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@voxpelli