Developers

developers@phpmyadmin.net

7004 discussions

[Phpmyadmin-devel] preg vs. ereg
by Robin Johnson 19 Aug '01

19 Aug '01

Ok, looking under 'Support Requests' (#447076) there is a note about using ereg instead of preg, so i went back to convert my lone instance of a preg in the code. But try as hard as I might, I can't manage to use eregi_replace to do the same thing as my bit of code. lib.inc.php3 - line 694 $sql = preg_replace( '/\W'.$data[1].'\./i', ' '.$data[0].'.', $sql); Could somebody else make a suggestion about the query I can use? my best conversion of the pcre was "[!a-zA-Z0-9_]".$data[1]."\." but that doesn't work :-(. I have also realized that my code adds a nasty little bug. this is the SQL i was using to test the above: SELECT c.id, s.id FROM classes c, staff s WHERE c.staff = s.id ORDER BY s.id now if i change the fields section at the start just slightly, and the where clause by taking out some of the white space: SELECT c.id,s.id FROM classes c, staff s WHERE c.staff=s.id ORDER BY s.id then the ',' in the fields gets replaced with a space, and your perfectly valid query is now invalid. The same thing happens with the '=' in the where clause. We need to find a way to preserve the other character that matched the \W in the pcre as well as add a space after it. I had the \W in there so that trying to match 's.' would not match 'foods.' . Any suggestions on this one? -- 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-----

3 3

Re: [Phpmyadmin-devel] Re: 2.2.0-final: when ?
by Loïc 19 Aug '01

19 Aug '01

Olivier, there were some problems with your fix for file upload. I've fixed them. 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] Re: 2.2.0-final: when ?
by Loïc 19 Aug '01

19 Aug '01

Bonsoir, Hi! >Do you think we will manage to fix all the current bugs >in the 10 next days ? Nope but I agree with Marc: the "zero-bug-target" will just mean to never release a plain new revision. >What are the most important show-stoppers for the moment ? I can't imagine a way to trully fix the bug with binary fields as I've already wrote in my previous mail. So it's not a show-stoppers IMHO, as soon as we achive a work-around in the case when cfgProtectBlob is TRUE. The bug #448223 (Dump hangs) is really annoying. I'm not sure it's trully a bug (maybe only a set_time_limit problem) but I don't have big enough databases to face it. Maybe we should also have a look at this suggestion: https://sourceforge.net/forum/forum.php?thread_id=127981&forum_id=72908 It's a really nice improvement that should not require too much work. I'm currently working on the bug #450255 (new javascript error with netscape3) and then will work on the second bug from bug report #449817 (2 bug in db_details.php). Witha bit of luck, these ones would be fixed within a few days. One thing that may be done before releasing: when you submit a query from a query box, the script always returns to 'db_details.php3' even if this query box were in 'tbl_properties.php3'. Not so nice and maybe easy to fix. This also means to return back to 'db_details.php3' if the current table has been dropped and to 'main.php3' if the current database has been dropped (I've already done this stuff and am testing it). Another similiar problem I've faced today: in advanced mode, if one db that do not exist is associated to the user, this db name is nevertheless set into the $dblib array (see lib.inc.php3, lines 194-197: nowhere the existence of the db is tested) and then this cause many problems all over the scripts. But the main show-stoppers is the user administration pages: I can't find enough contigous time to rewrite it according to our standards, take care of the js validity and remove the htmlspecialchars problems :( >Suggestion for the release plan / tasks list: >[ ] every developper tests so many things as possible, and > in both modes (adv auth and std), especially file upload > things, and every new features. ...and with magic_quote_gpc set to 'on' and 'off' ;) Regards from a rainy day at Versailles :( 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

2 1

Re: [Phpmyadmin-devel] Open bugs
by Loïc 19 Aug '01

19 Aug '01

Hi Robin & all! >I was going through the entire list of bugs, trying to see about getting >the number down, and it struck me that several have resolutions that would >indicate they are ready to be closed. Would the relevant people please >close off their bugs if they are done with them? Nope because if we close them now (before the next rc or plain version is released) some user will re-create them. Setting their priority to 1 is a way to let users know they are known bugs and, for us, to know they have been fixed till last rc. >In addition, we could maybe move this to a feature reqeust? >Resolution: 'Later' You're right for this one. 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] Open bugs
by Robin Johnson 19 Aug '01

19 Aug '01

I was going through the entire list of bugs, trying to see about getting the number down, and it struck me that several have resolutions that would indicate they are ready to be closed. Would the relevant people please close off their bugs if they are done with them? Resolution: 'Fixed' [ #444354 ] Various backslash problems [ #446982 ] Dump files ignored with Windows server [ #449430 ] (RC4) Quote/Select bug [ #450906 ] Disappearing + in data | 2.2.0rc4 [ #451085 ] (RC4) Can't assign NULL value to char(1) Resolution: 'Works for Me' [ #443499 ] Unable to "Insert textfile into table" In addition, we could maybe move this to a feature reqeust? Resolution: 'Later' [ #429945 ] After logout, can't login with same user -- 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-----

1 0

Re: [Phpmyadmin-devel] icq/aim/irc...
by Loïc 18 Aug '01

18 Aug '01

Hi all! Sorry but I don't use any of these soft. 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

3 2

[Phpmyadmin-devel] 2.2.0-final: when ?
by Olivier M. 18 Aug '01

18 Aug '01

Bonjour :) Everything is in the Subject-line... The homepage is currently saying: August 2001: 2.2.0-final. Do you think we will manage to fix all the current bugs in the 10 next days ? What are the most important show-stoppers for the moment ? If you are looking for thinks to fix, beside the bugs tracker, also check the http://www.phpwizard.net/phorum/list.php?f=1 forum: there are lots of people "crying" there... : sometimes for little things, but also about important problems. Otherwise I should maybe already do a pessimistic s/August/September/ on the index.html page... :) Thanks in advance for your feedback & Have a nice week-end! Olivier -- _________________________________________________________________ Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch

7 9

[Phpmyadmin-devel] our live demo
by Marc Delisle 18 Aug '01

18 Aug '01

Hi, I would like to know how stable is this demo. Do we have control over its stability? Trying to create table in it, generates "no database selected". Marc

3 4

[Phpmyadmin-devel] Re[3]: testing latest Loic patches
by Loïc 17 Aug '01

17 Aug '01

About the number of tables in left.php3, Marc wrote: >I am not sure if we will keep this left frame addition, I find it more difficult >to read db names. That's the reason why I lowered the font size for this information. But I agree it's more difficult to read tables' name. About databases properties: >In current cvs version, I already see the number of tables after the word Sum. The current cvs displays: | Table | Action | Records | Size | ............................................. | Sum (number1 table(s)) | number2 | size | I would prefer: | Table | Action | Records | Size | ............................................. | number1 | Sum | number2 | size | where number1 is the number of tables, number2 the number of records and size the size of table. 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

3 2

[Phpmyadmin-devel] Re: testing latest Loic patches
by Loïc 17 Aug '01

17 Aug '01

Hi Steve & list! About the left frame, Steve wrote: >nice changes, but i thinks the default value of $cfgLeftWidth >its to small, the most of my databases in left.php have >now a new line. It's a IE5+ bug. Nothing to do in the code unfortunatly. I've got a suggestion about the other improvement Olivier sets: the number of tables in db_details.php3 because I don't like its design very much. Why not to just have something like this for the last row: | Table | Action | Records | Size | ............................................. | number | Sum | number | size | where number and size are the values? Regards, 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

2 1

Jump to page:

2025

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