[2026-09-07 13:38:54] production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (Connection: mysql, Host: localhost, Port: 3306, Database: softwork_farajaprodb, SQL: alter table `permissions` add unique `permissions_name_guard_name_unique`(`name`, `guard_name`)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (Connection: mysql, Host: localhost, Port: 3306, Database: softwork_farajaprodb, SQL: alter table `permissions` add unique `permissions_name_guard_name_unique`(`name`, `guard_name`)) at /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Connection.php:857)
[stacktrace]
#0 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Connection.php(813): Illuminate\\Database\\Connection->runQueryCallback()
#1 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Connection.php(590): Illuminate\\Database\\Connection->run()
#2 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(122): Illuminate\\Database\\Connection->statement()
#3 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(708): Illuminate\\Database\\Schema\\Blueprint->build()
#4 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(526): Illuminate\\Database\\Schema\\Builder->build()
#5 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(363): Illuminate\\Database\\Schema\\Builder->create()
#6 /home/softwork/public_html/faraja.softworks.co.ke/database/migrations/2026_08_21_071218_create_permission_tables.php(26): Illuminate\\Support\\Facades\\Facade::__callStatic()
#7 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(517): Illuminate\\Database\\Migrations\\Migration@anonymous->up()
#8 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(442): Illuminate\\Database\\Migrations\\Migrator->runMethod()
#9 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(451): Illuminate\\Database\\Migrations\\Migrator->{closure:Illuminate\\Database\\Migrations\\Migrator::runMigration():438}()
#10 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(253): Illuminate\\Database\\Migrations\\Migrator->runMigration()
#11 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(43): Illuminate\\Database\\Migrations\\Migrator->{closure:Illuminate\\Database\\Migrations\\Migrator::runUp():253}()
#12 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(853): Illuminate\\Console\\View\\Components\\Task->render()
#13 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(253): Illuminate\\Database\\Migrations\\Migrator->write()
#14 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(211): Illuminate\\Database\\Migrations\\Migrator->runUp()
#15 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(138): Illuminate\\Database\\Migrations\\Migrator->runPending()
#16 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(118): Illuminate\\Database\\Migrations\\Migrator->run()
#17 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(672): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->{closure:Illuminate\\Database\\Console\\Migrations\\MigrateCommand::runMigrations():111}()
#18 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(111): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
#19 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(90): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()
#20 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#21 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#22 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\\Container\\Util::unwrapIfClosure()
#23 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#24 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Container/Container.php(799): Illuminate\\Container\\BoundMethod::call()
#25 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Console/Command.php(280): Illuminate\\Container\\Container->call()
#26 /home/softwork/public_html/faraja.softworks.co.ke/vendor/symfony/console/Command/Command.php(284): Illuminate\\Console\\Command->execute()
#27 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Console/Command.php(249): Symfony\\Component\\Console\\Command\\Command->run()
#28 /home/softwork/public_html/faraja.softworks.co.ke/vendor/symfony/console/Application.php(1144): Illuminate\\Console\\Command->run()
#29 /home/softwork/public_html/faraja.softworks.co.ke/vendor/symfony/console/Application.php(379): Symfony\\Component\\Console\\Application->doRunCommand()
#30 /home/softwork/public_html/faraja.softworks.co.ke/vendor/symfony/console/Application.php(218): Symfony\\Component\\Console\\Application->doRun()
#31 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run()
#32 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\\Foundation\\Console\\Kernel->handle()
#33 /home/softwork/public_html/faraja.softworks.co.ke/artisan(16): Illuminate\\Foundation\\Application->handleCommand()
#34 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Connection.php:601)
[stacktrace]
#0 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Connection.php(601): PDOStatement->execute()
#1 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Connection.php(846): Illuminate\\Database\\Connection->{closure:Illuminate\\Database\\Connection::statement():590}()
#2 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Connection.php(813): Illuminate\\Database\\Connection->runQueryCallback()
#3 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Connection.php(590): Illuminate\\Database\\Connection->run()
#4 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(122): Illuminate\\Database\\Connection->statement()
#5 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(708): Illuminate\\Database\\Schema\\Blueprint->build()
#6 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(526): Illuminate\\Database\\Schema\\Builder->build()
#7 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(363): Illuminate\\Database\\Schema\\Builder->create()
#8 /home/softwork/public_html/faraja.softworks.co.ke/database/migrations/2026_08_21_071218_create_permission_tables.php(26): Illuminate\\Support\\Facades\\Facade::__callStatic()
#9 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(517): Illuminate\\Database\\Migrations\\Migration@anonymous->up()
#10 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(442): Illuminate\\Database\\Migrations\\Migrator->runMethod()
#11 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(451): Illuminate\\Database\\Migrations\\Migrator->{closure:Illuminate\\Database\\Migrations\\Migrator::runMigration():438}()
#12 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(253): Illuminate\\Database\\Migrations\\Migrator->runMigration()
#13 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(43): Illuminate\\Database\\Migrations\\Migrator->{closure:Illuminate\\Database\\Migrations\\Migrator::runUp():253}()
#14 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(853): Illuminate\\Console\\View\\Components\\Task->render()
#15 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(253): Illuminate\\Database\\Migrations\\Migrator->write()
#16 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(211): Illuminate\\Database\\Migrations\\Migrator->runUp()
#17 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(138): Illuminate\\Database\\Migrations\\Migrator->runPending()
#18 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(118): Illuminate\\Database\\Migrations\\Migrator->run()
#19 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(672): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->{closure:Illuminate\\Database\\Console\\Migrations\\MigrateCommand::runMigrations():111}()
#20 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(111): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
#21 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(90): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()
#22 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#23 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#24 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\\Container\\Util::unwrapIfClosure()
#25 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#26 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Container/Container.php(799): Illuminate\\Container\\BoundMethod::call()
#27 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Console/Command.php(280): Illuminate\\Container\\Container->call()
#28 /home/softwork/public_html/faraja.softworks.co.ke/vendor/symfony/console/Command/Command.php(284): Illuminate\\Console\\Command->execute()
#29 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Console/Command.php(249): Symfony\\Component\\Console\\Command\\Command->run()
#30 /home/softwork/public_html/faraja.softworks.co.ke/vendor/symfony/console/Application.php(1144): Illuminate\\Console\\Command->run()
#31 /home/softwork/public_html/faraja.softworks.co.ke/vendor/symfony/console/Application.php(379): Symfony\\Component\\Console\\Application->doRunCommand()
#32 /home/softwork/public_html/faraja.softworks.co.ke/vendor/symfony/console/Application.php(218): Symfony\\Component\\Console\\Application->doRun()
#33 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run()
#34 /home/softwork/public_html/faraja.softworks.co.ke/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\\Foundation\\Console\\Kernel->handle()
#35 /home/softwork/public_html/faraja.softworks.co.ke/artisan(16): Illuminate\\Foundation\\Application->handleCommand()
#36 {main}
"}