Developers August 2004

developers@phpmyadmin.net

6 participants
10 discussions

[Phpmyadmin-devel] Theme versioning
by Michal Čihař 05 Sep '04

05 Sep '04

Hi all I just added themes versioning and naming into cvs. So now when there is change on theme requirements, please increase PMA_THEME_VERSION in libraries/defines.lib.php and $theme_version in themes/*/info.inc.php (of course after updating that theme). -- Michal Čihař | http://cihar.com

3 6

[Phpmyadmin-devel] BINARY and VARBINARY
by Alexander M. Turek 28 Aug '04

28 Aug '04

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi devels, it looks as if MySQL has silently deprecated the BINARY sttribute in MySQL 4.1. If you create a CHAR(3) BINARY field, it becomes CHAR(3) CHARACTER SET latin1 COLLATE latin1_bin. Old [VAR]CHAR BINARY fields are mapped to [VAR]BINARY. This leads us to various incompatibilities: 1) We don't have these fields in our list of possible table fields and I don't know if MySQL 3.23.32 supports the syntax, so adding them generally wouldn't we a good idea, imho. 2) tbl_properties_structure.php recognizes these fields correctly as binary fields, but strips off the string "BINARY", so "VARBINARY(20)" becomes "var(20)" and even worse "BINARY(20)" becomes "(20)". 3) when trying to alter these fields, both are recognized as VARCHAR BINARY, which is dangerous because if we just want to change the size for instance, they get changed to "VARCHAR CHARACTER SET latin1 COLLATE latin1_bin"... 3) The binary column in tbl_properties_structure is superfluous, imho. And so is the BINARY entry in the list of field attributes. 4) The parser does not recognize BINARY as column type. Here's a simple table for reproducing the problem: CREATE TABLE `binarytest` ( `one` binary(3), `two` varbinary(10) ) - -- Alexander M. Turek <rabus(a)users.sourceforge.net> _ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ <http://www.phpmyadmin.net> -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFBC+XHoHdnxuobFY4RAl5MAJ9rhasmTe78CKqEPzqnXC1NjSdtnACfQaiO C5a5uEpLgo0zrS/QBSxGH1k= =IzsE -----END PGP SIGNATURE-----

2 2

[Phpmyadmin-devel] Design Proposition
by Dmitry Martynenko 25 Aug '04

25 Aug '04

Hello Olivier and All, Nice to meet you. I have already contacted Olivier and he gave me OK to discuss the topic in devel list. I am Dmitry Martynenko (Art director at MDG (www.mdgcreative.net). I would be interested in creating a website and designing the interface for the newer versions of phpMyAdmin. We will provide the services for free (it would be like our donation to your project). We can start from the logo and your website design. If you will agree to my proposition I will send you my ideas. Dmitry Martynenko.

3 5

[Phpmyadmin-devel] about LIKE '%...%'
by Marc Delisle 13 Aug '04

13 Aug '04

Hi, We got some negative reports about putting this operator first in the list. Concerns are about performance (wildcard being slower, and in case of monster tables, slower meant > 45 min.). Before those reports, I was finding that putting LIKE '%...%' first was quite useful, as I almost always put the % manually for any search I do. I suggest for the next -rc to put back LIKE in the first position, followed by LIKE %...%. We could also move the list of operators from tbl_select.php to config, but this would probably be too much. Comments? Marc

2 2

[Phpmyadmin-devel] latin1_swedish_ci
by Kenneth Porter 11 Aug '04

11 Aug '04

Just loaded 2.6.0-rc1, using MySQL 4.1.3 on Fedora Core 2. I enabled the controluser features and get the errors below when loading the initial page. Some googling turns up some character set collation changes in MySQL that are probably responsible but I don't see what I need to do to fix this. <http://dev.mysql.com/doc/mysql/en/InnoDB_news-4.1.3.html> <http://dev.mysql.com/doc/mysql/en/News-4.1.2.html> Running mysqlcheck --all-databases says everything's ok. All tables seem to have locked to the latin1_swedish_ci collation. SQL-query: DocumentationEdit SELECT COMMENT FROM `pma_column_info` WHERE db_name = 'bugs' AND table_name = '' AND column_name = '(db_comment)' MySQL said: Documentation #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' SQL-query: DocumentationEdit SELECT COMMENT FROM `pma_column_info` WHERE db_name = 'bugs' AND table_name = '' AND column_name = '(db_comment)' MySQL said: Documentation #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

2 1

[Phpmyadmin-devel] 2.6.0-rc1 ?
by Marc Delisle 10 Aug '04

10 Aug '04

Hi, how about release candidate 1 this Sunday? Marc

3 2

Re: [Phpmyadmin-devel] about LIKE '%...%'
by Garvin Hicking 10 Aug '04

10 Aug '04

Hi Marc! > We got some negative reports about putting this operator first in the > list. Concerns are about performance (wildcard being slower, and in > case of monster tables, slower meant > 45 min.). I must say I particulary enjoyed having that %...% as default. In my daily working (and those of my co-workers) we seldomly use exact matching when we're searching. I do think we should leave that as default, and when users want to have an exact match, it's no problem for them to switch to the exact matching. > We could also move the list of operators from tbl_select.php to config, > but this would probably be too much. Yes, I think that would be too much overhead... $0.02, Garvin -- Garvin Hicking | Web-Entwickler | Make me happy: www.supergarv.de | #ICQ 21392242 | http://wishes.garv.info/

1 0

[Phpmyadmin-devel] phpMyAdmin-2.6.0-rc1 is released
by Marc Delisle 08 Aug '04

08 Aug '04

_ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ 2.6.0-rc1 http://www.phpmyadmin.net phpMyAdmin 2.6.0-rc1 - August 8th, 2004 ======================================== A set of PHP-scripts to administrate MySQL over the Web. -------------------------------------------------------- Announcement ------------ The phpMyAdmin Project is proud to announce the immediate availability of the first release candidate of phpMyAdmin 2.6.0. Supporting the new improved MySQL extension of php5 (MySQLi), phpMyAdmin has made a giant step towards the upcoming PHP and MySQL versions. During beta-1, phpMyAdmin has acquired a new CSS-based theme system. Two themes are included, and can be chosen from the main menu. Full documentation about the theme system will be done before the final 2.6.0 version. As the new milestone should to be as stable as possible, any feedback about 2.6.0-rc1 would be appreciated. Please note, that it is not recommended to run this testing release on production environments. phpMyAdmin is a web administration tool for MySQL databases, intended to handle a whole database server as well as a single database. Over the years, it has become the most popular GUI for MySQL and is downloaded about 6,000 times a day, according to SourceForge.net. The highlights of this release in detail: Highlights ---------- Upgrade note: If you are using MySQL 4.1.2 or later, the pmadb must be in UTF-8. See "Linked-tables infrastructure" in Documentation.html for a way to correctly create the pmadb, or upgrade it. Improvements: * PHP 5 mysqli extension support o better performance o improved security * Improved support for character sets * Support for UTF-8 databases under MySQL 4.1 * Site-configurable header and footer * Export: o can add custom text to SQL export headers o support for IF NOT EXISTS o support for INSERT IGNORE and UPDATE IGNORE o use unbuffered queries o enclosing SQL export in a transaction o selective row export o improved ANSI compatibility * Operations: now copy table defaults to "structure and data" * Operations: database renaming * Editing: option "Go back to this page" * Sort: natural order (configurable) * Search page: DISTINCT, IS NULL, IS NOT NULL, NOT LIKE, multiple choices for ENUM * Left panel Logout link * Popup calendar (date and time editing) for date, datetime and timestamp fields * Set and alter collations for databases, tables and fields * Security: Protection against cookie hijacking: encrypt also the user name, and set a time limit on the validity of encrypted password in the cookie * "(Un)check all" link for privileges page * (alpha2)Optional display of server choice as links * (alpha2)Click on result row to mark the checkbox * (alpha2)Show if BLOB is NULL * (alpha2)Mouse cursor in db structure and table structure views * (alpha2)Multiple row insert * (alpha2)Search: new choice LIKE %...% * (alpha2)Can now change the number of columns when adding fields * (beta1)Graphical redesign (CSS-based) and theme management * (beta1)InnoDB table defragmentation * (beta1)Use one cookie per server * (beta1)Default query can now contain field names * (beta1)MySQL 4.1.2 support ("engine") * (beta1)Export: experimental native Ms Excel support * (beta1)Export: add FOREIGN_KEY_CHECKS=0 * (beta1)Auth: catch error when server is not responding * (beta1)Operations: can now specify sort order for "Alter table order by" * (beta1)Support for SHA1 function * (beta1)Enable Relation view for InnoDB even if internal relations infrastructure is not in place * (rc1)Export: hexadecimal encoding of binary fields is now optional * (rc1)Database statistics: add collations * (rc1)Now it's possible to choose our connection character set * (rc1)Support for GROUP_CONCAT() * (rc1)Improved sort order in dropdown list of foreign value Fixes: * Error parsing floating point digit and GRANT...TO * Numeric field names * Keyword field names become capitalized * Substr transformation broken with utf-8 * CONSTRAINT error in MySQL 3.23.x * MySQL charsets not added to WHERE clauses * Export: o on-the-fly compression problem o CSV problem with double-byte characters o UPDATE option does not work * Editing: o Invalid escaping of + in ENUM o Undefined submit_mult o Cannot edit first row when no primary key o Cannot edit big table structure o Multi-edit: changes are lost o Editing of double and float numbers o Charset information was lost when changing fields * Invalid row count when emptying table * Error on Delete link after a db search * Interface: Icons not displayed for index management * Problem when the query contains quotes * Wrong detection of the CREATE privilege * Problem when the bookmark table does not exist * Password error when copying a user * Search page and empty VARCHAR column * IIS crash: header problem * (alpha2)Invalid SQL on empty table export * (alpha2)Multi-byte functions and windows- charsets * (alpha2)Handling of USE in multiple queries * (alpha2)Light mode undefined indices * (alpha2)Consistent window layout for query window * (alpha2)Missing localization for multi-row edit/delete/export * (alpha2)Data dictionary: wrong formatting * (alpha2)Uploading with UploadDir and open_basedir restriction * (alpha2)Handling of complex sort queries * (alpha2)Nested mode: collapsing problem * (alpha2)Multi-edit: wrong tabindex ids * (alpha2)Calendar: maximum values * (alpha2)Privileges: wrong message when editing for non-existent db * (alpha2)Parser and multibyte strings * (alpha2)Browsing of foreign table: problem with encoding of the primary key reference * (alpha2)Cookie login: avoid double frames * (alpha2)Nested table now also works with aliases tablenames * (beta1)Nested table: wrong group expanding (foreign characters) * (beta1)Shorten query for edit/delete * (beta1)Database search: use SELECT * * (beta1)Error when deleting last row * (beta1)Vertical mode: broken row highlighting * (beta1)Better handling of MySQL comments (-- followed by any control character) * (beta1)Wrong internal encoding for Hebrew * (beta1)Ignore comments for SQL splitting * (beta1)Synchronize left frame database drop-down box (number of tables) * (beta2)Undefined index in left frame * (beta2)Undefined variable db * (beta2)Granting privileges does not take wildcards into account * (beta2)Left frame does not reload on CREATE TABLE * (beta2)Exporting and more than one foreign key * (beta2)Javascript error when changing theme * (beta2)Warning in mysql.dbi.lib.php * (beta2)During table creation, query window tries to get the list of fields * (rc1)Security: fixes vulnerability disclosed on BUGTRAQ on 2004-06-29 * (rc1)Export: Fix export of '0' strings * (rc1)Export: Fix export of queries with empty WHERE clause * (rc1)Copying a table containing a TIMESTAMP under MySQL 4.1.2+ * (rc1)Could not create a primary key when there was none before * (rc1)DATETIME field export under MySQL 4.1.3 * (rc1)Error copying table data only * (rc1)Navigation: last page button did not show last page number * (rc1)Functions: some functions do not take parameters * (rc1)Wrong table options for non-MyISAM tables * (rc1)Undefined offset when no display field has been defined Detailed list of changes since version 2.2.0 is available under http://www.phpmyadmin.net/ChangeLog.txt Availability ------------ This software is available under the GNU General Public License V2.0. You can get the newest version at http://www.phpmyadmin.net/ Available file formats are: .zip, .tar.gz and .tar.bz2. If you install phpMyAdmin on your system, it's recommended to subscribe to the news mailing list by adding your address under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news This way, you will be informed of new updates and security fixes. It is a read only list, and traffic is not greater than a few mail every year. Support and Documentation ------------------------- The documentation is included in the software package as text and HTML file, but can also be downloaded from: http://www.phpmyadmin.net/documentation/ The software is provided as is without any express or implied warranty, but there is a bugs tracker page under: http://sourceforge.net/projects/phpmyadmin/ [click on "Bugs"] In addition, there are also a number of discussion lists related to phpMyAdmin. A list of mailing lists with archives is available at: http://sourceforge.net/mail/?group_id=23067 or http://sourceforge.net/projects/phpmyadmin/ [click on "Lists"] Finally, an users support forum is also available under: http://sourceforge.net/forum/forum.php?forum_id=72909 Known bugs ---------- - phpMyAdmin SQL parser chokes on fieldnames with certain non-ASCII characters (bugs #593598, #936161). To be informed about new releases fixing these problems, please subscribe to the news mailing list under http://lists.sourceforge.net/lists/listinfo/phpmyadmin-news or regularly check the sourceforge bugs tracker. Donations --------- The project accepts donations to help improve the product. There is a "Donations" link on http://www.phpmyadmin.net. Description ----------- phpMyAdmin is intended to handle the administration of MySQL over the Web. It can manage a whole MySQL server as well as a single database. Currently it can: - create and drop databases - create, copy, drop, rename and alter tables - do table maintenance - delete, edit and add fields - execute any SQL-statement, even batch-queries - manage keys on fields - load text files into tables - create and read dumps of tables - export data to CSV, XML and Latex formats - administer multiple servers - manage MySQL users and privileges - check referential integrity - using Query-by-example (QBE), create complex queries automatically connecting required tables - create PDF graphics of your Database layout - search globally in a database or a subset of it - communicate in 47 different languages Authors & Copyright ------------------- Copyright (C) 1998-2000 Tobias Ratschiller <tobias_at_ratschiller.com> Copyright (C) 2001-2004 Marc Delisle <DelislMa_at_CollegeSherbrooke.qc.ca> Olivier Müller <om_at_omnis.ch> Robin Johnson <robbat2_at_users.sourceforge.net> Alexander M. Turek <me_at_derrabus.de> Michal Cihar <michal_at_cihar.com> Garvin Hicking <me_at_supergarv.de> Marcel Tschopp <ne0x_at_users.sourceforge.net> + many other people (check the CREDITS section of our documentation) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA EOF -- Alexander M. Turek and Marc Delisle/ 2004-08-08

1 0

[Phpmyadmin-devel] CVS stats
by Michal Čihař 06 Aug '04

06 Aug '04

Hi all just needed some cvs stats for another project, so when I was playing with cvschangelogbuilder I also generated one for phpMyAdmin, it gives quite impressive numbers :-). If you are interested look at: http://www.cihar.com/phpMyAdmin/stats/ (The page has about 1.5 MB, so be careful, when you're on slow connection :-)) -- Michal Čihař | http://cihar.com

2 1

[Phpmyadmin-devel] cron on sourceforge
by Marc Delisle 02 Aug '04

02 Aug '04

Hi, as you may know, cron is currently disabled on sourceforge. Meanwhile I generate every few days the snapshot and the demo update. Marc

1 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

Developers August 2004