Error with database

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_*”

Hello,

i’m testing on paid hosting.
I have ’em_*’ table on my data base (3 tables).

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 6 years, 2 months ago by Stonehenge Creations.

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 6 years, 2 months ago by monagraphic.

Do you have an ad-blocker running in your browser? That prevented me to even open the top slider with WP page settings.

Hello Patrick,

i have no ad-blocker. I tried in private navigation, but the problem is the same.

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.

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.

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

Hello @angelo_nwl,

auto_increment is ok..

another way is try something like this

1. in your browser, type https://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)

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’

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/

Thanks, i’ll keep you informed.