PHPFixing
  • Privacy Policy
  • TOS
  • Ask Question
  • Contact Us
  • Home
  • PHP
  • Programming
  • SQL Injection
  • Web3.0

Monday, May 16, 2022

[FIXED] How can I solve this error in my Laravel model?

 May 16, 2022     laravel, mysql, php     No comments   

Issue

Here's my code. The database name is socapa.

class Student extends Model
{
...
public static function rsStuds( 
        $varSession_rsStuds,
        $varCampus_rsStuds,
        $varProgram_rsStuds,
        $varSeason_rsStuds,
        $startRow_rsStuds,
        $maxRows_rsStuds) {
        return Student::select(
                    'contacts.FirstName',
                    'contacts.LastName',
                    'contacts.ContactID',
                    'students.StudentID',
                    'registrations.CourseID',
                    'registrations.RegDate', 
                    'contacts.City',
                    'contacts.State', 
                    'contacts.Country', 
                    'campuses.CampusName', 
                    'programs.ProgramName', 
                    'courses.SessionID', 
                    'courses.CourseName', 
                    'courses.Season', 
                    'students.StudentID',
                    'programs.ProgramID', 
                    'sessions.SessionID',
                    'sessions.SessionName',
                    'programs.ProgramName')
                ->join('registrations', 'students.StudentID', '=', 'registrations.StudentID')
                ->join('contacts', 'contacts.ContactID', '=', 'students.StudentContactID')
                ->join('courses', 'courses.CourseID','=', 'registrations.CourseID')
                ->join('campuses', 'campuses.CampusID', '=', 'courses.CampusID')
                ->join('programs', 'programs.ProgramID', '=', 'courses.ProgramID')
                ->join('sessions', 'sessions.SessionID', '=', 'courses.SessionID')
                ->where('courses.SessionID', 'LIKE', "%".$varSession_rsStuds."%")
                ->where('courses.CampusID', 'LIKE', "%".$varCampus_rsStuds."%")
                ->where('courses.ProgramID', 'LIKE', "%".$varProgram_rsStuds."%")
                ->where('courses.Season', '=', ''.$varSeason_rsStuds)
                ->groupBy('courses.ProgramID')
                ->orderBy('contacts.LastName')
                ->skip(''.$startRow_rsStuds)
                ->take(''.$maxRows_rsStuds)->get();
    }
...
}

When I run the project, the error following bellow, appears.

Illuminate\Database\QueryException SQLSTATE[42000]: Syntax error or access violation: 1055 'socapa.contacts.FirstName' isn't in GROUP BY (SQL: select contacts.FirstName, contacts.LastName, contacts.ContactID, students.StudentID, registrations.CourseID, registrations.RegDate, contacts.City, contacts.State, contacts.Country, campuses.CampusName, programs.ProgramName, courses.SessionID, courses.CourseName, courses.Season, students.StudentID, programs.ProgramID, sessions.SessionID, sessions.SessionName, programs.ProgramName from students inner join registrations on students.StudentID = registrations.StudentID inner join contacts on contacts.ContactID = students.StudentContactID inner join courses on courses.CourseID = registrations.CourseID inner join campuses on campuses.CampusID = courses.CampusID inner join programs on programs.ProgramID = courses.ProgramID inner join sessions on sessions.SessionID = courses.SessionID where courses.SessionID LIKE %1% and courses.CampusID LIKE %1% and courses.ProgramID LIKE %1% and courses.Season = -1 group by courses.ProgramID order by contacts.LastName asc limit 50 offset 0)


Solution

Go to the config folder and open database.php find mysql and change

'strict' => false,


Answered By - Tharuka Dananjaya
Answer Checked By - Clifford M. (PHPFixing Volunteer)
  • Share This:  
  •  Facebook
  •  Twitter
  •  Stumble
  •  Digg
Newer Post Older Post Home

0 Comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Total Pageviews

Featured Post

Why Learn PHP Programming

Why Learn PHP Programming A widely-used open source scripting language PHP is one of the most popular programming languages in the world. It...

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Copyright © PHPFixing