prestashop: brad: elasticsearch: memory limit
Search stopped working, checked logs and received a Memory Exhausted of 512M. Checked php.ini but it was set to 2048M which is […]
prestashop: remove manufacturer list scroll
theme folder -> manufacturer-list.tpl To remove top scrool, around line 70, delete the following: <div class="top-pagination-content clearfix bottom-line"> {include file="$tpl_dir./pagination.tpl" no_follow=1} </div> […]
prestashop: manufacturer page slow
-> Classes-> Manufacturer.php /* $results = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(' SELECT p.`id_manufacturer`, COUNT(DISTINCT p.`id_product`) as nb_products FROM `'._DB_PREFIX_.'product` p USE INDEX (product_manufacturer) '.Shop::addSqlAssociation('product', 'p').' […]
talend: allocate memory
https://community.talend.com/t5/Migration-Configuration-and/Allocating-more-memory-to-Talend-Studio/ta-p/21642 Locate the .ini file inside the Talend installation folder. With 8 GB of memory available on 64-bit system, the optimal […]
openbravo: custom query to find invoice's product account
SELECT c_invoice.documentno, c_invoiceline.linenetamt, --m_product_acct.m_product_id, --m_product_acct.ad_org_id, m_product_acct.p_expense_acct, c_elementvalue.name FROM c_invoice LEFT JOIN c_invoiceline ON c_invoice.c_invoice_id = c_invoiceline.c_invoice_id LEFT JOIN m_product_acct ON c_invoiceline.m_product_id = […]
openbravo: set vendor prepayment accounting in bulk
UPDATE c_bp_vendor_acct SET v_prepayment_acct = '7521C6AF88074CFBA96E3AB7639D2902' WHERE c_acctschema_id = '092273C810444B4086ED18612E3F5833'
talend: random 40 character string
((java.util.UUID.randomUUID()).toString() + (java.util.UUID.randomUUID()).toString()).replace("-","").substring(0,40)
excel: create random 40 character string
=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)&RANDBETWEEN(10,99)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))
java: version
I have java 6 installed, and decided to install java 7. But even after I installed java 7 the system recognized java […]
prestashop: remove undefined from product list
When you switch the view from Manufacturer's Product List you get an undefined Character. To remove this go to /var/www/html/XXXXXXX/themes/default-bootstrap/js/global.js: Comment the […]