Bookstack install - Syntax error when updating database about bookstack HOT 7 OPEN

Hi @JaeggerLegane,
Can you detail the environment you're installing BookStack into (Operating System, database software & version/location etc...)

from bookstack.

Hi @JaeggerLegane, Can you detail the environment you're installing BookStack into (Operating System, database software & version/location etc...)

Hello Dan,

Thanks for your reply.

Here are some details of my environment:

• Shared host
• Apache 2.4.59
• MariaDB 10.5.25
• OS = Linux
• Web server = php 8.1.28

The error seems to point to script "2020_08_04_111754_drop_joint_permissions_id".
Do I need to update this script? If so, could you tell me what I would need to change?

Thanks in advance for your help

from bookstack.

Hi @JaeggerLegane,
You should not need to edit any app files, including that script.

The error shared would only really appear on subsequent php artisan migrate runs, after the first.
The real underlying issue would likely only have been seen on the original php artisan migrate run.
Ideally we need to see the error message thrown on the first command run.

If possible, and if there's no existing data to save in this instance, Could you delete all existing tables in the bookstack database then re-run the php artisan migrate step, being sure to record any errors that appear on first run.
Be careful if you share this database with any other applications, to ensure you only delete the tables for BookStack (always a good idea to backup the whole database if there's any risk of data).

from bookstack.

Hi @JaeggerLegane, You should not need to edit any app files, including that script.

The error shared would only really appear on subsequent php artisan migrate runs, after the first. The real underlying issue would likely only have been seen on the original php artisan migrate run. Ideally we need to see the error message thrown on the first command run.

If possible, and if there's no existing data to save in this instance, Could you delete all existing tables in the bookstack database then re-run the php artisan migrate step, being sure to record any errors that appear on first run. Be careful if you share this database with any other applications, to ensure you only delete the tables for BookStack (always a good idea to backup the whole database if there's any risk of data).

Hello Dan,

Thanks for your response.
I've deleted all the underlying tables in the DB and reran the php artisan migrate command.

I'm getting an error again relating to the permissions id script but it's slightly different this time, see below:

Any ideas?

from bookstack.

Thanks for the information @JaeggerLegane.
I've seen this occur before when an older (now-non-default) database engine is used.
Does your shared hosting provider give any control/option/access for the default database engine in use? Or do you have access to change default database configuration options at all?

from bookstack.

Thanks for the information @JaeggerLegane. I've seen this occur before when an older (now-non-default) database engine is used. Does your shared hosting provider give any control/option/access for the default database engine in use? Or do you have access to change default database configuration options at all?

I have considerable access to make changes to the DB engine myself yes. But for anything else I may need the webhost team, they are however pretty flexible on my requests.

What would you recommend that I change?

from bookstack.

@JaeggerLegane Do you have the ability to set the default_storage_engineoption? (Commonly done on non-shared systems via amy.conf` file)

If so, set that to default_storage_engine=InnoDB (which is usually the default).
Then restart the database, then re-attempt from an empty database.

from bookstack.