-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi list,
There's a small change that I'd like to see in 2.6.1, but I don't have
the time to implement it.
MySQL 4.1 supports adding comments on column level. Afaik, phpMyAdmin
only supports its own column comments, but not MySQL's native ones.
On top of that, I think that column comments don't fit into the relation
overview. I'd rather move the interface to the table structure editor.
This should be the preferred way to perform this operation.
Comments?
Regards,
AMT
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)
iD8DBQFBqfNM8c/ssWf/SMcRAnKnAJ49xllPYAspKmjU3GCJUI1ei2jf1gCeLX0D
BcOZFpe7X0TR8VNAvpPF6RM=
=eH72
-----END PGP SIGNATURE-----
Hi all,
Michael Keck just checked the themes
in the themes tracker for security issues.
We could announce that the themes tracker is to submit new themes,
and use a new mechanism to distribute them:
- create a new cvs module for the themes
- commit there the themes from the tracker, after inspection
- create a downloadable "themes" kit (I prefer only one kit)
- maybe play with the SF Screenshots feature to see what is possible
Marc
I have created the package theme-CacticaBlues and a new release.
This kit has been "checked" by Michael.
I used release 1.0 but I was not sure. If we say for example 2.6.1,
how will people react when PMA reaches 2.6.2? Would we have to release
each theme for each PMA version, even if they do not change?
Marc
Michael Keck a écrit:
> Okay,
>
> that would'nt be a problem.
> Is there a uri available for downloading themes? Posting new themes can
> we do over the theme-tracker.
> I will patch the box 'Themes' with to links (one for download and one
> for posting) and coding a download-area for themes, with an global
> include like we've done with releases.
>
> Michael
>
>
>
> Marc Delisle schrieb:
>
>> Michael,
>>
>> There is a limit of 6 screenshots, and it seems we cannot put links
>> or thumbnails. So I guess that for themes we should put them on
>> our home page where we control the behavior.
>>
>> Marc
>>
>> Michael Keck a écrit:
>>
>>> Hi,
>>>
>>> Marc, is it possible to put on the screenshots page html-text
>>> like links?
>>> Perhabs we can upload there some screens for the themes and
>>> link to the theme/whatever.zip.
>>> Can we put there smaller images (as thumbnails) and a link
>>> to the bigger view?
>>>
>>> Michael
>>>
Please let me check this during lunch time :)
I have to add a new package like "theme-star-wars".
Or does someone have a better naming scheme for downloadable themes?
Marc
Michael Keck a écrit:
> Okay,
>
> that would'nt be a problem.
> Is there a uri available for downloading themes? Posting new themes can
> we do over the theme-tracker.
> I will patch the box 'Themes' with to links (one for download and one
> for posting) and coding a download-area for themes, with an global
> include like we've done with releases.
>
> Michael
>
>
>
> Marc Delisle schrieb:
>
>> Michael,
>>
>> There is a limit of 6 screenshots, and it seems we cannot put links
>> or thumbnails. So I guess that for themes we should put them on
>> our home page where we control the behavior.
>>
>> Marc
>>
>> Michael Keck a écrit:
>>
>>> Hi,
>>>
>>> Marc, is it possible to put on the screenshots page html-text
>>> like links?
>>> Perhabs we can upload there some screens for the themes and
>>> link to the theme/whatever.zip.
>>> Can we put there smaller images (as thumbnails) and a link
>>> to the bigger view?
>>>
>>> Michael
>>>
_ __ __ _ _ _
_ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __
| "_ \| "_ \| "_ \| |\/| | | | | / _ \ / _` | "_ ` _ \| | "_ \
| |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | |
| .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_|
|_| |_| |___/ 2.6.1
http://www.phpmyadmin.net
phpMyAdmin 2.6.1 - January 23rd, 2005
=====================================
A set of PHP-scripts to administrate MySQL over the Web.
--------------------------------------------------------
Announcement
------------
The phpMyAdmin Project is proud to announce the immediate
availability of phpMyAdmin 2.6.1.
Almost four months have passed since 2.6.0, although three patch releases
were made to take care of several security alerts we received. In 2.6.1
there are two more security fixes. As a consequence of one of these fixes,
if you want to use MIME-based external transformations you have to use a
PHP version of 4.3.0 or later.
A major speed improvement for users of the "cookie" authentication type
is included starting from 2.6.1-rc1, but you must be running on a Web
server with the mcrypt PHP module.
Another improvement worth mentionning, which relates to a new feature
offered on MySQL 4.1.2+: on multi-user installations, the control user
no longer needs to have any rights to the "mysql" db. It is now only used
to access the linked-tables infrastructure (pmadb).
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:
* Using external transformations now requires PHP > 4.3.0
Improvements:
* Major speed improvement (if using auth_type = 'cookie') by using the
mcrypt library (if available on your system)
* Improved wording when adding fields
* (mysqli) support for compressed protocol and CLIENT_LOCAL_FILES
* Clickable active server in left panel
* Improved ANSI mode in various scripts
* Hints added (light bulb)
* Database copying
* New Database Operations tab: note that many db operations have been moved
here, including the PDF schema generation dialog
* Optional simple blocking of root login
* Binary log display
* Index creating on multiple fields
* Improved displaying of messages below tabs
* Handle MySQL "duplicate entry" error
* User list: top index for user initials
* Support for OLD_PASSWORD() function
* Under MySQL 4.1.2+, we no longer need the control user to have rights
over the "mysql" db
* New checks for common index problems
* Upload: show filename of uploaded file
* Improved page selector when browsing foreign table values
* Improved handling of InnoDB constraints
* Speed up display for left panel with PMA infrastructure is used
* New message "no activity..."
* Support of keywords NAMES and VIEW
* Can now edit next entry (based on the next numeric primary key)
* New warnings related to the use of mbstring
* Improved navigation in calendar
* Export: selectable SQL compatibility
* PDF schema: added support for output in UTF-8
Fixes:
* Security fix against some crafted data allowing arbitrary program
execution (if PHP safe mode is off and external transformations are activated)
* Security fix against a possible attack on read_dump.php (if PHP safe mode
is off)
* Incorrect appending of LIMIT to queries
* Export: insufficient space to save
* Export: convert end of line chars we get from MySQL
* Wrong double column sort (with JOIN)
* Export: (mysqli) some fields wrongly exported as BINARY
* Illegal mix of collations for converted strings
* Wrong tabbing from value to value
* Allow work on temporary tables
* UNIX_TIMESTAMP and optional parameter
* Export: improved zip headers
* 0 as field name caused problems
* Incorrect handling when no default server defined
* Export: Use just for SQL exports
* Comments and multi-table selects
* Security: deactivate the list of programs for external transformations
* Incorrect handling of OFFSET
* Better displaying of table-specific privileges for a db containing an
escaped character
* Since 2.6.0-pl3, connecting on a non-standard HTTP port did not work
* Do not catch Alt and Shift keys
* Do not duplicate constraints when exporting multiple databases
* Illegal length for LONGTEXT
* Moving/copying a table: problem with constraints copying
* Reloading frame on multiple queries
* Collations on non-text fields
* Use standardized MIME type for gzip/bzip2
* Problem with field names like 000
* Timestamps problem under MySQL 4.1.x
* Support Option key for field moving in Safari
* Error when adding a FLOAT field under MySQL 4.1.x
* Headers sent on invalid login
* Wrong treatment of MySQL error 1060
* Problem in bookmark logic when using MySQLi
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, copy 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-2005 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
Marc Delisle/ 2005-01-23
Hi,
What is the preferred way to debug phpmyadmin? I have php dbg installed
but that seems difficult to use in a multipage web context. What kind
of debug environment do you guys use?
Cheers,
Brian
Hello,
I've tested a few things today, here is a little something
to (re-)open the discussion :) I think it would be nice if PMA
would have a simple configuration generator, like in many
other projects:
What about something simple like that? :
http://www.phpmyadmin.net/swix_pma/setup/
Scoll to the end of the page to find the [generate] button.
It's based on the orginal Documentation.html, with
some special "cfgen" tags, which are simply parsed
by the setup/index.php script. (look at the .html source of
the original http://www.phpmyadmin.net/swix_pma/Documentation.html )
source: http://www.phpmyadmin.net/swix_pma/setup/index.phps
and http://www.phpmyadmin.net/swix_pma/setup/generate.phps
The generate.php script needs a special version
of the config.inc.php files (with lines like:
"$cfg['blowfish_secret'] = '%%blowfish_secret%%'; ")
Do you think something like that would be good?
Is that the right way? Feedback welcome :)
regards & have a nice week-end,
Olivier
--
_______________________________________________________
Olivier Müller - PGP key ID: 0x0E84D2EA - Switzerland
E-Mail: http://omx.ch/mail/ - AIM/iChat: swix3k
