Project

General

Profile

Actions
Copy link

Bug #54917

closed

Debug "Column 'first' cannot be null"

Added by Thomas Skierlo over 10 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Indexed Search
Target version:
-
Start date:
2014-01-12
Due date:
% Done:

100%

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

Description

On current master TYPO3 6.2.0beta3 I'm getting this debug message in FE (if in development mode). Fresh install, no upgrade.

exec_INSERTquery
caller     TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery
ERROR     Column 'first' cannot be null
lastBuiltQuery     INSERT INTO index_rel (phash,wid,count,first,freq,flags) VALUES ('260439973','17213122','1',NULL,'1126.7605633803','128')
debug_backtrace     require(24/typo3/sysext/cms/tslib/index_ts.php),24/index.php#41 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->generatePage_postProcessing#207 // TYPO3\CMS\IndexedSearch\Indexer->hook_indexContent#3368 // TYPO3\CMS\IndexedSearch\Indexer->indexTypo3PageContent#309 // TYPO3\CMS\IndexedSearch\Indexer->submitWords#574 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_INSERTquery#2021 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#198

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Bug #53662: DatabaseConnection INSERTquery does not allow NULL valuesClosed2013-11-15

Actions
Actions
Copy link
 #1

Updated by Markus Klein over 10 years ago

  • Status changed from New to Accepted
  • Priority changed from Should have to Must have
  • Complexity set to no-brainer
  • Is Regression changed from No to Yes

This is a regression to #53662.

Actions
Copy link
 #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 https://review.typo3.org/26757

Actions
Copy link
 #3

Updated by Markus Klein over 10 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions
Copy link
 #4

Updated by Gerrit Code Review almost 10 years ago

  • Status changed from Resolved to Under Review

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

Actions
Copy link
 #5

Updated by Gerrit Code Review almost 10 years ago

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

Actions
Copy link
 #6

Updated by Markus Klein almost 10 years ago

  • Status changed from Under Review to Resolved
Actions
Copy link
 #7

Updated by Timotheus Pokorra almost 10 years ago

Just as a note, because it took me a while to find this bug report and the solution:
In Typo3 6.1.8, my indexed_search did not show pages where the searched word was part of the title of the page.
I finally found that if I apply this change that fixes this bug, my problem is solved as well.
(I got here by comparing 6.1.8 and 6.1.9, where this bug has been fixed already)

Actions
Copy link
 #8

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF