Hello,
Still learning for my exams, but spent a moment on phpmyadmin
this afternoon:
- removed or recategorised some of the bugs (target: nb_bugs -> 0... :)
if you have some time, feel free to review some of the unasigned
bugs, and don't hesitate to close or move them to the feature
request page if you think it's necessary
- applied 2 patches:
- display of nb of tables on db_details (#451138)
- limiting length of displayed strings in browse view (#451137)
- added display of nb of tables in left.php : I don't know if you
will like it, but I find that practical on my server with 150 db's :)
(would be easy to remove if necessary: please comment!)
- made some tests und ns and opera
I'm happy to see the bugs list shrinking :) There are still a few
big bugs which need work before -final but it seems they are already
all assigned, so it seems to be on the right way.
I got several mails from people waiting for the real 2.2.0, for
example somebody working on the Sun Cobalt Server Appliances
software (they want to include phpMyAdmin): I "promised" him
it would be ready in 3-4 weeks: I hope it will the case :)
Voila, c'est tout :) Thanks for your work & see you later!
Olivier
--
_________________________________________________________________
Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland
qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
Hi Dan & all!
I've merged your fix into the CVS.
Thanks,
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
For the CSV export, should there be a "fields
escaped by option" and then optionally for
strings and not numbers, just like on import??
Dan Allen
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
Right now, if you use the form on the
db_details.php page to create either a new
database or a new table, it knows to update the
left.php frame since either new tables or new
databases are there...oh, and same thing with
drop. However, if either of these queries are
executed from the SQL query box....the frame is
not reloaded and the new tables/databases or the
lack thereof are not updated for the rest of the
session (without of course a force reload or
other action which would cause it already).
Anyway, long story short, we should run ereg on
the query and search for CREATE or DROP at the
beginning
ereg("^CREATE|^DROP",$query)
and then reload the left.php if either of those
are found.
Dan Allen
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
I came across a bug today in the load data from
infile. I had data in a text file that had rows
terminated with a line feed (\n). When the query
was executed, it echoed
...LINES TERMINATED BY "\\n"
however, that is incorrect because it is escaping
the \ so that it is not interpreted as a line fed
but literately as "\n"
The problem is, when the line termination
varibable goes into ldi_check.php, it strips the
slashes if magic quote are enabled...and then it
runs the sql_addslashes function, however, this
is not correct...it should only add slashes for
the single quotes and not for the backslashes if
it is backslash \n \r or both...Anyway...check
out the patch to the CVS version
Dan Allen
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
Could somebody else please have a look at the sf bug page for this one,
and see if they have any other possible solutions that could be used for
this bug? I'll give 12 hours before I work on it.
--
Robin Hugh Johnson
QTOD: "I used to be an idealist, but I got mugged by reality."
E-Mail : robbat2(a)orbis-terrarum.net
ICQ# : 30269588 or 41961639
Home Page : http://www.orbis-terrarum.net/
Time Zone : Pacific Daylight (GMT - 8)
-----BEGIN GEEK CODE-----
geekcode.comebb.org/ungeek
GCS/M/IT d-(+) s+:- a--- C++++
U++++ L++++ P--(+) W++ K++ PS+
N++ w--- O E---- M-(+) V-- Y++
PE++ PGP++ t-- 5 X+ R tv- b+++
D++ G++ e(*) h! r-- !y+
------END GEEK CODE------
-----PGP INFO----
Key ID:0x7E20DFA1
FingerPrint:
5447C73A 30FB144C 89521B69 2D6A615E 7E20DFA1
----PGP INFO-----
Hi All,
After a long sabbatical from developing on phpMyAdmin, due to final exams
and a month long vacation in South Africa [able to check my email only
with a 14.4 modem :-( ], I'm now coming back to carry on working.
I have noticed a few new bits popping into phpMyAdmin since i've been
using it as a user while I have been doing other things, and some of the
new bits are definetly getting places.
Just looking at the current status, 2.2.0-rc4, I'd assume we're working on
fixing as many bugs as possible to be ready for -final. What are the most
pressing issues that I can get to work on, and when are we aiming to
release -final by?
--
Robin Hugh Johnson
QTOD: "I used to be an idealist, but I got mugged by reality."
E-Mail : robbat2(a)orbis-terrarum.net
ICQ# : 30269588 or 41961639
Home Page : http://www.orbis-terrarum.net/
Time Zone : Pacific Daylight (GMT - 8)
-----BEGIN GEEK CODE-----
geekcode.comebb.org/ungeek
GCS/M/IT d-(+) s+:- a--- C++++
U++++ L++++ P--(+) W++ K++ PS+
N++ w--- O E---- M-(+) V-- Y++
PE++ PGP++ t-- 5 X+ R tv- b+++
D++ G++ e(*) h! r-- !y+
------END GEEK CODE------
-----PGP INFO----
Key ID:0x7E20DFA1
FingerPrint:
5447C73A 30FB144C 89521B69 2D6A615E 7E20DFA1
----PGP INFO-----
I've just pointed out that we use the "Location:" HTTP header
field in a manner that is not HTTP complilant. It seems that it
work because browsers seem to respect Postel's advice ("be
conservative in what you send and liberal in what you accept").
rfc 2816 says:
Location = "Location" ":" absoluteURI
An example is:
Location: http://www.w3.org/pub/WWW/People.html
And we use for example:
tbl_select.php3:181: header('Location: sql.php3?' . $url_query);
And that is quite not an absolute URI...
I didn't find any suitable header in rfc2616 that could replace
the "Location:" one and accept relative URI. ("Content-Location:"
is quite good but it does not specify a replacement for the original
requested URI).
It seems that in order to have phpMyAdmin generate absolute URI in
"Location:" HTTP headers, we have to introduce a configuration
variable that would hold the absolute path (server name + path!).
I don't think solving this is urgent because it works fine like that
(except lynx who warns the user that the Location URL is not absolute
and then goes to the right place).
We can postpone that for a later version or let it go and just document
that we do that (My lazyness would recommend letting it go :)).
Hi,
trying this with current cvs:
CREATE TABLE Binary_Table (
ID mediumint(8) unsigned NOT NULL auto_increment,
MyData blob NOT NULL,
PRIMARY KEY (ID)
) TYPE=MyISAM;
I get an allocation memory error in lib.inc.php3, line 1608.
Marc
Sorry for so many posts, but I have a lot of suggestions...
Right now, if you run a query (and not just a browse), it does not
return the total results...it only shows you 0 to 30 and then the
navigation buttons appear depending on whether there are more than 30
results. The reason for this is in lib.inc.php in the dispaly_table
function. This is how it should be....
if (!$is_simple&&!empty($db)) {
$result = mysql_query($sql_query);
$total = mysql_num_rows($result);
} // end if
whereas before it only ran the query for a browse by just counting all
the rows in the table...in fact, what needs to happen is the query needs
to be run again without LIMIT 30,0 to get the total number of rows...it
should be quite fast and maybe this can be a configuration option to
always calculate the total results returned...This way, you can add a
"Show All" button that will break out of the LIMIT, useful when you want
to get all the rows from a search repeatedly...
Dan Allen