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]
RE: Strange table problem
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]
RE: Strange table problem
At 03:44 AM 12/15/2006, Ruan wrote: 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 ` 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. Is there a reason why you can't use Drop View?? http://dev.mysql.com/doc/refman/5.1/en/drop-view.html Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Strange table problem
LOL - Now I feel silly. Thanks that worked. R -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Friday, December 15, 2006 5:37 PM To: mysql@lists.mysql.com Cc: mysql@lists.mysql.com Subject: RE: Strange table problem At 03:44 AM 12/15/2006, Ruan wrote: 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 ` 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. Is there a reason why you can't use Drop View?? http://dev.mysql.com/doc/refman/5.1/en/drop-view.html Mike -- 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]
Strange table problem
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