Fatal error Invalid datetime format when rebuilding search index

Software Support
8

Hi @lcmartinezru,

I suspect you’ve run into an UTF8MB4 character, which cannot be represented in the utf8_general_ci that you’re using. See this StackOverflow discussion for a discussion of the issues involved.

To adapt your database to UTF8MB4 there are two steps:

  1. Convert the database contents. You can do this from PHPMyAdmin, apparently, or use mysqldump to generate a database dump and change the encodings there before reloading. (There will probably be lots of information on StackOverflow about this.)
  2. Configure OJS to use the new encoding; see this thread for details.

Regards,
Alec Smecher
Public Knowledge Project Team