Skip to content

Instantly share code, notes, and snippets.

View tiagosampaio's full-sized avatar
🎯
Focusing

Tiago Sampaio tiagosampaio

🎯
Focusing
View GitHub Profile
@tiagosampaio
tiagosampaio / Database Fix for AUTO_INCREMENT exceeds max value.md
Created February 15, 2024 15:16 — forked from JesKingDev/Database Fix for AUTO_INCREMENT exceeds max value.md
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 (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (

@tiagosampaio
tiagosampaio / iterm2.md
Created June 25, 2023 15:12 — forked from squarism/iterm2.md
An iTerm2 Cheatsheet

Tabs and Windows

Function Shortcut
New Tab + T
Close Tab or Window + W (same as many mac apps)
Go to Tab + Number Key (ie: ⌘2 is 2nd tab)
Go to Split Pane by Direction + Option + Arrow Key
Cycle iTerm Windows + backtick (true of all mac apps and works with desktops/mission control)
@tiagosampaio
tiagosampaio / README.md
Created March 3, 2021 13:46 — forked from leek/_Magento2_DeleteTestData.md
Magento 2 - Delete All Test Data

These set of scripts are for Magento 2. For Magento 1, see this Gist.

@tiagosampaio
tiagosampaio / starulm.md
Created January 23, 2019 16:11 — forked from DrYazid/starulm.md
StarUml 3.0 full version

StarUML 3.0

  • 1- install staruml. : staruml
  • 2- install node.js : node.js
  • 3- go to ...\AppData\Local\Programs\StarUML\resources
  • 4- open CMD As admin
  • 5- execute