| Index
» Projects
» phpMyEdit
» Bug list
» Bug #301 |
 |
|
Viewing Bug Advanced Details |
[ Jump to Bugnotes ]
[ Bug History ]
[ Print ]
|
|
ID |
Category |
Severity |
Reproducibility |
Date Submitted |
Last Update |
|
0000301 |
other |
minor |
always |
2005-01-20 21:52 |
2005-01-22 10:20 |
|
|
|
Reporter |
mgarav@tiscali.it |
View Status |
public |
|
|
Assigned To |
|
|
Priority |
normal |
Resolution |
open |
Platform |
|
|
Status |
feedback |
Duplicate ID |
|
OS |
winnt iis php4.3.9 mysql 4.0.18 |
|
Projection |
none |
|
Version |
|
|
ETA |
none |
|
Product Version |
5.4 (stable) |
|
|
Product Build |
|
|
|
Votes |
1 |
|
|
|
Summary |
duplicate record |
|
Description |
browsing database some record are displayed twice. |
|
Steps To Reproduce |
browsing table with annexed scarti.php |
|
Additional Information / Solution |
|
|
Attached Files |
scarti.php (8,021 bytes) 2005-01-20 21:52 |
|
|
|
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. |
|
|
|
|
Login
Registration
Slovak
