July 2002 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] why a space in the cell?
by Marc Delisle 07 Jul '02

07 Jul '02

Hi, Is it for cosmetic reasons that at line 1087 of display_tbl.lib.php3 there is a space before the </td>: $vertical_display['data'][$row_no][$i] .= ' </td>' This causes a problem for a user (see bug 577645). Marc

2 1

[Phpmyadmin-devel] but in select from table with current cvs
by Beck, Mike 05 Jul '02

05 Jul '02

hi, i just found an interesting bug - in the select page if i want to see all columns and one column like something, then the tablename will have a blank in front like ` tablename` and one of the columns has one behind it... if i just want to see some of the columns it works... could we generally trim the string in PMA_backquote (i mean regardless of characterset i doubt that any tablename can ever begin or end with a blank)? Or does anybody have an idea where the blank gets inserted? -- Mike Beck mikebeck(a)users.sourceforge.net

2 1

[Phpmyadmin-devel] bug #574596
by Rabus 03 Jul '02

03 Jul '02

Hi list, could you have a short look at bug #574596? A user reports some export problems with Netscape Navigator 4.5. My question is: do we really need to work around NN 4.5 bugs? Regards, Alexander

2 1

[Phpmyadmin-devel] phpMyAdmin 2.3.0-rc2 is released
by Marc Delisle 03 Jul '02

03 Jul '02

Hi, You are welcome to try this second release candidate. No major bug was reported for -rc1, but we improved the new menus, merged some updated translations, and fixed some minor problems. The official page will be updated soon, but right now you can download the package at: https://sourceforge.net/project/showfiles.php?group_id=23067 Marc, for the dev. team.

2 5

[Phpmyadmin-devel] PmaAbsoluteUri again
by Robin Johnson 03 Jul '02

03 Jul '02

Hi List, I've just had a weekend away (mostly vacation, but with a little bit of work). I set up a copy of phpMyAdmin in a specific physical location, and I had a little problem. Basically they have a central copy of phpMyAdmin running, and the remote sites ALL access it via SSH tunnels. Yes, they do break HTTP/1.1 by doing this, as the server never gets a correct hostname, but rather a huge variety of different things. The smallest remote sites end up using http://localhost:(specific port #)/ as they are only one computer, but some of the larger ones use http://local_gateway:(specific port #)/ All of this traffic, regardless of the hostname and port involved is sent to the main http server at HQ, and all needs to work. The best I could do at the moment was leave $cfg['PmaAbsoluteUri'] unset, and comment out the warning in the code. But I think there might be a large number of other cases like this, where the auto-detection code for the PmaAbsoluteUri works perfectly, so we can leave it empty, and we do indeed want to get rid of the warning. But we don't want people abusing the option at the same time, so possibly we can add a simple option at the end as $cfg['PmaAbsoluteUri_DisableWarning'] Which can be used to disable the warning, and has lots of comments around it to tell them about it. If this idea is acceptable, I'll write it up. -- 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] eskuel / commentaires phpinfo
by Olivier M. 01 Jul '02

01 Jul '02

There are some nice ideas there... : http://eskuel.sourceforge.net/ :) And the comments (in french) under http://www.phpinfo.net/?p=commentaires&rub=news_phpinfo&id=598&id_comm=0 are also interesting: some people don't really like the new layout (as usual when there is a change somewhere)... Olivier -- _________________________________________________________________ Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch

3 3

[Phpmyadmin-devel] Patch to support multiple primary kets in schema
by Joshua Eichorn 01 Jul '02

01 Jul '02

