Getting a weird HTTP ERROR 500 on running query on a specific database table

Question

I have tried doing this

$query = "SELECT * FROM policies";
$policies = DB::select($query);

And also this $policies = Policy::all(); Whenever I try to do this, this happens

here is my controller function

public function getPremiumCollectionReport (Request $request) {
    $policies = Policy::all();
    echo $policies;
}

Other queries run perfectly well for other models and tables. And if I run the raw query in the sql server, it runs perfectly as well. Can anyone help me find a solution? I don't have a clue.

You can put exception handling in the code and check what is the error by debugging the code.. — Chetan
– Chetan, Commented Jun 19, 2017 at 5:10

Shateel Ahmed · Accepted Answer · 2017-06-20 03:46:32Z

1

I just found out that there were too many policies in that table for the server to handle. If I run the query for a smaller number of policies, the query runs successfully. It only happens when I try to select a large number of policies.

answered Jun 20, 2017 at 3:46

Shateel Ahmed

1,4042 gold badges13 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting a weird HTTP ERROR 500 on running query on a specific database table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related