Skip to content

Instantly share code, notes, and snippets.

View JesKingDev's full-sized avatar

Jessica King JesKingDev

5 followers · 5 following
View GitHub Profile
@JesKingDev
JesKingDev / Database Fix for AUTO_INCREMENT exceeds max value.md
Last active February 15, 2024 15:16
Data fix for the scenarios where gaps in a table's auto_increment result in the next value exceeding the max size of an INT. Specifically helps address the Magento Issue - AUTO_INCREMENT grows on every INSERT ... ON DUPLICATE on InnoDB tables #28387 ttps://github.com/magento/magento2/issues/28387

AUTO_INCREMENT grows on every INSERT ... ON DUPLICATE on InnoDB tables #28387

magento/magento2#28387

Symptom:

General system exception happened. SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'value_id' at row 1, query was: INSERT INTO catalog_product_entity_varchar (row_id,attribute_id,store_id,value) VALUES (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (

@JesKingDev
JesKingDev / Start GlobalProtect Service.sh
Last active April 2, 2021 13:10
RT https://joshcurry.co.uk/posts/how-to-quit-globalprotect-mac/ If you've used the globalprotect client for Mac, you may notice that there is no way to exit it, meaning it can continue submitting information about your system to your company in the background, including your current patches, interface information and much much more, even at time…
launchctl load /Library/LaunchAgents/com.paloaltonetworks.gp.pangp*
@JesKingDev
JesKingDev / Stop GlobalProtect Service.sh
Last active April 2, 2021 13:10
RT https://joshcurry.co.uk/posts/how-to-quit-globalprotect-mac/ If you've used the globalprotect client for Mac, you may notice that there is no way to exit it, meaning it can continue submitting information about your system to your company in the background, including your current patches, interface information and much much more, even at time…
launchctl unload /Library/LaunchAgents/com.paloaltonetworks.gp.pangp*