mirror of
https://github.com/BookStackApp/BookStack.git
synced 2026-02-07 19:06:05 +03:00
Upgrade issues #3298
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @rajengg23 on GitHub (Oct 24, 2022).
Attempted Debugging
Searched GitHub Issues
Describe the Scenario
I have tried to upgrade recent release 22.10 and i got issues as below
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'references' already exists (SQL: create table
references(idbigint unsigned not null auto_increment primary key,from_idint unsigned not null,from_typevarchar(25) not null,to_idint unsigned not null,to_typevarchar(25) not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')at vendor/laravel/framework/src/Illuminate/Database/Connection.php:712
708▕ // If an exception occurs when attempting to run a query, we'll format the error
709▕ // message to include the bindings with SQL, which will make this exception a
710▕ // lot more helpful to the developer instead of just the database's errors.
711▕ catch (Exception $e) {
➜ 712▕ throw new QueryException(
713▕ $query, $this->prepareBindings($bindings), $e
714▕ );
715▕ }
716▕ }
10 database/migrations/2022_08_17_092941_create_references_table.php:22
Illuminate\Support\Facades\Facade::__callStatic()
33 artisan:37
Illuminate\Foundation\Console\Kernel::handle()
Exact BookStack Version
22.10
Log Content
No response
PHP Version
8.X
Hosting Environment
20.04
@ssddanbrown commented on GitHub (Oct 24, 2022):
Hi @rajengg23,
This indicates there may have been unaddressed issues upon a previous upgrade.
Before anything, ensure your system/data is backed-up.
Are you familiar with performing operations on the database?
If so, please try dropping the
referencestable in your BookStack database, then re-run thephp artisan migratestep, noting any errors that appear on first run of that command.If you need guidance for make those database changes, let me know but I'd ideally need to know a little extra about your environment, such as is that Ubuntu? And did you originally use our install script?
@geoigeek commented on GitHub (Oct 24, 2022):
Hello,
I also have problems after the update to 22.10 (it's the first update for this installation). I can log in to bookstack with 2FA and then see only a blank page.
In the Apache Error Log I find the following:
Apache Access Log
@ssddanbrown commented on GitHub (Oct 25, 2022):
@geoigeek Your database does not look up-to-date. Please open a new issue so you can detail your specific environment and issue, and include the output of running the
php artisan migrateupdate step.@rajengg23 commented on GitHub (Oct 25, 2022):
Yes, I did but when I run php migrate it’s giving same error.
@ssddanbrown commented on GitHub (Oct 25, 2022):
@rajengg23 That last message was targeted for a different user.
If you were responding to my previous comment, Please confirm exactly how you're performing the requested step to drop the suggested table, and the exact command line output after first run of the migrate command after performing the table drop operation.
@rajengg23 commented on GitHub (Oct 25, 2022):
I tried drop table references; using MySQL
@rajengg23 commented on GitHub (Oct 25, 2022):
I got Error as below
In Connection.php line 712:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'references'
already exists (SQL: create table
references(idbigint unsigned not null auto_increment primary key,
from_idint unsigned not null,from_typevarchar(25) not null,to_idint unsigned not null,to_typevarchar(25) not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')
this is never happen i have change to fresh and then restore the database but remain on same issues
@ssddanbrown commented on GitHub (Oct 25, 2022):
If you are creating a fresh bookstack install, with migrated database, then restoring your old database into it, then I'd expect this error to occur. You should only restore into a fresh database with no existing tables.
If you are properly dropping the
referencestable you should not see that reported error. Again, Please confirm exactly how you're performing the requested step to drop the suggested table and any steps you're performing to ensure the table has been dropped.@ssddanbrown commented on GitHub (Nov 4, 2022):
Since there's been no follow-up I'm going to close this. If the issue remains and is something you still require to be fixed respond to my previous comment and this can then be re-opened.
@rajengg23 commented on GitHub (Nov 4, 2022):
Dan it’s not completed do you have steps to drop?
On Fri, Nov 4, 2022 at 5:41 AM Dan Brown @.***> wrote:
--
Thanks & Regards
Jay Prakash Pandey
8147708281
@ssddanbrown commented on GitHub (Nov 4, 2022):
Backup the system/all-data first.
sudo mysql -u rootuse bookstack;assuming you're BookStack database is calledbookstackwithin mysql.drop table references;.exit;php artisan migratecommand run.@ssddanbrown commented on GitHub (Nov 12, 2022):
Since there's been no further follow-up I'm going to close this off.
@quentinDupont commented on GitHub (Nov 21, 2023):
For information, i had to add '' to make it work :)