Title: Error with database Last modified: December 18, 2018 --- # Error with database * Resolved [monagraphic](https://wordpress.org/support/users/monagraphic/) * (@monagraphic) * [7 years, 3 months ago](https://wordpress.org/support/topic/error-with-databse/) * Hello, * when i try create new event, i have an error : * Les détails pour votre évènement sont incorrects, et ne peuvent être publiées, veuillez corriger les erreurs suivantes : Quelque chose s’est mal passé lors de l’enregistrement de votre évènement dans la table d’index. Veuillez en informer l’administrateur du site. * I think, there is a problem with database. * I tried : -Update Event Manager; -Update WP; -Update all plugins; -Deactivate all plugins; -Change theme by default theme; * But nothing works.. * I have a multisite (2 sites). * Thanks for help. - This topic was modified 7 years, 3 months ago by [monagraphic](https://wordpress.org/support/users/monagraphic/). Viewing 14 replies - 1 through 14 (of 14 total) * [timrv](https://wordpress.org/support/users/timrv/) * (@timrv) * [7 years, 3 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11002463) * Hello, * Are you testing it on local computer or on a paid hosting? Can you also check that there are tables em tables created on your database? those tables have a prefix of “em_*” * Thread Starter [monagraphic](https://wordpress.org/support/users/monagraphic/) * (@monagraphic) * [7 years, 3 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11006999) * Hello, * i’m testing on paid hosting. I have ’em_*’ table on my data base (3 tables). * [Stonehenge Creations](https://wordpress.org/support/users/duisterdenhaag/) * (@duisterdenhaag) * [7 years, 3 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11007030) * 3??? You should have 6 if you are using the free version. So it seems the installation was not done correctly. * 1) Deactivate the plugin in. 2) In your functions.php add: `delete_option('dbem_version');` 3) Reload any Admin page. 4) Delete the line you added in your functions.php ( IMPORTANT, or esle you will get stuck in a loop). 5) Reactivate the plugin. - This reply was modified 7 years, 3 months ago by [Stonehenge Creations](https://wordpress.org/support/users/duisterdenhaag/). * Thread Starter [monagraphic](https://wordpress.org/support/users/monagraphic/) * (@monagraphic) * [7 years, 3 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11011813) * Hello, * i tried your trick but seems not works. * 2 things : 1- When i edit event from edit page, not works; 2- If i use “quick edit” from events list page (All events), and change to “Publish”, the event is published and it works. * I tried to reintall the plugin but problem always here. * Thanks for help. * EDIT : i have 6 tables on database foreach multisite. - This reply was modified 7 years, 3 months ago by [monagraphic](https://wordpress.org/support/users/monagraphic/). * [Stonehenge Creations](https://wordpress.org/support/users/duisterdenhaag/) * (@duisterdenhaag) * [7 years, 3 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11017238) * Do you have an ad-blocker running in your browser? That prevented me to even open the top slider with WP page settings. * Thread Starter [monagraphic](https://wordpress.org/support/users/monagraphic/) * (@monagraphic) * [7 years, 3 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11043334) * Hello Patrick, * i have no ad-blocker. I tried in private navigation, but the problem is the same. * [timrv](https://wordpress.org/support/users/timrv/) * (@timrv) * [7 years, 3 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11045053) * Hello, * Have you tried testing it on a different computer? or maybe on iPad/Tablet and check if it still happens? There is a chance also that it might be a hosting issue, Could We know where do you host it? If your hosting have a caching, I would recommend that you try and disable it. * Just want to ask also, Do you have 6 tables already now? like what Patrick have mentioned. * Thread Starter [monagraphic](https://wordpress.org/support/users/monagraphic/) * (@monagraphic) * [7 years, 3 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11047201) * Hello Timrv, * I tried on different computer and my client too. I tried on different navigator. I tried on mobile and the problem is the same. * Our host is OVH. * I have 6 tables for each multisite on my database. * Plugin Support [angelo_nwl](https://wordpress.org/support/users/angelo_nwl/) * (@angelo_nwl) * [7 years, 2 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11086287) * using your site hosting cpanel > phpmyadmin you can edit events table (eg. wp_em_events table) then make sure field event_id is auto_increment * note: backup your database to make sure before editing any wordpress tables * Thread Starter [monagraphic](https://wordpress.org/support/users/monagraphic/) * (@monagraphic) * [7 years, 2 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11121122) * Hello [@angelo_nwl](https://wordpress.org/support/users/angelo_nwl/), * auto_increment is ok.. * Plugin Support [angelo_nwl](https://wordpress.org/support/users/angelo_nwl/) * (@angelo_nwl) * [7 years, 2 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11146793) * another way is try something like this * 1. in your browser, type [http://Name_of_your_site.com/wp-admin/options.php](http://Name_of_your_site.com/wp-admin/options.php) 2. search “dbem_version ” and replace it with lower digit so that updates will be triggered 3. click Save located at the bottom of the page 4. go to WP Plugins > Installed plugins (update EM and EMpro) * Thread Starter [monagraphic](https://wordpress.org/support/users/monagraphic/) * (@monagraphic) * [7 years, 2 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11166699) * Hello, * when i tried it, after saving, the dbem_version go back to 5.95. And have this error : * Event start UTC transition: Unknown column ‘event_start’ in ‘where clause’ Event end UTC transation: Unknown column ‘event_end’ in ‘where clause’ Event start UTC transition: Unknown column ‘event_start’ in ‘where clause’ Event end UTC transation: Unknown column ‘event_end’ in ‘where clause’ Event timezone setting: Unknown column ‘event_timezone’ in ‘where clause’ * [timrv](https://wordpress.org/support/users/timrv/) * (@timrv) * [7 years, 2 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11167181) * Hello, * I think there was an error with Installing the EM on your database. What I could recommend is. * 1. Try to do a fresh Install of Everything, WP + EM. 2. Make sure that your database user have all the permissions for that database, There are cases that the database user doesn’t have enough permissions thus it doesn’t create the tables correctly. 3. You could also try and do a complete uninstall of EM and manually delete em related tables on database 4. Make sure that you’re also using PHP 7.0 and above. * If you’re also using multi-site, Please make sure that you have checked this documentation. [https://wp-events-plugin.com/documentation/multisite/](https://wp-events-plugin.com/documentation/multisite/) * Thread Starter [monagraphic](https://wordpress.org/support/users/monagraphic/) * (@monagraphic) * [7 years, 2 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11167245) * Thanks, i’ll keep you informed. Viewing 14 replies - 1 through 14 (of 14 total) The topic ‘Error with database’ is closed to new replies. * ![](https://ps.w.org/events-manager/assets/icon-256x256.png?rev=1039078) * [Events Manager - Calendar, Bookings, Tickets, and more!](https://wordpress.org/plugins/events-manager/) * [Frequently Asked Questions](https://wordpress.org/plugins/events-manager/#faq) * [Support Threads](https://wordpress.org/support/plugin/events-manager/) * [Active Topics](https://wordpress.org/support/plugin/events-manager/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/events-manager/unresolved/) * [Reviews](https://wordpress.org/support/plugin/events-manager/reviews/) * 14 replies * 4 participants * Last reply from: [monagraphic](https://wordpress.org/support/users/monagraphic/) * Last activity: [7 years, 2 months ago](https://wordpress.org/support/topic/error-with-databse/#post-11167245) * Status: resolved