July 2002 - Developers - lists.phpmyadmin.net

[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

[Phpmyadmin-devel] Newbie
by Ivan Giglione 12 Jul '02

12 Jul '02

Hi I'm newbie with phpmyadmin Could you help me? Two Help: 1) I installed on RedHat PHPMYADMIN to use my personal mysql database but i see that those interface connect only TEST database, how to set the others databases? 2) I have to replace a databse CSV (ex. "first name"; "last name"; ) form a old database ACCESS .... on excel it's fine but on PhpMyAdmin there is not a page to import a CSV table. Coud u explain me how to do it? Sorry for my english, i'm italian. Thanx I'm italian, my english is not good

1 0

[Phpmyadmin-devel] current cvs broken?...
by Olivier M. 12 Jul '02

12 Jul '02

FYI: just tried it 5 min ago (leaving for a week trip to germany today): index gives -> Bienvenue à phpMyAdmin 2.3.0-rc3 Erreur requête SQL : SELECT VERSION() as version, USER() as user MySQL a répondu: Query was empty not really nice... :) mysqld Ver 3.23.44 for pc-linux-gnu on i686 php 4.2.1 regards, Olivier -- _________________________________________________________________ Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch

2 1

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

12 Jul '02

Hi List, I've got my SQL parser 100% now given the information that I have. It's ~10% slower than the speeds I posted before, but I think those are fast speeds still. Just in case somebody wants to put in a huge chunk of SQL in one of the SQL input boxes, and they don't really care about my parser seeing it, I think we should add a checkbox for them to bypass it if they want to. I see this as being really important if they are using the SQL upload box to run a really large SQL query, so maybe we even disable it automatically if they put in a query larger than a certain size. I'd say possibly all queries larger than 2k should not be parsed, as the odds say that the query is being pasted in from somewhere else. The funniest thing that, is I have now found two bugs in the parser mechanism of MySQL, and submitted bug reports for them. I haven't seen any reply yet tho. The main parser function is ready for merging in the source tree, apart from needing to be re-indented to match the rest of the code in PMA. On that note, could somebody make some suggestions as to settings for VIM to indent the sourcecode like we want it. I'm just tidying up the code of the extractor and the pretty-printer, and once those are all ready, they will be integrated into the source tree all at once. The entirety of my code is running ~900 lines at the moment, so I will put it into a new file, lib/parser.inc.php3. I've been invited on a short vacation on the 12th and 13th of this month, so I don't know if I will have the extractor ready for our -rc3 point on Sunday. I'll do my best to have it ready by Sunday, but I probably won't manage. -- Robin Hugh Johnson E-Mail : robbat2(a)orbis-terrarum.net Home Page : http://www.orbis-terrarum.net/?l=people.robbat2 ICQ# : 30269588 or 41961639

4 4

[Phpmyadmin-devel] Re: SQL Parser
by Lo�c 11 Jul '02

11 Jul '02

Hi List! >I've got my SQL parser 100% now given the information >that I have. Great :)) >I see this as being really important if they are using >the SQL upload box to run a really large SQL query, so >maybe we even disable it automatically if they put in >a query larger than a certain size. Right, as we just do something like that to not display the queries submitted at the top of the page if they are more than 15 at once. >The main parser function is ready for merging in the source >tree, apart from needing to be re-indented to match the rest >of the code in PMA. On that note, could somebody make some >suggestions as to settings for VIM to indent the sourcecode >like we want it. Yep, as stated in the documentation ;) just have a look at the "PEAR Coding Standards" page and mainly at this page: http://pear.php.net/manual/en/standards.php#standards.indenting 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] Contact needed... / http://www.phpmyadmin.net
by CyberMultilingual Mathias Levarek Ph.D. 10 Jul '02

10 Jul '02

Let us submit http://www.phpmyadmin.net for FREE on Japanese search engines, German search engines, Hispanic search engines , French search engines , Chinese search engines etc.....! After reviewing http://www.phpmyadmin.net, we have noticed that your website cannot be found on foreign search engines. Could you please put me in touch with your marketing director or whoever is in charge of web promotion for your website? As it stands Internet users searching on German search engines, French search engines, Hispanic, Portuguese, Italian, Japanese or Chinese search engines cannot find your website! In fact, it has not been optimized nor listed accordingly .... We will show you how to reach these multilingual markets without even having to translate your website! International search engines submission is not about doing business with foreigners in their native language but rather bringing foreigners to your website to do business with you in English! There are millions of foreigners who speak English but would rather use their native language to conduct a search. From the Japanese Yahoo to the German AltaVista, from the Spanish Lycos to the French Excite, get users to find your website when searching with Your Keywords in Their Mother Tongue. Let us submit your website on International search engines for FREE! Visit us at http://www.CyberMultilingual.com for full details! I do believe that a website like yours deserves a better exposure to international markets and this is why I would like to introduce you to our company: CyberDifference Corp. is an international website development agency mainly specialized in multilingual search engines submission in French, German, Spanish, Portuguese, Italian, Japanese, Chinese and Korean. You may request additional info by email at seo(a)cybermultilingual.com or call my office to schedule a free phone consultation: 1(928) 203 0835... Test a few markets! What will it be? The German web? The Japanese web? The French web? The choice is yours!! Let's double your Web exposure: reach "the other half of the Internet"! We will perform FREE monthly submissions for your site on foreign search engines.... Regards, Mathias LEVAREK Ph.D. seo(a)cybermultilingual.com ___________________________________________________________________ C Y B E R D I F F E R E N C E C O R P. PO BOX 2735 SEDONA, ARIZONA 86336 USA TEL:1(928) 203 0835 - FAX: 1(413) 622-3040 http://www.CyberMultilingual.com: Multilingual search engine submission. http://www.MetaNovation.com: Advanced search engine promotions through mirror site marketing http://www.SearchEngineJungle.com: Search Engine Promotion Seminars. This is not a spam: You are receiving this message because " phpmyadmin-devel(a)lists.sourceforge.net " is in our data base from a subscription to one of Cyberdifference Corp.'s international / multilingual e-marketing newsletters. If you want to opt-out and remove your records from our databases please email remove(a)cybermultilingual.com and mention "http://www.phpmyadmin.net" in the subject line. We comply with every removal / opt-out requests.

1 0

[Phpmyadmin-devel] Another patch to be submitted
by Lo�c 09 Jul '02

09 Jul '02

Hi List! Rabus wrote: >I've just merged your patch. Thanks. I've also put a patch against bug #579017 in the bug tracker. It would be nice if someone can test it and submit it into the CVS tree. 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