Broken after manual upgrade?
ciroiriarte opened this issue · 3 comments
ciroiriarte commented
LinkStack version
4.8.4
Description
Followed the instructions at https://linkstack.org/update/ which states to use update.zip to upgrade from 4.5.0 to 4.8.4.
Within the zip file, HOW\ TO\ UPDATE.md states to only run:
php artisan db:seed --class="ButtonSeeder"
which fails with:
Illuminate\Database\QueryException
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'alt' in 'field list' (SQL: insert into `buttons` (`alt`, `exclude`, `group`, `mb`, `name`) values (Custom, 1, default, 0, custom), (Custom Website, 1, default, 0, custom_website), (Bandcamp, 0, default, 0, bandcamp), (Buy Me a Coffee, 0, default, 0, coffee), (Cash App, 0, default, 0, cashapp), (Default Email, 1, default, 0, default email), (Default Email Alt, 1, default, 0, default email_alt), (Discord, 0, default, 0, discord), (Facebook, 0, default, 0, facebook), (Figma, 0, default, 0, figma), (GitHub, 0, default, 0, github), (GitLab, 0, default, 0, gitlab), (Goodreads, 0, default, 0, goodreads), (Instagram, 0, default, 0, instagram), (Kit, 0, default, 0, kit), (LinkedIn, 0, default, 0, linkedin), (Mastodon, 0, default, 0, mastodon), (Medium, 0, default, 0, medium), (Messenger, 0, default, 0, messenger), (Patreon, 0, default, 0, patreon), (PayPal, 0, default, 0, paypal), (Pinterest, 0, default, 0, pinterest), (Reddit, 0, default, 0, reddit), (Signal, 0, default, 0, signal), (Skoob, 0, default, 0, skoob), (Snapchat, 0, default, 0, snapchat), (SoundCloud, 0, default, 0, soundcloud), (Spotify, 0, default, 0, spotify), (Steam, 0, default, 0, steam), (Telegram, 0, default, 0, telegram), (TikTok, 0, default, 0, tiktok), (Tumblr, 0, default, 0, tumblr), (Twitch, 0, default, 0, twitch), (X, 0, default, 0, twitter), (Venmo, 0, default, 0, venmo), (Vimeo, 0, default, 0, vimeo), (Website, 1, default, 0, website), (WhatsApp, 0, default, 0, whatsapp), (WordPress, 0, default, 0, wordpress), (Xing, 0, default, 0, xing), (YouTube, 0, default, 0, youtube), (Heading, 1, default, 0, heading), (Space, 1, default, 0, space), (Phone, 1, default, 0, phone), (Trello, 0, default, 0, trello), (LittleLink Custom, 1, default, 0, littlelink-custom), (Space, 1, default, 0, space), (Amazon, 0, default, 0, amazon), (App Store, 0, default, 0, appstore), (Apple Music, 0, default, 0, apple-music), (Apple Podcasts, 0, default, 0, apple-podcasts), (Briar, 0, default, 0, briar), (Castopod, 0, default, 0, castopod), (CodePen, 0, default, 0, codepen), (Codeberg, 0, default, 0, codeberg), (CryptPad, 0, default, 0, cryptpad), (Dev.to, 0, default, 0, dev-to), (Deezer, 0, default, 0, deezer), (Epic Games, 0, default, 0, epic-games), (Etsy, 0, default, 0, etsy), (Firefox, 0, default, 0, firefox), (Flickr, 0, default, 0, flickr), (Funkwhale, 0, default, 0, funkwhale), (F-Droid, 0, default, 0, f-droid), (Itch.io, 0, default, 0, itchio), (Humble Bundle, 0, default, 0, humble-bundle), (Kickstarter, 0, default, 0, kickstarter), (Ko-fi, 0, default, 0, ko-fi), (Lemmy, 0, default, 0, lemmy), (Letterboxd, 0, default, 0, letterboxd), (Liberapay, 0, default, 0, liberapay), (Matrix, 0, default, 0, matrix), (Misskey, 0, default, 0, misskey), (Notion, 0, default, 0, notion), (Odysee, 0, default, 0, odysee), (OpenStreetMap, 0, default, 0, openstreetmap), (Owncast, 0, default, 0, owncast), (PeerTube, 0, default, 0, peertube), (Pixelfed, 0, default, 0, pixelfed), (Piwigo, 0, default, 0, piwigo), (Play Store, 0, default, 0, playstore), (Pleroma, 0, default, 0, pleroma), (Product Hunt, 0, default, 0, producthunt), (Session, 0, default, 0, session), (Strava, 0, default, 0, strava), (Unity, 0, default, 0, unity), (Unraid, 0, default, 0, unraid), (Untappd, 0, default, 0, untappd), (Upptime, 0, default, 0, upptime), (VRChat, 0, default, 0, vrchat), (YouTube Music, 0, default, 0, youtube-music), (All-Inkl, 0, default, 0, all-inkl), (Text, 1, default, 0, text), (Icon, 1, default, 0, icon), (Bookwyrm, 0, default, 0, bookwyrm), (vCard, 1, default, 0, vcard), (Apple Books, 0, default, 0, apple-books), (Scribd, 0, default, 0, scribd), (LinkStack, 0, default, 0, linkstack), (Picarto, 0, default, 0, picarto), (Trakt, 0, default, 0, trakt), (Last.fm, 0, default, 0, last-fm), (Itaku, 0, default, 0, itaku), (Furaffinity, 0, default, 0, furaffinity), (Bluesky, 0, default, 0, bluesky), (Firefish, 0, default, 0, firefish), (Streams, 0, default, 0, streams), (Pronouns.page, 0, default, 0, pronounspage), (BOOTH, 0, default, 0, booth), (HearThis.at, 0, default, 0, hearthisat), (Throne, 0, default, 0, throne), (Behance, 0, default, 0, behance), (Google Drive, 0, default, 0, gdrive), (Friendi.ca, 0, default, 0, friendica), (Simplex, 0, default, 0, simplex), (Xbox, 0, default, 0, xbox), (Threads, 0, default, 0, threads))
at vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
756▕ // If an exception occurs when attempting to run a query, we'll format the error
757▕ // message to include the bindings with SQL, which will make this exception a
758▕ // lot more helpful to the developer instead of just the database's errors.
759▕ catch (Exception $e) {
➜ 760▕ throw new QueryException(
761▕ $query, $this->prepareBindings($bindings), $e
762▕ );
763▕ }
764▕ }
i A column was not found: You might have forgotten to run your database migrations.
https://laravel.com/docs/master/migrations#running-migrations
+11 vendor frames
12 database/seeders/ButtonSeeder.php:958
Illuminate\Database\Eloquent\Model::__callStatic()
+23 vendor frames
36 artisan:37
Illuminate\Foundation\Console\Kernel::handle()
Basically I renamed the original directory, extracted files as the new app directory and recovered configuration.
Now a profile page loads, users can authenticate, but trying to access administration pages gives me some errors:
file_get_contents(config/advanced-config.php): Failed to open stream: No such file or directory
I wonder if it's expected to just overwrite new files keeping unmodified ones, but in that case upgrade would demand me to go version by version (not skeeping them, which doesn't make sense).
Any hints on what am I missing?
Details about your system
Ubuntu 22.04.5 LTS
PHP version: 8.1.2-1ubuntu2.20
How to reproduce
Manually upgrade
mv linkstack linkstack-old
unzip upgrade.zip
cp linkstack-old/.env linkstack/
cp linkstack-old/assets/img/*png linkstack/assets/img/
chown -R linkstack: linkstack
cd linkstack
php artisan db:seed --class="ButtonSeeder"
Possible Solution
No response
Additional Context
No response
ciroiriarte commented
For the record, fixed after visiting:
ciroiriarte commented
Thanks Matt!
tvx-matt commented
Glad I could help fix this issue on Discord. :)