I dont think product_beta.test is a table...It seems to be a view..
what is the create statement for it..
show create table product_beta.test; ???
-Lakshmi
Ruan wrote:
Hi everybody,
I have a very strange table problem - a table was created in one of our
databases, but I can't seem to drop it.
I tried with phpmyadmin and with mysql from command-line.
If I try to view it I receive this error:
View 'product_beta.test' references invalid table(s) or column(s) or
function(s) or definer/invoker of view lack rights to use them
And when I try to repair it:
| product_beta.test | repair | error | 'product_beta.test' is not BASE
TABLE |
I am logged in as root so I don't think it is a rights problem.
Any ideas on how to get rid of it?
Regards
Ruan Fourie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]