freescout icon indicating copy to clipboard operation
freescout copied to clipboard

Migration errors on MariaDB

Open FlashPapa opened this issue 3 years ago • 1 comments

Hi ! I've got this error when i do -> php artisan migrate:fresh


In Connection.php line 664:
                                                                                                                                                                                                                                                
  SQLSTATE[HY000]: General error: 1025 Error on rename of './freescout/send_logs' to './freescout/#sql-backup-a985-18ad' (errno: 168 "Unknown (generic) error from engine") (SQL: ALTER TABLE send_logs CHANGE status_message status_message T  
  EXT CHARACTER SET utf8mb3 DEFAULT NULL COLLATE `utf8mb3_unicode_ci`)                                                                                                                                                                          
                                                                                                                                                                                                                                                

In Exception.php line 18:
                                                                                                                                                                             
  SQLSTATE[HY000]: General error: 1025 Error on rename of './freescout/send_logs' to './freescout/#sql-backup-a985-18ad' (errno: 168 "Unknown (generic) error from engine")  
                                                                                                                                                                             

In PDOStatement.php line 115:
                                                                                                                                                                             
  SQLSTATE[HY000]: General error: 1025 Error on rename of './freescout/send_logs' to './freescout/#sql-backup-a985-18ad' (errno: 168 "Unknown (generic) error from engine")  
      

I am on [email protected] [email protected]

Before these errors I had others that I solved by doing:

In database.php i set 'engine' => 'InnoDB' and i change charset et collation like this : 'charset'=>'utf8', 'collation'=>'utf8_unicode_ci'

With mysql i have no error but with MariaDb it goes less well ;)

An idea ?

FlashPapa avatar Sep 25 '21 12:09 FlashPapa

Unfortunately no.

freescout-helpdesk avatar Oct 05 '21 07:10 freescout-helpdesk

@FlashPapa are you able to please backup everything and try using the PHP 8.1 and the modern MariaDB?

fulldecent avatar Oct 12 '22 15:10 fulldecent