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.

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

Adding or editing links result in 500 Server Error #884

Open
cloo opened this issue Jan 5, 2025 · 6 comments
Open

Adding or editing links result in 500 Server Error #884

cloo opened this issue Jan 5, 2025 · 6 comments

Comments

@cloo
Copy link

cloo commented Jan 5, 2025

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

@JulianPrieber
Copy link
Member

Could you provide a stack trace or error log?

@cloo
Copy link
Author

cloo commented Jan 11, 2025

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.

@matebitte
Copy link

Same here. Also special blocks like headings / spacers are broken.

This should be a heading:
Image

@matebitte
Copy link

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.

@breakiboy
Copy link

hi I have the same error. here is the trace of the Instance my Link
https://flareapp.io/share/xPQvVN17

@devinbaeten
Copy link

devinbaeten commented Jan 26, 2025

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')

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

5 participants