Loading...
 
Skip to main content

PHP Fatal error with ANY profile since 15.x: Search_MySql_LimitReachedException Incorrect datetime value: '0000-00-00 00:00:00' for column 'creation_date'

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
PHP Fatal error with ANY profile since 15.x: Search_MySql_LimitReachedException Incorrect datetime value: '0000-00-00 00:00:00' for column 'creation_date'
Version
15.x
15.x Regression
Category
  • Error
  • Regression
  • Community projects
  • Dogfood on a *.tiki.org site
  • Indexing
Feature
Installer (profiles, upgrades and server-related issues)
Search
Resolution status
Fixed or Solved
Submitted by
Xavier de Pedro
Volunteered to solve
Jonny Bradley
Lastmod by
Xavier de Pedro
Rating
(0)
Description

I've run a script on all profiles from all branches ( https://github.com/xavidp/TikiProfilesTester ) and I see that all profiles since 15.x throw this error message (which might be related to the fact that unified search index may be currently enabled by default)?

Copy to clipboard
PHP Fatal error:  Uncaught Search_MySql_LimitReachedException: Could not perform index modification: Incorrect datetime value: '0000-00-00 00:00:00' for column 'creation_date' at row 1 in /var/www/html/15.x/lib/core/Search/MySql/QueryBuffer.php:55
Stack trace:
#0 /var/www/html/15.x/lib/core/Search/MySql/QueryBuffer.php(37): Search_MySql_QueryBuffer->realFlush()
#1 /var/www/html/15.x/lib/core/Search/MySql/Table.php(195): Search_MySql_QueryBuffer->flush()
#2 /var/www/html/15.x/lib/core/Search/MySql/Table.php(28): Search_MySql_Table->flush()
#3 [internal function]: Search_MySql_Table->__destruct()
#4 {main}
  thrown in /var/www/html/15.x/lib/core/Search/MySql/QueryBuffer.php on line 55


Using php 5.6, and mysql (server) 5.7.12 (mysql client: libmysql - mysqlnd 5.0.11-dev - 20120503).

Profiles are applied through the command line with "php console.php p:a ProfileName"


Solution

r58695 seems to work for me, but only on my local so far

fixed for me too. Closing the bug report. Thanks jonnyb!

Importance
8
Easy to solve?
6
Priority
48
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
5936
Created
Wednesday 18 May, 2016 07:58:16 UTC
by Xavier de Pedro
LastModif
Thursday 26 May, 2016 07:44:44 UTC


Show PHP error messages