I didn't see any changes to this file in cvs since the rc1 release so this should apply cleanly. This allows tables with multiple primary keys to be documented correctly, without this only the last field is shaded. The Schema creation is great, thanks for the good work. -joshua eichorn jeichorn(a)phpdoc.org phpDocumentor (Php Auto Documentation) http://phpdoc.org --- pdf_schema.php Wed Jun 19 13:44:29 2002 +++ pdf_schema.php Fri Jun 28 10:19:43 2002 @@ -319,6 +319,7 @@ var $fields = array(); var $height_cell = 6; var $x, $y; + var $primary = array(); /** @@ -390,7 +391,7 @@ reset($this->fields); while (list(, $field) = each($this->fields)) { - if($field == $this->primary){$pdf->SetFillColor(215,121,123);} + if(in_array($field,$this->primary)){$pdf->SetFillColor(215,121,123);} if($field == $this->displayfield){$pdf->SetFillColor(142,159,224);} $pdf->PMA_PDF_cellScale($this->width, $this->height_cell, ' ' . $field, 1, 1, 'L', 1); $pdf->PMA_PDF_setXScale($this->x); @@ -462,7 +463,7 @@ if(mysql_num_rows($result)>0){ while ($row = PMA_mysql_fetch_array($result)) { if($row['Key_name'] == 'PRIMARY'){ - $this->primary = $row['Column_name']; + $this->primary[] = $row['Column_name']; } } } @@ -778,6 +779,7 @@ $pdf->SetDisplayMode('fullpage'); $pdf->Output($db . '_' . $pdf_page_number . '.pdf', TRUE); + //$pdf->Output('', TRUE); } // end of the "PMA_RT_showRt()" method

2 1

RE: [Phpmyadmin-devel] Re: eskuel / commentaires phpinfo
by Beck, Mike 01 Jul '02

01 Jul '02

> There's one thing of the new layout that I also don't like: > If I want to run an SQL query I'd like to see the structure of the > corresponding table... That's impossible with the new design. > And I think others would have simular problems with that... > i agree there, but i propose that we only show the printview of the structure there, to save time and bandwith. -- Mike Beck mike.beck(a)users.sourceforge.net

1 0

[Phpmyadmin-devel] Tr:bug report 2.3.0 rc2 (continue)
by Lo�c 01 Jul '02

01 Jul '02

Sorry guys, I'm really too busy to work on PMA these days... Loïc -----Message d'origine----- De: SailorMax <max(a)elkor.lv> A: Lo?c <loic-div(a)ifrance.com> Date: 28/06/02 Objet: bug report 2.3.0 rc2 (continue) Yahoo Loic! Previous my message: ~~~~~~~~~~~~~~~~~~~~ Sorry, don't have any time for find bug-place :) Example: I have table 'sys_user_data' with field 'ID' and some else. query 'DELETE FROM sys_user_data WHERE ID >= 23' convert to 'DELETE FROM sys_user_DATA WHERE ID >= 23' and myAdmin sad 'error' :) ~~~~~~~~~~~~~~~~~~~~ The decision: ~~~~~~~~~~~~~ file: sql.php line1: 588 is: $res_words_arr = array("DROP", "SELECT", "DELETE", "UPDATE", "INSERT", "LOAD", "EXPLAIN", "SHOW", "FROM", "INTO", "OUTFILE", "DATA", "REPLACE", "CHECK", "ANALYZE", "REPAIR", "OPTIMIZE", "TABLE", "ORDER", "HAVING", "LIMIT", "GROUP" , "DISTINCT"); must be: $res_words_arr = array("DROP", "SELECT", "DELETE", "UPDATE", "INSERT", "LOAD", "EXPLAIN", "SHOW", "FROM", "INTO", "OUTFILE", "DATA", "REPLACE", "CHECK", "ANALYZE", "REPAIR", "OPTIMIZE", "TABLE", "ORDER BY", "HAVING", "LIMIT", "GROUP" , "DISTINCT", "WHERE", "VALUES", "IGNORE"); (and so on. I can give you mysql.chm ;) ----------------- file: sql.php line1: 602 is: $sql_str = eregi_replace("$w ", "$w ", $sql_str); must be: $sql_str = eregi_replace("([^A-Za-z_]+)$w ", "\\1$w ", $sql_str); $sql_str = eregi_replace("^$w ", "$w ", $sql_str); ----------------- -- Go-seiko:-o inorimas! (SailorMax) mails: mailto:max@elkor.lv mailto:sailormax@navigators.lv mailto:sailormax@inbox.lv Web-Page: http://www.fao.lv/sm-info http://sm-info.h1.ru ______________________________________________________________________________ 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