June 2002 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Errors - Uninitialized string offset
by Michael Mulvihill 24 Jun '02

24 Jun '02

Hello, I'm getting the following errors when using phpMyAdmin: Notice: Uninitialized string offset: 0 in /home/y/share/htdocs/phpMyAdmin/db_details_structure.php on line 450 Notice: Uninitialized string offset: 0 in /home/y/share/htdocs/phpMyAdmin/libraries/display_tbl.lib.php on line 1396 Has anyone encounterd these errors. Michael Mulvihill mikem(a)yahoo-inc.com Do you uh, Yahoo!? www.yahoo.com

2 2

[Phpmyadmin-devel] Error Notice
by Michael Mulvihill 24 Jun '02

24 Jun '02

Hello, i'm getting the following error: Notice: Uninitialized string offset: 0 in /home/y/share/htdocs/phpMyAdmin/libraries/display_tbl.lib.php on line 1396 not sure what is going on...any info would be great.

1 0

[Phpmyadmin-devel] 2.3.0-rc1
by "Thomas Bähr [Office]" 24 Jun '02

24 Jun '02

2 1

[Phpmyadmin-devel] Good News and Bad News - SQL Parser
by Robin Johnson 23 Jun '02

23 Jun '02

Hi list. Firstly, the bad news. My text editor crashed while I was working on my new SQL parser, very badly. Totally trashed the file. However, I managed to recover nearly the entire file from the coredump. And the part that I didn't get back I was busy rewriting anyway. I'm gonna learn vi instead of using nano from now on. Now the good news: The parser is almost 100% ready to roll now. TODO: * detect basic errors in query * make sure other query types are all formatted quickly - verified working: SELECT, INSERT, DELETE, CREATE, DROP - todo: ALTER, UPDATE, ? * integrate with main PMA source * optimize more! (is profiling possible in PHP ?) * PHP3 compatibility ? URL: http://games.techbc.ca/~robbat2/sqlparse.php Notes: I have completely redone data.php from the MySQL lex.h in the source code, along with some modifications. This code hits some servers heavily for resources, I'm not sure why yet. (This is why it needs the optimizations). I still want a few more testcases to try out: 1. insert/select queries with nested calls to functions 2. update and alter queries Known Bugs: If you have a table/field name that is a function name, and it is not escaped using the backticks, then the formatting WILL be wrong. There is no workaround for this. MySQL will reject the query anyway, so I think we should just document this. If I get thru these issues this week, then I will see about getting the code into the CVS tree by next weekend. -- Robin Hugh Johnson E-Mail : robbat2(a)orbis-terrarum.net Home Page : http://www.orbis-terrarum.net/?l=people.robbat2 ICQ# : 30269588 or 41961639

1 0

[Phpmyadmin-devel] VIRUS DANS UN MAIL POUR VOUS DE listserv@univ-montp2.fr
by postmaster＠univ-montp2.fr 22 Jun '02

22 Jun '02

V I R U S A L E R T Notre antivirus a trouvé le(s) virus suivant(s) : W32/Klez.h@MM dans un email pour vous de : listserv(a)univ-montp2.fr Ce mail infecté a été stoppé, et ne compromets pas l'intégrité de votre système.

1 0

[Phpmyadmin-devel] [Phpmyadmin-cvs] CVS: phpMyAdmin sql.php3,1.108,1.109]
by Olivier M. 22 Jun '02

22 Jun '02

