phpMyEdit - Viewing Bug Advanced Details [ Go Back ]
301 other minor always 2005-01-20 21:52 2005-01-22 10:20
mgarav@tiscali.it  
winnt iis php4.3.9 mysql 4.0.18  
normal  
feedback 5.4 (stable)  
open  
none  
none  
duplicate record
browsing database some record are displayed twice.
browsing table with annexed scarti.php
0000301-scarti.php.txt (8 KB) 1970-01-01 01:33

Bug Notes
nepto   
2005-01-21 00:52   
My humble guess is, that there is some kind of wrong join...
However I did not review the source. I will do so earliest in the 25th, once my big school exam will be done. I'm learning now :)
michal   
2005-01-21 12:29   
are always the same records displayed twice ?
it's just display or they are twice in the db ?
removing 'values' option solves the problem ? (then it's a wrong join)
mgarav@tiscali.it   
2005-01-21 18:39   
Yes, always the same
Just display, db is ok
BINGO: removing:

'values' => array(
'table' => 'ol_aperti',
'column' => 'nr',
'description' => 'nr'
),
where I used two time 'nr' both in column and description ( my mistake, I suppose) this problem seems solved

Thanks
michal   
2005-01-21 22:16   
also there is 'join' option where you can make a custom join (for VLF), eg with an aditional where clause.

you say removing 'description' solved the problem ? strange... can you test also with cvs version ?
mgarav@tiscali.it   
2005-01-22 10:20   
Dear michal

I am more or less an end user, so my know how in this kind of thing is very poor.....

Any case:
to check if commenting (//) the description row ha solved the problem I compared the number of row displayed (figure near pages number) with the actual in database: Database 1780 row, with 'description' browswer reports 1825 rows and commenting 1780.(Curiosity: why 45 and not a different number of rows more? Looking on 'nr' value, none is repeated 45 times ) So I assumed the probrem corrected.
Another point: with mistake the answer speed is quite longer ( 5-7 times the correct).
If can help you I can do some other test, but I need to be "guided" step by step.(vlf? cvs?).
If useful I can send to you details on db ( very simple) and other info.