Entries tagged as repair
battery A1533 charger iPhone 5S Celine Chung remote controlled helicopter replacement Syma S107G A1524 belt case iPhone 6 Plus BEXCO Busan exposition house laser pointer pen porcelains travel Apple Watch watch water resistance barcode camera Nintendo Wii Oband T2 remote control running screen swimming watchOS 2 adapter cable iOS lightning Micro-USB USB Geekbench iPhone 3GS iPhone 4 iPhone 4S iPhone 5 iPhone 6S Plus PeaceKeeper Bluetooth Christmas tree decoration balls lights sled snow Hayun Chung screwdriver table cookie milk Oreo Homeplus pizza chocolate chip cookies couch FaceTime New Year's Day rice cake Skype Sung-Eun Kim tteokguk computer 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 car Larva shopping cart SR626SW band A1522 A1549 A1586 AT&T Canada Hong Kong iPhone 6 Japan Korea LTE T-Mobile USA Verizon iPhone 5C SK Telecom A1530 KT LGU+ VoIP VoLTE barometer Focus Pixels iOS 8 iPad iPad mini Reachability screen protector Apple Store Screen Glue Ferris wheel game Goat Simulator iPhone 6+ Touch ID COEX Fukuoka Fukuoka Airport Incheon International Airport subway leather case Vega LTE-A 3DMark Kraken Octane performance SunSpider 3D Touch A1687 A1779 earphone iPhone 7 Series 2 IoT refrigerator Samsung iPhone SE CGV Gwangju hot dog popcorn snack Galaxy Fold Galaxy S20 Ultra Galaxy Z Flip glass iPhone X cat Concierge EyeFly3D Galaxy S4 Zoom MicroSD fingerprint sensor box astronomy Moon Sanyo VPC-C4 satellite Minolta Dimage X20 binoculars Chuseok telescope eclipse Kodak Z1085 IS star Sun slow motion sound electric fan LED light trail M&M's OIS Cortex Camera cleaning window drain laundry washing machine bathroom fan tile Bolt EV electric vacuum cleaner kitchen stainless steel straw coronavirus infrared thermal imaging KPX office bus double decker London strike Underground fog Naju Tayo toy Bitgaram City train airport school BRT government complex Osong Station Sejong building construction boat Hakata hydrofoil lake park seaport Dazaifu museum temple udon cathedral flower garden SRT Gangneung hockey Lego The Lego Movie dinosaur InoQ Tyrannosaurus 3D printing hot-end Makibox squirrel bunny HT-Mini v2 balloon Jenga 123D Design Autodesk coin Electric Love Marathon heart Christmas Octonauts play set present apple tree Financial Museum Kwangju Bank vegetable Pop Up Pirate Anna Elsa princess Jeonnam Science Festival s9y server search iMac Mac mini Mavericks OS X network tag Twitter MySQL Yosemite macOS Sierra High Sierra Big Sur Burger King About Time premium ticket Creamy Pepper Burger Gravity IMAX Interstellar movie Lotteria restaurant chicken donut chicken tender spicy chicken fries hamburger Shrimp Steak Burger Captain Spicy clock desk ice cream cheese chicken nugget Whopper fries shrimp bread breakfast crab New Orleans wasabi diavola Monster X BBQ beef Bitcoin British Museum money fish chair assembly kit Education Center paint bed LAN printer planting blueberry yoghurt hotel mask sanitizer melodica coaxial cable EyeTV television cooler El Capitan iOS 9 Comic Life expressway traffic jam commute car wash engine oil gas station blizzard Tamiya wheel headlights lamp Sonata 2 KIXX PAO KEPCO smart meter smart plug solar panel BIXPO Daepoong DE101 drone ESS car inspection BuyBeam BL-628 power switch engine cover Hyundai card reader hub MacBook Air memory storage HDD Western Digital external case Seagate iOS 12 iOS 14 iPad Pro 9.7 A1633 A1634 A1688 iPhone 6S bicycle car-free street festival flea market Taekwondo Yeongtong BM Works Slim3 Zip smartphone mount playground flashlight air pump bell foot pump bottle holder Coriolis Daejeon National Science virtual reality road epoxy umbrella keyboard monitor Xbox blue screen of death CHKDSK error 0x00000024 laptop Ozobot programming cellphone pager telephone 850X MSI RevuAhn SSD U200X M7 pedometer accelerometer compass gyroscope ISS Han-gang river Seoul passcode Canon SX50 HS flare Iridium Alhena constellation Jupiter Orion
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.