I hope this is an easy fix for someone who knows Laravel and Datatables.
As you can see by the attachment, when ever you search you get this error.
I don't need it to search all the fields it is doing. Happy if it just searched first name / last name.
Just looking for a quick fix.
There error message:
DataTables warning: table id=DataTables_Table_0 - Exception Message:
SQLSTATE: Syntax error or access violation: 1583 Incorrect parameters in the call to native function 'LOWER' (SQL: select count(*) as aggregate from (select '1' as `row_count` from `users` where (LOWER(`users`.`name`) LIKE %aa% or LOWER(`users`.`first_name`) LIKE %aa% or LOWER(`users`.`last_name`) LIKE %aa% or LOWER(`users`.`email`) LIKE %aa% or exists (select * from `p5_tags` inner join `p5_tag_user` on `p5_tags`.`id` = `p5_tag_user`.`p5_tag_id` where `users`.`id` = `p5_tag_user`.`user_id` and LOWER(`p5_tags`.`tag`) LIKE %aa%) or exists (select * from `p5_user_genders` where `users`.`linked_gender_id` = `p5_user_genders`.`id` and LOWER(`p5_user_genders`.`gender_description`) LIKE %aa%) or exists (select * from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `users`.`id` = `role_user`.`user_id` and LOWER(`roles`.`title`) LIKE %aa%) or exists (select * from `users` as `laravel_reserved_0` where `laravel_reserved_0`.`id` = `users`.`created_by_id` and LOWER(`users` as `[url removed, login to view]`) LIKE %aa%))) count_row_table)
The file to download is:
[url removed, login to view] on
[url removed, login to view]
The instructions are:
1. Extract the archive and put it in the folder you want
2. Prepare your .env file there with database connection and other settings
3. Run "composer install" command
4. Run "php artisan migrate --seed" command. Notice: seed is important, because it will create the first admin user for you.
5. Run "php artisan key:generate" command.
And that's it, go to your domain and login:
Email: admin@[url removed, login to view]
P.S. If you want to use this admin panel for existing project, here's an article with instructions
Notice: if you use CKEditor fields, there are a few more commands to launch for Laravel Filemanager package:
php artisan vendor:publish --tag=lfm_config
php artisan vendor:publish --tag=lfm_public
14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hi i can complete your work for 30USD . I am a experienced laravel developer. i am working with laravel from last 5 years. I have done many large and small scale projects of laravel .