Suoritettu

Easy fix if you know Laravel and Data tables

Hi,

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

Thanks

James

Taidot: HTML, Laravel, MySQL, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: easy data entry job | need 50 freelancers, easy data entry job need 50 freelancers, graphs data tables maker, mysql data tables wordpress pages, aspx gridview data tables, 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

Tietoa työnantajasta:
( 60 arvostelua ) BOOVAL, Australia

Projektin tunnus: #16302876

Myönnetty käyttäjälle:

sanjayhadinwal

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 Lisää

$35 USD 1 päivässä
(3 Arvostelua)
2.3

14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

maxsmith8

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 Lisää

$30 USD 1 päivässä
(211 arvostelua)
8.0
junkyfunky

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 Lisää

$25 USD 1 päivässä
(110 arvostelua)
6.6
$40 USD 1 päivässä
(120 arvostelua)
6.7
ersumit88

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 Lisää

$88 USD 1 päivässä
(23 arvostelua)
4.5
$15 USD 1 päivässä
(7 arvostelua)
3.7
DnyaneshwerK24

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 Lisää

$25 USD 1 päivässä
(6 arvostelua)
2.4
chiragverma2207

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 .

$30 USD 1 päivässä
(2 arvostelua)
1.3
Drjsharma031

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

$40 USD 1 päivässä
(1 arvostelu)
0.0
singhnidhi13

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

$25 USD 2 päivässä
(0 arvostelua)
0.0
huynhbien

I can trying....

$25 USD 1 päivässä
(0 arvostelua)
0.0
$25 USD 1 päivässä
(0 arvostelua)
0.0
uistacks

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 Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0
somnathsah

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.

$22 USD 1 päivässä
(0 arvostelua)
0.0