We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.

Query breaking

Hello , so i have a huge problem , on my computer the code works perfectly , but when i upload it to my linux server 1 single query breaks the hole thing. How can i fix this ?

I've noticed that when i use the ->where() clause is when the server breaks down giving me an ERR_CONTENT_DECODING_FAILED error. So i tried to remove the where clause and it works , i just dont know why if on my computer works and not on the server.

Code:

      $logs = Logs::query()
      ->columns([
        "Manager\Models\Team.name",
        "Manager\Models\Logs.action",
        "Manager\Models\Logs.date",
        "Manager\Models\Logs.description"
      ])
      ->innerJoin('Manager\Models\Team', 'Manager\Models\Logs.user = Manager\Models\Team.uid')
      ->where("project = :project:")
      ->bind(["project"=>$urlrequest])
      ->execute();

Can you show us what is inside $urlrequest?

Have you tried perhaps using rawurldecode?

You should really use modelsManager to get rid of full namespaces.

How ?

You should really use modelsManager to get rid of full namespaces.

Just get modelsManager from di, use aliases, and check docs.

Where do you get $urlrequest from? What are the actual contents of it?

What is your local environment vs. production? Windows vs. GNU/Linux?