The Internet, 2003-12-28
Greetings,
The phpMyAdmin development team is pleased to announce
the availability of phpMyAdmin 2.5.5.
About version 2.5.5
===================
New minimum version requirements:
phpMyAdmin now requires at least PHP 4.1.x and MySQL 3.23.32.
MySQL 4.1 / 5.0 Note:
phpMyAdmin's support for MySQL 4.1 / 5.0 is still experimental
Improvements:
* General code optimization by removing old PHP3-compatibility
* Make default functions configurable
* Visual scratchboard: show column names
* Show overhead in table list, allow to check all overheaded tables
at once
* Export: can suppress dates information
* MySQL error messages improved formatting
* Printview: display linked values and other relational features
* Export: allow delayed INSERTs, and support for UPDATE and REPLACE
statements
* Show result of last SHOW query when using multiple queries
* Can now specify the default query
* Catch table renaming with dot in the new name
* Multi-row edit
* Date MIME transformation: show also real data before transformation
* New language: Basque
* Printview: show number of rows
Fixes:
* Relation view: non-unique keys were not displayed as possible
choices for foreign keys
* Try to upload history in table only if configured so
* Opera and Export dynamic options
* Try to show sorting by indexes only if makes sense
* Some undefined variables
* SQL-history and js errors
* Export and CSV for Excel can now choose the Excel edition
* Multi-row delete in vertical mode
* Execute stored bookmarks had a problem
* Transformations: now allow more timestamps
* Export: added XML header
* Could not enter the string "NULL"
* Export: fixed LaTeX output, and unique fields are now bold
* Export: foreign keys problem
* FULLTEXT is possible not just on TEXT but also MEDIUMTEXT, etc
* Now we can kill more processes
* Display problem with repeated headers
* In Server view, left frame did not keep server choice, language, etc
* Sort on some aliased columns did not work
* Left panel and non-escaping of single quotes
* Backquotes were present in the db name choice for Create db
* Support for FORCE INDEX
* Problem when DROPping the only remaining db
* Fix moving foreign key definition on Windows
* Go & Bookmark problem with queries having a "+" in them
* Print view on non-IE browsers
Download/support information on http://www.phpmyadmin.net.
Marc Delisle, for the team.
The Internet, 2003-12-14
Greetings,
The phpMyAdmin development team is pleased to announce
the availability of the second release candidate for phpMyAdmin 2.5.5.
About 2.5.5-rc2
---------------
New minimum version requirements:
phpMyAdmin now requires at least PHP 4.1.x and MySQL 3.23.32.
MySQL 4.1 Note:
phpMyAdmin's MySQL 4.1 support is still experimental
Improvements:
* General code optimization by removing old PHP3-compatibility
* Make default functions configurable
* Visual scratchboard: show column names
* Show overhead in table list, allow to check all overheaded tables
at once
* Export: can suppress dates information
* MySQL error messages improved formatting
* Printview: display linked values and other relational features
* Export: allow delayed INSERTs, and support for UPDATE and REPLACE
statements
* Show result of last SHOW query when using multiple queries
* Can now specify the default query
* Catch table renaming with dot in the new name
* Multi-row edit
* Date MIME transformation: show also real data before transformation
* New language: Basque
* Printview: show number of rows
Fixes:
* Relation view: non-unique keys were not displayed as possible
choices for foreign keys
* Try to upload history in table only if configured so
* Opera and Export dynamic options
* Try to show sorting by indexes only if makes sense
* Some undefined variables
* SQL-history and js errors
* Export and CSV for Excel can now choose the Excel edition
* Multi-row delete in vertical mode
* Execute stored bookmarks had a problem
* Transformations: now allow more timestamps
* Export: added XML header
* Could not enter the string "NULL"
* Export: fixed LaTeX output, and unique fields are now bold
* Export: foreign keys problem
* FULLTEXT is possible not just on TEXT but also MEDIUMTEXT, etc
* Now we can kill more processes
* Display problem with repeated headers
* In Server view, left frame did not keep server choice, language, etc
* Sort on some aliased columns did not work
* Left panel and non-escaping of single quotes
* Backquotes were present in the db name choice for Create db
* Support for FORCE INDEX
* Problem when DROPping the only remaining db
* Fix moving foreign key definition on Windows
Download/support information on http://www.phpmyadmin.net
or http://phpmyadmin.sourceforge.net.
Marc Delisle, for the team.
SF bug tracker refuses new submissions for the moment (at least in our
project)
so I submit this here for comments.
Thanks,
Marc
--------------
From Andrew Weiner:
I get the following error in export.php when using the
export tab and choose save as file and save on server is
checked.
Warning: Compilation failed: missing terminating ] for
character class at offset 4 in /phpMyAdmin/export.php on line
251
Line 251:
$save_filename = $cfg['SaveDir'] . preg_replace('@[/\\]
@','_',$filename);
There seems to be problems with the preg_replace syntax in
various phpMyAdmin files. In general the regex should be
delimited with a / on either side of the expression example:
preg_replace('/@[/\\]@/','_',$filename);
In this particular error bracketing the expression produces the
following error:
Warning: Unknown modifier '\' in /phpMyAdmin/export.php on
line 251
Please look into this and make the necessary modifications.
Thanks,
Andrew
Hi,
In order to make an end studies work in the domain of visualization and navigation into a relational database, I would like to use PhpMyAdmin as a library. The purpose of the work is to make another graphical interface allowing the users to navigate through the records of the database following the hypertext links on foreign keys, as it is now implemented into PhpMyAdmin. The difference with wath PhpMyAdmin offers is that the users shouldn't have access to the "administration" functions. Typically, it will work with only one database, showing all tables and records and allowing to follow the hypertext links on foreign keys (with some variants like not showing the value of the key (often an id) but perhaps some other more meaningful value recored in the foreign table) and allowing to make some SQL queries but without write-privileges on the db. No other functionnality is required, the interface must stay simple enough to allow navigation by many "not initiated to informatics" people.
1) Do you think using PhpMyAdmin as a library is possible? Is it enough modularized to allow me to use PhpMyAdmin through an API without much difficulties?
2) Do you have docs showing how PhpMyAdmin is constructed? (Class diagram, include files diagram, a table saying wich file does wath, a document explaining the structure of PhpMyAdmin, or something else) If yes, is it possible to receive this?
3) I think it would be the best to develop my application using PHP but do you know if it is possible to call php functions from Java? (This is possible for C or C++ functions through the Java Native Interface but I don't know for PHP)
In advance, thank you very much for you help,
MEYTS Michaël.
Hi,
I will wait a few days before creating the maintenance branch
for 2.5.5, unless someone really wants to start some development
for the next version. This way, fixes will be merged faster
(just in HEAD).
Marc