Entries tagged as
Mac mini server Mavericks OS X network MySQL Yosemite Naju Celine Chung coaxial cable EyeTV Gwangju television cooler electric fan USB El Capitan iOS 9 macOS repair Sierra AirPod apple Mac Studio monitor tag Twitter search s9y High Sierra Big Sur battery remote controlled helicopter replacement Syma S107G A1522 A1524 iPhone 6 Plus screen Screen Glue screen protector Touch ID camera cleaning bus Tayo toy Burger King clock desk office melodica car headlights lamp Sonata 2 iPhone 5 bicycle bottle holder epoxy umbrella computer laptop iPhone 5S iPhone SE Bluetooth iPhone 6S Plus remote control electricity LG Prada 3.0 Seojun Electric smart meter adapter Apple Watch belt case cable charger GPS lightning Micro-USB pen Gangneung Starbucks LED HDD keyboard Xbox cellphone JooN 2 power plug watch Europe Japan Korea O2E Smart Multi-Charger UK USA iOS Hayun Chung tester USB-C Native Union card reader hub MacBook Air memory storage iOS 13 iPhone 11 Pro MicroSD mouse Hancom Office NEO Microsoft Office 365 Windows 10 iOS 15 LG Cube XD7 MQ01ABD100 Toshiba external case Leto L2SU 2TB WD20NPVX Western Digital Acasis DT-S2 Samsung scale SSD Seagate Christmas tree decoration balls lights sled snow screwdriver table cookie milk Oreo Homeplus pizza chocolate chip cookies couch FaceTime New Year's Day rice cake Skype Sung-Eun Kim tteokguk swing Toys R Us trampoline Mega Kids Box Megabox movie theatre Wesley Woo-Duk Hwang-Chung tortilla wrap toothbrush salad Disney Frozen Danish butter cookies animation Larva shopping cart coronavirus cafeteria KPX Bitgaram City Hanaro mask Nonghyup shopping construction school sanitizer infrared thermal imaging elevator clinic restaurant supermarket toilet building convenience store library beverage coffee shop green tea latte Daejeon exposition museum National Science travel station hospital vaccine face poster ball bed globe headphones pink breakfast rice porridge Lunar New Year traditional Korean dress Hyung-Bae Kim kite sausage Cloud Cuckoo Palace Princess Unikitty The Lego Movie Evil Robot playground slide Bulacan Philippines volunteering golf elementary fire middle police post office Ozobot programming KBS news concert MITs-M4300 performance Swing Live Fest SBS EBS KTV emergency summer baseball game home run election rain satellite TV shower water crypto currency electronics kit Seoul Yongsan hockey ice ice rink Olympic and Paralympic Games MacBook Pro iOS 12 iPad Pro 9.7 iPhone X iPhone XS Bolt EV CarPlay electric iOS 14 iPhone 7 Apple TV 4th Gen Smart Cover stand A1533 AT&T A1530 LTE SK Telecom slow motion fingerprint sensor M7 pedometer 3DMark Cortex Camera Geekbench iPhone 3GS iPhone 4S Kraken Octane SunSpider accelerometer compass gyroscope astronomy ISS Moon satellite sound Han-gang river passcode Canon SX50 HS iPhone 5C flare Iridium Alhena constellation Jupiter Orion Apple Store Osaka iOS 10 A1779 earphone iPhone 6 box iPhone 4 iPhone 6+ dock iPad mini speaker iPhone 7 Plus Apple TV 4K iOS 16 iPhone 13 Pro AirTag Fukuoka Fukuoka Airport Incheon International Airport subway Canal City Hakata Hakata Shinpu Japanese food ramen Ramen Stadium A1549 A1586 KT LGU+ butadon park tower boat Busan hydrofoil zoo iPad IPTV SK Broadband Apple Arcade Apple Music Apple TV+ embassy passport visa COEX Samseong skyline smog relocation cabinet Gangnam Hyundai Sonata 2 Kodak DC280 Suwon Yeongdeungpo Yeongtong McMuffin meal box pancakes Hyundai KEPCO Parnas Seolleung airplane airport Gimpo Lotte World Seoul National University train mall
I skipped upgrading the iMac server’s OS to macOS 10.15 Catalina last year mainly due to the removal of 32-bit application support. After a year, the clean-up of obsolete apps was complete, paving the way for the upgrade.
During the preparation, there was a bit of a hiccup with the MySQL database, But putting the data to a new one largely solved the issue and the website ended up loading much quicker. Two minor errors occurred after moving to the new database, which were quickly resolved by editing the configuration file:
1. "Query failed: Out of sort memory, consider increasing server sort buffer size"
Solution: increase sort_buffer_size from the default of 262144
2. "Query failed: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'blog.multilingual_body.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"
Solution: remove only_full_group_by in sql_mode
sql_mode=STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION
With all the pieces ready I went with the installation of macOS 11.0 Big Sur. It took about an hour and except for a prolonged setup time of the iCloud, things went smoothly.