Improved SQL expression formatting, updated test plan.

Build #164 finished with FAILURE status: http://ci.in-portal.org/job/in-portal-52x/164/

1. Installation is possible only with PHP v.7 because of "random_int" function, used in added code.

1. Installation is possible only with PHP v.7 because of "random_int" function, used in added code.
2. After installation with PHP v.7.2 new "SecurityHmacKey" and "SecurityEncryptionKey" settings were added normally, but test.php resulting in exception: -
   

Removed test file.

Fixed API difference causing a notice (and non-working cache), when attempting to get several keys at once using get method.

In D340#7001, @erik wrote:

2. When testing, I tried to add more rows to "Regional" grid, and, after 5-6 rows added by standard in-portal grid interface, i got errors.
   

This must be perception issue with that specific icon and fact, that it has own transparent margins that aren't aligned. Below I've attached 2 images to demonstrate the issue:

1. I do not understand where is improvement. I see, that before icon was 1 pixel over checkox. Now it is 1 pixel under checkbox, and I do not see any issue related to row count in "before" case
   

1. Updated demo data of "default" and "simple" themes to make them searchable immediately after installation.
2. Improved trimming logic, when combining content block data to end up in less trailing spaces.
3. Fixed notice during search about missing PageContent field of categories.

Remove unneded changes from grid_blocks.tpl

Fixed Firefox icon alignment issues on large (>10 rows) grids

Changes for all modules

Not reopening, but test plan have issues:

In D351#6952, @alex wrote:

Test plan requested updates:

• cover auto-usage of Memcached on PHP 7+, when Memcache is configured to be used
• cover usage of new caching backend (all public methods via corresponding kApplication facade methods (e.g. MemcachedCacheHandler::add maps to kApplication::addCache and so on)
  
  I'm not able to test any further, because all data set to cache will auto-expire immediately.

Made requested code fixes. TODO - test plan changes.

Test plan requested updates:

Build #161 finished with FAILURE status: http://ci.in-portal.org/job/in-portal-52x/161/

Condition moved one level up.

Added missing phrase translation.

No matter how I try to follow test plan I'm get getting pages used in test:

Test plan not updated to cover searching through large amount of text.

GROUP_CONCAT usage replaced with concatenation on php level.

You're only testing new code, but existing code isn't tested. The test plan should also cover, that shipping limitations are applied correctly.

Improvement for calculations result caching

Also the test plan doesn't cover a glimpse of what's actually being checked in code. To test what you've done you need to manually change values of corresponding setting via ini_set (to cover each if/else created) before calling new code from startup.php to assert that result is desired number of bytes.

Also update test plan to cover cases, when we're searching last word in large text (more then 65 KB).

No, this error is not related to current task changes.

In D243#6845, @erik wrote:

No strlen error in debugger from changed ValidateRange method. 'FirstName' test value detected as invalid in other validation method (ValidateType) and not passed to ValidateRange method.

No strlen error in debugger from changed ValidateRange method. 'FirstName' test value detected as invalid in other validation method (ValidateType) and not passed to ValidateRange method.

Done refactoring.

Fixed bug in recursive call parameter.