Website running on managed WP unreachable after latest automatic upgrade
-
@guyds When we make a thing is unstable, our managed instances and internal instances are updated first. It then starts rolling out things slowly. I think your app was one of the super early adopters.
@girish said in Website running on managed WP unreachable after latest automatic upgrade:
@guyds When we make a thing is unstable, our managed instances and internal instances are updated first. It then starts rolling out things slowly. I think your app was one of the super early adopters.
Ok, that's a plausible explanation.
@girish said in Website running on managed WP unreachable after latest automatic upgrade:
@guyds thanks for testing! Do you think you can send me the log file to support@cloudron.io ? (I really just want the full RENAME line which is getting truncated here. Maybe you can just paste that fully here?) You can do this by Downloading the log file and getting that line.
I downloaded the full logfile but even then the RENAME command is truncated:
2022-03-15T19:35:24.000Z ==> Migrating database tables to have a prefix 2022-03-15T19:35:24.000Z ==> Renaming using RENAME TABLE `banhammer` TO `wp_banhammer`,`commentmeta` TO `wp_commentmeta`,`comments` TO `wp_comments`,`frmt_form_entry` TO `wp_frmt_form_entry`,`frmt_form_entry_meta` TO `wp_frmt_form_entry_meta`,`frmt_form_views` TO `wp_frmt_form_views`,`icwp_wpsf_audit_trail` TO `wp_icwp_wpsf_audit_trail`,`icwp_wpsf_events` TO `wp_icwp_wpsf_events`,`icwp_wpsf_geoip` TO `wp_icwp_wpsf_geoip`,`icwp_wpsf_ip_lists` TO `wp_icwp_wpsf_ip_lists`,`icwp_wpsf_notes` TO `wp_icwp_wpsf_notes`,`icwp_wpsf_reports` TO `wp_icwp_wpsf_reports`,`icwp_wpsf_sessions` TO `wp_icwp_wpsf_sessions`,`icwp_wpsf_traffic` TO `wp_icwp_wpsf_traffic`,`itsec_bans` TO `wp_itsec_bans`,`itsec_distributed_storage` TO `wp_itsec_distributed_storage`,`itsec_fingerprints` TO `wp_itsec_fingerprints`,`itsec_geolocation_cache` TO `wp_itsec_geolocation_cache`,`itsec_lockouts` TO `wp_itsec_lockouts`,`itsec_logs` TO `wp_itsec_logs`,`itsec_mutexes` TO `wp_itsec_mutexes`,`itsec_opaque_tokens` TO `wp_itsec_opaque_tokens`,`itsec_temp` TO `wp_itsec_temp`,`itsec_user_groups` TO `wp_itsec_u 2022-03-15T19:35:24.000Z ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`wp_itsec_u' at line 1I created a support ticket.
-
The issue here was the GROUP_CONCAT has a default length of 1024 or so. Setting session variable
SET group_concat_max_len=10000fixes the issue. -
The issue here was the GROUP_CONCAT has a default length of 1024 or so. Setting session variable
SET group_concat_max_len=10000fixes the issue. -
@girish I had the same problem today following a Worpress update. I think the problem comes from the Civicrm plugin which has many tables. I restored with the last backup and disabled the automatic update, but that's not a solution.
-
@girish I had the same problem today following a Worpress update. I think the problem comes from the Civicrm plugin which has many tables. I restored with the last backup and disabled the automatic update, but that's not a solution.
-
It seems civicrm does not use WP's
table_prefixat all. Well, I pushed a new package which simply ignore civicrm tables.@girish Ignoring the civicrm tables works.
However, I have the same kind of problem with an integration of MRBS in Wordpress for authentication. As the tables were properly renamed during the update, I simply set the ad hoc variable (
$db_tbl_prefix = "wp_mrbs_";) in the configuration file and it works.But I guess there are other use cases where renaming tables causes problems.
-
@girish Ignoring the civicrm tables works.
However, I have the same kind of problem with an integration of MRBS in Wordpress for authentication. As the tables were properly renamed during the update, I simply set the ad hoc variable (
$db_tbl_prefix = "wp_mrbs_";) in the configuration file and it works.But I guess there are other use cases where renaming tables causes problems.
@jeau Good to know, thanks!
We have to do this migration since WordPress it says it doesn't support not having a table prefix. See:
-
@jeau Good to know, thanks!
We have to do this migration since WordPress it says it doesn't support not having a table prefix. See:
