$_Post Not Appearing In Log

Yii 1.1 General Discussion
1

Hi all,

I’m trying to debug why my SQL is getting passed null values like this:


Executing SQL: INSERT INTO `tracker` (`user_id`) VALUES (NULL)

.

So, I set my log route like this




'log' => array(

            'class' => 'CLogRouter',

            'routes' => array(

                array(

                    'class' => 'CFileLogRoute',

                    'levels' => 'error, warning, ,info, log, trace',

                    'filter' => array(

                        'class' => 'CLogFilter',

                        'logUser' => true,

                        'logVars' => array(

                            '_GET',

                            '_POST',

                            '_SERVER'

                        )

                    ),

                ),

                array(

                    'class' => 'CWebLogRoute',

                ),

//                array(

//                    'class'=>'CEmailLogRoute',

//                    'levels'=>'error, warning',

//                    'emails'=>'u@me.com', //change for prod

//                ),

            ),

        ),

But all that appears in my application.log file is the $_GET, $_SERVER, and the trace like this:





2014/01/22 16:31:31 [info] [application] $_GET=array (

  'model' => 'tracker',

)


$_SERVER=array (

  'HTTP_HOST' => 'localhost:8888',

  'HTTP_X_TITANIUM_ID' => '7a70566a-d37a-4822-a5c2-f3bbb2c2ab49',

  'HTTP_X_REQUESTED_WITH' => 'XMLHttpRequest',

  'HTTP_ACCEPT_ENCODING' => 'gzip',

  'CONTENT_TYPE' => 'application/json',

  'CONTENT_LENGTH' => '976',

  'HTTP_CONNECTION' => 'close',

  'HTTP_USER_AGENT' => 'Appcelerator Titanium/3.1.3.GA (iPhone Simulator/7.0.3; iPhone OS; en_US;)',

  'PATH' => '/usr/bin:/bin:/usr/sbin:/sbin',

  'SERVER_SIGNATURE' => '',

  'SERVER_SOFTWARE' => 'Apache/2.2.25 (Unix) mod_ssl/2.2.25 OpenSSL/0.9.8y DAV/2 PHP/5.5.3',

  'SERVER_NAME' => 'localhost',

  'SERVER_ADDR' => '::1',

  'SERVER_PORT' => '8888',

  'REMOTE_ADDR' => '::1',

  'DOCUMENT_ROOT' => '/Applications/MAMP/htdocs',

  'SERVER_ADMIN' => 'dummy@dummy.com',

  'SCRIPT_FILENAME' => '/Applications/MAMP/htdocs/dashboard/index.php',

  'REMOTE_PORT' => '56584',

  'GATEWAY_INTERFACE' => 'CGI/1.1',

  'SERVER_PROTOCOL' => 'HTTP/1.1',

  'REQUEST_METHOD' => 'POST',

  'QUERY_STRING' => '',

  'REQUEST_URI' => '/dashboard/index.php/api/tracker',

  'SCRIPT_NAME' => '/dashboard/index.php',

  'PATH_INFO' => '/api/tracker',

  'PATH_TRANSLATED' => '/Applications/MAMP/htdocs/api/tracker',

  'PHP_SELF' => '/dashboard/index.php/api/tracker',

  'REQUEST_TIME_FLOAT' => 1390404691.52,

  'REQUEST_TIME' => 1390404691,

  'argv' => 

  array (

  ),

  'argc' => 0,

)

2014/01/22 16:31:31 [trace] [system.CModule] Loading "log" application component

in /Applications/MAMP/htdocs/dashboard/index.php (13)

2014/01/22 16:31:31 [trace] [system.CModule] Loading "request" application component

in /Applications/MAMP/htdocs/dashboard/index.php (13)

2014/01/22 16:31:31 [trace] [system.CModule] Loading "urlManager" application component

in /Applications/MAMP/htdocs/dashboard/index.php (13)

2014/01/22 16:31:31 [info] [application] [ApiController:actionCreate]

in /Applications/MAMP/htdocs/dashboard/protected/controllers/ApiController.php (93)

in /Applications/MAMP/htdocs/dashboard/index.php (13)

2014/01/22 16:31:31 [trace] [system.CModule] Loading "db" application component

in /Applications/MAMP/htdocs/dashboard/protected/controllers/ApiController.php (98)

in /Applications/MAMP/htdocs/dashboard/index.php (13)

2014/01/22 16:31:31 [trace] [system.db.CDbConnection] Opening DB connection

in /Applications/MAMP/htdocs/dashboard/protected/controllers/ApiController.php (98)

in /Applications/MAMP/htdocs/dashboard/index.php (13)

2014/01/22 16:31:31 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `tracker`

in /Applications/MAMP/htdocs/dashboard/protected/controllers/ApiController.php (98)

in /Applications/MAMP/htdocs/dashboard/index.php (13)

2014/01/22 16:31:31 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `tracker`

in /Applications/MAMP/htdocs/dashboard/protected/controllers/ApiController.php (98)

in /Applications/MAMP/htdocs/dashboard/index.php (13)

2014/01/22 16:31:31 [trace] [system.db.ar.CActiveRecord] Tracker.insert()

in /Applications/MAMP/htdocs/dashboard/protected/controllers/ApiController.php (126)

in /Applications/MAMP/htdocs/dashboard/index.php (13)

2014/01/22 16:31:31 [trace] [system.db.CDbCommand] Executing SQL: INSERT INTO `tracker` (`user_id`) VALUES (NULL)

in /Applications/MAMP/htdocs/dashboard/protected/controllers/ApiController.php (126)

in /Applications/MAMP/htdocs/dashboard/index.php (13)

I know $_POST is sent and valid because I tested it with a stand-along web service I built. It inserts my data perfectly. [size="2"]Can someone help my understand why $_POST fails to appear in the log? Bonus points for explaining what happened to my $_POST data.[/size]

[size="2"]Thanks.[/size]

2

I guess the POST Body is empty and thus the $_POST array. The "insert" log in your trace indicates that because it inserts NULL





INSERT INTO `tracker` (`user_id`) VALUES (NULL)