Easy fix if you know Laravel and Data tables


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[42000]: 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]

Password: password

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



Beceriler: HTML, Laravel, MySQL, PHP, Yazılım Mimarisi

Daha fazlasını görün: easy data entry job | need 50 freelancers, easy data entry job need 50 freelancers, easy fix yoog search, stored procedure copy data tables write, know claient data entry calssified works, data tables xml file, good looking powerpoint data tables, access executable include data tables, screen scrape sql data tables, able display data tables iphone, data tables joomla, net 1003 application data tables, http wwwgetafreelancercomprojectsdata processing data entrycaptcha worker need fromhtml, send access data tables excel, php display data tables web page

İşveren Hakkında:
( 54 değerlendirme ) BOOVAL, Australia

Proje NO: #16302876



Hello Sir, Good morning. I have gone through your requirement and understood your issue. There is issue with datatables search, Yes, i can resolve this issue according to your requirement. I have checked you Daha fazlası

1 gün içinde 35$ USD
(1 Değerlendirme)

16 freelancers are bidding on average $32 for this job


Hello, I am available to discuss the project and ready to get started. I have a team of highly skilled professionals, which consists of Designers, Web and App Developers. We have enough experiences with WEB develo Daha fazlası

1 gün içinde 30$ USD
(202 Değerlendirme)

Hello, I've read your project description and I want to tell you that i can fix this error as per your requirement. Lets have a quick chat to discuss this project and further proceed accordingly. We have extensi Daha fazlası

1 gün içinde 25$ USD
(100 Değerlendirme)
1 gün içinde 40$ USD
(119 Değerlendirme)

Hi, there . I have strongly experienced in developing website as Laravel expert for 3+ years . I am proficient in Laravel framework so I can fix this for you perfectly . I will dedicate my knowledge and passion for Daha fazlası

1 gün içinde 25$ USD
(25 Değerlendirme)

Hello As per your RFP, I understood that I have to develop a Laravel website in which you are facing the search issue. Please share the website with credentials so that I can analyze it in detail and provide Daha fazlası

1 gün içinde 88$ USD
(17 Değerlendirme)
1 gün içinde 15$ USD
(5 Değerlendirme)

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 .

1 gün içinde 30$ USD
(2 Değerlendirme)

Dear Hiring Manager, Hope you are doing well I have gone through your project description i can fix Laravel and Data tables that you mentioned in description We have huge experience of website design, mobile applica Daha fazlası

1 gün içinde 25$ USD
(0 Değerlendirme)

I'm expertise laravel freelancer with having 5 year experience in development fields. I'm ready to start work right away

1 gün içinde 40$ USD
(1 Değerlendirme)

Hi, Please let me know more about the project. So I could tell you about the work flow and the output. I have 4+ Year’s Experience Thank You

in 2 gün içinde25$ USD
(0 Değerlendirme)

I can trying....

1 gün içinde 25$ USD
(0 Değerlendirme)
1 gün içinde 25$ USD
(0 Değerlendirme)

Hi, i am a full stack mobile & web dev having similar technical skills & experience & have already worked on a similar project before so can do this Ref : [url removed, login to view] Great exp Daha fazlası

1 gün içinde 31$ USD
(0 Değerlendirme)

Talented and experienced PHP Software Engineer with good experience with latest technology. I am a hard worker and enjoy working at all critical conditions. Relevant Skills and Experience I have worked as a PHP develo Daha fazlası

1 gün içinde 25$ USD
(0 Değerlendirme)

I saw the error, there are some problems in the database query, I can fix it very early if you let me work on this.

1 gün içinde 22$ USD
(0 Değerlendirme)