Support

March 17, 2017 at 10:14 am

Hi Lorenzo,

sorry but I did what you adviced and the result is the same. If I enable the DEBUG MODE my website is down … can you help?

Regards

Yvan

The following errors have occurred:
There were errors creating the Event Espresso database tables and Event Espresso has been deactivated. To view the errors, please enable WP_DEBUG in your wp-config.php file.
There were errors creating the Event Espresso database tables and Event Espresso has been deactivated. To view the errors, please enable WP_DEBUG in your wp-config.php file.
A database error has occurred. Turn on WP_DEBUG for more information.
There were errors creating the Event Espresso database tables and Event Espresso has been deactivated. To view the errors, please enable WP_DEBUG in your wp-config.php file.
There were errors creating the Event Espresso database tables and Event Espresso has been deactivated. To view the errors, please enable WP_DEBUG in your wp-config.php file.

March 20, 2017 at 7:48 am

Hello Lorenzo,

the answer of my web host is negative: OVH told me that I had the full right and no limitation to create tables in my databases. Any other idea ?

Regards

Yvan

March 23, 2017 at 8:30 am

Hi Lorenzo,

we have installed a new database on a test serveur where it was possible to install the plugin. We did a dump of the tables created by EE4 and it’s now working on the production server, but still I don’t like the process and still don’t understand why we had this issue.

As I told you it’s possible to create tables with my host OVH, it’s more a problem of code due to EE4. Here’s the debug message, can you give me more news in order to solve definitively this issue ?

Thank you

Yvan

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question_group’ doesn’t exist]
SELECT QSG_system FROM dev_esp_question_group WHERE QSG_system != 0

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question_group’ doesn’t exist]
SHOW FULL COLUMNS FROM dev_esp_question_group

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question_group’ doesn’t exist]
SHOW FULL COLUMNS FROM dev_esp_question_group

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question’ doesn’t exist]
SELECT QST_system FROM dev_esp_question WHERE QST_system != ”

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM dev_esp_question

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question_group_question’ doesn’t exist]
INSERT INTO dev_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 1)

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM dev_esp_question

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question_group_question’ doesn’t exist]
INSERT INTO dev_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 2)

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM dev_esp_question

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question_group_question’ doesn’t exist]
INSERT INTO dev_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 3)

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM dev_esp_question

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question_group_question’ doesn’t exist]
INSERT INTO dev_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 4)

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM dev_esp_question

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question_group_question’ doesn’t exist]
INSERT INTO dev_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 5)

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM dev_esp_question

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question_group_question’ doesn’t exist]
INSERT INTO dev_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 6)

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM dev_esp_question

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question_group_question’ doesn’t exist]
INSERT INTO dev_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 7)

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM dev_esp_question

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question_group_question’ doesn’t exist]
INSERT INTO dev_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 8)

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM dev_esp_question

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question_group_question’ doesn’t exist]
INSERT INTO dev_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 9)

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM dev_esp_question

Erreur de la base de données WordPress : [Table ‘peacesposite.dev_esp_question_group_question’ doesn’t exist]
INSERT INTO dev_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 10)

Notice: WPDB Error “Table ‘peacesposite.dev_esp_payment_method’ doesn’t exist” while running wpdb method “get_var” with arguments [“SELECT COUNT(Payment_Method.PMD_ID) FROM dev_esp_payment_method AS Payment_Method WHERE Payment_Method.PMD_scope LIKE ‘%CART%'”]. Automatically attempting to fix EE Core DB in /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/db_models/EEM_Base.model.php on line 2263

Notice: WPDB AGAIN: Error “Table ‘peacesposite.dev_esp_payment_method’ doesn’t exist” while running the same method and arguments as before. Automatically attempting to fix EE Addons DB in /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/db_models/EEM_Base.model.php on line 2263

Fatal error: Uncaught exception ‘EE_Error’ with message ‘WPDB Error: “Table ‘peacesposite.dev_esp_payment_method’ doesn’t exist”‘ in /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/db_models/EEM_Base.model.php:2202 Stack trace: #0 /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/db_models/EEM_Base.model.php(2134): EEM_Base->_do_wpdb_query(‘get_var’, Array) #1 /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/db_models/EEM_Payment_Method.model.php(136): EEM_Base->count(Array) #2 /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/helpers/EEH_Activation.helper.php(1208): EEM_Payment_Method->count_active(‘CART’) #3 /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/helpers/EEH_Activation.helper.php(153): EEH_Activation::insert_default_payment_methods() #4 /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/EE_System.core.php(376): EEH_Activation::initialize_db_content() #5 [internal function]: EE_System->init in /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/db_models/EEM_Base.model.php on line 2202

March 23, 2017 at 10:12 am

@josh
I am trying to find a solution, I am not saying that your code is crap. I have paid for a plugin – $280 isn’t nothing – and I would like to use it without any fear.

Can you find an explanation to this problem?

March 24, 2017 at 8:25 am

Hi

I have tried to install the plugin People Addon and again I had a warning message (see bellow)

I can access the plugin event if I had this warning but I want to understand why we continue to have this issue.

I don’t have technical skills to understand what is going on, I can give you full access to my host and backoffice in order to solve the problem.

Here is the message :
The following errors have occurred:

WordPress database error: []
CREATE TABLE dev_esp_people_to_post ( PTP_ID bigint(20) unsigned NOT NULL AUTO_INCREMENT, PER_ID bigint(20) unsigned NOT NULL DEFAULT 0, OBJ_ID bigint(20) unsigned NOT NULL DEFAULT 0, OBJ_type varchar(50) NOT NULL DEFAULT ‘Event’, P2P_Order tinyint(3) NOT NULL DEFAULT 0, PT_ID bigint(20) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (PTP_ID), KEY PER_ID (PER_ID), KEY OBJ_ID (OBJ_ID), KEY OBJ_type (OBJ_type), KEY PT_ID (PT_ID) ) ENGINE=InnoDB DEFAULT CHARACTER SET ‘utf8mb4_unicode_ci’

Stack Trace:#0 /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/helpers/EEH_Activation.helper.php(745): EventEspresso\core\services\database\TableManager->createTable(‘esp_people_to_p…’, ‘\n\t\t\tPTP_ID bigi…’, ‘InnoDB ‘) #1 /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/data_migration_scripts/EE_Data_Migration_Script_Base.core.php(557): EEH_Activation::create_table(‘esp_people_to_p…’, ‘\n\t\t\tPTP_ID bigi…’, ‘ENGINE=InnoDB ‘, true) #2 /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/data_migration_scripts/EE_Data_Migration_Script_Base.core.php(430): EE_Data_Migration_Script_Base->_create_table_and_catch_errors(‘esp_people_to_p…’, ‘\n\t\t\tPTP_ID bigi…’, ‘ENGINE=InnoDB ‘, true) #3 /home/peacespo/www/wp-content/plugins/eea-people-addon/core/data_migration_scripts/EE_DMS_People_1_0_0.dms.php(57): EE_Data_Migration_Script_Base->_table_is_new_in_this_version(‘esp_people_to_p…’, ‘\n\t\t\tPTP_ID bigi…’) #4 /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/EE_Addon.core.php(348): EE_DMS_People_1_0_0->schema_changes_before_migration() #5 /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/EE_Addon.core.php(305): EE_Addon->initialize_db() #6 [internal function]: EE_Addon->initialize_db_if_no_migrations_required(”) #7 /home/peacespo/www/wp-includes/class-wp-hook.php(298): call_user_func_array(Array, Array) #8 /home/peacespo/www/wp-includes/class-wp-hook.php(323): WP_Hook->apply_filters(”, Array) #9 /home/peacespo/www/wp-includes/plugin.php(453): WP_Hook->do_action(Array) #10 /home/peacespo/www/wp-content/plugins/event-espresso-core-master/core/EE_System.core.php(856): do_action(‘AHEE__EE_System…’) #11 [internal function]: EE_System->perform_activations_upgrades_and_migrations(”) #12 /home/peacespo/www/wp-includes/class-wp-hook.php(298): call_user_func_array(Array, Array) #13 /home/peacespo/www/wp-includes/class-wp-hook.php(323): WP_Hook->apply_filters(”, Array) #14 /home/peacespo/www/wp-includes/plugin.php(453): WP_Hook->do_action(Array) #15 /home/peacespo/www/wp-settings.php(449): do_action(‘init’) #16 /home/peacespo/www/wp-config.php(95): require_once(‘/home/peacespo/…’) #17 /home/peacespo/www/wp-load.php(37): require_once(‘/home/peacespo/…’) #18 /home/peacespo/www/wp-admin/admin.php(31): require_once(‘/home/peacespo/…’) #19 /home/peacespo/www/wp-admin/plugins.php(10): require_once(‘/home/peacespo/…’) #20 {main}
A database error has occurred. Turn on WP_DEBUG for more information.

Best regards

Yvan

March 24, 2017 at 12:25 pm

Hi,
there is a problem when creating tables via the platform event expresso.

Have a look to the SQL of wordpress :
SQL query:

CREATE TABLE dev_esp_people_to_post (
PTP_ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
PER_ID bigint(20) unsigned NOT NULL DEFAULT 0,
OBJ_ID bigint(20) unsigned NOT NULL DEFAULT 0,
OBJ_type varchar(50) NOT NULL DEFAULT ‘Event’,
P2P_Order tinyint(3) NOT NULL DEFAULT 0,
PT_ID bigint(20) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (PTP_ID),
KEY PER_ID (PER_ID),
KEY OBJ_ID (OBJ_ID),
KEY OBJ_type (OBJ_type),
KEY PT_ID (PT_ID)
) ENGINE = InnoDB DEFAULT CHARACTER SET ‘utf8mb4_unicode_ci’

MySQL said: Documentation
#1115 – Unknown character set: ‘‘utf8mb4_unicode_ci’’

As you can see, WordPress gives back a error message with the creation table request. The problem comes on the SQL query with the quote

MySQL said: Documentation
#1115 – Unknown character set: ‘‘utf8mb4_unicode_ci’’

Can you help ?