Tekil Mesaj gösterimi - PHP ile Excell Yüklerken Aldığım Hatalar

Konu PHP ile Excell Yüklerken Aldığım Hatalar

21-12-2020, 14:47:32

Merhaba, yüklediğim excell dosyası 10bin satırdır.

SQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone awaySQLSTATE[HY000]: General error: 2006 MySQL server has gone....................

ve aşağıdaki gibi bişey kullanmam gerekiyor galiba nasıl yapabilirim:

SET GLOBAL connect_timeout=3600

Bu şekilde de bir hata var

SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='