Developers June 2002

developers@phpmyadmin.net

18 participants
58 discussions

[Phpmyadmin-devel] New SQL parser
by Robin Johnson 19 Jun '02

19 Jun '02

Hi List. I've written the first steps in having a new parser for the SQL queries Run: http://games.techbc.ca/~robbat2/sqlparse.php View Source: http://games.techbc.ca/~robbat2/src.php I will teach it the different between reserved words and other words tommorow. It already does a much better job on strings and data inside quotes than Mike's previous code. Could somebody please look at the code, and make suggestions on how to do the array stuff with PHP3 ? I'm upgrading my test platform to Apache 2.0.39 and the latest PHP tommorow morning, so that we can be sure things work on the cutting edge. -- Robin Hugh Johnson E-Mail : robbat2(a)orbis-terrarum.net Home Page : http://www.orbis-terrarum.net/?l=people.robbat2 ICQ# : 30269588 or 41961639

3 4

[Phpmyadmin-devel] 2.3.0-rc1 tomorrow?
by Marc Delisle 19 Jun '02

19 Jun '02

Hi, I plan to release 2.3.0-rc1 tomorrow, then we only merge: - translation updates - light patches - light bug fixes. Any show stopper you can think of? Marc

6 22

[Phpmyadmin-devel] MAJOR Colourizer bug
by Robin Johnson 18 Jun '02

18 Jun '02

I've found a MAJOR bug in the colourizing SQL formatting. The Bug ID is #570898. Priority: 9 Severity: Blocker (I've been using bugzilla a bit much) Copy of bug report: just from looking at the colourizing code, I wondered what would happen with a specific query. So I tried it out with dire results: SQL Query fragment: CREATE TABLE bar1 ( bar text NOT NULL ) TYPE=MyISAM; INSERT INTO bar1 VALUES ('I\'m a little teapot. Short and STOUT. =_=.\r\n,,,,, commas ;;;;; semi-colons\r\nSELECT DATABASE TABLE DOUBLE \r\n'); Output: CREATE TABLE bar1 ( bar text NOT NULL ) TYPE=MyISAM; INSERT INTO bar1 VALUES ( 'I\'malittleteapot.ShortandSTOUT.=_=.\r\n,,,,,commas;;;;;semi-colons\r\nSELECTDATABASETABLEDOUBLE\r\n' ) This will TOTALLY strip the spaces in the displayed query, which destroys the string that is displayed. Part two: Using the previous table, go to manually insert a row, and use this for your data: I'm a little teapot. Short and STOUT. =_=. ,,,,, commas ;;;;; semi-colons SELECT DATABASE TABLE DOUBLE Here is the output: INSERT INTO `bar1` ( `bar` ) VALUES ( ' ) ; We have lost the ENTIRE string. The flaw is a major design flaw in the code with regards to the way that quotes ( ' " ` ) are handled. At the moment the format parser breaks down the query at the start. Instead of doing that, we need to work thru the query character by character. -- 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] Can not select each server's charset ?
by luc 18 Jun '02

18 Jun '02

Hi list, I don't want to set $cfg['DefaultCharset'] statically in config.inc.php3. Because we can't select the charset to each MySQL server with different charset. This feature is not good, I think. Best regards, luc

3 4

[Phpmyadmin-devel] Bugs
by Robin Johnson 18 Jun '02

18 Jun '02

Hi List, I've done some bug hunting. Server: Apache2.0.36, PHP-4.3.0-dev, MySQL 3.23.49a Browsers: Mozilla 1.1 alpha (mips-sgi-irix6.5), Mozilla 1.0 (i686-pc-linux-gnu) , IE6, IE5.5, Konqueuer 2.2.2 I've posted up 4 new bugs on the tracker that are actually code bugs, that effect all the browsers. I haven't tested for any browser-specific problems, but if you want me to, just tell me a test case and I'll try it out. I can test with large number of other browsers and platforms as well, just tell me what you want me to try out. (My boss told me I can work on PMA some while we wait for something, so I'm literally getting paid to work on it now :-) -- 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

Fwd: Re: [Phpmyadmin-devel] 2.3.0-rc1 tomorrow?
by Michal Cihar 18 Jun '02

18 Jun '02

Hi > >-> You have an error in your SQL syntax near '' at line 1 > >(tested with opera and netscape) You get (or got, I did use yesterday version) when pmadb was not set in config, which is probably not correct behavior. Regards Michal Cihar nijel at users dot sourceforge dot net http://cihar.liten.cz

1 0

[Phpmyadmin-devel] PMA Bugs
by Robin Johnson 18 Jun '02

18 Jun '02

I'm testing the CVS as at 8pm -0800 with Apache2. And adding bug reports to the SF tracker. -- 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] hide the utf-8 choices?
by Marc Delisle 18 Jun '02

18 Jun '02

Hi, This has been suggested to me by Michal, and I want to get your opinion: if $cfg['AllowAnywhereRecoding'] is false, do we need to display all the -utf-8 choices in the drop-down for language selection? In other words, will users have the need to use the -utf-8 charset in other situations? Another idea: would it be OK to display only the -utf-8 choices when $cfg['AllowAnywhereRecoding'] is true? I assume that PMA 2.3.0 will have more -utf-8 language files than the present czech, english and german. -- Marc Delisle

1 0

[Phpmyadmin-devel] unnecessary "comma"
by luc 17 Jun '02

17 Jun '02

Hi list, an only unnecessary "comma". $ cvs diff Documentation.html Index: Documentation.html =================================================================== RCS file: /cvsroot/phpmyadmin/phpMyAdmin/Documentation.html,v retrieving revision 1.261 diff -r1.261 Documentation.html 756c756 <        KEY (db_name),<br / > --- >        KEY (db_name)<br />

2 1

[Phpmyadmin-devel] ok, i am off to holiday ;-)
by mike.a.beck＠t-online.de 15 Jun '02

15 Jun '02

hi everybody, i just finished and merged the transition of the tables to a centralized pmadb, please have a look at the changelog and documentation.html / .txt to see what has been changed and where the tables are suppossed to be now. ( i only had time to take care of installation and configuration instructions there, possibly the faq/usage tips has to be changed as well, allthough i doubt, maybe somebody can have a look? also note, that in config.inc.php3 the variable is no longer called bookmarkdb but pmadb (this is changed in the bookmarkstuff as well, you only will need to check your config.inc.developer.php3) column_comments are now possible, they are written in tbl_relation and as yet only shown in tbl_printview (you won't usually have enough place for them in the pdf anyway). maybe a usage tip for that would help. i did not find the time to see about the one bug where syntaxcoloring doesn't show the table comment. also i saw a bug which only occurs with konqueror 3 it seems: when i want to update a rows content instead it always inserted a new row for me, with mozilla it was ok. still all the relationstuff should work now, and if you need any of those information have a look at libraries/relation.lib.php3, there is some nice functions there that should make life easier (like finding out which features actually should work) hope it works well enough that it won't be in the way of releasing rc1 cheers Mike Beck mikebeck(a)users.sourceforge.net

1 0

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 June 2002