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
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
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.
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?
if the error is common as my /tmp directory is full or small, how it can be fixed?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
works fine !!