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]

Reply via email to