Support

Home › Forums › Event Espresso Premium › Errors in DB

Errors in DB

Posted: December 27, 2018 at 1:35 pm


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?

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, 3 months ago ago

Topic Tags

Notifications

This topic is: not resolved
Event Espresso