]> git.joonet.de Git - adminer.git/log
adminer.git
8 years agoEditor: Don't set time zone from PHP
Lukas Tribus [Sat, 9 Sep 2017 09:44:42 +0000 (11:44 +0200)]
Editor: Don't set time zone from PHP

Current implementation checks the delta between the local time and
UTC, and applies the delta as time zone for MySQL.

This assumption is wrong if the current time is DST enabled, but the
time that is converted isn't - and vice versa.

For example, Europe/Prague is "CET-1CEST,M3.5.0,M10.5.0/3", when
the MySQL connections is setup now (September, DST enabled) and
we are reading a TIMESTAMP from November, then MySQL applies +0200
instead of +0100 to that timestamp even though November is supposed
to be DST disabled.

There is no reliable and portable way in PHP to understand the
time zone, especially since PHP >= 5.4.0 ignores environment
variable and OS settings [1].

MySQL needs to be properly setup (TZ data loaded [2] and default
TZ set [3]), then everything will work just fine.

The current implementation however causes wrong data 50% of the
time, even when OS/MySQL/PHP is properly setup. As a MySQL
connection will converte timestamps from both DST enabled and
DST disabled dates, a static UTC offset must never be set at
connection level (set time_zone = ...).

This change removes the current implementation, therefor maintaining
OS/MySQL defaults, fixing the DST issue in properly configured
environments.

[1] http://php.net/manual/en/function.date-default-timezone-get.php
[2] https://dev.mysql.com/doc/refman/5.5/en/mysql-tzinfo-to-sql.html
[3] https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html

8 years agoMake sure all sidebar elements are pushed down, not just the form.
Jonathan Vollebregt [Sat, 2 Sep 2017 18:14:51 +0000 (20:14 +0200)]
Make sure all sidebar elements are pushed down, not just the form.

This was breaking the #logins block at the log in screen.

8 years agoUpdate AdminerTablesFilter to produce li as per c9801e2e2418
Jonathan Vollebregt [Wed, 3 May 2017 20:14:14 +0000 (22:14 +0200)]
Update AdminerTablesFilter to produce li as per c9801e2e2418

8 years agoMySQL: Remove dedicated view for replication status
Jakub Vrana [Fri, 19 May 2017 09:11:44 +0000 (11:11 +0200)]
MySQL: Remove dedicated view for replication status

