Developers August 2001

developers@phpmyadmin.net

26 participants
147 discussions

[Phpmyadmin-devel] div things
by Olivier M. 15 Aug '01

15 Aug '01

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

1 0

[Phpmyadmin-devel] Re: load data bug
by Loïc 15 Aug '01

15 Aug '01

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

1 0

[Phpmyadmin-devel] suggestion for csv export
by Dan Allen 14 Aug '01

14 Aug '01

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/

1 0

[Phpmyadmin-devel] suggestion for reloading of left.php
by Dan Allen 14 Aug '01

14 Aug '01

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/

4 3

[Phpmyadmin-devel] load data bug
by Dan Allen 14 Aug '01

14 Aug '01

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/

1 0

[Phpmyadmin-devel] Bug #449858, Error Changing Column DataType
by Robin Johnson 14 Aug '01

14 Aug '01

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.com ebb.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-----

2 4

[Phpmyadmin-devel] Rejoining
by Robin Johnson 13 Aug '01

13 Aug '01

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.com ebb.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-----

4 8

[Phpmyadmin-devel] HTTP compilance
by Benjamin Gandon 13 Aug '01

13 Aug '01

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 :)).

2 1

[Phpmyadmin-devel] problem with expand_sql_query()
by Marc Delisle 13 Aug '01

13 Aug '01

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

2 2

[Phpmyadmin-devel] query results
by Dan Allen 12 Aug '01

12 Aug '01

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

2 1

← Newer
1
...
7
8
9
10
11
12
13
14
15
Older →

Jump to page:

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 2001