Salut Marc, ----- Forwarded message from Marc Delisle <lem9(a)users.sourceforge.net> ----- Modified Files: sql.php3 Log Message: patch 565627 Index: sql.php3 =================================================================== RCS file: /cvsroot/phpmyadmin/phpMyAdmin/sql.php3,v retrieving revision 1.108 retrieving revision 1.109 [....] ! mysql_free_result($cna_all_result); [...] ----- End forwarded message ----- because of this line (mysql_free_result), I now get lots of warnings when a page calls sql.php3... : Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/ admin/www/mysql2/sql.php3 on line 346 Warning: Cannot add header information - headers already sent by (output started at /home/ admin/www/mysql2/sql.php3:346) in /home/admin/www/mysql2/libraries/ob.lib.php3 on line 53 Warning: Cannot add header information - headers already sent by (output started at /home/ admin/www/mysql2/sql.php3:346) in /home/admin/www/mysql2/header.inc.php3 on line 23 Warning: Cannot add header information - headers already sent by (output started at /home/ admin/www/mysql2/sql.php3:346) in /home/admin/www/mysql2/header.inc.php3 on line 24 Warning: Cannot add header information - headers already sent by (output started at /home/ admin/www/mysql2/sql.php3:346) in /home/admin/www/mysql2/header.inc.php3 on line 25 Warning: Cannot add header information - headers already sent by (output started at /home/ admin/www/mysql2/sql.php3:346) in /home/admin/www/mysql2/header.inc.php3 on line 26 Warning: Cannot add header information - headers already sent by (output started at /home/ admin/www/mysql2/sql.php3:346) in /home/admin/www/mysql2/header.inc.php3 on line 28 If I comment the line, everything looks good... :) Same setup as usual (php 4.2.1, mysql 3.23.44, unix). Is this function really backward compatible? Regards, Olivier -- _________________________________________________________________ Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch

2 2

[Phpmyadmin-devel] New SQL Parser - now mostly complete
by Robin Johnson 21 Jun '02

21 Jun '02

Hi List, The new SQL parser is functional now, and very capable as well as fast. Again I am looking for hints and ideas about PHP3 incompatibilites if there are any in my code (I'm not sure). http://games.techbc.ca/~robbat2/sqlparse.php If there is some long and convoluted but still valid query that you want me to test my code on, please send it my way. Check out the LARGE_* query tests before you do though. I'd like suggestions on how to make it even faster on the huge query sets, like the SQL_MS_SQL* tests that I have in the test harness. The current code now uses absoltely NO Regex or PCRE functions, and does nearly everything via strings with a few arrays. I'd also like suggestions on what we want the indenting to look like, so that I can code it in as well. Any specific preferences? The only thing that remains in my code is more SQL validator, which is mainly for the structure, like missing brackets/quotes etc. I don't think I will do validation of the keywords or number of function arguments. -- Robin Hugh Johnson E-Mail : robbat2(a)orbis-terrarum.net Home Page : http://www.orbis-terrarum.net/?l=people.robbat2 ICQ# : 30269588 or 41961639

2 1

[Phpmyadmin-devel] phpMyAdmin 2.3.0-rc1 is released
by Marc Delisle 21 Jun '02

21 Jun '02

Hi, you are welcome to try this first release candidate for version 2.3.0. Some improvements: - new page layout for table and db properties - centralized db for support tables - can specify a different charset for MySQL and HTML - utf-8 charset support - schema output in PDF - operators in field selection - translation feedback page - print view for SQL results - EXPLAIN support - generate PHP code from a query - full database search - IP-based Allow/Deny - foreign table display field - support for some MyISAM table options - XML export Some bug fixes: CURDATE did not work in the function list javascript error with Mozilla and Opera a mysql error when dropping fields alter table was not working on a replicate bookmark error when the table no longer exists bad limit of the number of characters for numeric fields problem with headers in Apache 2 See http://www.phpmyadmin.net. Marc Delisle, for the team.

6 8

RE: [Phpmyadmin-devel] New SQL Parser - now mostly complete
by Robin Johnson 20 Jun '02

20 Jun '02

On Fri, 21 Jun 2002, Michal Cihar wrote: > Could you give somewhere also source of data.php? It seems to be > required for make it work. I want to test this code on some complicated > queries. Please send me the queries as well to add to my test system. The data.php is on the source page as well now. > Here are few possible speedups (not tested, just an ideas which came as I saw that): Thanks. -- Robin Hugh Johnson E-Mail : robbat2(a)orbis-terrarum.net Home Page : http://www.orbis-terrarum.net/?l=people.robbat2 ICQ# : 30269588 or 41961639

1 0

[Phpmyadmin-devel] New backwards compatibility code / 2.2.7-rc1 release
by Rabus 20 Jun '02

20 Jun '02

Hi Robin, Marc & list, I've just merged my revised version of the backwards compatibility code for old config files. Could you please test it a bit? It should work better than the old one. About the RC1 releases: As nobody protested against it, we will also release 2.2.7 RC1 today, right? Marc, please send along a note via e-mail or icq (#56915822) when you're ready and I'll push up the version numbers and tag the files. Regards, Alexander

2 6