- Developers - lists.phpmyadmin.net

RE: [Phpmyadmin-devel] Big bug to confirm!
by Loïc 28 Aug '01

28 Aug '01

Hi Benjamin & all! >Well I find that quite strange. I had tested a bit and really thought >comments were harmless in sql queries. My tests: remove the call to remove_remarks in db_readdump.php3 then try to upload and execute a dump file containing: ---------- file start here --------- # table `test2` structure CREATE TABLE test2 ( id mediumint(8) NOT NULL auto_increment, value text NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM; # table `test2` data INSERT INTO test2 VALUES (1,'normal data'); INSERT INTO test2 VALUES (2,'!!! Exclamation !!!'); ------ eof ------------- You should be displayed an error message because since... - ... the first comment line and the "create table" statement are submitted at once... - ... and the second comment line and the first "insert into" statement are they are submitted at once... ... mysql understand that the only instruction to execute is the second "insert into" statement, all other lines are comments :( >Anyway, if you try to remove comments again, you have >to ignore '#' that are in SQL strings if you don't want to >bring back the # bug (#444279). That's the annoying point... 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

Re: [Phpmyadmin-devel] patch for tbl_dump.php
by Loïc 28 Aug '01

28 Aug '01

Hi Marc & all! >Just tested with IE 5.0 some dumps, both with .sql and .gz: >the files generated are ok, Great :) >however after the file is saved, IE is still doing something, >don't know what. Maybe cleaning memory from useless segments? (I still can't face the "dump hangs" bug). >Any other tests needed? Not at this time, thanks. I've opened a bug report with known aliases bugs with the current cvs version (bug #456119). I wonder if these ones are showstoppers or not... I'm currently working on bug #444279 that resurfaced since we have to use back the remove_remark function. 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

Re: [Phpmyadmin-devel] patch for tbl_dump.php
by Loïc 28 Aug '01

28 Aug '01

Hi again! The patch from Dan & Ignacio is merged into the CVS. I cannot retain the "text/plain" mime type because most of the browsers do not suggest to download the generated file with it but displays it on screen. BTW I think there is a problem with the "attachment" clause in the "Content-Disposition" header and IE5.0. Can someone test this? 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] frustrating problem with NULL values in number fields
by Loïc 28 Aug '01

28 Aug '01

Hi Dan & list! I've tried to fix this problem. Please have a look at the last CVS revision and tell me if it works. 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] create database: no check on the name ?
by Olivier M. 28 Aug '01

28 Aug '01

Other little thing: seems there are no checks made on the Create DB field (main.php3): if I type "fadfdppö 'fa'fdax" as db name, it will be created without problem: drwx------ 2 mysql daemon 35 Aug 28 00:45 fadfdppö \'fa\'fdax Shouldn't we add a check to see if the name is valid ? Olivier -- _________________________________________________________________ Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch

2 1

[Phpmyadmin-devel] 2.2.0-FINAL - Beta testers wanted! (cvs version)
by Olivier M. 28 Aug '01

28 Aug '01

Hello, We're a few days before final release of phpMyAdmin 2.2.0 (planned on next sunday, finally :). Just in case, if you could test the latest CVS version available under http://phpmyadmin.sourceforge.net/cvs/ and check if the latest bugs you noticed have been corrected, that would be very nice. Thanks in advance for your feedback on the phpmyadmin-devel mailing list, or eventually on the users forum. Regards, Olivier Müller, for the devel team. -- _________________________________________________________________ Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch

3 11

[Phpmyadmin-devel] Re: to delay or not to delay ?
by Loïc 28 Aug '01

28 Aug '01

Hi Olivier & All! Well I don't yet whether we should delay the plain 2.2.0 release or not because I can't find enough time to have a deep look at the new bugs since last friday. >Btw, what is this $fields_prev[] information for ? Let's say one of your field current value is `this is "my" vel`. To have it displayed and take into account as a value of a form field it has to rewritten to `this is & quot;my & quot; val`. Let's say that while altering the current record you do not modify this field (ie you modify only onther(s) fields), then the value passed by the form is `this is & quot;my & quot; val` and your field will be updated with this value. $fields_prev[] is only a way to ensure fields with special characters would be modified only if this is trully required by the user. >And it seems to be ok now. If the one who made that (loic ? :) >could check if it is ok, that would be nice thanks. Will check this asap. Cheers, 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

[Phpmyadmin-devel] frustrating problem with NULL values in number fields
by Dan Allen 27 Aug '01

27 Aug '01

When you are creating a new field and you want the default to be NULL, the query is getting passed through as ... default 'NULL' ... but since the quotes are around NULL, it is interpreted as the string NULL so the default becomes 0...maybe we could add a little checkbox for null, so it would be like Default ------- -- | | or | |null ------- -- what do you think? Dan Allen

2 1

[Phpmyadmin-devel] Error in tbl_copy.php3?
by Jan Paul Schmidt 25 Aug '01

25 Aug '01

I'm sorry, if this is the wrong address for submitting bug reports for phpmyadmin. The homepage and documentation is quite unclear concerning this. At least for me :o) It looks like the following is not fixed already for MySQL 3.23 under Linux. The SQL-Statement returned from get_table_def in lib.inc.php3 is in lower case (,,create table ...''). In tbl_copy.php3, this string is used with ereg_replace to create a SQL-Statement for the new table. But: The regular expression is ,,CREATE TABLE ...'', so this results always in a table already exists error. I changed this by using eregi_replace instead of ereg_replace. jps

3 2

[Phpmyadmin-devel] [assid@assid.com: phpMyAdmin CVS]
by Olivier Mueller 25 Aug '01

25 Aug '01

some personal mails I got (can't look at it for the moment) ----- Forwarded message from Satish Alwani <assid(a)assid.com> ----- Date: Fri, 24 Aug 2001 08:03:32 -0400 From: "Satish Alwani" <assid(a)assid.com> Reply-To: <assid(a)assid.com> To: <mysql(a)8304.ch> Subject: phpMyAdmin CVS Sorry, ot exactly used to working with Beta versions of oftwares which are based on something else... ike in this case we require php.. mysql etc. Okie heres my info pache 1.3.20 ySQL 3.23.40 HP 4.0.6 rowser : Microsoft Internet Explorer 5.5 perating System : Windows 98SE VS Released : 23Aug2001 I know my PHP installation and mysql installation s fine.. since the prev. version of phpmyadmin et works.. and i do some scripting on this pc.. hich works. As I mentioned earlier.. the left side shows the atabase and tables okay.. but when i open nything.. the main frame keeps wanting to ownload the called page. As soon as i get used to beta testing on softwares ikle these again (been over year or so) i'll tart commenting them in properly, sorry to be a usisance till then. Currently I'm testing for PHPEdit.. Its a IDE for HP on windows. so as u can guess.. u dont need to ention most of the supports u have.. except for he os.. and im the one reporting all the weird ugs in since i use it in my actual coding. Ciao ssid --------- Original Message --------------------------------- rom: Olivier Müller <mysql(a)8304.ch> eply-To: mysql(a)8304.ch ate: Fri, 24 Aug 2001 09:49:12 +0200 (CEST) sorry, but if you don't tell exactely your setup php version, mysql ersion, etc.) and your browser type, it won't elp... ---------------------------------------------------------------- http://www.phpwizard.net/phorum/read.php?f=1&i=4840&t=4811> ent by Phorum 3.1 <http://phorum.org> ----- End forwarded message ----- -- ________________________________________________________________ Olivier Müller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland Omnis Internet Services - http://www.omnis.ch

1 0