Michal Čihař - Archive for Jan. 1, 2017

Stardicter 1.1, the set of scripts to convert some freely available dictionaries to StarDict format, has been released today. The biggest change is that it will also keep source data together with generated dictionaries. This is good for licensing reasons and will also allow to actually build these as packages within Debian.

Full list of changes:

• Various cleanups for first stable release.
• Fixed generating of README for dictionaries.
• Added support for generating source tarballs.
• Fixed installation on systems with non utf-8 locale.

As usual, you can install from pip, download source or download generated dictionaries from my website. The package should be soon available in Debian as well.

Last week was mostly focused on catching up after two weeks of vacation. That involved quite a lot of things in our issue tracker and cleanup of pending things in pull requests.

Handled issues:

• #13683 Cannot edit blob fields
• #13678 Unexpected 'print' in index.php on line 97
• #13630 Fix error on signon login, need create a cookie with sessionID
• #13560 Change all table collations
• #13682 Added change all table collations when changing database collation
• #13670 Fix edit index field size bug
• #13515 Edit Index field size
• #13687 Adding a column to a table leads to logout
• #13547 Add hhvm 3.21 to test matrix
• #13539 Parameter binding syntax gives error in the SQL editor
• #173 Fix #172 Support parameter binding

Last week was heavily focused on our Selenium tests and improving their speed and reliability. This was pretty much achieved and there seem to be no random failures now.

Handled issues:

• #13659 Attempt to optimize Selenium tests
• #13664 Change password shown behind navigation #13662
• #13657 Use nginx for running Selenium tests
• #13656 Various cleanups in DBI
• #13650 Rewrite forms management to objects
• #13648 Make hash extension required
• #13645 Pagination and Export Issue 4.7.0 & 4.7.4
• #13647 import of table with virtual col (exported with phpMyAdmin) is impossible
• #13380 RFC: Add configuration for Probot Stale
• #13646 Refactor config descriptions
• #13183 Keep Alive Error?
• #13533 "Choose column to display" does not work
• #13638 Notice when browsing IS
• #13632 gitgnore ".github" folder
• #13604 Error when browsing table
• #13637 Warning on invalid metadata from MySQL
• #13639 Notice: Undefined index: statement
• #13640 Notice: Undefined index: querytype
• #13611 Twig introduces ctype dependecy
• #13633 Some elements are not translated directly after changing language
• #13629 Saving diagram fails
• #13635 Designer cannot save page
• #13619 Solved issue #13617
• #13617 Unnecessary data should not come in clipboard copied table
• #169 UNTIL keyword

Last week was pretty productive on bug fixing side. These were quite varied from server monitor breakage on non Linux and Windows platforms to minor rendering issues of date selector. Quite interesting new feature is that our SQL parser now better understands to some MariaDB extensions.

Handled issues:

• #13444 JavaScript error in Status Monitor on FreeBSD server
• #13353 phpmyadmin search size large database not work
• #13500 recaptcha fails
• #13628 TypeError in server monitor
• #13158 Please enter a valid length!
• #13267 Database with dot (.) in name is not shown when DisableIS is set to true
• #13336 Phpmyadmin "Show binary contents as HEX" missing
• #13347 Missing values on modifying fields with CURRENT_TIME default and 'on update CURRENT_TIME()' attribute
• #13620 Update openid.php
• #13516 Adjust subdomains at url.php
• #13556 500 error on opening setup. Globals[dbi] is missing
• #13576 In "user(s) having access to database" table "Action" column is blank
• #13603 Run Selenium tests on pull requests
• #13612 Calender blocked by hint
• #13615 Error when executing query with WITH clause
• #166 MariaDB: INTERSECT and EXCEPT keywords
• #4 Define multiple contexts

Last week was again mostly spent on fixing bugs and going through reports on our error reporting server. This is really valuable tool for finding problems which hit our users, on the other side there is simply too many things there and sometimes it's hard to pinpoint something really important.

Besides that I've also ensured that all our libraries work well with upcoming PHP 7.2 and all are now tested on Travis CI against this version as well.

