hellios78 / flexviews

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

script trying to insert record in wrong table #10

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. cd consumer/
2. php run_consumer.php
3. wait for queries

What is the expected output? What do you see instead?
script crash

What version of the product are you using? On what operating system?
flexviews 1.7.1

Please provide any additional information below.

The line at 
http://code.google.com/p/flexviews/source/browse/trunk/consumer/include/flexcdc.
php#635

if($valList) {
  my_mysql_query($sql . $valList, $this->dest) or die1("COULD NOT EXEC SQL:\n$sql\n" . mysql_error() . "\n");
}

trying to insert record value from previous table in the loop.

Fix suggestion :

if($valList) {
  my_mysql_query($sql . $valList, $this->dest) or die1("COULD NOT EXEC SQL:\n$sql\n" . mysql_error() . "\n");
  $valList ='';
}

Original issue reported on code.google.com by c.liouke...@gmail.com on 6 Sep 2011 at 2:11

GoogleCodeExporter commented 9 years ago
This appears to be a problem with RENAME TABLE support.

Will investigate further.

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

GoogleCodeExporter commented 9 years ago
Fixed in latest SVN.

Original comment by greenlion@gmail.com on 1 Jul 2012 at 9:25

GoogleCodeExporter commented 9 years ago
Fixed in latest SVN.

Original comment by greenlion@gmail.com on 1 Jul 2012 at 9:25

GoogleCodeExporter commented 9 years ago
This somehow regressed.  Fixed again in commit 266.

Original comment by greenlion@gmail.com on 4 Jul 2012 at 12:03