No Event Found Issue in Modern Events Calendar

How to solve the “No Event Found” issue in the Modern Events Calendar

If you receive the message “No Event Found!” please check it before submitting a ticket. If your issue is not resolved, you can submit a ticket for assistance.

First, please make sure that you are using the latest version of MEC.

1. Please read the following article: Setup Date Option On Shortcodes.
2. Please check the following (even again):

Now, follow the checklist below.

1. Update permalinks from Dashboard > Settings > Permalinks
2. Update events and shortcodes again
3. Remove filter options from shortcodes
4. Check the events to not be expired
5. Featured images for events in the Carousel shortcode
6. Deactivate all your plugins and let MEC remain active alone, set your theme on default, then reload the page. If the issue is solved, then activate your plugins one by one and then your theme, refresh your page, and check to see which plugin is causing the issue. Then let us know the results.
7. Please check MEC Dashboard if you have Upcoming Events.

If the issue persists, please follow the instruction below.

Fix “No Event Found” With SQL Query:

We strongly advise you to get a backup of your database first.

If none of the above methods helped, we need to write a query that can work with the database of your website.

Firstly, please find the “#__mec_*** ” and delete them (Drop).

In the next step, open install.sql in the directory below:

wp-content\plugins\modern-events-calendar\assets\sql\install.sql

Note 1: Usually, “wp_” is the default prefix of all tables. You should change the prefix instead to this “#__”
Note 2: You can find the WordPress prefix on the wp-config file

Now, you should add a new query for your WordPress database, so please follow the steps below.

Some characters should be replaced as follow.

Find [:CHARSET:] => Replace with utf8mb4 or utf8
Find [:COLLATE:] => Replace with utf8mb4_unicode_ci or utf8_general_ci
Find #__         => Replace with Table prefix (Normally wp_)

Find and replace the correct charset.

For example, find all #__ in the install.sql and replace it with your WordPress prefix. Also, find [:CHARSET:] & [:COLLATE:], then replace them with the correct string.

Note: Do not save the install.sql file.

Now copy all of the code in the install.sql file [modified with the replace codes] and paste it into the SQL Query in your database, and then click on the GO button.

After that, you install MEC tables, and you need to save all of the events and shortcodes on your website, open all events, shortcodes, and taxonomies, etc. and click on the update button to save all of them in the database.
 
I hope the above steps help you. If you have any issues yet, please let me know: https://webnus.net/support/