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'
- 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
- Community projects
- Dogfood on a *.tiki.org site
- Regression
- Indexing
- Feature
- Search
Installer (profiles, upgrades and server-related issues) - Resolution status
- Fixed or Solved
- Submitted by
- Xavier de Pedro
- Volunteered to solve
- Jonny Bradley
- Lastmod by
- Xavier de Pedro
- Rating
- 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)?
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 (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 5936
- Created
- Wednesday 18 May, 2016 07:58:16 GMT-0000
by Xavier de Pedro - LastModif
- Thursday 26 May, 2016 07:44:44 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
;){kind=link}
;){kind=link}