search

bmlt-enabled / bmlt-root-server

This is the Main Root Server Repo for the Basic Meeting List Toolbox
MIT License
13 stars 14 forks source link

New version gives 500 | Server Error #860

Closed brustar64 closed 1 year ago

brustar64 commented 1 year ago

After doing the 3 card monty rename the new version gives a 500 error. switch back and the old version works. My workflow is

  1. download the new version
  2. Extract the contents
  3. rename main_server to "main_server_new"
  4. recompress main_server_new
  5. Upload the zip file to public_html
  6. extract the main_server_new zip
  7. three card monty rename
  8. check the root server and it fails

Initally tried using PHP 8.0 and it failed. So I changed to 8.1 and it still gives the same error

jbraswell commented 1 year ago

Is there a log file in main_server/storage/logs?

jbraswell commented 1 year ago

If there are no log files in storage/logs, I'll probably need you to give me access to the host.

brustar64 commented 1 year ago

If there are no log files in storage/logs, I'll probably need you to give me access to the host.

laravel.log

jbraswell commented 1 year ago

Based on the contents of the file, I am going to need access to your host to get this fixed. Will you reach out to me on slack or facebook messenger?

jbraswell commented 1 year ago

It looks like this problem is caused by the host's default mysql storage engine being MyISAM instead of InnoDB. The first migration fails to create a primary key constraint on the na_session table's id column, which is a varchar(255) column. We've opened a ticket with the web host to change the default storage engine.

Because it failed on the first migration, and because that migration is only creating the na_sessions table, no data is corrupted.

jbraswell commented 1 year ago

Fixed in 3.0.1.