Skip to content

Instantly share code, notes, and snippets.

Avatar
👨‍💻

Alfred Bez alfredbez

👨‍💻
View GitHub Profile
@alfredbez
alfredbez / dump-oxid-database.sh
Created Jun 15, 2020
Dumps a oxid database without the views
View dump-oxid-database.sh
# Replace DBUSER & DBNAME before running this
mysqldump \
-uDBUSER \
-p \
DBNAME \
--lock-tables=false \
$(mysql \
-uDBUSER \
-p \
DBNAME \
@alfredbez
alfredbez / Readme.md
Last active May 28, 2020
OXID error: Table 'oxid.oxv_oxshops_0' doesn't exist
View Readme.md

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
alfredbez / README.md
Last active Nov 23, 2016 — forked from Im0rtality/README.md
PHP CLI Debugging in Vagrant using Xdebug and PHPStorm
View README.md

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
View keybase.md

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:

View .vimrc
" 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
alfredbez / pre-commit
Created Apr 24, 2015
Deploy with git, rsync & gulp
View pre-commit
#!/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
alfredbez / typo3.selectStorage.sql
Created Feb 11, 2015
Liefert alle Datensätze, die Dateilinks aus dem Storage 1 (meistens "fileadmin") einbinden
View typo3.selectStorage.sql
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
View print.css
@media print
{
*,
*:before,
*:after
{
background: transparent !important;
box-shadow: none !important;
color: #000000 !important; /* Black prints faster:
http://www.sanbeiji.com/archives/953 */
View MinifyHtml.php
protected function _commentCB($m)
{
return (0 === strpos($m[1], '[') || false !== strpos($m[1], '<![') || false !== strpos($m[1], 'TYPO3SEARCH'))
? $m[0]
: '';
}
View detectCapslock.js
$('body').keypress(function(e) {
var s = String.fromCharCode( e.which );
if ( s.toUpperCase() === s && s.toLowerCase() !== s && !e.shiftKey ) {
console.log('caps is on');
}
});