people is empty since last updates

[Anonymous]

Hello Francky,

first of all thank you for this great plugin !
I recently noticed that the people page shows “Empty” and I saw that in changelog in version 1.9.7 you made some changes … the strange thing is that when i go to groups page and if i try to create a new group i can see and add all the people… so I think there is bug.

Anothe thing i just don’t understand and that is a bit annoying is that evry time you release an update I have several event automatically created, they look like sample events and this a bit anoying because they are published online and not in draft so some times I forget te delete them and my users can see them, would it be possible to prevent those creations
?

[Franky]

1.9.7 ?? That”s from 2017/09/27 … There have been about 40 versions after that …
Which version are you on? The 3 events are only created if the events table doesn’t exist. Maybe something is wrong with your db user (not enough rights or so)?

[Anonymous]

Ho sorry I did not see the date I read the changelog in the wrong order. I have all needed right on database otherwise i would have a lot of problem i think, the user i connect to WP admin portal is administrator. I have to say that this issue is quite recent because 2 weeks ago i was able to see all the previous customer in the people page.
Regarding the problem with the 3 events i always had this behaviour since I m using your plugin. I’m using version Version 2.0.43.

[Anonymous]

And the event table is existing because i have several events created and they are all working fine (i can see them and customers can book them) so I do not think that there is an access right problem.

[Franky]

Ok, some things:

– first the people issue: check your browser console for javascript errors. Maybe there’s some conflict with another plugin causing issues.
– second: what is the value of ’eme_version’ in the wp_options table? Also I’m very curious about the structure of the eme events table (typically called wp_eme_events). Like I said: those events only get added if the database table didn’t exist at the moment of install/update
– also any php errors/warnings in your server logfiles might be useful
– do you have the same issue with those events if you disable/re-enable the EME plugin?

[Franky]

Also, for your db user: check if the query “SHOW TABLES LIKE wp_eme_events” works in your wordpress db with your wordpress db user (assuming ‘wp_’ is your db prefix).

[Franky]

no reply, closing

[Anonymous]

eme_version in wp_options table : 210
also any php errors/warnings in your server logfiles might be useful : don’t know where to find them ..

SHOW TABLES LIKE “v2g_eme_events” : Ok returns table

structure of the eme events table :

— phpMyAdmin SQL Dump
— version 4.7.7
— https://www.phpmyadmin.net/
—
— Hôte : localhost:3306
— Généré le : mar. 25 sep. 2018 à 22:24
— Version du serveur : 5.6.30-cll-lve
— Version de PHP : 5.6.30

SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”;
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = “+00:00”;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

—

— ——————————————————–

—
—
—

CREATE TABLE v2g_eme_events (
event_id mediumint(9) NOT NULL,
event_status mediumint(9) DEFAULT ‘1’,
event_author mediumint(9) DEFAULT ‘0’,
event_name text COLLATE utf8mb4_unicode_520_ci NOT NULL,
event_slug text COLLATE utf8mb4_unicode_520_ci,
event_url text COLLATE utf8mb4_unicode_520_ci,
event_start_time time NOT NULL,
event_end_time time NOT NULL,
event_start_date date NOT NULL,
event_end_date date DEFAULT NULL,
creation_date datetime DEFAULT CURRENT_TIMESTAMP,
modif_date datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
event_notes longtext COLLATE utf8mb4_unicode_520_ci,
event_rsvp tinyint(1) DEFAULT ‘0’,
use_paypal tinyint(1) DEFAULT ‘0’,
use_2co tinyint(1) DEFAULT ‘0’,
use_webmoney tinyint(1) DEFAULT ‘0’,
use_fdgg tinyint(1) DEFAULT ‘0’,
use_mollie tinyint(1) DEFAULT ‘0’,
use_sagepay tinyint(1) DEFAULT ‘0’,
price text COLLATE utf8mb4_unicode_520_ci,
currency text COLLATE utf8mb4_unicode_520_ci,
rsvp_number_days tinyint(3) UNSIGNED DEFAULT ‘0’,
rsvp_number_hours tinyint(3) UNSIGNED DEFAULT ‘0’,
event_seats text COLLATE utf8mb4_unicode_520_ci,
event_contactperson_id mediumint(9) DEFAULT ‘0’,
location_id mediumint(9) DEFAULT ‘0’,
recurrence_id mediumint(9) DEFAULT ‘0’,
event_category_ids text COLLATE utf8mb4_unicode_520_ci,
event_attributes text COLLATE utf8mb4_unicode_520_ci,
event_properties text COLLATE utf8mb4_unicode_520_ci,
event_page_title_format text COLLATE utf8mb4_unicode_520_ci,
event_single_event_format text COLLATE utf8mb4_unicode_520_ci,
event_contactperson_email_body text COLLATE utf8mb4_unicode_520_ci,
event_respondent_email_body text COLLATE utf8mb4_unicode_520_ci,
event_registration_recorded_ok_html text COLLATE utf8mb4_unicode_520_ci,
event_registration_pending_email_body text COLLATE utf8mb4_unicode_520_ci,
event_registration_updated_email_body text COLLATE utf8mb4_unicode_520_ci,
event_registration_cancelled_email_body text COLLATE utf8mb4_unicode_520_ci,
event_registration_paid_email_body text COLLATE utf8mb4_unicode_520_ci,
event_registration_denied_email_body text COLLATE utf8mb4_unicode_520_ci,
event_registration_form_format text COLLATE utf8mb4_unicode_520_ci,
event_cancel_form_format text COLLATE utf8mb4_unicode_520_ci,
registration_requires_approval tinyint(1) DEFAULT ‘0’,
registration_wp_users_only tinyint(1) DEFAULT ‘0’,
event_image_url text COLLATE utf8mb4_unicode_520_ci,
event_image_id mediumint(9) NOT NULL DEFAULT ‘0’,
event_external_ref text COLLATE utf8mb4_unicode_520_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

[Franky]

Check your browser manual on how to get the console errors, and ask your site admin for logfiles and errors.
Concerning the events getting created: you can check the code in events-manager.php, function eme_create_events_table: the 3 events only get inserted if the table wp_eme_events doesn’t exist (SHOW TABLES LIKE ‘v2g_eme_events’).

[Author]

Posts