phpMyAdmin Planet phpMyAdmin

Google Summer of Code’19 with PhpMyAdmin — “Refactoring and Improving Designer”

I would like to thank Google for enabling students to participate in open source development through GSoC. Also, I am very happy to announce that I’ll be working with phpMyAdmin this summer on the project ‘Refactoring and Improving Designer’.

“ Code refactoring should not be done just because we can.”

When the designer section of phpMyAdmin was initially written, there was no jQuery. But now since it exists and due to the advantages of jQuery over JavaScript and it’s a necessity over here, we could make this section better by making use of jQuery[Refactoring] and also resolve the existing issues[Improving]. Also, this project will be beneficial for both the important stakeholders, i.e. developers and user community.

This project will be beneficial for both the important stakeholders, i.e. developers and user community.

Developers:

• It will simplify HTML document traversing, event handling, animating, Ajax interactions, etc. Also, it is very powerful and easy to use
• Since jQuery has been optimized thus, developers can do the same things in fewer lines of code.

Users:

• Reduced load time
• It will be more secure once we reduce the number of global variables and functions
• Existing issues faced and reported by the users will be resolved

Also, while refactoring we have to follow good coding practices so that a new developer won’t face a problem in understanding the code.

Currently, the designer contains the following 6 JavaScript files:

In this time period, I will be refactoring different JS files for the first 2 phases and will be resolving some issues in the last phases of the GSoC timeline.

Project Schedule

May 6 — May 26, 2019

• Bonding with the community
• Get more familiar with the designer section
• Discuss the approach proposed of both the refactoring and issues, improvise based on the discussion

May 27 — June 2, 2019

• Refactor “history.js”
• Testing

June 3 — June 9, 2019

• Document and verify it with the mentor
• Refactor other small sized files

June 10 — June 16, 2019

• Change things as per review
• Refactor all files other than “move.js”(2.1K+ lines of code)
• Test work on a regular basis

June 17 — June 23, 2019

• Documentation and testing
• Verify work from the mentor
• Complete and submit work for phase-1 evaluation

First Mid evaluation: June 24–28, 2019

June 29 — July 5, 2019

• Update the files based on reviews of mentor
• Start refactoring with “move.js” file

June 6 — June 12, 2019

• Finish refactoring of “move.js”
• Test it properly

July 13 — July 21, 2019

• Verify work
• Refactor and make it more readable
• Finalize whole refactoring work
• Document and test the complete work
• Submit work for phase-1 evaluation

Second Mid evaluation: July 22–26, 2019

July 27 — August 2, 2019

• Discuss and finalize the possible solution of all the issues with mentors

August 3 — August 9, 2019

• Submit PR for : #14945, #13371

August 10 — August 16, 2019

• Submit PR for: #13587, #12286

August 17 — August 26, 2019

• Makeup duration
• Complete all the remaining work
• Document and testing
• Submit final work product

August 26 — Sept 3, 2019

• Mentors Submit Final Evaluations
• Final results of Google Summer of Code 2019 (3rd Sept 2019)

I’ll be updating my weekly progress of the project on this blog.

During week-2, I have created my first PR history.js — improving performance targeted at “gsoc-db-designer” branch. It’s merged after a lot of issues and discussions. Some of the issues were:

• Merge Conflict: It was because I started my work with the master branch and not from the already created “gsoc-db-designer” branch. Variable names were also different in this branch as compared to the master branch.
• ESLint error: While making changes, I made a few changes at places due to which I got this error.

Finally, this PR is merged. In this PR, I have done some improvements like earlier, we were calculating the length of an array each time in a for loop but now we have stored the length of the array outside the loop and use this variable inside the loop. Thus improving the performance of the designer’s history section.

Also, in the same week, I have started and submitted work for the second PR(link to the PR which was closed due to some issues). Here in this PR, I have made some issues at the start and due to which this PR includes the commit messages of the first PR too.

For next week, I have to resolve these things and complete the rest of the work.

Earlier before the GSoC results, I had a conversation with my mentor and I got to know that project (Refactoring and Improving designer) is unlikely to come as a GSoC project this year as there was less number of mentors available during the coding period. Thus I created a PR related to this project so that at least I can push the work which I have planned. Here is a link to that PR( https://github.com/phpmyadmin/phpmyadmin/pull/15165).

Later when GSoC results were out and I got selected to work on this project, I have closed the previous PR and discussed how are we gonna work on this project.

Initially, I suggested — “I am planning to create a single PR for the whole refactoring work in the designer section. Good to go?” But later on discussion with a mentor Maurício Meneghini Fauth, we decided that we can create a separate branch “gsoc-db-designer” at upstream where I can create all my PRs related to the project. Its because we don’t think it(everything in a single PR) is a good idea, as it is very difficult to review such a big pull request. And thus, it is better to open small pull requests that can be merged into the master branch or into a new branch just for this.

So finally after this discussion, I have started my work towards my first PR for my GSoC work.

May 6, 11:30 pm, I went to the GSoC website, hit the refresh button and searched my name under the list of selected projects. My name popped up and I was over the moon and it took me a while to let it all soak in.

Hello everyone!

I’ve been selected as a Google Summer of Code developer for the year 2019. Over the Summer I’ll be working with phpMyAdmin on the project ‘General Improvements’ under my mentor Saksham Gupta.

phpMyAdmin is currently well equipped and widely used web interface for MySQL and MariaDB. It has an Intuitive web interface and support for most MySQL features like managing databases, tables, columns, relations, indexes, users, permissions, etc along with a number of other features.

Still, there are a number of improvements and new features that can be added in the current version of code. Though they do not hinder the user’s working, adding them would make the user experience more seamless and smooth. The aim is to make the code free of, and less prone to, bugs, and add features to further enhance the accessibility, adaptability, and user-friendliness.

Further, I would like to throw some light on how I went about contributing to the organisation and my application process.

After the list of organisations was introduced, I looked through the list to find organisations with a familiar technology stack and project aligned with my interests. phpMyAdmin was one such organisation. I had some prior experience with Open Source as I applied for GSoC last year too.

Firstly I went through their project ideas and one of the ideas caught my eye. It was ‘General Improvements’ project which included adding new features and fixing some critical issues in the current platform. It included:

Fixing Theme Generator: A tool to create custom theme.
Adding Favourites Feature: Ability to mark important database and tables.
Creating composer packages: phpMyAdmin configuration files as a composer package
and some other Bugs and improvements in the code.

I immediately decided to apply for this project. I started with scouring some bugs and fixing them, this not only supplemented my PHP knowledge but also helped me in understanding the huge code base, contributing guidelines, healthy development practices, quality of code expected, etc. and not to mention the hands-on experience of working on a real-time project for an international organisation under brilliant mentors.

I frequently interacted with the community on their Gitter channel or on github issues with questions about their products and they were helpful in guiding me throughout. At the same time, I tried to help other developers in the community with setting up the projects, reviewing their pull requests, failed builds, etc. Even though I wasn’t always aware of the solution, I always tried to look up the errors and go through the relevant documentation to solve them and this was a win-win situation because even I ended up learning a lot in the process.

I started with my proposal couple of weeks before the deadline and got them reviewed by the mentor a week before, made relevant changes and submitted the final proposal. I had to follow a fixed template provided by the organisation for the proposal.

After submitting my proposal, the next month majorly went into preparing and appearing for my end semester examinations, I kept contributing to the organisation and interacting with the community members and of course GSoC results were always on my mind.

And finally the result came in my favour and on 6th may I received the mail:

In the following blogs, I will document my experience working on the project and all that I learn in the process. :)

