New answers tagged database
2
If you have a modern (e.g. Debian 10+) server installed fresh, you should be OK. If not, I believe these are the settings you want in your server config (e.g. /etc/mysql/mariadb.conf.d/50-server.cnf if you're using MariaDB on Debian)
innodb_large_prefix = 1
#https://mariadb.com/kb/en/library/innodb-system-variables/#innodb_file_format
innodb_file_format = ...
1
It's a good question. I haven't come across any problems like this. I see one varchar(512) custom field in utf8mb4 and the longest value it has at the moment is 383 and both the field and index seem fine, but it wasn't converted it's always been utf8mb4. I do have innodb_default_row_format=dynamic which I remember seeing somewhere that's what tables need.
...
0
We are having this same issue. The civicrm_contact_push_notification_messages table has grown to 4GB with 14million records in just 14 days. There is a 'Civimobile clean old push notification messages' scheduled job but it only cleans notifications older than 90 days.
This appears to be causing timeouts on our server due to low resources. Is there any way we ...
0
My solution is very noob, but it works:
1) backup the database first with myphpadmin, it will skip civicrm_acl_contact_cache since its corrupted
2) drop and restore the current db, use old civicrm database sql backup (if you don't have you can also create new civicrm and make new db backup), open the sql file with notepad (I would use notepad++ or open sql ...
3
This is down to the fact that you probably have logging turned on in your Drupal environment. So the easiest thing to do would be to turn it off before you migrate and turn it back on in Wordpress (Administer -> Misc -> Logging). If you cant do that (or it still doesn't work) then you have a couple of 'hacks' to make get to the point that you can at ...
0
Check your privileges on the database, John. I suspect this may be a MySQL issue.
W
Top 50 recent answers are included
