is it for mysql 8.0.28 or is it a multisite wordpress bug in 5.9

CADENTIC

6/15/23, 10:09 AM

    cusomizedprefixwp_1_posts: Table 'cusomizedDB.cusomizedprefixwp_1_posts' doesn't exist
cusomizedprefixwp_1_comments: Table 'cusomizedDB.cusomizedprefixwp_1_comments' doesn't exist
cusomizedprefixwp_1_links: Table 'cusomizedDB.cusomizedprefixwp_1_links' doesn't exist
cusomizedprefixwp_1_options: Table 'cusomizedDB.cusomizedprefixwp_1_options' doesn't exist
cusomizedprefixwp_1_postmeta: Table 'cusomizedDB.cusomizedprefixwp_1_postmeta' doesn't exist
cusomizedprefixwp_1_terms: Table 'cusomizedDB.cusomizedprefixwp_1_terms' doesn't exist
cusomizedprefixwp_1_term_taxonomy: Table 'cusomizedDB.cusomizedprefixwp_1_term_taxonomy' doesn't exist
cusomizedprefixwp_1_term_relationships: Table 'cusomizedDB.cusomizedprefixwp_1_term_relationships' doesn't exist
cusomizedprefixwp_1_termmeta: Table 'cusomizedDB.cusomizedprefixwp_1_termmeta' doesn't exist
cusomizedprefixwp_1_commentmeta: Table 'cusomizedDB.cusomizedprefixwp_1_commentmeta' doesn't exist

it asked me to repair the table with define('WP_ALLOW_REPAIR', true); but repair and optimizations failed. if you have already encountered this issue or if you have already know the fixes let me know, what did I miss actually? is it for mysql 8.0.28 or is it a multisite wordpress bug in 5.9 both are new released.

thx

0 + 0

wordpress

wordpress-mu

Tero Kilkanen

6/15/23, 6:53 PM

Have you changed the WordPress database table prefix?

CADENTIC

6/15/23, 9:33 PM

of course, that is how we deal with it always. for multisite it requires * (wildcard ) in subdomains and most likely Cloudflare will not manage it within the proxy. that is the problem. they will keep it DNS only. it is basically the firewall issue on Oracle Linux 8 or RHEL 8. table name can be prefixed with anything but max table name's length in MySQL 64 characters. this is how is it.

Tero Kilkanen

6/15/23, 9:35 PM

Subdomains are not related to database table prefix. The error message shows really odd table prefix for the WP table names, so this is why I am asking.

CADENTIC

6/15/23, 9:38 PM

the error message is odd due to the reason the OS is not ubuntu. it's related to SELinux in rhel 8. x and oracle Linux 8. my OS is Oracle Linux 8.

Tero Kilkanen

6/15/23, 9:59 PM

The error message is from MySQL, and there is nothing related to operating system in it.

CADENTIC

6/16/23, 6:54 AM

MySQL supports 64 characters. this is how is it and those tables' names' length was not exceeding that length. BTW: I thought the same way as you think but I found that `php-fpm` processes are not having enough access due to `SELINUX`' it was within `/var/log/audit.log` and after that `grep php-fpm /var/log/audit/audit.log | audit2allow -a` and `grep php-fpm /var/log/audit/audit.log | audit2allow -a -M apache_php_fpm` and during database table creation the PHP is firing ultimately from WordPress installation. but if you have a better solution please share.

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: is it for mysql 8.0.28 or is it a multisite wordpress bug in 5.9

TH: ใช้สำหรับ mysql 8.0.28 หรือเป็นข้อผิดพลาดของ wordpress หลายไซต์ใน 5.9

RO: este pentru mysql 8.0.28 sau este o eroare wordpress multisite în 5.9

RU: это для mysql 8.0.28 или это многосайтовая ошибка wordpress в 5.9

VI: nó dành cho mysql 8.0.28 hay nó là lỗi wordpress nhiều trang trong 5.9

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.