1

Topic: How to find the table?

In the project the code is fulfilled

INSERT INTO ` ms_query_log ` (` procedure `, ` params `, ` result `, ` ip `, ` exec_time `, ` cache `, ` microtime `, ` user_id `) VALUES

But produces an error

General error: 1364 Field ' execution_filed ' does not have a default value

In the list of tables I do not see this table and Select query * from ms_query_log does not work, writes invalid object name ms_query_log
I look through management studio, under sa

2

Re: How to find the table?

MS SQL does not generate "General error"

3

Re: How to find the table?

Probably error  a site on the basis of an error from mssql
I suspect that the site the table sees, a question as to me too to see the table?

4

Re: How to find the table?

tadeyiloda;
It after all it?

5

Re: How to find the table?

The probably same error, also dares field adding execution_filed in request
But  it is interesting to me where this table can hide? Why I it do not see?

6

Re: How to find the table?

tadeyiloda;
At you Lavarel 5.2? I would transfer a question to a branch with PHP...

7

Re: How to find the table?

At me
Only what for to transfer if a question on ms sql

8

Re: How to find the table?

tadeyiloda wrote:

at me
Only what for to transfer if a question on ms sql

Generally a question most likely on mysql.

9

Re: How to find the table?

tadeyiloda;
You php.ini precisely have  a line extension=php_pdo_mssql.dll?

10

Re: How to find the table?

tadeyiloda wrote:

it is possible the same error, and dares field adding execution_filed in request
But  it is interesting to me where this table can hide? Why I it do not see?

Probably, you look tables, and it is necessary to watch representation;
Probably, you look not that basis;
Probably, you look not that DBMS
It is possible to guess indefinitely, connect to a problem of your administrator a DBMS

11

Re: How to find the table?

Release, my error
As it appeared there is a call on mysql

12

Re: How to find the table?

tadeyiloda;
Indeed. Laravel if I do not confuse, yes? smile

13

Re: How to find the table?

No, yii1
The problem was in that that the project uses basis mssql, and the title of the table the automatic machine switched to searches in mssql
The moderator: the Subject is transferred from a forum "Microsoft SQL Server".