What you can probably spot from past posts on my blog, my open source contributions are heavily focused on Weblate and I've phased out many other activities. The main reason being reduced amount of free time with growing family, what leads to focusing on project which I like most. It's fun to develop it and it seems like it will work business wise as well, but that's still something to be shown in the future.

Anyway it's time to admit that I will not spend much time on other things in near future.

Earlier this year, I've resigned from being phpMyAdmin project admin. I was in this role for three years and I've been contributing to the project for 18 years. It has been time, but I haven't contributed significantly in last few months. I will stay with the project for few more months to handle smooth transition, but it's time to say good bye there.

On the Debian project I want to stay active, but I've reduced my involvement and I'm looking for maintainers for some of my packages (mostly RPM related). The special case is the phpMyAdmin package where I was looking for help since 2017, but it still didn't help from the package becoming heavily outdated with security issues what lead to it's removal from Buster. It seems that this has triggered enough attention to resurrect work on the updated packages.

Today I've gone through my personal repos on GitHub and I've archived bunch of them. These have not received any attention for years (many of them were dead by the time I've imported them to GitHub) and it's good to clearly show that to random visitors.

I'm still main developer behind Gammu, but I'm not really doing there more than occasional review of pull requests and merging them. I don't want to abandon the project without handing it out to somebody else, but the problem is that there is nobody else right now.

Filed under: Debian English Gammu SUSE

I've been publishing updates about Weblate on my blog for past seven years. Now the project has grown up enough to deserve own space to publish posts. Please update your bookmarks and RSS readers to new location directly on Weblate website.

The Weblate website will receive another updates in upcoming weeks, I'm really looking forward to these.

New address for Weblate blog is https://weblate.org/news/.

New address for the RSS feed is https://weblate.org/feed/.

Filed under: Debian English SUSE Weblate

Weblate 3.6.1 has been released today. It is a bugfix release fixing several issues reported after the 3.6 release.

Full list of changes:

• Improved handling of monolingual Xliff files.
• Fixed digest notifications in some corner cases.
• Fixed addon script error alert.
• Fixed generating MO file for monolingual PO files.
• Fixed display of uninstalled checks.
• Indicate administered projects on project listing.
• Allow update to recover from missing VCS repository.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

Weblate 3.6 has been released today. It brings rewritten notifications, user data download and several other improvements. It also sets depreciation timeline for Python 2 installations - after April 2020 Weblate will only support Python 3.

Full list of changes:

• Add support for downloading user data.
• Addons are now automatically triggered upon installation.
• Improved instructions for resolving merge conflicts.
• Cleanup addon is now compatible with app store metadata translations.
• Configurable language code syntax when adding new translations.
• Warn about using Python 2 with planned termination of support in April 2020.
• Extract special chars from the source string for visual keyboard.
• Extended contributor stats to reflect both source and target counts.
• Admins and consistency addons can now add translations even if disabled for users.
• Fixed description of toggle disabling Language-Team header manipulation.
• Notify users mentioned in comments.
• Removed file format autodetection from component setup.
• Fixed generating MO file for monolingual PO files.
• Added digest notifications.
• Added support for muting component notifications.
• Added notifications for new alerts, whiteboard messages or components.
• Notifications for administered projects can now be configured.
• Improved handling of three letter language codes.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

The translation-finder module has been released in version 1.1. It is used by Weblate to detect translatable files in the repository making setup of translation components in Weblate much easier. This release brings lot of improvements based on feedback from our users, making the detection more reliable and accurate.

Full list of changes:

• Improved detection of translation with full language code.
• Improved detection of language code in directory and file name.
• Improved detection of language code separated by full stop.
• Added detection for app store metadata files.
• Added detection for JSON files.
• Ignore symlinks during discovery.
• Improved detection of matching pot files in several corner cases.
• Improved detection of monolingual Gettext.

Filed under: Debian English SUSE Weblate

Weblate 3.5.1 has been released today. Compared to the 3.5 release it brings several bug fixes and performance improvements.

Full list of changes:

• Fixed Celery systemd unit example.
• Fixed notifications from http repositories with login.
• Fixed race condition in editing source string for monolingual translations.
• Include output of failed addon execution in the logs.
• Improved validation of choices for adding new language.
• Allow to edit file format in component settings.
• Update installation instructions to prefer Python 3.
• Performance and consistency improvements for loading translations.
• Make Microsoft Terminology service compatible with current zeep releases.
• Localization updates.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

Weblate 3.5 has been released today. It includes improvements in the translation memory, addons or alerting.

Full list of changes:

• Improved performance of built in translation memory.
• Added interface to manage global translation memory.
• Improved alerting on bad component state.
• Added user interface to manage whiteboard messages.
• Addon commit message now can be configured.
• Reduce number of commits when updating upstream repository.
• Fixed possible metadata loss when moving component between projects.
• Improved navigation in the zen mode.
• Added several new quality checks (Markdown related and URL).
• Added support for app store metadata files.
• Added support for toggling GitHub or Gerrit integration.
• Added check for Kashida letters.
• Added option to squash commits based on authors.
• Improved support for xlsx file format.
• Compatibility with tesseract 4.0.
• Billing addon now removes projects for unpaid billings after 45 days.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

wlc 1.0, a command line utility for Weblate, has been just released. The most important change is marking this stable and releasing actual 1.0. It has been around long enough to indicate it's stability.

Full list of changes:

• Marked as stable release.
• Added support for more parameters on file upload.

wlc is built on top of Weblate API, you can use it on Weblate 2.10 or newer, though some features might require more recent version. Of course you use it on our hosting offering. Usage examples can be found in the wlc documentation.

Filed under: Debian English SUSE Weblate

Weblate 3.4 has been released today. The most visible new feature are guided translation component setup or performance improvements, but there are several other improvements as well.

Full list of changes:

• Added support for XLIFF placeholders.
• Celery can now utilize multiple task queues.
• Added support for renaming and moving projects and components.
• Include chars counts in reports.
• Added guided adding of translation components with automatic detection of translation files.
• Customizable merge commit messages for Git.
• Added visual indication of component alerts in navigation.
• Improved performance of loading translation files.
• New addon to squash commits prior to push.
• Improved displaying of translation changes.
• Changed default merge style to rebase and made that configurable.
• Better handle private use subtags in language code.
• Improved performance of fulltext index updates.
• Extended file upload API to support more parameters.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

Weblate 3.3 has been released today. The most visible new feature are component alerts, but there are several other improvements as well.

Full list of changes:

• Added support for component and project removal.
• Improved performance for some monolingual translations.
• Added translation component alerts to highlight problems with a translation.
• Expose XLIFF unit resname as context when available.
• Added support for XLIFF states.
• Added check for non writable files in DATA_DIR.
• Improved CSV export for changes.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

Upcoming Weblate 3.3 will bring new feature called alerts. This is one place location where you will see problems in your translations. Right now it mostly covers Weblate integration issues, but it will be extended in the future for deeper translation wide diagnostics.

This will help users to better integrate Weblate into the development process giving integration hints or highlighting problems Weblate has found in the translation. It will identify typical problems like not merged git repositories, parse errors in files or duplicate translation files. You can read more on this feature in the Weblate documentation.

You can enjoy this feature on Hosted Weblate right now, it will be part of upcoming 3.3 release.

Filed under: Debian English SUSE Weblate

Weblate 3.2.2 has been released today. It's a second bugfix release for 3.2 fixing several minor issues which appeared in the release.

Full list of changes:

• Remove no longer needed Babel dependency.
• Updated language definitions.
• Improve documentation for addons, LDAP and Celery.
• Fixed enabling new dos-eol and auto-java-messageformat flags.
• Fixed running setup.py test from PyPI package.
• Improved plurals handling.
• Fixed translation upload API failure in some corner cases.
• Fixed updating Git configuration in case it was changed manually.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

Setting up translation components in Weblate can be tricky in some cases, especially if you lack knowledge of the translation format you are using. Also this is something we wanted to automate from the very beginning, but there were always more pressing things to implement. But now the time is coming as I've just made first beta release of translation-finder, tool to help with this.

The translation-finder will look at filesystem (eg. checked out repository) and tries to find translatable files. So far the heuristics is pretty simple, but still it detects just fine most of the projects currently hosted on our hosted localization platform. Still if you find issue with that, you're welcome to provide feedback in our issue tracker.

The integration into Weblate will come in next weeks and will be able to enjoy this new feature in the 3.3 release.

Filed under: Debian English SUSE Weblate

wlc 0.9, a command line utility for Weblate, has been just released. There are several new commands like translation file upload or repository cleanup. The codebase has been also migrated to use requests instead of urllib.

Full list of changes:

• Switched to requests
• Added support for cleanup command.
• Added support for upload command.

wlc is built on API introduced in Weblate 2.6 and still being in development, you need at least Weblate 2.10 (or use on our hosting offering). You can find usage examples in the wlc documentation.

Filed under: Debian English SUSE Weblate

Two years ago, I've taken over uTidylib maintainership. Two years has passed without any bigger contribution, but today there is a new version with support for recent html-tidy and Python 3.

The release still can't be uploaded to PyPI (see https://github.com/pypa/warehouse/issues/4860), but it's available for download from my website or tagged in the GitHub repository.

Full list of changes is quite small:

• Compatibility with html-tidy 5.6.0.
• Added support for Python 3.

Anyway as I can not update PyPI entry, the downloads are currently available only on my website: https://cihar.com/software/utidylib/

Filed under: Debian English SUSE uTidylib

Weblate 3.2.1 has been released today. It's a bugfix release for 3.2 fixing several minor issues which appeared in the release.

Full list of changes:

• Document dependency on backports.csv on Python 2.7.
• Fix running tests under root.
• Improved error handling in gitexport module.
• Fixed progress reporting for newly added languages.
• Correctly report Celery worker errors to Sentry.
• Fixed creating new translations with Qt Linguist.
• Fixed occasional fulltext index update failures.
• Improved validation when creating new components.
• Added support for cleanup of old suggestions.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

Weblate 3.2 has been released today. It's fiftieth release of Weblate and also it's release with most fixed issues on GitHub. The most important change is in the background - introduction of Celery to process background tasks. The biggest user visible change is extended translation memory.

Full list of changes:

• Add install_addon management command for automated addon installation.
• Allow more fine grained ratelimit settings.
• Added support for export and import of Excel files.
• Improve component cleanup in case of multiple component discovery addons.
• Rewritten Microsoft Terminology machine translation backend.
• Weblate now uses Celery to offload some processing.
• Improved search capabilities and added regular expression search.
• Added support for Youdao Zhiyun API machine translation.
• Added support for Baidu API machine translation.
• Integrated maintenance and cleanup tasks using Celery.
• Improved performance of loading translations by almost 25%.
• Removed support for merging headers on upload.
• Removed support for custom commit messages.
• Configurable editing mode (zen/full).
• Added support for error reporting to Sentry.
• Added support for automated daily update of repositories.
• Added support for creating projects and components by users.
• Built in translation memory now automatically stores translations done.
• Users and projects can import their existing translation memories.
• Better management of related strings for screenshots.
• Added support for checking Java MessageFormat.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

Weblate 3.1 has been released today. It contains mostly bug fixes, but there are some new feature as well, for example support for Amazon Translate.

Full list of changes:

• Upgrades from older version than 3.0.1 are not supported.
• Allow to override default commit messages from settings.
• Improve webhooks compatibility with self hosted environments.
• Added support for Amazon Translate.
• Compatibility with Django 2.1.
• Django system checks are now used to diagnose problems with installation.
• Removed support for soon shutdown libravatar service.
• New addon to mark unchanged translations as needing edit.
• Add support for jumping to specific location while translating.
• Downloaded translations can now be customized.
• Improved calculation of string similarity in translation memory matches.
• Added support by signing Git commits by GnuPG.

Update:

Weblate 3.1.1 was released as well fixing test suite failure on some setups:

• Fix testsuite failure on some setup.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

Weblate 3.0.1 has been released today. It contains several bug fixes, most importantly possible migration issue on users when migrating from 2.20. There was no data corruption, just some of the foreign keys were possibly not properly migrated. Upgrading from 3.0 to 3.0.1 will fix this as well as going directly from 2.20 to 3.0.1.

Full list of changes:

• Fixed possible migration issue from 2.20.
• Localization updates.
• Removed obsolete hook examples.
• Improved caching documentation.
• Fixed displaying of admin documentation.
• Improved handling of long language names.

If you are upgrading from older version, please follow our upgrading instructions, the upgrade is more complex this time.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

This week I updated the code style to fit some of the PSR-2 rules, refactored some files and upgraded to Twig 2, in addition to helping the GSoC students.

Issues:

• #14341 Fix bug reported on pull request #14305
• #14317 Extension removal

The post Weekly phpMyAdmin contributions 2018-W22 appeared first on mauriciofauth.com.

This week I made up for the additional hours I worked on in the previous weeks. I removed the $dbi global variable from several classes, in addition to helping the GSoC students.

Issues:

• #14305 Remove md5 twig extension

The post Weekly phpMyAdmin contributions 2018-W21 appeared first on mauriciofauth.com.

This week I enabled the strict type mode in all PHP files, fixed some bugs and reviewed pull requests, in addition to helping the GSoC students.

Issues:

• #14286 Fix central columns in-line edit bug
• #14231 #13893 issue fix Simulating queries produce unexpected results
• #14272 fixes broken links to icons in the setup page
• #14304 [5.0.0-dev] Strict mode php errors
• #13893 Simulating queries produces unexpected results
• #14119 fix: AUTO_INCREMENT error when only exporting table structure in database-level exports; issue #14066
• #14066 Export MySQL Table (only structure) AUTOINCREMENT error
• #14296 Enable strict mode in PHP files
• #14278 Central columns can’t be edited or deleted by multiple selection after single edit
• #14290 Enable strict mode in some classes

The post Weekly phpMyAdmin contributions 2018-W20 appeared first on mauriciofauth.com.

This week I fixed some bugs, reviewed pull requests, replaced some deprecated jQuery functions and added type declarations to multiple classes, in addition to helping the GSoC students.

Issues:

• #14280 Adapt html functions to Twig templates
• #13999 Incorrect CURRENT_TIMESTAMP DDL generated with MariaDB 10.2
• #14265 Issue #14019 fix: Allow parameter in AllowThirdPartyFraming
• #14019 Allow parameter in ‘AllowThirdPartyFraming’
• #14189 Remember table’s sorting broken in 4.8.0
• #14204 Remember table’s sorting broken in 4.8.0 issue: #14189 fixed
• #14067 IS NULL search operator produces no WHERE SQL with spatial fields
• #14068 SPATIAL fields with no unique index/autoincrement error when clicking
• #14121 View spatial fields as WKT doesn’t work
• #14125 Fix for issues with spatial fields
• #14266 HTML entity incorrectly displayed
• #14275 Revert modifications
• #14267 Require a polyfill instead of the cytpe extension
• #14249 Edit/Replace view: missing Go button
• #14263 Fix for missing go button in view edit, #14249
• #14177 Fixes bug #13968
• #13968 Data truncated error with current_timestamp().000000 and mariaDB 10.2
• #14260 Language does not change in 4.8.0.1
• #14261 #14260 Fixed configuration for DefaultLang and Lang

The post Weekly phpMyAdmin contributions 2018-W19 appeared first on mauriciofauth.com.

This week I fixed some bugs and reviewed multiple pull requests, in addition to helping the GSoC students.

Issues:

• #14202 Binary foreign key enhancement #13894
• #14255 Addapt getTableHeader to twig template
• #14258 Patch for #14257 CodeMirror hints hidden
• #14257 CodeMirror hints hidden in functions/procedures/triggers
• #14216 Fix XML Export fatal error and add Move columns preview SQL
• #14212 [4.8.0] XML Export from single table throws fatal error (PHP 7.2)
• #14155 Feature Request: Move columns preview SQL
• #14211 Duplicate hidden token input field issue solved
• #14166 Changes to make Get auto saved query and show this query here again button functional
• #14254 #14253 Git commit info not showing when the repository is a submodule
• #14209 Duplicate hidden token input fields
• #14253 Git commit info not showing when the repository is a submodule
• #14094 Fix bugs in SQL query restore after session expire
• #14163 Not showing default query on changing table
• #14148 Not showing previous query on clearing Codemirror and then clicking get saved query
• #14144 “Show this query here again” checkbox does not work
• #14118 SQL tab already has a query loaded
• #14093 No auto saved query everytime new sql page is loaded
• #13894 Binary foreign key enhancement
• #14128 [4.8 RC1] Show 2FA Secret next to QR
• #14154 Display the secret for 2FA – #14128
• #14141 Remove inline styles from Relation.php

The post Weekly phpMyAdmin contributions 2018-W18 appeared first on mauriciofauth.com.

This week I added type declarations to some classes, refactored the PhpMyAdmin\Dbi\DbiMysqli class to use the mysqli class and fixed some bugs.

Issues:

• #14244 Fixes some jQuery Migrate warnings
• #12373 Theme selection for future releases
• #14210 Add Metro theme
• #14213 getThemeUniqueValue error in master
• #14232 4.8.0.1: Colums hidden on low resolution display
• #14102 More Dropdown not fully visible
• #14199 UI Issue – date picker hides in scroll frame
• #14029 Horizontal scrollbar not visible
• #14193 Regression – Scrolling down messes up the fixed column names
• #14206 patch fixed for the datepickerui broken #14199
• #14196 Fix for ui regression issues
• #14228 #14049 issue fix Query builder doesn’t work when the selected column …
• #14226 #12772 issue central column attributes don’t get filled in
• #14169 Regression – Action Icons glitch in 4.8.0
• #14194 UI Issue – I have to scroll down, to be able to scroll horizontally
• #14165 Query builder doesn’t work when selected column is * #14049 issue fix
• #14049 Query builder doesn’t work when selected column is *
• #12772 Central columns attributes don’t get filled in
• #14073 Central columns attributes don’t get filled in #12772 issue solved
• #14179 Remove Inline Styles from Ruotines.php
• #14173 Fix for error when running prepared statements, #14162
• #14162 SQL parser error trying to run a prepared statement
• #14137 Tables stop at border
• #14135 Tables in designer don’t stop at border
• #14224 Use array_key_exists instead of in_array + array_keys

The post Weekly phpMyAdmin contributions 2018-W17 appeared first on mauriciofauth.com.

This week I added type declarations to some classes and added the Metro theme in the master branch.

Issues:

• #14175 Theme problem in 4.8 version
• #14208 Fix errors due to undefined variables

The post Weekly phpMyAdmin contributions 2018-W16 appeared first on mauriciofauth.com.

This week the phpMyAdmin began to require PHP 7.1 in the master branch. So I updated the dependencies and removed some PHP 5 code. I also refactored some classes by replacing the static methods with instance methods.

Issues:

• #13896 Bump minimum version to PHP 7.1 for phpMyAdmin 5.0
• #13919 Remove font size feature
• #13925 Remove font size feature
• #14186 Bump minimum version to PHP 7.1

The post Weekly phpMyAdmin contributions 2018-W15 appeared first on mauriciofauth.com.

Weblate 3.0 has been released today. It contains brand new access control module and 61 fixed isssues.

Full list of changes:

• Rewritten access control.
• Several code cleanups that lead to moved and renamed modules.
• New addon for automatic component discovery.
• The import_project management command has now slightly different parameters.
• Added basic support for Windows RC files.
• New addon to store contributor names in PO file headers.
• The per component hook scripts are removed, use addons instead.
• Add support for collecting contributor agreements.
• Access control changes are now tracked in history.
• New addon to ensure all components in a project have same translations.
• Support for more variables in commit message templates.
• Add support for providing additional textual context.

If you are upgrading from older version, please follow our upgrading instructions, the upgrade is more complex this time.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English phpMyAdmin SUSE Weblate

The Docker container for Weblate got several improvements in past days and if you're using it, it might be worth reviewing your setup.

It has been upgraded to Python 3 and Django 2. This should cause no problems as Weblate itself supports both for quite some time, but if you were extending Weblate somehow, you might have to update these extensions to make them compatible.

The default cache backend is now redis. It will be required in future for some features, so you will have to switch at some point anyway. The memcached support is still there in case you want to stick with current setup.

Cron jobs have been integrated into the main container. So you no longer need to trigger them externally. This save quite some pain with offloaded indexing and another features which rely on regular execution.

Another important change is in logging - all logs are now go to the standard output, so you will get them by docker-compose logs and other Docker management commands. This will make debugging easier.

Filed under: Debian English SUSE Weblate

Hosted Weblate provides also free hosting for free software projects. The hosting requests queue has grown too long and waited for more than month, so it's time to process it and include new projects. I hope that gives you have good motivation to spend Christmas break by translating free software.

This time, the newly hosted projects include:

• ASS Danmaku - firefox extension for downloading danmaku
• KeePass DX - KeePass implementation for Android
• Liberapay Everywhere - the official Liberapay browser extension
• Offline QR Code Generator - browser add-on allowing you to quickly generate a QR code
• Guake - drop-down terminal for GNOME
• Planner - Project and Task manager designed for elementary OS
• EasySSH - The SSH connection manager to make your life easier.
• Misskey - A Twitter-like SNS
• Starke Verben - Android Application to learn your strong verbs
• FMIT - Free Music Instrument Tuner
• Crappy Firetitle - A firefox extension allowing customisation of windows' title
• Piano Booster - a MIDI file player that displays the musical notes AND teaches you how to play the piano

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

Filed under: Debian English SUSE Weblate

Next release on Weblate roadmap is called 3.0 and will bring some important changes. Some of these are already present in the Git repository and deployed on Hosted Weblate, but more of that will follow.

Component discovery

Component discovery is useful feature if you have several translation components in one repository. Previously import_project management command was the only way to help you, however it had to be executed manually on any change. Now you can use Component discovery addon which does quite similar thing, however is triggered on VCS update, so it can be used to follow structure of your project without any manual interaction. This feature is already available in Git and on Hosted Weblate, though you have to ask for initial setup there.

Code cleanups

Over the years (first Weblate release was more than six years ago) the code structure is far from optimal. There are several code cleanups scheduled and some of them are already present in Git repository. This will make Weblate easier to maintain and extend (eg. with third party file format drivers).

User management

Since the beginning Weblate has relied on user management and permissions as provided by Django. This is really not a good fit for language / project matrix permissions which most people need so we've come with Group ACL to extend this. This worked quite well for some use cases, but it turned out to be problematic for others. It is also quite hard to setup properly. For Weblate 3.0 this will be dropped and replaced by access control which fits more use cases. This is still being finalized in our issue tracker, so if you have any comments to this, please share them.

Migration path

Due to above mentioned massive changes, migrations across 3.0 will not be supported. You will always have to upgrade to 3.0 first and then upgrade to further versions. The code cleanups will also lead to some changes in the configuration, so take care when upgrading and follow upgrading instructions.

Filed under: Debian English SUSE Weblate

Last week I refactored some classes by replacing the static methods with instance methods.

Issues:

• #14057 Login screen doesn’t appear in android native browser+chrome
• #14076 Enable columns names by default for CSV in issue #14007 solved
• #14007 Enable columns names by default for CSV exports

The post Weekly phpMyAdmin contributions 2018-W14 appeared first on mauriciofauth.com.

Hosted Weblate provides also free hosting for free software projects. The hosting requests queue has grown too long and waited for more than month, so it's time to process it and include new projects. I hope that gives you have good motivation to spend Christmas break by translating free software.

This time, the newly hosted projects include:

• OCCRP Investigative Dashboard - Organized Crime and Corruption Reporting Project
• Tachiyomi - manga reader for Android
• Sozi - a zooming presentation editor and player
• SoundSwitch - application to switch default playing device on Windows
• Project Hamster - a time tracking application
• Fragments - a GTK3 BitTorrent client
• Quack - Qualitative and Usable Aur paCKage helper
• RMS: Personal Data Safe - an article from Richard Stallman

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

Filed under: Debian English SUSE Weblate

Weblate 2.20 has been released today. There are several performance improvements, new features and bug fixes.

Full list of changes:

• Improved speed of cloning subversion repositories.
• Changed repository locking to use third party library.
• Added support for downloading only strings needing action.
• Added support for searching in several languages at once.
• New addon to configure Gettext output wrapping.
• New addon to configure JSON formatting.
• Added support for authentication in API using RFC 6750 compatible Bearer authentication.
• Added support for automatic translation using machine translation services.
• Added support for HTML markup in whiteboard messages.
• Added support for mass changing state of strings.
• Translate-toolkit at least 2.3.0 is now required, older versions are no longer supported.
• Added built in translation memory.
• Added componentlists overview to dashboard and per component list overview pages.
• Added support for DeepL machine translation service.
• Machine translation results are now cached inside Weblate.
• Added support for reordering commited changes.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

Last week was very productive. I spent most of my time reviewing all the pull requests. I’ve also fixed a few minor bugs and refactored the static methods of some classes.

Issues:

• #14117 Designer: “Add options” dialog doesn’t reset when canceling: #14110 issue fixed
• #14122 Enhancement: Button to add a central column from existing tables #14043
• #14110 Designer: “Add options” dialog doesn’t reset when canceling
• #14126 Designer: Add option dialogue error handling needs to be modified
• #14139 Error while adding central column from existing tables
• #14142 Fix for adding central column, #14139
• #14043 Enhancement- Button to add a central column from existing tables.
• #14111 Designer: Add options dialog is pre-filled with spaces
• #14114 Designer: Add options dialog is pre-filled with spaces #14111 issue fix
• #14113 Designer: Improperly escaped code in “Add option” dialog #14109 issue fix
• #14109 Designer: Improperly escaped code in “Add option” dialog
• #14115 Fix for “Export tables as seperate files”, #14080
• #14080 “Export tables as separate files” gives empty download
• #14097 JavaScript error in Designer: getElementById() #14079 issue fix
• #14079 JavaScript error in Designer: getElementById()
• #14092 Fixes error 404 on creating views, issue #14082
• #14082 error 404 on creating new view in new PhpMyAdmin releases
• #14012 Fix errors on zoom search errors, issue #13439
• #13439 Table zoom page errors
• #14031 Fixes error in foreign key sql generation + drop foreign key contraint
• #14010 Fix broken Relation View
• #14009 Problem with saving the relation view
• #14037 fix: wrong argument type passed when creating foreign key
• #13941 Argument 5 passed to PhpMyAdmin\Table::_getSQLToCreateForeignKey() must be of the type array, string given
• #14105 Cannot read property sql_query of undefined: #14104 issue fix
• #14104 Cannot read property ‘sql_query’ of undefined
• #14101 sqlform is undefined error when browsing a GIS table

The post Weekly phpMyAdmin contributions 2018-W13 appeared first on mauriciofauth.com.

Last week was mostly spent on reviewing GSoC proposals and on reviewing pull requests. I’m also refactored the PhpMyAdmin\Relation class by replacing the static methods with instance methods.

Issues:

• #14103 jQuery.fn.blur() event shorthand is deprecated
• #14107 Addapt getHtmlForAddColumn to use twig template
• #14071 Database structure page improperly escaped HTML code
• #14098 Fix improperly escaped HTML code in database structure page; issue #14071
• #14011 “Show Report Details” button does not work
• #14116 Addapt getHtmlForTableNavigation to twig template
• #14108 Fixes JavaScript error when editing rows with Internet Explorer
• #14072 Import fails with error code 200
• #14085 Fixes Import Fail
• #14064 Fix buggy sql.lib.php on debian9 with PHP7.2
• #13981 Remove inline styles in ReplicationGui.php
• #14030 Fatal error: Uncaught TypeError: Argument 5 passed to PhpMyAdmin\Table::_getSQLToCreateForeignKey() must be of the type array, string given

The post Weekly phpMyAdmin contributions 2018-W12 appeared first on mauriciofauth.com.

Last week I refactored some classes by replacing the static methods with instance methods and fixed a few minor bugs.

Issues:

• #14075 Fixes for issue 14059
• #14061 Login form not shown with Internet Explorer 11
• #14059 Indexes are not created on Structure tab after update to 4.7.9

The post Weekly phpMyAdmin contributions 2018-W11 appeared first on mauriciofauth.com.

Last week was pretty quiet. The most interesting part was licensing issue with two factor authentication library we use. In the end the library was relicensed to MIT, what makes it compatible with pretty much anything.

I've spent some time on the Debian packages as well, I'm getting closer to make them work again, but there are still some issues to overcome.

Handled issues:

• #14074 Replace google2fa library
• #14046 Restore SQL query after session expire

Filed under: English phpMyAdmin

Last week was a bit quiet, I've spend some time on our infrastructure and doing reviews. There is still big pending task to update Debian packages and I will hopefully get to it this week.

Handled issues:

• #14065 Can not connect to remote server without manual modification in codebase
• #61 Add CAA DNS Record for PMA websites when possible
• #179 Documentation improvements

Filed under: English phpMyAdmin

Last week I've continued on reviewing incoming pull requests and issues without coding much myself. It seems that amount of incoming issues is still quite big.

Handled issues:

• #14005 Supported versions
• #14048 Fixes adding new column in query builder, #14047
• #13940 arg_separator breaks PMA: Call to a member function getCurrentUserAndHost
• #13927 NEED HELP PHPMyAdmin compatibility with PHP 7.1
• #13984 Unable to logout of phpMyAdmin-4.6.6-5 on Ubuntu
• #14003 Issue saving design
• #14047 Add column button in query builder doesn't work
• #14032 Warning in ./libraries/sql.lib.php#601
• #14034 Designer add table
• #14035 Fix Broken Designer Add Table
• #13887 4.7.7: PHP Warning: Unknown: Input variables exceeded 1000. To increase the limit change max_input_vars in php.ini.

Filed under: English phpMyAdmin

Last week I back-ported a bug fix that was affecting branch 4.7. I removed the references to PMD in favor of Designer and I also refactored some classes by replacing the static methods with instance methods.

Issues:

• #14025 Class ‘ZipArchive’ not found in /srv/pma/libraries/classes/ZipExtension.php:29
• #14000 Add PHP Nightly version to Travis-CI
• #13931 Sort is broken
• #14036 Fix broken sort
• #14042 Rename PMD to Designer

The post Weekly phpMyAdmin contributions 2018-W08 appeared first on mauriciofauth.com.

Last week was mostly spent on reviewing pull requests. There is quite a lot them coming in and I always feel bad when we're not able to review incoming code in timely manner, but unfortunately it happens time to time.

Handled issues:

• #13892 Fix charset error when creating/editing routines; bug #13889
• #14036 Fix broken sort
• #14006 Translated using Weblate (Filipino)
• #13964 Warning: hash_equals(): Expected known_string to be a string, null given
• #14021 fix maintenance operations
• #14022 Max height not set for console
• #14024 Set console max height, issue #14022
• #13889 Create/Edit routine charset bug
• #150 Security release 4.7.8 missing on docker hub

Filed under: English phpMyAdmin

Last week was very productive. I refactored some classes to use instance methods, fixed some bugs and merged some PRs.

Issues:

• #13988 Fix case in which Config::checkServers is never called
• #13769 Database list and general settings not being displayed during development of phpmyadmin
• #12611 :hover applied incorrectly on ‘table indexes’ rows for multiple-column indexes.
• #13952 Insert page should prompt before reducing number of rows
• #13987 Prompt before reducing number of rows
• #14015 Refactor PhpMyAdmin\CreateAddField class
• #14020 Fix icons with wrong size in the Original theme
• #14013 Some icons with wrong size in the Original theme
• #13983 Fix for broken profiling; issue #13969
• #13969 Profiling breaks user session
• #13980 Hover not working on master but working on stable
• #13998 Fixes Hover on tables
• #14001 Fix table horizontal scrolling
• #13959 Too many fields(>13 in my case) in a table leading to page overflow

The post Weekly phpMyAdmin contributions 2018-W07 appeared first on mauriciofauth.com.

Weblate 2.19.1 has been released today. This is bugfix only release mostly to fix problematic migration from 2.18 which some users have observed.

Full list of changes:

• Fixed migration issue on upgrade from 2.18.
• Improved file upload API validation.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

Last week was mostly spent on fixing issues with translations and improving our Docker container. That is now based on official PHP FPM image, so it will always get latest stable PHP instead of the one shipped by Alpine.

Besides that there was small, but important change in the motranslator library which no longer sets system locale (as it really has no good reason to do that). This change lead to releasing new major version of the library as it might need code changes for users who relied on this (what was the phpMyAdmin case).

Handled issues:

• #13996 Translated using Weblate (Filipino)
• #144 Use upstream PHP FPM Alpine Docker image
• #147 502 error on logout under a load-balancer
• #24 Number format may be changed inadvertently

Filed under: English phpMyAdmin

Last week I refactored some classes by replacing the static methods with instance methods and fixed a few minor bugs.

Issues:

• #13972 Refactor PhpMyAdmin\InsertEdit class
• #13778 ‘Range search’ window keeps popup when trying to select another operator at Search menu.
• #13971 Fix for issue #13778
• #13979 removed inline styles from AuthenticationConfig.php file-issue 12262
• #13985 Refactor PhpMyAdmin\ErrorReport class
• #13986 Refactor PhpMyAdmin\Normalization class
• #13976 Columns not sorting
• #13978 Fix textarea failed to popup (issue #13518)
• #13518 Cell editor missing the popup edit box (which has ‘Press escape to cancel editing’ at bottom)

The post Weekly phpMyAdmin contributions 2018-W06 appeared first on mauriciofauth.com.

Weblate 2.19 has been released today. The biggest improvement are probably addons to customize translation workflow, but there are some other enhancements as well.

Full list of changes:

• Fixed imports across some file formats.
• Display human friendly browser information in audit log.
• Added TMX exporter for files.
• Various performance improvements for loading translation files.
• Added option to disable access management in Weblate in favor of Django one.
• Improved glossary lookup speed for large strings.
• Compatibility with django_auth_ldap 1.3.0.
• Configuration errors are now stored and reported persistently.
• Honor ignore flags in whitespace autofixer.
• Improved compatibility with some Subversion setups.
• Improved built in machine translation service.
• Added support for SAP Translation Hub service.
• Added support for Microsoft Terminology service.
• Removed support for advertisement in notification mails.
• Improved translation progress reporting at language level.
• Improved support for different plural formulas.
• Added support for Subversion repositories not using stdlayout.
• Added addons to customize translation workflows.

If you are upgrading from older version, please follow our upgrading instructions.

You can find more information about Weblate on https://weblate.org, the code is hosted on Github. If you are curious how it looks, you can try it out on demo server. Weblate is also being used on https://hosted.weblate.org/ as official translating service for phpMyAdmin, OsmAnd, Turris, FreedomBox, Weblate itself and many other projects.

Should you be looking for hosting of translations for your project, I'm happy to host them for you or help with setting it up on your infrastructure.

Further development of Weblate would not be possible without people providing donations, thanks to everybody who have helped so far! The roadmap for next release is just being prepared, you can influence this by expressing support for individual issues either by comments or by providing bounty for them.

Filed under: Debian English SUSE Weblate

Hosted Weblate provides also free hosting for free software projects. The hosting requests queue has grown too long and waited for more than month, so it's time to process it and include new projects. I hope that gives you have good motivation to spend Christmas break by translating free software.

This time, the newly hosted projects include:

• gImageReader - an OCR application
• GASdottoNG - a purchasing groups management platform
• Pentobi - a computer opponent for the board game Blokus
• Mindfulness at the computer - an application to remind taking breaks
• CalcPvAutonome - a tool to calculate solar panels for autonomous systems
• GAFAM - a poster campaign
• openScale - an app which support various Bluetooth scales
• Your local weather - an application which displays current weather and location wherever you are.
• Event Sync for Facebook - an application to sync your Facebook events into your Android calendar
• Bodyweight timer for Sailfish OS - a time supporting app for traing purposes (bodyweight-training) on Jolla Sailfish OS
• PDF Mix Tool - an application to split, merge, rotate and mix PDF files.
• tinyMediaManager - a multi OS media management tool
• Night Clock - a night clock with alarm and date for Android

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

Filed under: Debian English SUSE Weblate

Last week I refactored the PhpMyAdmin\CentralColumns class by replacing the static methods with instance methods.

Issues:

• #13090 Row coloring issue @ Indexes
• #13877 Fix Row coloring issue@Indexes
• #13880 Colour issue in rows on hover
• #13960 Fixes Colour issue in rows on hover
• #13966 Refactor PhpMyAdmin\CentralColumns class

The post Weekly phpMyAdmin contributions 2018-W05 appeared first on mauriciofauth.com.

Last week I extracted the PhpMyAdmin\Utils\HttpRequest class from the PhpMyAdmin\Util class and refactored it to use instance methods instead of static methods.

Issues:

• #13932 count() function error on PHP7.2
• #13578 Allow custom number of rows to be inserted
• #13876 Allow Custom number of rows to be inserted

The post Weekly phpMyAdmin contributions 2018-W04 appeared first on mauriciofauth.com.

Last week I refactored the PhpMyAdmin\BrowseForeigners class by replacing the static methods with instance methods. I also investigated ways to increase code coverage.

Issues:

• #13935 Simplify returns
• #13936 Use assertNotSame instead of comparison in test

The post Weekly phpMyAdmin contributions 2018-W03 appeared first on mauriciofauth.com.

Last week was mostly spent on our infrastructure - I've migrated all virtual machines from old server to new one. This went pretty smoothly with about one hour delay during the migration. Everything now should work just fine and with considerably increased performance.

Handled issues:

• #13938 Warning in PHP 7.2
• #13939 Warning in PHP 7.2
• #13917 Force PHP platform in composer to oldest supported version
• #13831 PHP 5 / 7 compatibility

Filed under: English phpMyAdmin

Last week I refactored the PhpMyAdmin\Display\Export class by moving the HTML to the templates and replacing the static methods with instance methods.

The post Weekly phpMyAdmin contributions 2018-W02 appeared first on mauriciofauth.com.

Last week was equally spent on issues and infrastructure. There is quite serious regression in the 4.7.7 release which needs to be fixed (so far just the issue has been identified). In the same time our server is having hardware problems and we're preparing to migrate to new one (if everything goes well, the migration will be completed by the time you read this).

Handled issues:

• #13890 open in new tab on edit query dont't work on 4.7.7
• #13913 Distinct values -> No database selected
• #13885 create_release should only generate signatures for the current release
• #13907 4.7.7 -- clicking column title to sort results opens "insert" form.
• #13886 Upload rate limit error in manage.py
• #13910 fix #13712 Doesn't default to primary key when creating relations
• #13712 Doesn't default to primary key when creating relations
• #13758 single-sign-on: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given
• #13914 Settings reset prevents login and causes PHP Warnings

Filed under: English phpMyAdmin

Last week was a bit calmer. I removed the javascript that was used to hide the action buttons on the table structure page. This code had a very low performance and the short-term solution was to remove it.

Issues:

• #13694 MenuResizer is VERY slow
• #13905 Use CSS to hide table structure action buttons

The post Weekly phpMyAdmin contributions 2018-W01 appeared first on mauriciofauth.com.

First week of 2018 was a bit less intense on the code fixing side, but I've done some work on our infrastructure preparing for migration to the new server, which should be available as soon as Conservancy approves payments for it.

The new server will be located at Hetzner and you can check more details on the selection process in our wiki. The current server has been used for almost 10 years and is really showing it's age.

Handled issues:

• #13828 Two factor: doesn't ask for second factor
• #145 Update to Alpine 3.7

Filed under: English phpMyAdmin