|
ltdan
|
October 4, 2021 at 1:40 am
I moved the website from one host to another. I uploaded my site and had to deactivate all my plugins to get it to load. When I activate EE4 it causes a gateway timeout and crashes the website. all other plugins are deactivated.
|
|
ltdan
|
October 4, 2021 at 1:41 am
website https://ldconsultingllc.com
|
|
ltdan
|
October 4, 2021 at 1:52 am
also https://leaig.org both sites won’t let me into the admin section at all until i deactivate EE4
|
|
Tony
|
October 4, 2021 at 5:26 am
Hi there,
How did you move the site?
If you check the servers error log, what error is being thrown when EE4 is active?
|
|
ltdan
|
October 4, 2021 at 9:41 am
I used all-in-one wp migration
|
|
ltdan
|
October 4, 2021 at 9:41 am
[Mon Oct 04 07:52:01.051755 2021] [proxy_fcgi:error] [pid 1309:tid 139862631958272] (70007)The timeout specified has expired: [client 144.202.65.108:47078] AH01075: Error dispatching request to : (polling) [Mon Oct 04 07:52:01.151200 2021] [proxy_fcgi:error] [pid 1310:tid 139862741063424] (70007)The timeout specified has expired: [client 144.202.65.108:47080] AH01075: Error dispatching request to : (polling) [Mon Oct 04 07:52:03.123767 2021] [proxy_fcgi:error] [pid 1669:tid 139862623565568] (70007)The timeout specified has expired: [client 68.2.33.114:59535] AH01075: Error dispatching request to : (polling), referer: https://ldconsultingllc.com/ [Mon Oct 04 07:53:02.501766 2021] [proxy_fcgi:error] [pid 1309:tid 139862732670720] (70007)The timeout specified has expired: [client 144.202.65.108:47082] AH01075: Error dispatching request to : (polling) [Mon Oct 04 07:53:02.696761 2021] [proxy_fcgi:error] [pid 1669:tid 139862631958272] (70007)The timeout specified has expired: [client 54.36.148.157:17917] AH01075: Error dispatching request to : (polling) [Mon Oct 04 07:53:03.600148 2021] [proxy_fcgi:error] [pid 1309:tid 139862741063424] (70007)The timeout specified has expired: [client 144.202.65.108:47102] AH01075: Error dispatching request to : (polling) [Mon Oct 04 07:53:03.600139 2021] [proxy_fcgi:error] [pid 1309:tid 139862615172864] (70007)The timeout specified has expired: [client 144.202.65.108:47100] AH01075: Error dispatching request to : (polling) [Mon Oct 04 07:54:03.949780 2021] [proxy_fcgi:error] [pid 1309:tid 139862640350976] (70007)The timeout specified has expired: [client 144.202.65.108:47104] AH01075: Error dispatching request to : (polling) [Mon Oct 04 07:54:03.949791 2021] [proxy_fcgi:error] [pid 1669:tid 139862766241536] (70007)The timeout specified has expired: [client 144.202.65.108:47110] AH01075: Error dispatching request to : (polling) [Mon Oct 04 07:56:00.601092 2021] [proxy_fcgi:error] [pid 1309:tid 139862699099904] [client 68.2.33.114:59646] AH01071: Got error ‘PHP message: WordPress database error ALTER command denied to user ‘ldcadmin_ldcmtb’@’localhost’ for table ‘wp_cli_cookie_scan_cookies’ for query ALTER TABLE wp_cli_cookie_scan_cookies ADD CONSTRAINT FOREIGN KEY (category_id) REFERENCES wp_cli_cookie_scan_categories (id_cli_cookie_category) made by activate_plugins, activate_plugin, do_action(‘activate_cookie-law-info/cookie-law-info.php’), WP_Hook->do_action, WP_Hook->apply_filters, Cookie_Law_Info_Cookie_Scaner->activator, Cookie_Law_Info_Cookie_Scaner->install_tables, Cookie_Law_Info_Cookie_Scaner->update_tables’, referer: https://ldconsultingllc.com/wp-admin/plugins.php?plugin_status=all&paged=1&s
|
|
Tony
|
October 4, 2021 at 1:50 pm
Ok, so those errors don’t list anything from Event Espresso.
These:
[Mon Oct 04 07:52:01.051755 2021] [proxy_fcgi:error] [pid 1309:tid 139862631958272] (70007)The timeout specified has expired:
Mean the request too longer than the specific server timeout, likely within apache. The default is normally 60 and that should be fine, but apparently something is taking a lot longer than that on your site.
Which leads onto the error included:
[proxy_fcgi:error] [pid 1309:tid 139862699099904] [client 68.2.33.114:59646] AH01071: Got error ‘PHP message: WordPress database error ALTER command denied to user
That’s from the cookie law plugin you have active on the site but the fact that you are getting ‘user denied’ when it is trying to update the database tables points to a permissions issue with the site. The code in question is trying to update the database, but the credentials used don’t have permission to do so by the looks of it.
As mentioned, that’s not from Event Espresso but EE will also need to update the database and may well be running into the same issue. I recommend you create a ticket with your host and give them the above error to investigate further.
|
|
ltdan
|
October 4, 2021 at 3:24 pm
i cleared my log and tried it again.
21:08:13.738293 2021] [proxy_fcgi:error] [pid 1649:tid 140616792979200] (70007)The timeout specified has expired: [client 72.216.188.13:49274] AH01075: Error dispatching request to : (polling) [Mon Oct 04 21:08:13.749760 2021] [proxy_fcgi:error] [pid 1649:tid 140616818157312] (70007)The timeout specified has expired: [client 144.202.65.108:53936] AH01075: Error dispatching request to : (polling) [Mon Oct 04 21:08:39.344397 2021] [proxy_fcgi:error] [pid 1339:tid 140616960833280] [client 68.2.33.114:65352] AH01071: Got error ‘PHP message: PHP Warning: in_array() expects parameter 2 to be array, bool given in /home/ldcadmin/public_html/wp-admin/includes/plugin.php on line 658’, referer: https://ldconsultingllc.com/wp-admin/plugins.php [Mon Oct 04 21:18:59.115548 2021] [proxy_fcgi:error] [pid 1339:tid 140616801371904] [client 68.2.33.114:49230] AH01071: Got error ‘PHP message: WordPress database error ALTER command denied to user ‘ldcadmin_ldcmtb’@’localhost’ for table ‘wp_esp_line_item’ for query ALTER TABLE wp_esp_line_item ALTER COLUMN LIN_timestamp SET DEFAULT ‘2021-10-04 21:18:58’ made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, EE_System->perform_activations_upgrades_and_migrations, do_action(‘AHEE__EE_System__perform_activations_upgrades_and_migrations’), WP_Hook->do_action, WP_Hook->apply_filters, EE_System->initialize_db_if_no_migrations_required, EEH_Activation::initialize_db_and_folders, EEH_Activation::create_database_tables, EE_DMS_Core_4_10_0->schema_changes_before_migration, EE_Data_Migration_Script_Base->_table_has_not_changed_since_previous, EE_Data_Migration_Script_Base->_create_table_and_catch_errors, EEH_Activation::create_table, EventEspresso\\core\\services\\database\\TableManager->createT…’, referer: https://ldconsultingllc.com/wp-admin/plugins.php [Mon Oct 04 21:19:59.223126 2021] [proxy_fcgi:error] [pid 1339:tid 140616801371904] (70007)The timeout specified has expired: [client 68.2.33.114:49230] AH01075: Error dispatching request to : (polling), referer: https://ldconsultingllc.com/wp-admin/plugins.php [Mon Oct 04 21:19:59.900250 2021] [proxy_fcgi:error] [pid 1649:tid 140616801371904] (70007)The timeout specified has expired: [client 144.202.65.108:54072] AH01075: Error dispatching request to : (polling) [Mon Oct 04 21:20:00.533565 2021] [proxy_fcgi:error] [pid 1649:tid 140616868513536] (70007)The timeout specified has expired: [client 144.202.65.108:54076] AH01075: Error dispatching request to : (polling) [Mon Oct 04 21:20:00.533576 2021] [proxy_fcgi:error] [pid 1340:tid 140616868513536] (70007)The timeout specified has expired: [client 144.202.65.108:54078] AH01075: Error dispatching request to : (polling) [Mon Oct 04 21:20:00.657311 2021] [proxy_fcgi:error] [pid 1340:tid 140616876906240] (70007)The timeout specified has expired: [client 144.202.65.108:54080] AH01075: Error dispatching request to : (polling)
|
|
ltdan
|
October 4, 2021 at 3:30 pm
i added alter to the permissions but I got the same error
|
|
ltdan
|
October 4, 2021 at 3:31 pm
could it be a permissions issue on your end because the IP address changed? It is still the same website but at a new IP address. 144.202.65.108
|
|
ltdan
|
October 4, 2021 at 3:32 pm
i also turned off the cookie law
|
|
ltdan
|
October 4, 2021 at 3:41 pm
so I restored our other site leiag.org and it has event espresso and it restored fine and does not have any issues
|
|
Tony
|
October 5, 2021 at 3:33 am
Same error:
[Mon Oct 04 21:18:59.115548 2021] [proxy_fcgi:error] [pid 1339:tid 140616801371904] [client 68.2.33.114:49230] AH01071: Got error ‘PHP message: WordPress database error ALTER command denied to user ‘ldcadmin_ldcmtb’@’localhost’ for table ‘wp_esp_line_item’ for query ALTER TABLE wp_esp_line_item ALTER COLUMN LIN_timestamp SET DEFAULT ‘2021-10-04 21:18:58’
That’s now happening when EE attempts to update the database and it uses $wpdb to do so which means your server isn’t set up correctly to allow it to update the database.
i added alter to the permissions but I got the same error
The user can’t have the correct permissions to alter the database if you getting the same error above.
could it be a permissions issue on your end because the IP address changed? It is still the same website but at a new IP address. 144.202.65.108
No, we intentionally don’t limit Event Espresso based on the license key (which would be the only thing on our end connected with your site) so this has nothing to do with EventEspresso.com/your license/our servers etc.
Event Espresso is installed on your site locally and all of the data is managed locally to your site in the database. Event Espresso (and other plugins) are trying to update your database locally but the user set up on that server doesn’t allow it. It’s a server config issue rather than a plugin issue.
i also turned off the cookie law
Ok, but this isn’t a plugin issue. Your plugins (whichever ones are trying update the database) are showing your symptoms of the problem but the underlying issue is your site can’t update its own database.
so I restored our other site leiag.org and it has event espresso and it restored fine and does not have any issues
I get error 403 when I try to view the pages but what do you mean by restored in this context?
What version of Event Espresso is it running?
|
|
ltdan
|
October 5, 2021 at 1:27 pm
i moved two sites to the same server.. ldconsultingllc.com and leiag.org. both use EE4. leiag.org works fine on the server but ldconsultingllc.com gives me the error. the configuration of both on the server is the same. that is why it is confusing to me.
|
|
ltdan
|
October 5, 2021 at 1:28 pm
I used al-in-one-wp-migration for both
|
