Hi, The dump revealed this:
--------------------------------------------------------------------+ | View | Create View | test | CREATE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY DEFINER VIEW `test` AS select `beta_users`.`user_id` AS `user_id`,`beta_user s`.`user_type` AS `user_type`,`beta_users`.`group_id` AS `group_id`,`beta_users` .`user_permissions` AS `user_permissions`,`beta_users`.`user_perm_from` AS `user _perm_from`,`beta_users`.`user_ip` AS `user_ip`,`beta_users`.`user_regdate` AS ` user_regdate`,`beta_users`.`username` AS `username`,`beta_users`.`user_password` AS `user_password`,`beta_users`.`user_passchg` AS `user_passchg`,`beta_users`.` user_email` AS `user_email`,`beta_users`.`user_email_hash` AS `user_email_hash`, `beta_users`.`user_birthday` AS `user_birthday`,`beta_users`.`user_lastvisit` AS `user_lastvisit`,`beta_users`.`user_lastmark` AS `user_lastmark`,`beta_users`.` user_lastpost_time` AS `user_lastpost_time`,`beta_users`.`user_lastpage` AS Carries on for quite a bit longer... If it is a view, how would one go about removing it? Thanks for your help and quick response. R -----Original Message----- From: Lakshmi M P [mailto:[EMAIL PROTECTED] Sent: Friday, December 15, 2006 10:43 AM To: Ruan Cc: mysql@lists.mysql.com Subject: Re: Strange table problem 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]