Skip to content

Instantly share code, notes, and snippets.

View alfredbez's full-sized avatar
👨‍💻

Alfred Bez alfredbez

👨‍💻
View GitHub Profile
@alfredbez
alfredbez / Intercept.php
Last active December 6, 2022 13:06
Testing stdout output with PHPUnit
<?php
class Intercept extends \php_user_filter
{
public static $cache = '';
public function filter($in, $out, &$consumed, $closing)
{
while ($bucket = stream_bucket_make_writeable($in)) {
self::$cache .= $bucket->data;
$consumed += $bucket->datalen;
@alfredbez
alfredbez / dump-oxid-database.sh
Created June 15, 2020 12:06
Dumps a oxid database without the views
# 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 13:26
OXID error: Table 'oxid.oxv_oxshops_0' doesn't exist

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 November 23, 2016 17:32 — forked from Im0rtality/README.md
PHP CLI Debugging in Vagrant using Xdebug and PHPStorm

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

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:

" 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 April 24, 2015 14:02
Deploy with git, rsync & gulp
#!/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 February 11, 2015 14:08
Liefert alle Datensätze, die Dateilinks aus dem Storage 1 (meistens "fileadmin") einbinden
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
@media print
{
*,
*:before,
*:after
{
background: transparent !important;
box-shadow: none !important;
color: #000000 !important; /* Black prints faster:
http://www.sanbeiji.com/archives/953 */
@alfredbez
alfredbez / MinifyHtml.php
Created February 9, 2015 14:19
Zeile 171 - 176
protected function _commentCB($m)
{
return (0 === strpos($m[1], '[') || false !== strpos($m[1], '<![') || false !== strpos($m[1], 'TYPO3SEARCH'))
? $m[0]
: '';
}