CRAZY phpMyAdmin Behavior with SQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Sniper007
Forum Newbie
Posts: 17
Joined: Tue May 11, 2004 8:43 pm

CRAZY phpMyAdmin Behavior with SQL

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

sounds like a caching problem..

do you have... Tools > Internet Options > "Settings" button > "Every visit to the page" selected?
Sniper007
Forum Newbie
Posts: 17
Joined: Tue May 11, 2004 8:43 pm

Tried I-net cache settings - no luck

Post 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*
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

what's your cache size set to?
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Re: CRAZY phpMyAdmin Behavior with SQL

Post 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
Sniper007
Forum Newbie
Posts: 17
Joined: Tue May 11, 2004 8:43 pm

Cache Size

Post by Sniper007 »

My Temp Internet Files allowance is 625 Megs.

...Looking into MySQL Front.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

proxy-caching, possibly?
Post Reply