Hopefully fixed the MySQL 5 problems.

diff --git a/views.module b/views.module
index 9437ca4..4b39014 100644 (file)
--- a/views.module
+++ b/views.module
@@ -1709,7 +1709,7 @@ function _views_save_view($view) {
     // Prepare the query:
     foreach ($view as $key => $value) {
       if (in_array((string) $key, $fields)) {
-        $k[] = db_escape_string($key);
+        $k[] = "`" . db_escape_string($key) "`";
         $v[] = $value;
         $s[] = "'%s'";
       }

diff --git a/views.mysql b/views.mysql
index c945ed3..d11feaf 100644 (file)
--- a/views.mysql
+++ b/views.mysql
@@ -12,7 +12,7 @@ create table if not exists view_view (
   type int(2),
   block int(1),
   url int(2),
-  sql longtext,
+  'sql' longtext,
   countsql longtext,
   changed int(11),
   PRIMARY KEY (vid),