Find Jobs
Hire Freelancers

Easy fix if you know Laravel and Data tables

$10-30 USD

완료함
게시됨 약 6년 전

$10-30 USD

제출할때 지불됩니다
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 `[login to view URL]`) LIKE %aa%))) count_row_table) The file to download is: [login to view URL] on [login to view URL] 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@[login to view URL] 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
프로젝트 ID: 16302876

프로젝트 정보

13 제안서
원격근무 프로젝트
활동 중 6년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
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 your files that are located at [login to view URL] . If you hire me i can start work accordingly. Please let me know if you want to discuss more about it. Thank you.
$35 USD 1일에
5.0 (6 건의 리뷰)
2.7
2.7
13 이 프로젝트에 프리랜서들의 평균 입찰은 $33 USD입니다.
사용자 아바타
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 development for 10+ years. Please visit our profile and see our project reviews https://www.freelancer.com/u/maxsmith8.html Looking forward to your response, Lets discuss more over Chat box. Thanks & Regards, Sam
$30 USD 1일에
4.8 (255 건의 리뷰)
8.0
8.0
사용자 아바타
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 extensive experience in Designing Websites, Building Portals, Developing Complex Web Applications in all major platforms. We have worked with several top companies and brands. If you want, I can share our portfolio with you as well. Thanks, Faizan
$25 USD 1일에
4.9 (157 건의 리뷰)
7.0
7.0
사용자 아바타
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일에
5.0 (3 건의 리뷰)
2.4
2.4
사용자 아바타
I'm expertise laravel freelancer with having 5 year experience in development fields. I'm ready to start work right away
$40 USD 1일에
5.0 (1 건의 리뷰)
0.0
0.0
사용자 아바타
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일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
I can trying....
$25 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 developer and expertise in Laravel and codeigniter framework.
$25 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (AUSTRALIA)
BOOVAL, Australia
5.0
63
결제 수단 확인
7월 12, 2006부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.