FUDforum: Bug Reports » fud30_group_cache table, shouldn't it be a view?

Home » FUDforum Development » Bug Reports » fud30_group_cache table, shouldn't it be a view?

Show: Today's Messages :: Polls :: Message Navigator

Re: fud30_group_cache table, shouldn't it be a view? [message #167448 is a reply to message #167361]

Fri, 22 June 2012 07:31

NeXuS
Messages: 121
Registered: July 2010
Location: South Korea

Karma:

Senior Member
Contributing Core Developer

I have a patch ready with the q_bit syntax everyting, but it seems I have hit a problem with MySQL views.
The select statement works as expected but the view gives an error

ERROR 1356 (HY000): View 'fud_test.group_cache' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use

I am filing a bug in a few minutes, let's see if there is any answer.

Report message to a moderator

[Message index]

		fud30_group_cache table, shouldn't it be a view? By: NeXuS on Sat, 26 May 2012 06:41
		Re: fud30_group_cache table, shouldn't it be a view? By: naudefj on Sat, 26 May 2012 08:03
		Re: fud30_group_cache table, shouldn't it be a view? By: NeXuS on Sat, 09 June 2012 10:03
		Re: fud30_group_cache table, shouldn't it be a view? By: naudefj on Sat, 09 June 2012 12:30
		Re: fud30_group_cache table, shouldn't it be a view? By: NeXuS on Sat, 09 June 2012 13:21
		Re: fud30_group_cache table, shouldn't it be a view? By: NeXuS on Sat, 09 June 2012 14:31
		Re: fud30_group_cache table, shouldn't it be a view? By: naudefj on Sun, 10 June 2012 07:42
		Re: fud30_group_cache table, shouldn't it be a view? By: NeXuS on Fri, 22 June 2012 07:31
		Re: fud30_group_cache table, shouldn't it be a view? By: NeXuS on Wed, 27 June 2012 00:40
		Re: fud30_group_cache table, shouldn't it be a view? By: naudefj on Wed, 27 June 2012 06:31
		Re: fud30_group_cache table, shouldn't it be a view? By: NeXuS on Wed, 27 June 2012 06:52

Previous Topic:	upgrade.php and q_bitand()
Next Topic:	Backup bug

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 14:51:10 GMT 2024

Total time taken to generate the page: 0.04188 seconds