search

HarunRRayhan / lux-client-management-system

The Ultimate Client Management System. It's an all-in-one solution for managing projects, task, invoices and many more...
MIT License
33 stars 9 forks source link

php artisan key:generate command related errors #4

Open Mantolong opened 2 years ago

Mantolong commented 2 years ago

Greetings. There seem to be an issue with the code. When I run 'php artisan key:generate' I get the following error: C:\Developments\laravel\lux-client-management-system>php artisan migrate Migration table created successfully. Migrating: 2014_10_12_000000_create_users_table

Illuminate\Database\QueryException

SQLSTATE[HY000]: General error: 1128 Function 'ngram' is not defined (SQL: create fulltext index users_fulltext_index on users(first_name, last_name, email) with parser ngram )

at C:\Developments\laravel\lux-client-management-system\vendor\laravel\framework\src\Illuminate\Database\Connection.php:671 667▕ // If an exception occurs when attempting to run a query, we'll format the error 668▕ // message to include the bindings with SQL, which will make this exception a 669▕ // lot more helpful to the developer instead of just the database's errors. 670▕ catch (Exception $e) { ➜ 671▕ throw new QueryException( 672▕ $query, $this->prepareBindings($bindings), $e 673▕ ); 674▕ } 675▕ } 675▕

1 C:\Developments\laravel\lux-client-management-system\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:72 Doctrine\DBAL\Driver\PDOException::("SQLSTATE[HY000]: General error: 1128 Function 'ngram' is not defined")

2 C:\Developments\laravel\lux-client-management-system\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:67 PDOException::("SQLSTATE[HY000]: General error: 1128 Function 'ngram' is not defined")

Please assist. Thank you

mountbee commented 2 years ago

make sure your database config are correct on .env