Link to home
Start Free TrialLog in
Avatar of AussieSilver
AussieSilver

asked on

#126 phpmyadmin error

Hi, im using phpMyAdmin to keep track my database, when i select any databases and select a table then click to structure >> it show me this error

Error

SQL query: Edit Edit

SHOW FULL FIELDS FROM `account` ;

MySQL said: Documentation
#126 -


it happened recently, it was working fine before, could someone please give some help !!
thank you
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Try "SHOW FULL COLUMNS FROM `account` ;"  'FIELDS' doesn't appear in the documentation.  http://dev.mysql.com/doc/refman/5.0/en/show-columns.html
This is common if your /tmp directory is full or to small for the operation to complete in.
Avatar of AussieSilver
AussieSilver

ASKER

even I tried the command SHOW FULL COLUMNS FROM `account` ;"  'FIELDS'; it showing the same error and also SHOW COLUMNS FROM mydb; showing error #1146 -
if the error is common as my /tmp directory is full or small, how it can be fixed?
ASKER CERTIFIED SOLUTION
Avatar of Cory Hanson
Cory Hanson
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
works fine !!