[solved] Nextant scan issue: SQLSTATE[42000]: Syntax error or access violation

🍱 Features & apps fulltextsearch
1

Hello,

when i would start the indexing i get this error:

  [    Doctrine\DBAL\Exception\DriverException]                                                                                     
      An exception occurred while executing '                                                                                       
      			SELECT `fileid`, `storage`, `path`, `parent`, `name`,                                                                      
      				`mimetype`, `storage_mtime`, `mimepart`, `size`, `mtime`,                                                                 
      				 `encrypted`, `etag`, `permissions`, `checksum`                                                                           
      			FROM `oc_filecache`                                                                                                        
      			WHERE `storage` = ? AND `name` COLLATE UTF8_general_ci LIKE ?' with params [3, "%%%"]:                                     
      SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'UTF8_general_ci' is not valid for CHARACTER SET 'utf8mb4'   
                                                               
    [Doctrine\DBAL\Driver\PDOException]                                                                                           
      SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'UTF8_general_ci' is not valid for CHARACTER SET 'utf8mb4'  
                                                                                                                               
      [PDOException]                                                                                                                
      SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'UTF8_general_ci' is not valid for CHARACTER SET 'utf8mb4'

how can i solve it?

2

The issue was that the database tables have this format “utf8mb4” but it must be “uft8_general_ci”. I have edit the tables with phpmyadmin and all issues are solved.