Handled issues:

• #13606 Clicking "Refresh" on "All status variables" page yields a "Token mismatch" error
• #13605 Minor refactoring in Selenium tests
• #13601 Connecting to Azure MySQL database
• #13597 Fix #13593 : removed whitespace in textarea for column default value
• #13599 Warning on using debug_backtrace
• #13600 Warning on failure during export
• #12791 Warning on creating unknown context
• #13595 ALTER TABLE parser error
• #13594 Fix random selenium failure tests
• #13593 Default value field contains whitespace
• #13590 #13512 Patch
• #13512 Add inde issue

Hosted Weblate provides also free hosting for free software projects. The hosting requests queue has grown too long, so it's time to process it and include new project.

This time, the newly hosted projects include:

• Gadgetbridge - cloudless replacement for your gadget vendors' closed source Android applications.
• SUSI AI Chat - artificial intelligence for personal assistants, robots, help desks and chatbots
• SUSI AI Android app - Susi Android App
• TeamWard Client - personal Android League Of Legends assistant
• User-Agent Switcher - easily override the browser's User-Agent string
• Safe Eyes - protect your eyes from asthenopia
• XCSoar - the open-source glide computer

If you want to support this effort, please donate to Weblate, especially recurring donations are welcome to make this service alive. You can do them on Liberapay or Bountysource.

Since some time we're using siphash algorithm to speed up looking up strings in Weblate. Even though it is used by Python internally, it's not exposed in the standard library so several third party modules appeared in the PyPI. Out of all these siphashc or rather it's Python 3 fork siphashc3 seemed to perform best, so I've started to use that.

However it turned out that none of them is in active maintenance anymore. The original version lacks Python 3 support, while the siphashc3 uses odd versioning which causes problems to some pip versions.

After trying to get fix into siphashc3 without much of success, I've spoken to original author of siphashc and he has agreed to hand over maintainership to me. So it's new home is at https://github.com/WeblateOrg/siphashc and new release is already available on PyPI.

Note: Originally we were using MD5 in Weblate, but siphash has shown to be faster and fits into 64-bits, what makes it easier to store and index in SQL databases as LONGINT.

Last week was a bit less intensive on bug fixes, but I've spent quite a lot of time on improving our localized documentation and fixing various errors there. This is really something what should be automatically checked in Weblate in the long term, but right now it results in build failures in Travis.

Handled issues:

• #13553 fix error in table
• #13568 Setup script message "Show hidden messages (#MSG_COUNT)"
• #13588 Add QBE tests
• #13585 show error message on export page when database is empty

I've spent last week on DebConf, where main motivation to come was to meet with other phpMyAdmin team members. Besides that we've met with Marc, former phpMyAdmin lead.

On the coding side, it was pretty much just reviewing pull requests and some minor fixes.

Handled issues:

• #13583 Add selenium tests for typing and executing SQL query
• #13571 fix issue #13538
• #13537 type decimal length/values 2nd can't be set
• #13538 "No user selected" warning should come, selecting "Export" button without selecting any checkbox again user in "User Accounts" tab
• #134 alpine+lighttpd+php7-fpm does not work.
• #67 Add a page for the contract developer position
• #65 empty box space in screenshots
• #163 INSERT .. (SELECT ...) fails due to parenthesis

Hosted Weblate provides also free hosting for free software projects. The hosting requests queue was over one month long, so it's time to process it and include new project.

This time, the newly hosted projects include:

• ManaPlus - 2D MMORPG client
• Documentation for Tiled - a tile map editor
• OpenRefine - a tool for working with messy data and improving it
• Gradio - an app for finding and listening to internet radio stations
• RedReader - an unofficial open source Reddit client for Android.
• Arctica Framework - a pluggable remote services framework
• Ayatana Indicators - an application indicators framework
• Skolab Groupware - a continuation of Kolab Groupware

If you want to support this effort, please donate to Weblate, especially recurring donations are welcome to make this service alive. You can do them on Liberapay or Bountysource.