Project

General

Profile

Actions

Bug #61051

closed

MySQL Error "Column 'IP' cannot be null" on CLI while getting php errors

Added by Daniel Hürtgen over 10 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Must have
Assignee:
Category:
Logging
Target version:
Start date:
2014-08-19
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
5.4
Tags:
Complexity:
no-brainer
Is Regression:
No
Sprint Focus:

Description

If you execute a command via CLI (here via the ExtbaseCommandController) and getting some php errors while execution HTML errors will be printed on the CLI.

<table class="typo3-debug" border="0" cellpadding="0" cellspacing="0" bgcolor="white" style="border:0px; margin-top:3px; margin-bottom:3px;">
        <tr>
            <td style="background-color:#bbbbbb; font-family: verdana,arial; font-weight: bold; font-size: 10px;">exec_INSERTquery</td>
        </tr>
        <tr>
            <td>

            <table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr>
                        <td valign="top"><font face="Verdana,Arial" size="1">caller</font></td>
                        <td><font face="Verdana,Arial" size="1" color="red">TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery<br /></font></td>
                    </tr><tr>
                        <td valign="top"><font face="Verdana,Arial" size="1">ERROR</font></td>
                        <td><font face="Verdana,Arial" size="1" color="red">Column 'IP' cannot be null<br /></font></td>
                    </tr><tr>
                        <td valign="top"><font face="Verdana,Arial" size="1">lastBuiltQuery</font></td>
                        <td><font face="Verdana,Arial" size="1" color="red">INSERT INTO sys_log (userid,type,action,error,details_nr,details,IP,tstamp,workspace) VALUES ('5','5','0','1','0','Core: Error handler (BE): PHP Warning: ************'). in ********** line 768',NULL,'1408436630','0')<br /></font></td>
                    </tr><tr>
                        <td valign="top"><font face="Verdana,Arial" size="1">debug_backtrace</font></td>
                        <td><font face="Verdana,Arial" size="1" color="red">include(le/typo3_src/typo3/sysext/extbase/Scripts/CommandLineLauncher.php),le/typo3_src/typo3/cli_dispatch.phpsh#53 // TYPO3\CMS\Extbase\Core\Bootstrap-&gt;run#21 // TYPO3\CMS\Extbase\Core\Bootstrap-&gt;handleRequest#184 // TYPO3\CMS\Extbase\Mvc\Cli\RequestHandler-&gt;handleRequest#195 // TYPO3\CMS\Extbase\Mvc\Dispatcher-&gt;dispatch#61 // TYPO3\CMS\Extbase\Mvc\Controller\CommandController-&gt;processRequest#69 // TYPO3\CMS\Extbase\Mvc\Controller\CommandController-&gt;callCommandMethod#112 // call_user_func_array#211 // **********-&gt;*****# // ********-&gt;*****#178 // **********-&gt;******#485 // DOMDocument-&gt;schemaValidate#768 // TYPO3\CMS\Core\Error\ErrorHandler-&gt;handleError# // TYPO3\CMS\Core\Error\ErrorHandler-&gt;writeLog#137 // TYPO3\CMS\Core\Database\DatabaseConnection-&gt;exec_INSERTquery#190 // TYPO3\CMS\Core\Database\DatabaseConnection-&gt;debug#202<br /></font></td>
                    </tr></table>
            </td>
        </tr>
    </table>
Actions #1

Updated by Markus Klein over 10 years ago

  • Category changed from Backend API to Logging
  • Status changed from New to Accepted
  • Assignee set to Markus Klein
  • Priority changed from Should have to Must have
  • Target version set to next-patchlevel
  • Complexity set to no-brainer

Ok, typical issue on command line, no IP. ;-)

Actions #2

Updated by Gerrit Code Review over 10 years ago

  • Status changed from Accepted to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/32247

Actions #3

Updated by Gerrit Code Review over 10 years ago

Patch set 1 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/32257

Actions #4

Updated by Markus Klein over 10 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #5

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF