Found 56653 resume files in backend/resumes/ Starting import (text extraction only — no Groq calls)... [1/56653] Ads88201913.docx ... OK (ID: 2) [2/56653] KrishanKant[21_0].doc ... OK (ID: 3) [3/56653] RUCHITA BHATIA.doc ... OK (ID: 4) [4/56653] 1218201910.docx ... OK (ID: 5) [5/56653] 818201933.doc ... OK (ID: 6) [6/56653] COMPUTER SCIENCE TEACHER SILIGURI2.docx ... OK (ID: 7) [7/56653] GAGANSAHNI maths.doc ... OK (ID: 8) [8/56653] 418201913.docx ... OK (ID: 9) [9/56653] jsk_PROFILE.doc ... OK (ID: 10) [10/56653] NK226202019.doc ... OK (ID: 11) [11/56653] TGT BIOLOGY SCIENCE DELHI2.pdf ... OK (ID: 12) [12/56653] shailendraverma[6_3].docx ... OK (ID: 13) [13/56653] ResumeRanjanKhatawkar.pdf ... OK (ID: 14) [14/56653] ResumeShenbagaraja.docx ... OK (ID: 15) [15/56653] 424201911.docx ... OK (ID: 16) [16/56653] JYOTIHANDA[5_10].docx ... OK (ID: 17) [17/56653] NK321202012.docx ... OK (ID: 18) [18/56653] ujjwal - assessment sheet.pdf ... OK (ID: 19) [19/56653] yogeshTripathi[18_0].docx ... OK (ID: 20) [20/56653] SAHANASHARMA- Art Director 2D (2).doc ... OK (ID: 21) [21/56653] 4262019_35.docx ... OK (ID: 22) [22/56653] HOD English IGCSE Faridabad2.doc ... OK (ID: 23) [23/56653] Nk113202030.docx ... OK (ID: 24) [24/56653] Bharat sharan - Author _ ex-principal, dav public school,sijua-dhanbad. - _ 25 Yrs 0 Month.docx ... OK (ID: 25) [25/56653] Paramesh-Resume-Jan15-edited.docx ... OK (ID: 26) [26/56653] FauziaAfreen[12_0].docx ... OK (ID: 27) [27/56653] SadhnaJha[.doc ... OK (ID: 28) [28/56653] Niharika sharma - Prt - 4 Yrs 0 Month.doc ... OK (ID: 29) [29/56653] Nk324202029.docx ... OK (ID: 30) [30/56653] Rengaraj subbiah - Director - - 25 Yrs 0 Month.docx ... OK (ID: 31) [31/56653] NK608202056.docx ... OK (ID: 32) [32/56653] IBDP HOD Business Management Dehradun.doc ... OK (ID: 33) [33/56653] Ads74201926.docx ... OK (ID: 34) [34/56653] SS9202019229.pdf ... OK (ID: 35) [35/56653] ceevee.docx ... OK (ID: 36) [36/56653] Kiran Rai -Principal.docx ... OK (ID: 37) [37/56653] Ads723201912.docx ... OK (ID: 38) [38/56653] ResumeNabanitaPaulPatra.docx ... OK (ID: 39) [39/56653] CV_Dr_Sunanda_Salve(1).docx ... OK (ID: 40) [40/56653] Ads62720199.docx ... OK (ID: 41) [41/56653] poonamlatayadav Physics.doc ... OK (ID: 42) [42/56653] Ads5820194.docx ... OK (ID: 43) [43/56653] AnbuPackiarajK[4_5].pdf ... OK (ID: 44) [44/56653] ResumeNafeesKhan.pdf ... OK (ID: 45) [45/56653] SS9202019296.docx ... OK (ID: 46) [46/56653] POOJASHARMA[2_7].doc ... OK (ID: 47) [47/56653] JAYANTAKUMARBERA[7_0].doc ... OK (ID: 48) [48/56653] rozina evangeline resume.doc ... OK (ID: 49) [49/56653] Nk131202038.docx ... OK (ID: 50) [50/56653] Kamalika - IB Eng.pdf ... OK (ID: 51) [51/56653] NK313202062.doc ... OK (ID: 52) [52/56653] CV_neha.docx ... OK (ID: 53) [53/56653] NK619202021.docx ... OK (ID: 54) [54/56653] RESUME_dm_1(1).docx ... OK (ID: 55) [55/56653] ResumeShikhaArora.docx ... OK (ID: 56) [56/56653] Shruti.latest_resume.docx ... Exception 'yii\db\Exception' with message 'SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like' The SQL being executed was: SELECT EXISTS(SELECT * FROM `candidates` WHERE `resume_text` LIKE '%Shruti Arya\n New Delhi, India\n 91-8130882881\n 📧 shrutiarya015@gmail.com\n\n\n \n\nObjective-152399114300\n-1%') AS `result`' in /Applications/MAMP/htdocs/selection-search-app/vendor/yiisoft/yii2/db/Schema.php:677 Error Info: Array ( [0] => HY000 [1] => 1267 [2] => Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like' ) Caused by: Exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'' in /Applications/MAMP/htdocs/selection-search-app/vendor/yiisoft/yii2/db/Command.php:1320 Stack trace: #0 /Applications/MAMP/htdocs/selection-search-app/vendor/yiisoft/yii2/db/Command.php(1320): PDOStatement->execute() #1 /Applications/MAMP/htdocs/selection-search-app/vendor/yiisoft/yii2/db/Command.php(1186): yii\db\Command->internalExecute('SELECT EXISTS(S...') #2 /Applications/MAMP/htdocs/selection-search-app/vendor/yiisoft/yii2/db/Command.php(443): yii\db\Command->queryInternal('fetchColumn', 0) #3 /Applications/MAMP/htdocs/selection-search-app/vendor/yiisoft/yii2/db/Query.php(446): yii\db\Command->queryScalar() #4 /Applications/MAMP/htdocs/selection-search-app/console/controllers/ResumeController.php(60): yii\db\Query->exists() #5 [internal function]: console\controllers\ResumeController->actionImport('backend/resumes...') #6 /Applications/MAMP/htdocs/selection-search-app/vendor/yiisoft/yii2/base/InlineAction.php(60): call_user_func_array(Array, Array) #7 /Applications/MAMP/htdocs/selection-search-app/vendor/yiisoft/yii2/base/Controller.php(182): yii\base\InlineAction->runWithParams(Array) #8 /Applications/MAMP/htdocs/selection-search-app/vendor/yiisoft/yii2/console/Controller.php(187): yii\base\Controller->runAction('import', Array) #9 /Applications/MAMP/htdocs/selection-search-app/vendor/yiisoft/yii2/base/Module.php(547): yii\console\Controller->runAction('import', Array) #10 /Applications/MAMP/htdocs/selection-search-app/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction('resume/import', Array) #11 /Applications/MAMP/htdocs/selection-search-app/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction('resume/import', Array) #12 /Applications/MAMP/htdocs/selection-search-app/vendor/yiisoft/yii2/base/Application.php(382): yii\console\Application->handleRequest(Object(yii\console\Request)) #13 /Applications/MAMP/htdocs/selection-search-app/yii(27): yii\base\Application->run() #14 {main}