hellios78 / flexviews

Automatically exported from code.google.com/p/flexviews
0 stars 0 forks source link

flexviews.flexview_mview_signal table not found #6

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Created a simple table as per the instruction in the demo file
2. Followed the instructions given
3. Ran CALL flexviews.refresh(flexviews.get_id('game', 'player_points'), 
'BOTH', NULL);

What is the expected output? What do you see instead?
flexviews.flexview_mview_signal table not found
After digging found that at line 214 in procs/refresh.sql there is a reference 
to a table flexviews.flexviews_mview_signal. This table is not present in the 
schema nor is it available anywhere in the code. 

What version of the product are you using? On what operating system?
MySQL 5.1.X 
CentOS 5.5

Please provide any additional information below.
flexviews.flexviews_mview_signal

Original issue reported on code.google.com by poorna.s...@gmail.com on 5 Jul 2011 at 6:02

GoogleCodeExporter commented 9 years ago
The flexviews.flexviews_mview_signal table is created by the install program by 
calling:
call flexviews.create_mvlog('flexviews','signal');

Please double check the installation steps to determine if a step was missed 
somewhere, or perhaps an error was encountered during setup.

Original comment by greenlion@gmail.com on 12 Jul 2011 at 11:00

GoogleCodeExporter commented 9 years ago
Correct, but a small typo... worked with 
CALL flexviews.create_mvlog('flexviews', 'mview_signal');

Original comment by shash...@cozygames.co.uk on 13 Jul 2011 at 5:16

GoogleCodeExporter commented 9 years ago
Make sure you use the latest tarball ([1.7.1] released yesterday).
This release fixes a bug in logging for UPDATE statements.

Original comment by greenlion@gmail.com on 13 Jul 2011 at 6:59

GoogleCodeExporter commented 9 years ago

Original comment by greenlion@gmail.com on 30 Jun 2012 at 6:25