Page 1 of 1

Console + phpMyAdmin not showing updated column names?

Posted: Sat Dec 06, 2008 2:14 am
by JAB Creations
In phpMyAdmin I have not been seeing the updated column names when I revised the naming scheme for columns.

Then to be sure before I started this thread I loaded up DOS and then entered in to MySQL console. I connect, use, describe, and the column names appear as the same old columns names do in phpMyAdmin!

I changed these column names at least two or three weeks ago so I've rebooted my system numerous times since then. I'm not sure what to do and disabling and clearing the cache while obvious clearly hasn't helped me out.

The odd thing is when I execute MySQL queries though PHP I have to select the new column names...and now that I can't view them I'm only getting even more confused...can any one imagine that? :|

Has any one encountered this before? Suggestions please?

The following did not work...
RESET QUERY CACHE
FLUSH TABLES

Re: Console + phpMyAdmin not showing updated column names?

Posted: Sat Dec 06, 2008 5:27 am
by JAB Creations
I manually renamed the columns and they appear to display fine now. I'm still not sure how this happened though I'll know what I have to do if I see any broken MySQL queries.