Author: Alari
-
WooCommerce Multilingual translated variations’ quantity out of sync fix
This PHP script may help if WooCommerce Multilingual product variation quantities are getting out of sync. Basically what it does is it deletes old “post_product_variation” relations from icl_translations table and creates new ones (and the ones which were already missing – that’s where the problem is) using pure PHP mysqli connection rather than any WordPress/WooCommerce…
-
MediaWiki, Parsoid and Heroku configuration hints
(MediaWiki 1.31.0) Login “Remember password” checked by default Add to LocalSettings.php: $wgHooks[‘AuthChangeFormFields’][] = function ($requests, $fieldInfo, &$formDescriptor, $action) { $formDescriptor[‘rememberMe’][‘default’] = true; return true; }; See Hooks/AuthChangeFormFields and HTMLForm. However, if you need it because of random session drops then see the next chapter: Session handling / PHP’s default session handler / Session problems $wgSessionsInObjectCache…
-
Fix Jasny File Input in Avant theme and IE / MS Edge
Applies to “Avant – Clean and Responsive Bootstrap 3.3.2 Admin” or Avant 1.4 (c) 2015 as written in readme.txt. Open /HTML/assets/css/styles.css, find the following block: .btn-file > input { position: absolute; top: 0; right: 0; margin: 0; opacity: 0; filter: alpha(opacity=0); transform: translate(-300px, 0) scale(4); -webkit-transform: translate(-300px, 0) scale(4); font-size: 23px; height: 100%; width: 100%;…
-
Using IF condition in SELECT in Active Record SQL scope (for Yii)
Instead of a string value use an array to specify different ‘select’ expressions (just a string will get exploded using comma as delimter and there’ll be an error). NB! New variables defined only in SQL query code (with AS) should be defined also in the Model: // AR variables defined in SQL query code public…