September 28, 2016September 28, 2016php, prestashop 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 […]
September 23, 2016December 24, 2018ubuntu 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
September 16, 2016mysql, postgresql 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 […]
September 16, 2016mysql, postgresql 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 […]
September 8, 2016September 8, 2016idempiere, postgresql idempiere: alter sequence Update M_Product_ID UPDATE ad_sequence SET currentnext = 1026150 WHERE ad_sequence_id = 114 Update Product PriceList UPDATE ad_sequence SET currentnext = 1026138 WHERE ad_sequence_id […]