hellios78 / flexviews

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

setup problems #1

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
Hi,

Latest trunk tries to check the format of the binlog in the destination server, 
not on the source.

The attached patch fixes that, and the case of undefined '$pr'.

Regards,
Luciano Rocha

Original issue reported on code.google.com by lfro...@gmail.com on 29 Mar 2011 at 12:01

Attachments:

GoogleCodeExporter commented 9 years ago
The patch was wrong, attaching a working one.

Original comment by lfro...@gmail.com on 29 Mar 2011 at 2:32

Attachments:

GoogleCodeExporter commented 9 years ago
Thank you for the contribution.  I will apply your fix shortly.

Original comment by greenlion@gmail.com on 26 Apr 2011 at 8:26

GoogleCodeExporter commented 9 years ago

Original comment by justin.s...@percona.com on 28 Apr 2011 at 2:39

GoogleCodeExporter commented 9 years ago
Index: flexcdc.php
===================================================================
--- flexcdc.php (revision 235)
+++ flexcdc.php (working copy)
@@ -49,7 +49,11 @@

        if(!$r) {
                echo1("SQL_ERROR IN STATEMENT:\n$a\n");
-               if($debug){ $pr=print_r(debug_backtrace(),true); echo1($pr); }
+               if($debug) {
+                       $pr = mysql_error($b);
+                       echo1(print_r(debug_backtrace(),true));
+                       echo1($pr);
+               }
        }

        return $r;
@@ -440,7 +444,7 @@

                $sql = "select @@binlog_format";
-               $stmt = my_mysql_query($sql, $this->dest);
+               $stmt = my_mysql_query($sql, $this->source);
                $row = mysql_fetch_array($stmt) or die1($sql . "\n" . mysql_error() . "\n");

                if($row[0] != 'ROW') {

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