Error 502 Bad Gateway when I try to query table in SQL Server and server nginx

[juanludukeboss]

Hi,
When I try to query table in SQL Server with the API, always I'm getting error 502 Bad Gateway. The server is ok, because a sample file with PDO connection PHP is working correctly, but the API is not working.
For analyze the problem, I have doing profiling and I'm looking that the server is very slow in the method that get the structure information table and finally return 502 Bad Gateway. I attach capture of profiling.

[mevdschee]

Thank you for filing this issue. It seems the request takes longer than 30 seconds, is that correct?

[mevdschee]

Can you tell me how many tables and how many columns you have in your database? The method you see that are slow are analyzing the database structure.

[juanludukeboss]

Yes, the problem is that database has about 3.000 tables, ¿it is possible that this is the problem?

[mevdschee]

Yes it is.. I'm analyzing all the tables and I'm storing the structure in the cache for quick retrieval.

[juanludukeboss]

It's possible modify anything in the API for just analyze the structure of tables that we are going to work, because for this project only needs 10 tables of this database. But the database complete is about 3.000 tables.

[mevdschee]

Currently this is not configurable, but I can make it so that you can.

[juanludukeboss]

I would appreciate it very much, because I only need to work with 10 tables for this project and I want to use this API, because this API is wonderful and very easy to use

[mevdschee]

I've released a new version (v2.6.0).

You can specify the "tables" now in the configuration.

Let me know whether or not it works for you.

[juanludukeboss]

The new parameter 'tables' in the configuration, Is a array of tables??

[mevdschee]

Yes, a string representing an array. As the README states it is a "Comma separated list of tables", see:

https://github.com/mevdschee/php-crud-api/blob/master/README.md

Does that work for you?

[juanludukeboss]

No, the response return error 500, but the json response is "code" : 9999, very curious.

I Attach capture.

[mevdschee]

Please enable "debug" in the configuration, that may give you some extra information (in the headers).

[juanludukeboss]

The error is in the line 5526. I attach the capture.

[mevdschee]

What request do you do? Are you comparing with a text ntext or image? I can't do what sql server can't do ;-)

[mevdschee]

You could try to use "field,sw,value" instead of "field,eq,value" when you are comparing.

[juanludukeboss]

no, the query is very simple. The filter is in a numeric field. I attach the capture

[mevdschee]

Is the primary key a text, ntext or image?

[mevdschee]

Comment out 10585 (Content-Length) and uncomment line 5525. You should see the failing query. This should help you find the cause.

[juanludukeboss]

Yes, the primary key is varchar type field. I has commented this line and effectively the problem is this. Attach the capture.
What solution can I make here??, because the database is not mine, is a database the my customer and it is in production with other program. :(

[mevdschee]

Did you find the failing SQL query?

[juanludukeboss]

I think that for this project I will design a simpler API, because there are very few tables and actions that must be performed on this SQL Server database.

Thank you very much for your help.

[mevdschee]

Thank you very much for your help.

You are welcome. Good luck with the project and thank you for your feedback!