apache: change default not found image
This is globally controlled by apache, or locally controlled by your .htaccess file (which basically changes the local apache configurations on local […]
pgsql: cannot alter character length because of dependant views
SQL error: ERROR: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view rv_warehouseprice […]
best bi software
JasperSoft Pentaho Watson Analytics *** Very Poor (even cancelled the trial) *** Microsoft Power BI AWS Quick Sight *** Still on Trial *** […]
mautic: clear cache from application
root@ubuntu:~# php /var/www/mautic/app/console cache:clear Note that after clearing Cache the App is Stuck because there is a Permissions problem (Mautic cannot write […]
postgresql: table sizes
SELECT *, pg_size_pretty(total_bytes) AS total , pg_size_pretty(index_bytes) AS INDEX , pg_size_pretty(toast_bytes) AS toast , pg_size_pretty(table_bytes) AS TABLE FROM ( SELECT *, total_bytes-index_bytes-COALESCE(toast_bytes,0) […]
mysql: enable logging
mysql> show variables like '%log%'; Recreate the log files I deleted by mistake. It appears the MySQL does not recreate them automatically. […]
prestashop: debug mode and memory upgrade
To turn on debug mode go to: config/defines.inc.php Set define('_PS_MODE_DEV_', false); --> define('_PS_MODE_DEV_', true); To upgrade PHP Memory Limit vim /etc/php5/apache2/php.ini --- Go […]
ubuntu: extract emails from txt file
grep -E -o "[-0-9a-zA-Z.+_]+@[-0-9a-zA-Z.+_]+\.[a-zA-Z]{2,4}" Bounced_Emails.txt > bounced_clean.txt
csv import manual
Remove Commas from strings Truncate String Length using LEFT function in Excel Use CLEAN Function to remove unwanted breaks and non displaying […]
sql query: remove leading and trailing double quotes
UPDATE m_product SET name = TRIM(BOTH '"' FROM name) WHERE m_product_id = '1128493' UPDATE m_product set name = replace(name, '""', '"') WHERE […]