Page 1 of 1

CRAZY phpMyAdmin Behavior with SQL

Posted: Sat May 15, 2004 11:31 pm
by Sniper007
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?

Posted: Sat May 15, 2004 11:41 pm
by feyd
sounds like a caching problem..

do you have... Tools > Internet Options > "Settings" button > "Every visit to the page" selected?

Tried I-net cache settings - no luck

Posted: Sun May 16, 2004 12:08 am
by Sniper007
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*

Posted: Sun May 16, 2004 12:17 am
by feyd
what's your cache size set to?

Re: CRAZY phpMyAdmin Behavior with SQL

Posted: Sun May 16, 2004 5:21 am
by malcolmboston
Sniper007 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?
I have exactly the same problem, i now use MySQL Front

Cache Size

Posted: Sun May 16, 2004 10:43 am
by Sniper007
My Temp Internet Files allowance is 625 Megs.

...Looking into MySQL Front.

Posted: Sun May 16, 2004 11:18 am
by feyd
Have you tried setting that down to a more managable, 10MB or something? Mine's set around there and I have no issues with caching nearly anything.

Posted: Sun May 16, 2004 4:17 pm
by patrikG
proxy-caching, possibly?