Developers

developers@phpmyadmin.net

7004 discussions

[Phpmyadmin-devel] A commit, please
by Lo�c 15 Jul '02

15 Jul '02

Hi List! Could one of you test and submit the patch I've suggested in support request #579565 (DELETE SYNTAX)? 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

2 1

[Phpmyadmin-devel] Re: table name with "." / pma demo
by Loïc 15 Jul '02

15 Jul '02

Hi List! Olivier wrote: >try to delete the table "www.nukeland" This is a known MySQL problem: dot is an invalid character in db/table/column name but MySQL doesn't check for it while creating db/table/column. BTW it can't do anything with such a db/table/colum. PMA already checks for such invalid characters as soon as you create db/table/column with PMA forms. But it doesn't if you run a SQL script and I'm afraid it would be really too hard to code it. 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] ok for -rc3?
by Marc Delisle 14 Jul '02

14 Jul '02

Or is someone working on something today? Mike you wanted to add some messages and validation before -rc3... will you do it today? Marc

1 0

[Phpmyadmin-devel] SQL Standards
by Robin Johnson 13 Jul '02

13 Jul '02

The person I was working with pointed me to a little used link on their site, and I believe that all of us here should take a look at it when we have time. It's a link to get the draft copy of the SQL-200x standard, which, according to him as he is on the ISO SQL committee, is fairly near ready to be released. He also says there will be no more fixes to it, other than spelling/typo fixes. Here is the link: http://www.jtc1sc32.org/sc32/jtc1sc32.nsf/23933607697154bf852566160054bcf7/… You want the first PDF file. Most notably in it, I find that some things that MySQL thinks are valid, are NOT part of the SQL standard. ESP how it does the valid identifier tokens that I had trouble with. MySQL claims valid tokens are: ([A-Za-z$_0-9]*[a-zA-Z$_][A-Za-z$_0-9]*) But the standard says: ([a-zA-Z][a-zA-Z_0-9]*) There are a number of other things, so such a point where I have this question: Should we explictly support MySQL where it diverges from the standard, or only support the SQL standard, with minimal MySQL extensions? -- 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 2

[Phpmyadmin-devel] sql.php3 version 1.117
by Marc Delisle 13 Jul '02

13 Jul '02

Hi, I would like to understand the change made today in sql.php3. If I understand correctly, it is to avoid doing the big query if we are just displaying the sql-code of the previous query. If this is the case, I think we should also remove the navigation bar (show x rows...), the insert new row, print view, bookmark label, and avoid the "undefined variable" on $fields_meta at line 493. Marc

1 1

[Phpmyadmin-devel] my contribution
by ZARAZ Admin 13 Jul '02

13 Jul '02

I'd like to contribute to phpMyAdmin project, but you already have a lot of very knowledgeable people for PHP. What do you think if I will redesign the front page of http://www.phpmyadmin.net in a neat way? I will send you few samples, ok? -- Regards, Admin http://www.zaraz.com

2 1

[Phpmyadmin-devel] SQL Validator
by Robin Johnson 12 Jul '02

12 Jul '02

Hi List, A few months ago, after there was an article on slashdot about an SQL Validator product that you could use freely via the web, I contacted the company behind it, and suggested that they make a web service version of the web page they had before, that could be used from within other applications. One of their developers that saw my email, and was a great fan of phpMyAdmin got back to me, and said he'd talk to management about it. I didn't hear anything for a few months, until a few weeks ago, he contacted me again, with access to the prototype of the service. I wrote a small (~15 lines + PHP classes from ActiveState) PHP client that works wonderfully for the initial version, and we saw his service was great. As an optional feature, I would like to include the PHP calls to the SOAP service in phpMyAdmin. It would get a link in the query box, just like we currently have for the 'PHP Code' and it would enable you to click on the link and send the data to Mimer via the SOAP service to be validated. In addition to just validating the query, if there is anything wrong with your query compared to what the standards, it lists each error, along with possible corrections. Up till yesterday, it was only in a text format, but as of later today, it will be a parsable XML format that I have had input on the design of. I foresee an additional option for it's use. If you type in a query, and the MySQL server gives you an error message, then run the validator as well, and it will list possible corrections for each error in the query, allowing newbie SQL users to debug their SQL queries in record time. Just a note, DB-config is now officially postponed until 2.3.1, as it needs some more design work, due to a few things pointed out to me regarding security. MySQL parser now passes every one of the tests that are bundled with MySQL, so I think it is ready :-). -- 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] REALLY no new strings for 2.3?
by Beck, Mike 12 Jul '02

12 Jul '02

hi everybody, one thing i'd really like to do now, before the rc3 is to have a chance for the user to see why the relationstuff is not working. what i'd like to do is: when relation_lib deactivates relations have a link on the frontpage saying relation features deactivated, please click here for analysis then link to a page that will just answer tbl_relation ... <font color="green">OK</font> tbl_coords ... <font color="red">not found</font> [Doku> where [Doku] would be a link to documentation.html where it explains how tbl_coords should look like. (and of course enter a variable DontWarnAboutRelation = FALSE; to config.inc.php3 now, i don't think it is absolutely necessary to translate OK,not found and Doku, but of course there would be that one sentence on the main page. so do you want me to wait with that for 2.3.1 (i wouldn't like that as i think it might really help some users and therefore should be there when we first officially release with the new features) or can i implement it and we just ignore if this warning stays english for some users (Documentation.html is also only available in english, so whoever sets up pma has to be able to read english and this warning is meant to help the admin not the users) cheers Mike

3 2

RE: [Phpmyadmin-devel] SQL Standards
by Robin Johnson 12 Jul '02

12 Jul '02

On Fri, 12 Jul 2002, Beck, Mike wrote: > > Should we explictly support MySQL where it diverges from the > > standard, or > > only support the SQL standard, with minimal MySQL extensions? > > > hmm, at least there are some where i really think it is dumb that MySQL > allows them: especially the _ because it is a wildcard as well, and you can > get into problems using it. I definetly agree some of the problems are due to MySQL not following the SQL standards. For the moment, I'm going to integrate my tokenizer as is, along with the extractor and pretty-printer. I'm working on a tokenizer that follows the SQL standard more closely, and I'll replace the current tokenizer with the new one that is faster and mostly standards compliant in 2.3.1. There are a few things MySQL has that I think should stay. Most notable amongst them is hexadecimal numbers. -- 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

answered: RE: [Phpmyadmin-devel] Newbie
by Beck, Mike 12 Jul '02

12 Jul '02

answered per pm

1 0

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