Skip to content

Instantly share code, notes, and snippets.

@icedream

icedream/oxideshop-d3-devmode.sql

Last active March 15, 2017 10:27
Show Gist options
  • Save icedream/6c8365f7964cb66427c9d67ea371f002 to your computer and use it in GitHub Desktop.
Save icedream/6c8365f7964cb66427c9d67ea371f002 to your computer and use it in GitHub Desktop.
Download ZIP
Useful SQL snippets
Raw
oxideshop-d3-devmode.sql
-- Enable developer mode in D3 module connector which disables usage of TMP
UPDATE d3_cfg_mod
SET `OXVALUE` = TO_BASE64(IF(`OXVALUE` = '' OR `OXVALUE` = 'N%3B',
'O%3A8%3A%22stdClass%22%3A1%3A%7Bs%3A29%3A%22d3_cfg_mod__blClrTmp_notmpuse%22%3Bs%3A1%3A%221%22%3B%7D',
REPLACE(FROM_BASE64(`OXVALUE`),
'%22d3_cfg_mod__blClrTmp_notmpuse%22%3Bs%3A1%3A%220',
'%22d3_cfg_mod__blClrTmp_notmpuse%22%3Bs%3A1%3A%221')
))
WHERE `OXMODID` = 'd3modcfg_lib';
Raw
oxideshop-devmode.sql
-- Disable production mode in all shops for local testing
UPDATE oxshops
SET `OXPRODUCTIVE` = '0';
Raw
useful-sql-snippets.md

Useful SQL snippets

This Gist just contains all sorts of useful SQL snippets for local testing and/or development.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment