Skip to content

Error (SQLSTATE[HY000]) while saving #878

New issue

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

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

Already on GitHub? # to your account

Closed
magostinelli opened this issue Dec 25, 2024 · 6 comments
Closed

Error (SQLSTATE[HY000]) while saving #878

magostinelli opened this issue Dec 25, 2024 · 6 comments

Comments

@magostinelli
Copy link

LinkStack version

4.8.4

Description

After editing a page, example adding a space between links, i receive the following error:
SQLSTATE[HY000]: General error: 1 table links has no column named type_params

Query sql involved:
insert into "links" ("title", "button_id", "type_params", "user_id", "id", "updated_at", "created_at") values (5, 43, {"type":"spacer","custom_html":true,"ignore_container":false,"incl

Details about your system

Debian 11, yunohost 11.3.0.2, php 8.1

How to reproduce

Insert or edit links, and save

Possible Solution

No response

Additional Context

immagine

@tvx-matt
Copy link

@magostinelli
It would seem a required table is missing from your database.

Please try executing your.domain/update?finishing
This has previously fixed missing tables in the database.
If this does not work, feel free to ping me and I will take a further look.

@magostinelli
Copy link
Author

Thanks you for your fast reply, I have already tried with update finishing, but nothing changed.

@JulianPrieber
Copy link
Member

You have to run the entire update again. The preparing step has to finish properly.

@magostinelli
Copy link
Author

Yes, but I Don't know how to restart the database upgrade manually, because the of installati on is managed by yunohost. If I revert back an old backup my users will have the old data in their pages.

@magostinelli
Copy link
Author

magostinelli commented Jan 1, 2025

Any news? I tried with /update or update?finishing but nothing changed.

@JulianPrieber
Copy link
Member

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants