Support

Home › Forums › Event Espresso Premium › Errors in DB

Errors in DB

Posted: December 27, 2018 at 1:35 pm

Viewing 6 reply threads


ktapp

December 27, 2018 at 1:35 pm

I have been developing my new site and trying to install EE4 on the site. I have the everything license. In local development when I activate it throws errors. As well when I took the site live yesterday I attempted to install and activate EE4 and again errors and had to manually remove the plugin. I do have a copy of the errors. Any help getting EE4 working again.


Josh

  • Support Staff

    •

December 27, 2018 at 1:40 pm

Hi,

May I ask what were the database errors about?


ktapp

December 27, 2018 at 1:42 pm

This is what I get.

WordPress database error: [Table ‘pennyroyal.wp_esp_question_group’ doesn’t exist]
SELECT QSG_system FROM wp_esp_question_group WHERE QSG_system != 0

WordPress database error: [Table ‘pennyroyal.wp_esp_question_group’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_esp_question_group

WordPress database error: [Table ‘pennyroyal.wp_esp_question_group’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_esp_question_group

WordPress database error: [Table ‘pennyroyal.wp_esp_question’ doesn’t exist]
SELECT QST_system FROM wp_esp_question WHERE QST_system != ”

WordPress database error: [Table ‘pennyroyal.wp_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_esp_question

WordPress database error: [Table ‘pennyroyal.wp_esp_question_group_question’ doesn’t exist]
INSERT INTO wp_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 1)

WordPress database error: [Table ‘pennyroyal.wp_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_esp_question

WordPress database error: [Table ‘pennyroyal.wp_esp_question_group_question’ doesn’t exist]
INSERT INTO wp_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 2)

WordPress database error: [Table ‘pennyroyal.wp_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_esp_question

WordPress database error: [Table ‘pennyroyal.wp_esp_question_group_question’ doesn’t exist]
INSERT INTO wp_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 3)

WordPress database error: [Table ‘pennyroyal.wp_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_esp_question

WordPress database error: [Table ‘pennyroyal.wp_esp_question_group_question’ doesn’t exist]
INSERT INTO wp_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 4)

WordPress database error: [Table ‘pennyroyal.wp_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_esp_question

WordPress database error: [Table ‘pennyroyal.wp_esp_question_group_question’ doesn’t exist]
INSERT INTO wp_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 5)

WordPress database error: [Table ‘pennyroyal.wp_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_esp_question

WordPress database error: [Table ‘pennyroyal.wp_esp_question_group_question’ doesn’t exist]
INSERT INTO wp_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 6)

WordPress database error: [Table ‘pennyroyal.wp_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_esp_question

WordPress database error: [Table ‘pennyroyal.wp_esp_question_group_question’ doesn’t exist]
INSERT INTO wp_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 7)

WordPress database error: [Table ‘pennyroyal.wp_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_esp_question

WordPress database error: [Table ‘pennyroyal.wp_esp_question_group_question’ doesn’t exist]
INSERT INTO wp_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 8)

WordPress database error: [Table ‘pennyroyal.wp_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_esp_question

WordPress database error: [Table ‘pennyroyal.wp_esp_question_group_question’ doesn’t exist]
INSERT INTO wp_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 9)

WordPress database error: [Table ‘pennyroyal.wp_esp_question’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_esp_question

WordPress database error: [Table ‘pennyroyal.wp_esp_question_group_question’ doesn’t exist]
INSERT INTO wp_esp_question_group_question (QSG_ID, QST_ID, QGQ_order) VALUES (0, 0, 10)

( ! ) Notice: WPDB Error “Table ‘pennyroyal.wp_esp_payment_method’ doesn’t exist” while running wpdb method “get_var” with arguments [“SELECT COUNT(Payment_Method.PMD_ID) FROM wp_esp_payment_method AS Payment_Method WHERE Payment_Method.PMD_scope LIKE ‘{de4e0fbce627c9efd83bfbb77498b203db385998b5685d3a1b2815d627264d73}CART{de4e0fbce627c9efd83bfbb77498b203db385998b5685d3a1b2815d627264d73}'”]. Automatically attempting to fix EE Core DB in C:\wamp64\www\wp-content\plugins\event-espresso-core-reg\core\db_models\EEM_Base.model.php on line 2377
Call Stack
# Time Memory Function Location
1 0.0001 409512 {main}( ) …\plugins.php:0
2 0.0002 410184 require_once( ‘C:\wamp64\www\wp-admin\admin.php’ ) …\plugins.php:10
3 0.0002 410664 require_once( ‘C:\wamp64\www\wp-load.php’ ) …\admin.php:31
4 0.0003 411400 require_once( ‘C:\wamp64\www\wp-config.php’ ) …\wp-load.php:37
5 0.0003 418432 require_once( ‘C:\wamp64\www\wp-settings.php’ ) …\wp-config.php:91
6 0.6315 12496184 do_action( ) …\wp-settings.php:467
7 0.6315 12496560 WP_Hook->do_action( ) …\plugin.php:453
8 0.6315 12496560 WP_Hook->apply_filters( ) …\class-wp-hook.php:310
9 2.2998 14935688 EE_System->perform_activations_upgrades_and_migrations( ) …\class-wp-hook.php:286
10 2.2998 14935688 do_action( ) …\EE_System.core.php:1102
11 2.2998 14936064 WP_Hook->do_action( ) …\plugin.php:453
12 2.2998 14936064 WP_Hook->apply_filters( ) …\class-wp-hook.php:310
13 2.2999 14937080 EE_System->initialize_db_if_no_migrations_required( ) …\class-wp-hook.php:286
14 2.3616 15576848 EEH_Activation::initialize_db_content( ) …\EE_System.core.php:565
15 2.4262 16146840 EEH_Activation::insert_default_payment_methods( ) …\EEH_Activation.helper.php:143
16 2.4262 16146840 EEM_Payment_Method->count_active( ) …\EEH_Activation.helper.php:1136
17 2.4262 16148000 EEM_Payment_Method->count( ) …\EEM_Payment_Method.model.php:144
18 2.4279 16152592 EEM_Payment_Method->_do_wpdb_query( ) …\EEM_Base.model.php:2239
19 2.4279 16152592 EEM_Payment_Method->_process_wpdb_query( ) …\EEM_Base.model.php:2306
20 2.4996 16689632 trigger_error ( ) …\EEM_Base.model.php:2377

( ! ) Notice: WPDB AGAIN: Error “Table ‘pennyroyal.wp_esp_payment_method’ doesn’t exist” while running the same method and arguments as before. Automatically attempting to fix EE Addons DB in C:\wamp64\www\wp-content\plugins\event-espresso-core-reg\core\db_models\EEM_Base.model.php on line 2377
Call Stack
# Time Memory Function Location
1 0.0001 409512 {main}( ) …\plugins.php:0
2 0.0002 410184 require_once( ‘C:\wamp64\www\wp-admin\admin.php’ ) …\plugins.php:10
3 0.0002 410664 require_once( ‘C:\wamp64\www\wp-load.php’ ) …\admin.php:31
4 0.0003 411400 require_once( ‘C:\wamp64\www\wp-config.php’ ) …\wp-load.php:37
5 0.0003 418432 require_once( ‘C:\wamp64\www\wp-settings.php’ ) …\wp-config.php:91
6 0.6315 12496184 do_action( ) …\wp-settings.php:467
7 0.6315 12496560 WP_Hook->do_action( ) …\plugin.php:453
8 0.6315 12496560 WP_Hook->apply_filters( ) …\class-wp-hook.php:310
9 2.2998 14935688 EE_System->perform_activations_upgrades_and_migrations( ) …\class-wp-hook.php:286
10 2.2998 14935688 do_action( ) …\EE_System.core.php:1102
11 2.2998 14936064 WP_Hook->do_action( ) …\plugin.php:453
12 2.2998 14936064 WP_Hook->apply_filters( ) …\class-wp-hook.php:310
13 2.2999 14937080 EE_System->initialize_db_if_no_migrations_required( ) …\class-wp-hook.php:286
14 2.3616 15576848 EEH_Activation::initialize_db_content( ) …\EE_System.core.php:565
15 2.4262 16146840 EEH_Activation::insert_default_payment_methods( ) …\EEH_Activation.helper.php:143
16 2.4262 16146840 EEM_Payment_Method->count_active( ) …\EEH_Activation.helper.php:1136
17 2.4262 16148000 EEM_Payment_Method->count( ) …\EEM_Payment_Method.model.php:144
18 2.4279 16152592 EEM_Payment_Method->_do_wpdb_query( ) …\EEM_Base.model.php:2239
19 2.4279 16152592 EEM_Payment_Method->_process_wpdb_query( ) …\EEM_Base.model.php:2306
20 2.5038 16697824 EEM_Payment_Method->_process_wpdb_query( ) …\EEM_Base.model.php:2379
21 2.5050 16683000 trigger_error ( ) …\EEM_Base.model.php:2377

( ! ) Fatal error: Uncaught EE_Error: WPDB Error: “Table ‘pennyroyal.wp_esp_payment_method’ doesn’t exist” in C:\wamp64\www\wp-content\plugins\event-espresso-core-reg\core\db_models\EEM_Base.model.php on line 2311
( ! ) EE_Error: WPDB Error: “Table ‘pennyroyal.wp_esp_payment_method’ doesn’t exist” in C:\wamp64\www\wp-content\plugins\event-espresso-core-reg\core\db_models\EEM_Base.model.php on line 2311
Call Stack
# Time Memory Function Location
1 0.0001 409512 {main}( ) …\plugins.php:0
2 0.0002 410184 require_once( ‘C:\wamp64\www\wp-admin\admin.php’ ) …\plugins.php:10
3 0.0002 410664 require_once( ‘C:\wamp64\www\wp-load.php’ ) …\admin.php:31
4 0.0003 411400 require_once( ‘C:\wamp64\www\wp-config.php’ ) …\wp-load.php:37
5 0.0003 418432 require_once( ‘C:\wamp64\www\wp-settings.php’ ) …\wp-config.php:91
6 0.6315 12496184 do_action( ) …\wp-settings.php:467
7 0.6315 12496560 WP_Hook->do_action( ) …\plugin.php:453
8 0.6315 12496560 WP_Hook->apply_filters( ) …\class-wp-hook.php:310
9 2.2998 14935688 EE_System->perform_activations_upgrades_and_migrations( ) …\class-wp-hook.php:286
10 2.2998 14935688 do_action( ) …\EE_System.core.php:1102
11 2.2998 14936064 WP_Hook->do_action( ) …\plugin.php:453
12 2.2998 14936064 WP_Hook->apply_filters( ) …\class-wp-hook.php:310
13 2.2999 14937080 EE_System->initialize_db_if_no_migrations_required( ) …\class-wp-hook.php:286
14 2.3616 15576848 EEH_Activation::initialize_db_content( ) …\EE_System.core.php:565
15 2.4262 16146840 EEH_Activation::insert_default_payment_methods( ) …\EEH_Activation.helper.php:143
16 2.4262 16146840 EEM_Payment_Method->count_active( ) …\EEH_Activation.helper.php:1136
17 2.4262 16148000 EEM_Payment_Method->count( ) …\EEM_Payment_Method.model.php:144
18 2.4279 16152592 EEM_Payment_Method->_do_wpdb_query( ) …\EEM_Base.model.php:2239


Josh

  • Support Staff

    •

December 27, 2018 at 2:07 pm

The errors indicate that your server is configured to not allow WordPress to create additional database tables. Can you use a tool like PHPmyadmin to check to see if any of those _esp_ tables were added?


ktapp

December 29, 2018 at 12:02 pm

I was able to finally manually export the tables from our old DB into the new one and its working ok. I am currently installing the add-ons and still getting the occasional error but not crashing my site. I noticed that my DB is not creating any InnoDB tables and I can’t figure that out. Still working on it.


ktapp

December 30, 2018 at 11:56 pm

Hey Josh, I was able to update my wp_config.php file and got it working. Thanks


Tony

  • Support Staff

    •

December 31, 2018 at 9:18 am

Hi there,

It will be down to your wamp config but I’m curious to know what you had to change for this to work, can you add any details?
Viewing 6 reply threads

The support post ‘Errors in DB’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3 Documentation for Event Espresso 4

Status: closed

Updated by Tony 5 years, 11 months ago ago

Topic Tags

Notifications

This topic is: not resolved
Event Espresso