Adding or editing links result in 500 Server Error
cloo opened this issue · 14 comments
LinkStack version
4.8.4
Description
After update to 4.8.4 (or could be earlier, as I did not edit links every time), adding and editing links broke. Interfaces work well, but clicking on "Save" and "Save and add more" result in Error 500.
Deleting links is permitted.
Trying to create a backup also results in 500.
File access permissions in "diagnosis" page are reported as ok. File permissions in system are linkstack:www-data. Tried to bulk-change to linkstack:linkstack without success.
Details about your system
Debian 12, YunoHost 12.0.9.1 (stable), bare metal home server.
How to reproduce
not sure what info to provide here.
Possible Solution
No response
Additional Context
No response
Could you provide a stack trace or error log?
I need some help here.
/var/log has no linkstack folder, and in linkstack docs do not help me find it.
Getting stack trace seems to require specific knowledge too.
Here’s what I could gather with debug mode enabled: https://flareapp.io/share/KPgYM2q5#debug
No context block, since there’s sensitive info there. If you need something specific, let me know.
hi I have the same error. here is the trace of the Instance my Link
https://flareapp.io/share/xPQvVN17
I tried running the failed MySQL query for adding a social link directly in my database client, and found that the strings are not in quotations, leading to a format-related error from my DB. Not sure if this is the problem, but it seems to be related to the database in some way.
Original:
insert into links (link, user_id, title, button_id, id, updated_at, created_at) values (https://github.com/devinbaeten, 1, github, 94, 395209690, 2025-01-26 00:53:32, 2025-01-26 00:53:32)Corrected:
insert into `links` (`link`, `user_id`, `title`, `button_id`, `id`, `updated_at`, `created_at`) values ('https://github.com/devinbaeten', 1, 'github', 94, 395209690, '2025-01-26 00:53:32', '2025-01-26 00:53:32')@tvx-matt, is this fixed on v4.8.4? I am currently running this version and experience the issue.
My bad, @devinbaeten, It seems I got this confused with another previous fix for the same / similar issue previously.
I do not however seem to have this issue on the Latest Beta versions.
@tvx-matt, got it. Thanks for confirming. It's not a critical issue for me, so I will most likely wait to test further until the fix is brought to a new release.
I am also encountering the same problem now. And because I activated "Automatic Upgrade" as soon as I installed it, I can't add links now.
