alfredbez

$('body').keypress(function(e) { 
    var s = String.fromCharCode( e.which );
    if ( s.toUpperCase() === s && s.toLowerCase() !== s && !e.shiftKey ) {
        console.log('caps is on');
    }
});

alfredbez

protected function _commentCB($m)
{
    return (0 === strpos($m[1], '[') || false !== strpos($m[1], '<![') || false !== strpos($m[1], 'TYPO3SEARCH'))
        ? $m[0]
        : '';
}

alfredbez

@media print
{
  *,
  *:before,
  *:after
  {
    background: transparent !important;
    box-shadow: none !important;
    color: #000000 !important; /* Black prints faster:
                                  http://www.sanbeiji.com/archives/953 */

alfredbez

SELECT DISTINCT
  t4.title as Seite,
  t4.uid as SeitenID,
  t3.header as Titel,
  t3.uid as InhaltsID
FROM
  sys_file as t1,
  sys_file_reference as t2,
  tt_content as t3,
  pages as t4

alfredbez

#!/bin/sh

### Are any Sass files canged or added?
if git status -s | grep  '^M.\+s[ac]ss$'
then
  gulp --cwd path/to/gulpfile css
fi

### Are any JS files canged or added?
if git status -s | grep  '^M.\+js$'

alfredbez

" This must be first, because it changes other options as side effect
set nocp

""""""""""""""""""""""""""
" pathogen init
""""""""""""""""""""""""""
execute pathogen#infect()
syntax on
filetype plugin indent on

alfredbez

Keybase proof

I hereby claim:

• I am alfredbez on github.
• I am alfredbez (https://keybase.io/alfredbez) on keybase.
• I have a public key whose fingerprint is B99D 5003 3459 26BD 13DB 91E0 10F9 D95A 4DDB 2313

To claim this, I am signing this object:

alfredbez

In host:

1. Go to PHPStorm Settings > Project settings > PHP > Servers
2. Add server with following parameters:
   • Name: vagrant (same as serverName= in debug script)
   • Host, port: set vagrant box IP and port
   • Debugger: Xdebug
   • [v] Use path mappings
   • Map your project root in host to relative dir in guest

• Hit OK

alfredbez

Problem

This error is logged in oxideshop.log:

Base table or view not found: 1146 Table 'oxid.oxv_oxshops_0' doesn't exist at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:42, Doctrine\\DBAL\\Driver\\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'oxid.oxv_oxshops_0' doesn't exist at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'oxid.oxv_oxshops_0' doesn't exist at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)
[stacktrace]
#0 /var/www/html/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php(601): OxidEsales\\EshopCommunity\\Core\\Database\\Adapter\\Doctrine\\Database->convertException(Object(Doctrine\\DBAL\\Exception\\TableNotFoundException))
#1 /var/www/html/vendor/oxid-esales/oxideshop-ee/Core/Model/BaseModel.php(660): OxidEsales\\EshopC

alfredbez

# Replace DBUSER & DBNAME before running this
mysqldump \
  -uDBUSER \
  -p \
  DBNAME \
  --lock-tables=false \
  $(mysql \
    -uDBUSER \
    -p \
    DBNAME \