Skip to content

Instantly share code, notes, and snippets.

View DavidBruchmann's full-sized avatar
💭
It's all about compatibility

David Bruchmann DavidBruchmann

💭
It's all about compatibility
  • Webdevelopment Barlian
  • Bandung, West Java, Indonesia
View GitHub Profile
@alexsegura
alexsegura / gist:9895452
Created March 31, 2014 15:52
Get MySQL error code with Doctrine DBAL
<?php
$sql = '...';
$stmt = $conn->prepare($sql);
try {
$stmt->execute();
} catch (\Doctrine\DBAL\DBALException $e) {
$previous = $e->getPrevious();
@rvollebregt
rvollebregt / debug-sql
Last active September 8, 2021 14:34
Debug SQL query in TYPO3 8 Extbase
/** @var ObjectManager $objm */
$dbParser = $this->objectManager->get(Typo3DbQueryParser::class);
$sql = $dbParser->convertQueryToDoctrineQueryBuilder($query)->getSQL();
DebuggerUtility::var_dump($sql);
@einpraegsam
einpraegsam / Update.sql
Created January 22, 2018 10:42
Update TYPO3 Powermail from 2.x to 5.x or a newer version
# Just copy all tables from plural to singular naming
create table tx_powermail_domain_model_form LIKE tx_powermail_domain_model_forms;
insert tx_powermail_domain_model_form select * from tx_powermail_domain_model_forms;
create table tx_powermail_domain_model_page LIKE tx_powermail_domain_model_pages;
insert tx_powermail_domain_model_page select * from tx_powermail_domain_model_pages;
create table tx_powermail_domain_model_field LIKE tx_powermail_domain_model_fields;
insert tx_powermail_domain_model_field select * from tx_powermail_domain_model_fields;
@h3nn3s
h3nn3s / ConvertApplicationAreaValuesToBinaryDataProcessor.php
Created January 30, 2018 11:00
TYPO3 powermail DataProcessor: Convert checkbox positions to there decimal represenation
<?php
namespace HenrikZiegenhain\MyExt\DataProcessor;
/***************************************************************
* Copyright notice
*
* (c) 2018 Henrik Ziegenhain <henrik@ziegenhain.me>
* All rights reserved
*
* This script is part of the TYPO3 project. The TYPO3 project is