Alright, I was able to ignore it at first, but NOW it's really starting to get on my NERVES.
I can create a table just fine in my database. And when I try to make CHANGES to the STRUCTURE of the table, they take effect... but the the changes are not always DISPLAYED under the STRUCTURES tab in phpMyAdmin!!! Often times I could get the changes to display by clicking on another tab (like SQL or Browse) then clicking BACK onto the structures tab. BUT NOW THAT isn't even working! It's almost like phpMyAdmin is loading a stored version of what it thinks my structure page looks like... This same strange event has ALSO occurred under the BROWSE tab after making changes in the table's data.
I know the changes I make are taking place in reality (despite what phpMyAdmin tells me) because I can still run queries on new columns (for example) that I've inserted into my table structure (despite the fact that these columns don't show up when viewing my structure.)
PLEASE, this is VERY disorientating. It's so difficult to work on a database when what you are being shown is not what actually exists! Maybe it's something to do with my browser (IE 6.0). Any ideas?
CRAZY phpMyAdmin Behavior with SQL
Moderator: General Moderators
Tried I-net cache settings - no luck
Yes, that was one of the first things I tried, but unfortunately it didn't work. It's getting so bad where I don't even know what is in my database anymore. Tables are showing up that I deleted... But when I try to delete them again phpMyAdmin tells me it's not there...
NO CRAP its not there! WHY ARE YOU SHOWING IT TO ME!?
*slaps phpMyAdmin*
NO CRAP its not there! WHY ARE YOU SHOWING IT TO ME!?
*slaps phpMyAdmin*
-
malcolmboston
- DevNet Resident
- Posts: 1826
- Joined: Tue Nov 18, 2003 1:09 pm
- Location: Middlesbrough, UK
Re: CRAZY phpMyAdmin Behavior with SQL
I have exactly the same problem, i now use MySQL FrontSniper007 wrote:Alright, I was able to ignore it at first, but NOW it's really starting to get on my NERVES.
I can create a table just fine in my database. And when I try to make CHANGES to the STRUCTURE of the table, they take effect... but the the changes are not always DISPLAYED under the STRUCTURES tab in phpMyAdmin!!! Often times I could get the changes to display by clicking on another tab (like SQL or Browse) then clicking BACK onto the structures tab. BUT NOW THAT isn't even working! It's almost like phpMyAdmin is loading a stored version of what it thinks my structure page looks like... This same strange event has ALSO occurred under the BROWSE tab after making changes in the table's data.
I know the changes I make are taking place in reality (despite what phpMyAdmin tells me) because I can still run queries on new columns (for example) that I've inserted into my table structure (despite the fact that these columns don't show up when viewing my structure.)
PLEASE, this is VERY disorientating. It's so difficult to work on a database when what you are being shown is not what actually exists! Maybe it's something to do with my browser (IE 6.0). Any ideas?
Cache Size
My Temp Internet Files allowance is 625 Megs.
...Looking into MySQL Front.
...Looking into MySQL Front.