Title: Table doesn’t exist Last modified: April 12, 2018 --- # Table doesn’t exist * Resolved [marissa44](https://wordpress.org/support/users/marissa44/) * (@marissa44) * [8 years, 1 month ago](https://wordpress.org/support/topic/table-doesnt-exist-9/) * Hi! * Recently I’ve tried to install this plugin. However, when I try to open the plugin I get an error: ‘Fout bij het communiceren met de database’. When I try to create an event I get the following error: ‘WordPress databasefout: [Table doesn’t exist]. Since I really want to use your plugin I tried reactivating and reinstalling, but that doesn’t seem to resolve the issue. I even tried reinstalling wordpress and using a new database, but the problem of missing columns keeps haunting me. Can you please help? Viewing 9 replies - 1 through 9 (of 9 total) * Plugin Author [Franky](https://wordpress.org/support/users/liedekef/) * (@liedekef) * [8 years, 1 month ago](https://wordpress.org/support/topic/table-doesnt-exist-9/#post-10173840) * Does your configured wordpress database user has the right to create tables? Because if not, that will be the problem. * Thread Starter [marissa44](https://wordpress.org/support/users/marissa44/) * (@marissa44) * [8 years, 1 month ago](https://wordpress.org/support/topic/table-doesnt-exist-9/#post-10174235) * Hi Franky, * Users has the right to create tables but in the database only two tables are created: wp_eme_groups and wp_eme_usergroups. * Plugin Author [Franky](https://wordpress.org/support/users/liedekef/) * (@liedekef) * [8 years, 1 month ago](https://wordpress.org/support/topic/table-doesnt-exist-9/#post-10174280) * If that is the case: can you check the webserver logfiles? It should indicate some errors concerning table creation then. Also: what DB version are you using( might be important) and what php version? * Thread Starter [marissa44](https://wordpress.org/support/users/marissa44/) * (@marissa44) * [8 years, 1 month ago](https://wordpress.org/support/topic/table-doesnt-exist-9/#post-10174419) * I’m using php version 5.6 and my DB version is 5.5.52. * I checked the error log and found errors concerning EME, but I´m only a noob and don´t really know what I´m looking for. The error that stands out to me shows this: * [Thu Apr 12 12:09:06.839676 2018] [fcgid:warn] [pid 6288:tid 139755685672704][ client 87.215.25.234:51638] mod_fcgid: stderr: WordPress databasefout Invalid default value for ‘creation_date’ bij query CREATE TABLE wp_eme_events (, referer: [http://mysite.nl/wp-admin/plugin-install.php?s=events+made+easy&tab=search&type=term](http://mysite.nl/wp-admin/plugin-install.php?s=events+made+easy&tab=search&type=term) * I think this explains why the table wp_eme_events was never created and this is a returning error for the rest of the missing tables. * Plugin Author [Franky](https://wordpress.org/support/users/liedekef/) * (@liedekef) * [8 years, 1 month ago](https://wordpress.org/support/topic/table-doesnt-exist-9/#post-10174608) * Indeed that is the problem. It seems your DB version is too old for a newer feature that I put in. Although wordpress recommends 5.6, I admit this is a problem, and I’ll take a look at how to fix this. But to be blunt: is there no way to upgrade to a newer mysql version? Both php 5.6 and mysql 5.5 are pretty old. PHP 5.6 will be end of life at the end of this year, see [http://php.net/supported-versions.php](http://php.net/supported-versions.php) * [2skinnywheels](https://wordpress.org/support/users/2skinnywheels/) * (@2skinnywheels) * [8 years, 1 month ago](https://wordpress.org/support/topic/table-doesnt-exist-9/#post-10174912) * I just got off the phone with my hosting service. They weren’t very helpful. It appears I should be able to upgrade my PHP version from within cpanel from 5.6.3 to 7.0 but not MySql which is currently 5.5.58-cll. I followed the step to change the PHP version but I still get the errors. I can’t tell if it actually changed anything. When I look at Server Information, it still still reports I’m using PHP 5.6.3. * Plugin Author [Franky](https://wordpress.org/support/users/liedekef/) * (@liedekef) * [8 years, 1 month ago](https://wordpress.org/support/topic/table-doesnt-exist-9/#post-10174944) * Well, it is not a php problem, but mysql-related. The reason is I default datetime columns to “CURRENT_TIMESTAMP” (or “NOW”), and in older mysql versions that was not possible … I had hoped people would’ve switched by now, and certainly hosting providers should be amongst the first (I support sites on 3 providers, all have mariadb in place). The only thing I can do is check for the mysql version and not initialize to ‘NOW’ … Another possibility (if you really need to go forward now), is to edit events-manager.php yourself and remove all the text saying “ DEFAULT CURRENT_TIMESTAMP” and “DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”( not the lines, just those words) It won’t affect your setup, just not track creation and update timings for events and such … but of course it will not handle updates, so I’d need to do something to account for older versions (and I’ll handle it in the next version). * [2skinnywheels](https://wordpress.org/support/users/2skinnywheels/) * (@2skinnywheels) * [8 years, 1 month ago](https://wordpress.org/support/topic/table-doesnt-exist-9/#post-10175029) * I just tried removing that text and it caused problems when logging in to my dashboard. Just a blank screen. I performed a find and replace to replace the exact text with no value. Is there another way I should do it? * Plugin Author [Franky](https://wordpress.org/support/users/liedekef/) * (@liedekef) * [8 years, 1 month ago](https://wordpress.org/support/topic/table-doesnt-exist-9/#post-10175921) * You probably made a typo. However, I prepared a dev-version that should fix your issue, you can download it here: [https://wordpress.org/plugins/events-made-easy/advanced/](https://wordpress.org/plugins/events-made-easy/advanced/) * Deactivate and remove the current EME (make sure no EME database tables are left) and then: replace the events-made-easy folder/files in your plugin dir with the one you download from the link above After that you should be able to reactivate it and it should be ok. Viewing 9 replies - 1 through 9 (of 9 total) The topic ‘Table doesn’t exist’ is closed to new replies. * ![](https://ps.w.org/events-made-easy/assets/icon-256x256.png?rev=1856035) * [Events Made Easy](https://wordpress.org/plugins/events-made-easy/) * [Frequently Asked Questions](https://wordpress.org/plugins/events-made-easy/#faq) * [Support Threads](https://wordpress.org/support/plugin/events-made-easy/) * [Active Topics](https://wordpress.org/support/plugin/events-made-easy/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/events-made-easy/unresolved/) * [Reviews](https://wordpress.org/support/plugin/events-made-easy/reviews/) ## Tags * [Database Error](https://wordpress.org/support/topic-tag/database-error/) * 9 replies * 3 participants * Last reply from: [Franky](https://wordpress.org/support/users/liedekef/) * Last activity: [8 years, 1 month ago](https://wordpress.org/support/topic/table-doesnt-exist-9/#post-10175921) * Status: resolved