Skip to content

After update to 2.5.9 #35

Description

@lastsamurai26

SQLSTATE[HY000]: General error: 1 no such column: links.custom_css (SQL: select "links"."link", "links"."id", "links"."button_id", "links"."title", "links"."custom_css", "links"."custom_icon", "buttons"."name" from "links" inner join "buttons" on "buttons"."id" = "links"."button_id" where "user_id" = 3 order by "up_link" asc, "order" asc)

I hope I didn't do anything wrong but after the update I can't access my page anymore only the admin panel.

Activity

  1. JulianPrieber commented on Apr 27, 2022

    @JulianPrieber
    Member

    This is most likely due to a missing database entry. The last update added two new database entries, which you're probably missing.

    Assuming you are running with the default, SQLite database, try temporarily replacing your database with the one in the zip file found here, just to be sure.

    Please make a backup of your current database before doing that.

  2. lastsamurai26 commented on Apr 27, 2022

    @lastsamurai26
    MemberAuthor

    Yes, I saw it :/ new indexes have been created in the create links :-D dooof can't I update them somehow ? means I have to transfer my datasets

  3. JulianPrieber commented on Apr 27, 2022

    @JulianPrieber
    Member

    Honestly, I'm not even sure myself. Lemme try real quick.

  4. JulianPrieber commented on Apr 27, 2022

    @JulianPrieber
    Member

    In my testing, I was not able to add the entry with the usual migrate command php artisan migrate. After some digging online, it seems to be possible to add new columns to the database with migrations, but I'm not really sure how.

    I would probably just add the entries manually. Or rebuild the links from scratch.

  5. lastsamurai26 commented on Apr 27, 2022

    @lastsamurai26
    MemberAuthor

    I compared both databases with each other and copied all the data records from my own database as SQL and then copied them into the new database, including the users.

    Correct I have rebuilt the database manually with the "Update database".

  6. lastsamurai26 commented on Apr 27, 2022

    @lastsamurai26
    MemberAuthor

    :-( I would like to help, but I don't know how this seeder works and how the migration should work. Maybe I can find a solution then you can build it in.

  7. JulianPrieber commented on Apr 27, 2022

    @JulianPrieber
    Member

    About a month ago, I experimented with implementing this solution here and this would probably work for us, but currently there is a bug present in the code which makes using the thing impossible. This bug was pointed out multiple times by users, but the dev isn't actively responding to issues at the moment, so it might be awhile until this can finally be implemented.

  8. lastsamurai26 commented on Apr 27, 2022

    @lastsamurai26
    MemberAuthor

    ok, if this has already been reported but the developer does not fix it, does anyone know where the error lies so that this can be cloned and then fixed?

  9. JulianPrieber commented on Apr 27, 2022

    @JulianPrieber
    Member

    I tried a bit myself, but I can't really find the cause. This appears to be a simple formatting error that should be fairly easy to solve if you know what you're doing in PHP.

  10. lastsamurai26 commented on Apr 27, 2022

    @lastsamurai26
    MemberAuthor

    I'll have to take a look at it and see if I can find the problem.

  11. JulianPrieber commented on Apr 27, 2022

    @JulianPrieber
    Member

    This issue probably describes it best: https://github.com/codedge/laravel-selfupdater/issues/309. I'm fairly certain that this issue got introduced with a decently recent push, but I'm not entirely sure about the exact time frame.

    The issue is that a function calling a certain URL with cURL has a syntax error, more precisely, a simple "/" is missing between the version variable and the URL.

  12. locked and limited conversation to collaborators on Apr 28, 2022
  13. converted this issue into a discussion #38 on Apr 28, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions