{"id":14242419,"date":"2021-03-27T10:20:35","date_gmt":"2021-03-27T10:20:35","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/translatepress-sql-errors-option-php\/"},"modified":"2021-03-27T10:20:35","modified_gmt":"2021-03-27T10:20:35","slug":"translatepress-sql-errors-option-php","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/translatepress-sql-errors-option-php\/","title":{"rendered":"TranslatePress SQL errors &#8211; option.php"},"content":{"rendered":"<p>Hello,<br \/>\nSince update to WordPress 5.7 and PHP 7.4.14 I encounter the same kind of error as mentioned in <a href=\"https:\/\/wordpress.org\/support\/topic\/translatepress-encountered-sql-errors-5\/?view=all\">this<\/a> thread: error linked to options.php.<br \/>\nI contacted my hosting company and they confirmed that database has the permission to create and change tables.<\/p>\n<p>My latest error message log looks like: <\/p>\n<pre><code>1\nlast_error\tTable &#039;zdfbhxh5y8_trp_gettext_en_us&#039; already exists\ndisable_automatic_translations\tJa\nurl\thttps:\/\/www.billekens.org\/wp-admin\/options.php\ndetails\tError creating gettext strings tables\ndate_time\t2021-03-27 09:33:59\ntimestamp\t1616837639\n2\nlast_error\t\ndisable_automatic_translations\tJa\nurl\thttps:\/\/www.billekens.org\/wp-admin\/options.php\ndetails\tError creating regular strings tables\ndate_time\t2021-03-27 09:33:59\ntimestamp\t1616837639\n3\nlast_error\tDuplicate key name &#039;index_name&#039;\ndisable_automatic_translations\tJa\nurl\thttps:\/\/www.billekens.org\/wp-admin\/options.php\ndetails\tError creating regular tables\ndate_time\t2021-03-27 09:33:59\ntimestamp\t1616837639\n4\nlast_error\tTable &#039;zdfbhxh5y8_trp_gettext_nl_nl&#039; already exists\ndisable_automatic_translations\tJa\nurl\thttps:\/\/www.billekens.org\/wp-admin\/options.php\ndetails\tError creating gettext strings tables\ndate_time\t2021-03-27 09:33:59\ntimestamp\t1616837639\n5\nlast_error\t\ndisable_automatic_translations\tJa\nurl\thttps:\/\/www.billekens.org\/wp-admin\/options.php\ndetails\tError creating regular strings tables\ndate_time\t2021-03-27 09:30:42\ntimestamp\t1616837442<\/code><\/pre>\n<p>Do you have any idea what could cause the problem?<br \/>\nI really like your plugin, as it is a very user friendly and complete tool to manager several languages!<br \/>\nThank yo so much for your help.<br \/>\nJan<\/p>\n","protected":false},"template":"","class_list":["post-14242419","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14242419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14242419\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=14242419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}