8 years agoSort table names (bug #552)
Jakub Vrana [Fri, 19 May 2017 08:56:17 +0000 (10:56 +0200)]
Sort table names (bug #552)

8 years agoUpdate es.inc.php
Alfonso Montero [Fri, 21 Apr 2017 15:13:35 +0000 (17:13 +0200)]
Update es.inc.php

8 years agoAdd a donate link
Jakub Vrana [Sun, 16 Apr 2017 08:42:27 +0000 (10:42 +0200)]
Add a donate link

8 years agoRelease 4.3.1 v4.3.1
Jakub Vrana [Fri, 14 Apr 2017 07:48:11 +0000 (09:48 +0200)]
Release 4.3.1

8 years agoFix SQL command autofocus
Jakub Vrana [Sun, 9 Apr 2017 10:29:42 +0000 (12:29 +0200)]
Fix SQL command autofocus

8 years agoAdd a todo
Jakub Vrana [Sun, 9 Apr 2017 10:13:18 +0000 (12:13 +0200)]
Add a todo

8 years agoDon't overwrite previous cookies (bug #539)
Jakub Vrana [Sun, 9 Apr 2017 09:03:42 +0000 (11:03 +0200)]
Don't overwrite previous cookies (bug #539)

8 years agoPostgreSQL: Fix JSONB version support
Jakub Vrana [Sat, 8 Apr 2017 18:17:08 +0000 (20:17 +0200)]
PostgreSQL: Fix JSONB version support

8 years agoPostgreSQL: Support JSON and JSONB data types (bug #542)
Jakub Vrana [Sat, 8 Apr 2017 17:59:13 +0000 (19:59 +0200)]
PostgreSQL: Support JSON and JSONB data types (bug #542)

8 years agoUpdate haeckel design (thanks to Klemens Haeckel)
Jakub Vrana [Sat, 8 Apr 2017 17:51:13 +0000 (19:51 +0200)]
Update haeckel design (thanks to Klemens Haeckel)

8 years agoUpdating Russian translation
Andre Polykanine A.K.A. Menelion Elensúlë [Sat, 1 Apr 2017 18:59:20 +0000 (21:59 +0300)]
Updating Russian translation

8 years agoFix table dependency on export
Deni [Thu, 6 Apr 2017 16:15:06 +0000 (18:15 +0200)]
Fix table dependency on export

8 years agoFix PostgreSQL nullable fields in export
Deni [Thu, 6 Apr 2017 15:39:25 +0000 (17:39 +0200)]
Fix PostgreSQL nullable fields in export

8 years agoPostgreSQL: Fix index size computation in PostgreSQL < 9.0 (reverts 4c78976c)
Jakub Vrana [Sat, 8 Apr 2017 17:32:29 +0000 (19:32 +0200)]
PostgreSQL: Fix index size computation in PostgreSQL < 9.0 (reverts 4c78976c)

8 years agoRelease 4.3.0 v4.3.0
Jakub Vrana [Wed, 15 Mar 2017 17:24:12 +0000 (18:24 +0100)]
Release 4.3.0

8 years agoReorder changelog
Jakub Vrana [Wed, 15 Mar 2017 15:57:58 +0000 (16:57 +0100)]
Reorder changelog

8 years agoUpdate JUSH
Jakub Vrana [Wed, 15 Mar 2017 11:53:26 +0000 (12:53 +0100)]
Update JUSH

8 years agoHighlight JSON
Jakub Vrana [Fri, 10 Mar 2017 07:56:58 +0000 (08:56 +0100)]
Highlight JSON

8 years agoPrint number of bytes in blob in italics
Jakub Vrana [Fri, 10 Mar 2017 07:19:58 +0000 (08:19 +0100)]
Print number of bytes in blob in italics

8 years agoMySQL: Support JSON data type
Jakub Vrana [Fri, 10 Mar 2017 07:15:52 +0000 (08:15 +0100)]
MySQL: Support JSON data type

8 years agoSupport MySQL 8
Jakub Vrana [Thu, 9 Mar 2017 17:52:00 +0000 (18:52 +0100)]
Support MySQL 8

8 years agoUse SameSite cookies (except session cookie)
Jakub Vrana [Tue, 7 Mar 2017 17:12:23 +0000 (18:12 +0100)]
Use SameSite cookies (except session cookie)

8 years agoRely on noreferrer in Firefox too
Jakub Vrana [Wed, 1 Mar 2017 10:35:01 +0000 (11:35 +0100)]
Rely on noreferrer in Firefox too

8 years agoImprove SQLite login error message
Jakub Vrana [Wed, 1 Mar 2017 10:23:20 +0000 (11:23 +0100)]
Improve SQLite login error message

8 years agoUpdate URL
Jakub Vrana [Mon, 27 Feb 2017 12:43:33 +0000 (13:43 +0100)]
Update URL

8 years agoSave bytes
Jakub Vrana [Wed, 22 Feb 2017 10:49:25 +0000 (11:49 +0100)]
Save bytes

8 years agoLint PHP files
Jakub Vrana [Tue, 21 Feb 2017 12:47:19 +0000 (13:47 +0100)]
Lint PHP files

8 years agoSimplify SQLite development
Jakub Vrana [Tue, 21 Feb 2017 12:13:39 +0000 (13:13 +0100)]
Simplify SQLite development

8 years agoDocument new engines
Jakub Vrana [Tue, 21 Feb 2017 12:05:43 +0000 (13:05 +0100)]
Document new engines

8 years agoAvoid referencing global variable (doesn't work in PHP 7.1 if Adminer is included...
Jakub Vrana [Tue, 21 Feb 2017 10:52:28 +0000 (11:52 +0100)]
Avoid referencing global variable (doesn't work in PHP 7.1 if Adminer is included inside a function)

8 years agoBump version
Jakub Vrana [Mon, 20 Feb 2017 17:11:31 +0000 (18:11 +0100)]
Bump version

8 years agoElasticsearch: allow empty server name
Jakub Vrana [Mon, 20 Feb 2017 17:07:30 +0000 (18:07 +0100)]
Elasticsearch: allow empty server name

8 years agoHide materialized views in MySQL
Jakub Vrana [Sun, 19 Feb 2017 14:11:05 +0000 (15:11 +0100)]
Hide materialized views in MySQL

8 years agoUnindent
Jakub Vrana [Sun, 19 Feb 2017 13:32:01 +0000 (14:32 +0100)]
Unindent

8 years agoElasticsearch: Support HTTPS by inputting https://server (bug #446)
Jakub Vrana [Mon, 20 Feb 2017 17:06:14 +0000 (18:06 +0100)]
Elasticsearch: Support HTTPS by inputting https://server (bug #446)

8 years agoSave bytes
Jakub Vrana [Mon, 20 Feb 2017 16:25:59 +0000 (17:25 +0100)]
Save bytes

8 years agoMySQL: Support spatial indexes (bug #455)
Jakub Vrana [Mon, 20 Feb 2017 16:25:19 +0000 (17:25 +0100)]
MySQL: Support spatial indexes (bug #455)

8 years agoFix dropping foreign keys linking to other database
Jakub Vrana [Mon, 20 Feb 2017 15:59:13 +0000 (16:59 +0100)]
Fix dropping foreign keys linking to other database

8 years agoMove 'Create user' above the list of users
Jakub Vrana [Mon, 20 Feb 2017 15:52:10 +0000 (16:52 +0100)]
Move 'Create user' above the list of users

8 years agoUse 'Create database' instead of 'Create new database'
Jakub Vrana [Mon, 20 Feb 2017 15:47:03 +0000 (16:47 +0100)]
Use 'Create database' instead of 'Create new database'

8 years agoSupport high Unicode characters in shorten_utf8 (bug #481)
Jakub Vrana [Mon, 20 Feb 2017 15:22:30 +0000 (16:22 +0100)]
Support high Unicode characters in shorten_utf8 (bug #481)

8 years agoFix where() escaping in MS SQL (bug #496)
Jakub Vrana [Mon, 20 Feb 2017 14:23:22 +0000 (15:23 +0100)]
Fix where() escaping in MS SQL (bug #496)

8 years agoAdd jsonly class to JS checkboxes
Jakub Vrana [Mon, 20 Feb 2017 14:11:47 +0000 (15:11 +0100)]
Add jsonly class to JS checkboxes

8 years agoDisplay message about missing master status
Jakub Vrana [Mon, 20 Feb 2017 13:06:19 +0000 (14:06 +0100)]
Display message about missing master status

8 years agoAdd Czech translation
Jakub Vrana [Mon, 20 Feb 2017 11:55:57 +0000 (12:55 +0100)]
Add Czech translation

8 years agoAdd basic support for MySQL replication
Matthew Gamble [Fri, 4 Dec 2015 23:43:28 +0000 (10:43 +1100)]
Add basic support for MySQL replication

8 years agoCheckbox for bool in psql
Adam Kuśmierz [Wed, 29 Jun 2016 16:27:34 +0000 (18:27 +0200)]
Checkbox for bool in psql

8 years agoFixed all alternative designs after changes in a list of tables made here: https...
Peter Knut [Sun, 19 Feb 2017 22:18:44 +0000 (23:18 +0100)]
Fixed all alternative designs after changes in a list of tables made here: https://github.com/vrana/adminer/pull/116

8 years agoPostgreSQL: Allow changing materialized views
Jakub Vrana [Mon, 20 Feb 2017 11:13:09 +0000 (12:13 +0100)]
PostgreSQL: Allow changing materialized views

8 years agoPostgreSQL: Fix index size computation
Jakub Vrana [Mon, 20 Feb 2017 11:06:41 +0000 (12:06 +0100)]
PostgreSQL: Fix index size computation

8 years agoVerify commit success after import.
Jakub Vrana [Sun, 19 Feb 2017 13:22:41 +0000 (14:22 +0100)]
Verify commit success after import.

Fixes https://sourceforge.net/p/adminer/bugs-and-features/521/.

8 years agoAdd javascript move for editing
Jonathan Vollebregt [Tue, 31 May 2016 18:36:00 +0000 (20:36 +0200)]
Add javascript move for editing

8 years agoforeign key link fix - added missing ns
Jan Kalina [Fri, 15 Jul 2016 22:34:42 +0000 (00:34 +0200)]
foreign key link fix - added missing ns

8 years agoTables list implemented as <ul>
Peter Knut [Sun, 7 Dec 2014 23:01:52 +0000 (00:01 +0100)]
Tables list implemented as <ul>

Encapsulation of list items is necessery for advanced CSS themes.

8 years agoChanged NULL format
newsiram [Wed, 17 Dec 2014 09:47:57 +0000 (10:47 +0100)]
Changed NULL format

+ <i> was not italics
+ reduce font & showed border

8 years agoFix MS SQL Driver to not show warnings for version fetching on connection and to...
Loren Klingman [Tue, 30 Dec 2014 15:54:28 +0000 (10:54 -0500)]
Fix MS SQL Driver to not show warnings for version fetching on connection and to retrieve the next set of results properly

8 years agofix logger for SQL commands
Mathieu Rochette [Wed, 11 Mar 2015 16:52:11 +0000 (17:52 +0100)]
fix logger for SQL commands

8 years agoHide databases the user can't connect to
Felix Geyer [Sun, 7 Jun 2015 19:52:43 +0000 (21:52 +0200)]
Hide databases the user can't connect to

pg_database lists all databases including the ones the user can't connect to.
There is little point in showing them when we know connecting will fail.

8 years agoBreadcumb no longer blocks the logout button.
0xACE [Fri, 14 Aug 2015 01:26:35 +0000 (03:26 +0200)]
Breadcumb no longer blocks the logout button.

Not sure why the top bar is blocking the logout button. This patch allows the user  to see and click the logout button.

8 years agoEdit json and jsonb types in textarea
Kakysha [Mon, 14 Sep 2015 22:34:01 +0000 (01:34 +0300)]
Edit json and jsonb types in textarea

8 years agoAdd namespace to routine call
Gargaj [Sat, 19 Sep 2015 21:24:09 +0000 (23:24 +0200)]
Add namespace to routine call

MSSQL is picky about this, shouldn't affect the drivers that don't use namespaces.

8 years agoDo not set input type as numeric if field is an array
K0n24d [Mon, 21 Sep 2015 19:35:51 +0000 (21:35 +0200)]
Do not set input type as numeric if field is an array

8 years agoNew skin 'flat'
isra00 [Mon, 5 Oct 2015 19:02:53 +0000 (21:02 +0200)]
New skin 'flat'

8 years agomake bytea fields shortable
nafex [Tue, 6 Oct 2015 13:08:02 +0000 (15:08 +0200)]
make bytea fields shortable

8 years agoPostgreSQL export: table structure, columns, sequences, indexes, foreign keys, commen...
Lubor Bilek [Thu, 10 Jul 2014 10:34:08 +0000 (12:34 +0200)]
PostgreSQL export: table structure, columns, sequences, indexes, foreign keys, comments, trigger definition

8 years agoAdd plugin for printing table indexes structure in expanded format
Matthew Gamble [Sun, 6 Dec 2015 00:43:49 +0000 (11:43 +1100)]
Add plugin for printing table indexes structure in expanded format

8 years agoAdd plugin for printing table structure in expanded format
Matthew Gamble [Sat, 5 Dec 2015 23:14:55 +0000 (10:14 +1100)]
Add plugin for printing table structure in expanded format

Instead of trying to squeeze everything into three columns, this plugin
uses multiple columns for each part of a column's structure.

8 years agoMove rendering of table structure and indexes list into plugin system
Matthew Gamble [Sat, 5 Dec 2015 14:21:37 +0000 (01:21 +1100)]
Move rendering of table structure and indexes list into plugin system

This allows the creation of a plugin to extend the display of either or
both of these things.

8 years agoHandle checkboxes properly in selectAddRow()
Matthew Gamble [Sun, 6 Dec 2015 03:11:48 +0000 (14:11 +1100)]
Handle checkboxes properly in selectAddRow()

8 years agofixed Elastic table_status()
Ion Bazan [Wed, 16 Mar 2016 11:05:51 +0000 (12:05 +0100)]
fixed Elastic table_status()

8 years agoImprove limit check in edit-foreign plugin
Jiří Barouš [Tue, 26 Apr 2016 10:31:40 +0000 (12:31 +0200)]
Improve limit check in edit-foreign plugin

The limit is enforced in the query to prevent out-of-memory errors for big target tables.

8 years agoAdminerTablesFilter: Persist filter value in a tab
Jonathan Vollebregt [Tue, 31 May 2016 22:18:25 +0000 (00:18 +0200)]
AdminerTablesFilter: Persist filter value in a tab

8 years agoUpdate AdminerTablesFilter
Jonathan Vollebregt [Tue, 31 May 2016 19:02:16 +0000 (21:02 +0200)]
Update AdminerTablesFilter

* Removes children request (Should work on IE6, 7, 8 now)
* Uses <strong> instead of <b>
* Doesn't leave said <strong> tags behind after updating the list
* Highlights multiple matches in a single table name
* Works case insensitively
* Improves performance with setTimeout
    With 400 tables, the old implementation locks up the tab (or
    browser if using something without multiprocess) for about
    half a second per keyup. Yes, this includes modifiers that
    don't actually change the filter. The new version handles
    the same event in 0.09 milliseconds.

    That's with all the above improvements.
    Tested in firefox 45.1.1 performance monitor.

8 years agoAdded support for binary foreign keys selection on edit
Alessandro Frangioni [Tue, 28 Jun 2016 08:25:39 +0000 (10:25 +0200)]
Added support for binary foreign keys selection on edit

8 years agoPlugin: Use <select> on custom user types in psql
Adam Kuśmierz [Wed, 29 Jun 2016 16:34:58 +0000 (18:34 +0200)]
Plugin: Use <select> on custom user types in psql

8 years agoTabs must also be escaped in JSON strings
Janne Cederberg [Thu, 7 Jul 2016 12:34:59 +0000 (15:34 +0300)]
Tabs must also be escaped in JSON strings

If database table data contains tab characters (0x09) then those
must also be escaped along with newlines and carriage returns for
the resulting JSON file to be valid.

8 years agoFix index length with Postgresql
PiR-B- [Thu, 18 Aug 2016 12:15:03 +0000 (14:15 +0200)]
Fix index length with Postgresql

8 years agopostgresql error with index on hidden columns (ctid)
soleuu [Tue, 30 Aug 2016 11:23:14 +0000 (13:23 +0200)]
postgresql error with index on hidden columns (ctid)

8 years agoFixed background of the list of the tables.
Daniel Berthereau [Sat, 8 Oct 2016 22:00:00 +0000 (00:00 +0200)]
Fixed background of the list of the tables.

8 years agoDocument changes
Jakub Vrana [Sat, 18 Feb 2017 16:37:12 +0000 (17:37 +0100)]
Document changes

8 years agoAdded pdo_dblib as a driver for MSSQL (as native MSSQL driver does not exist for...
Charles Wu [Mon, 10 Oct 2016 23:47:16 +0000 (16:47 -0700)]
Added pdo_dblib as a driver for MSSQL (as native MSSQL driver does not exist for PHP7)

8 years agoUse null instead of undefined on after parsing JSON
Jakub Vrana [Sat, 18 Feb 2017 16:31:54 +0000 (17:31 +0100)]
Use null instead of undefined on after parsing JSON

8 years agoChanged 'undefined' to 'null'
shaununderwood [Sun, 23 Oct 2016 19:23:38 +0000 (20:23 +0100)]
Changed 'undefined' to 'null'

'undefined' is not a valid JSON attribute value and should been 'null'

8 years agoFixed mssql driver for usage with microsoft's php7 sqlsrv extension
Massimiliano Torromeo [Tue, 15 Nov 2016 13:54:01 +0000 (14:54 +0100)]
Fixed mssql driver for usage with microsoft's php7 sqlsrv extension

8 years agoPlugin which shows sql structure comments in field names title
Adam Kusmierz [Tue, 20 Dec 2016 08:43:55 +0000 (09:43 +0100)]
Plugin which shows sql structure comments in field names title

8 years agoPHP Warning hidden and better parsing times (at least for postgresql)
Adam Kusmierz [Tue, 20 Dec 2016 08:38:22 +0000 (09:38 +0100)]
PHP Warning hidden and better parsing times (at least for postgresql)

8 years agopostgresql : ERROR: function connection_id() does not exist
soleuu [Mon, 16 Jan 2017 16:03:02 +0000 (17:03 +0100)]
postgresql : ERROR: function connection_id() does not exist

8 years agopostgresql : unique partial index musn't be considered as unique. can cause problems...
soleuu [Tue, 17 Jan 2017 09:25:35 +0000 (10:25 +0100)]
postgresql : unique partial index musn't be considered as unique. can cause problems on row edition

8 years agoFix error found by PHPStan
Jakub Vrana [Thu, 16 Feb 2017 18:05:45 +0000 (19:05 +0100)]
Fix error found by PHPStan

8 years agomistype correction
jose [Wed, 1 Feb 2017 15:37:44 +0000 (15:37 +0000)]
mistype correction

8 years agoAdd accessibility labels to Foreign keys
Jakub Vrana [Mon, 23 Jan 2017 23:12:42 +0000 (15:12 -0800)]
Add accessibility labels to Foreign keys

8 years agoAdd accessibility labels to Indexes
Jakub Vrana [Mon, 23 Jan 2017 22:29:00 +0000 (14:29 -0800)]
Add accessibility labels to Indexes

8 years agoUse class instead inline style
Jakub Vrana [Mon, 23 Jan 2017 22:10:50 +0000 (14:10 -0800)]
Use class instead inline style

8 years agoAdd accessibility labels to databases and tables checkboxes
Jakub Vrana [Mon, 23 Jan 2017 22:05:47 +0000 (14:05 -0800)]
Add accessibility labels to databases and tables checkboxes

8 years agoEscape quote in field name to make it work in Chrome (thanks to zcepenela pani)
Jakub Vrana [Mon, 23 Jan 2017 21:30:05 +0000 (13:30 -0800)]
Escape quote in field name to make it work in Chrome (thanks to zcepenela pani)

8 years agoAdditional theme with responsive and RTL support
Lucas Sandery [Wed, 31 Aug 2016 12:39:02 +0000 (22:09 +0930)]
Additional theme with responsive and RTL support

Signed-off-by: Lucas Sandery <lucas-sandery@users.noreply.github.com>