| Index
» Projekty
» phpMyEdit
» Fórum
» Error displaying with DG enabled .. |
 |
KyleK29
Založený: 14.09.2004
Príspevky: 5
Zaslal: 2004-09-29 22:33
Návrat hore
Odpovedať s citátom
|
Ok, I got a weird one for ya. My table was displaying/working great for a few weeks. However, I started not getting data on the view (add works), change, delete, etc screens just out of the blue one day. So I rebuilt it using the setup file, and it worked fine (not the table I presume). I ported the options I had setup for the various columns. Everything fine. I ported the CSS file, works fine. The very last thing to be ported over is the Button Display code and that is where my problem lies.
If I have it set to DG, it will only display "Change, Cancel" on anything I click. If I set it to DB (default) it'll display it all (like it's supposed to). It used to work with DG, but just stopped working. Fresh installs & setup with the debug reveal nothing.
I ran debug, this is the code with both instances, it's doing this with all tables using PHPmyEdit DG (or UG, UGB, etc, anything with G) that I have setup.
Here's the ultimate kicker. This happened shortly (can't remember) after I lost the ability to use PHPmyAdmin aswell (for a short while). I emailed my host and it came up shortly afterwards, but since then, that outage of a few days - this has been different (in the way I described).
MySQL version 4.0.20-standard
PHP version 4.3.8
|
KyleK29
Založený: 14.09.2004
Príspevky: 5
Zaslal: 2004-09-29 22:39
Návrat hore
Odpovedať s citátom
|
Forgot the code:
With default 'DB':
| Kód: |
Variables per GET
Variables per POST sfn\[0\]=0 fl=0 operation=View qfn= fm=0 rec=#1
Current instance variables page_name=Hockey_Reports.php hn=localhost un=XXX pw=XXX db=XXX tb=Hockey_Reports key=GM key_type=string inc=25 options=ACPVDF fdd=Array fl=0 fm=0 sfn=sfn[0]=0 qfn= sw= rec=#1 navop= saveadd= moreadd= canceladd= savechange= morechange= cancelchange= savedelete= canceldelete= cancelview= operation=View
query opts:
Array
(
)
1
get vars:
1
*DISPLAYS ALL TABLE DATA LIKE NORMAL* |
With down/graphic 'DG':
| Kód: |
Variables per GET fl=0 fm=0 sfn\[0\]=0 operation=View rec=
Variables per POST
Current instance variables page_name=Hockey_Reports2.php hn=localhost un=XXXX pw=XXXX db=XXXX tb=Hockey_Reports key=GM key_type=string inc=25 options=ACPVDF fdd=Array fl=0 fm=0 sfn=sfn[0]=0 qfn= sw= rec= navop= saveadd= moreadd= canceladd= savechange= morechange= cancelchange= savedelete= canceldelete= cancelview= operation=View
query opts:
Array
(
)
1
get vars:
1
*DISPLAYS Change / Cancel and time/speed*
|
There's subtle differences in there. Obviously the big one is the "rec=" on the DB has a # which corresponds with the column. The ones using T or G have it blank.
Also, incase it's important, DT (UT/etc) also does the same thing. Anything beside default doesn't work to post the data.
If I use DGB, the graphic buttons do not work, but selecting the radial button and clicking (example) "View" works fine. So my guess is that the text/graphic buttons are failing in their linking.
Any ideas?
|
KyleK29
Založený: 14.09.2004
Príspevky: 5
Zaslal: 2004-11-16 00:17
Návrat hore
Odpovedať s citátom
|
Since I was planning on moving hosts anyway, I stopped using it and just waited. Now that I that has happened, I still get the problems. But today, I noticed something that may reveal what the problem could be. I divider columns that I added using the "add" button, each bar is filled with "-" within it. If I use the Graphic buttons to click on one of those, it will open up fine, edit fine, etc. However, if I click the regular-filled out data, it stops.
Here's the kicker, the first column is filled with "Game #" then each row is populated like "#1" "#2" "#3" depending on the game number (for sorting purposes). Now, it appears that the "#" charactor is what is killing the graphic/text buttons. Radial button works fine though. This does appear to be something with the PhP version released around the time of my initial post. As it didn't happen until they updated their PHP version.
As a test, I picked Game#6 and edited the "#06" in the "Game" column to be simply "06" and after doing so, the graphic buttons work as normal. So the problem seems to be with the latest version of PHP and the "#" character in PHPMyEdit non-default mode.
|
michal
Založený: 17.06.2003
Príspevky: 537
Bydlisko: Slovakia
Zaslal: 2004-11-16 11:22
Návrat hore
Odpovedať s citátom
|
# is a special html character.
in phpMyEdit.class.php near line 2042
try to change
$qviewStr = $qpviewStr . '&rec='.$key_rec;
to
$qviewStr = $qpviewStr . '&rec='.htmlspecialchars($key_rec);
|
nepto
Založený: 06.01.2003
Príspevky: 320
Bydlisko: Phoenix, Arizona (USA)
Zaslal: 2004-11-16 21:08
Návrat hore
Odpovedať s citátom
|
Bug? Submit to tracker pls
_________________
Ondrej Jombik (Nepto)
Visit my
homepage
, review my recent
CV
or
projects
and give me some
feedback
.
|
michal
Založený: 17.06.2003
Príspevky: 537
Bydlisko: Slovakia
Zaslal: 2004-11-29 11:30
Návrat hore
Odpovedať s citátom
|
KyleK29 , did it solve your problem or my guess was wrong ?
|
|
Odoslať novú tému
Odpovedať na tému
|
|
|
|
Prihlásiť
Registrácia
English
