Hi, I am on Apache 2.2 php 5.2.6 D6.10 on ubuntu server 8.10 - Installed module, enabled it, no problem, went to configure it and clicked list and got this:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: column "template" does not exist LINE 1: SELECT pid FROM patterns WHERE name = "template" ^ in /var/www/sparcs/includes/database.pgsql.inc on line 139.
    * user warning: query: patterns_save_pattern SELECT pid FROM patterns WHERE name = "template" in /var/www/sparcs/sites/all/modules/patterns/patterns.module on line 684.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "info" LINE 1: ...mple for creating your own patterns.", "a:3:{s:4:"info";a:7:... ^ in /var/www/sparcs/includes/database.pgsql.inc on line 139.
    * user warning: query: patterns_save_pattern INSERT INTO patterns (name, status, file, updated, enabled, title, description, pattern) VALUES ( "template", 0, "sites/all/modules/patterns/patterns/template.xml", "1236182375", 0, "Drupal6 Template", "Template/sample for creating your own patterns.", "a:3:{s:4:"info";a:7:{s:5:"title";s:16:"Drupal6 Template";s:11:"description";s:47:"Template/sample for creating your own patterns.";s:6:"author";s:5:"Vaish";s:12:"author_email";s:20:"vnd@graviteklabs.com";s:7:"version";s:3:"0.1";s:8:"category";s:8:"Template";s:4:"core";s:3:"6.x";}s:7:"modules";a:20:{i:0;s:8:"taxonomy";i:1;s:7:"profile";i:2;s:4:"menu";i:3;s:8:"pathauto";i:4;s:7:"content";i:5;s:10:"fieldgroup";i:6;s:13:"optionwidgets";i:7;s:4:"text";i:8;s:6:"number";i:9;s:10:"imagefield";i:10;s:4:"date";i:11;s:10:"date_popup";i:12;s:8:"imageapi";i:13;s:11:"imageapi_gd";i:14;s:10:"imagecache";i:15;s:13:"imagecache_ui";i:16;s:5:"views";i:17;s:8:"views_ui";i:18;s:5:"devel";i:19;s:10:"admin_menu";}s:7:"actions";a:71:{i:0;a:2:{s:3:"tag";s:17:"imagecache_preset";s:4:"name";s:11:"photo_thumb";}i:1;a:8:{s:3:"tag";s:17:"imagecache_action";s:6:"preset";s:11:"photo_thumb";s:4:"name";s:25:"imagecache_scale_and_crop";s:5:"width";s:5:"120px";s:6:"height";s:5:"120px";s:7:"xoffset";s:6:"center";s:7:"yoffset";s:6:"center";s:6:"weight";s:3:"-10";}i:2;a:2:{s:3:"tag";s:17:"imagecache_preset";s:4:"name";s:10:"photo_page";}i:3;a:5:{s:3:"tag";s:17:"imagecache_action";s:6:"preset";s:10:"photo_page";s:4:"name";s:16:"imagecache_scale";s:5:"width";s:5:"500px";s:6:"height";s:5:"500px";}i:4;a:11:{s:3:"tag";s:7:"content";s:4:"name";s:19:"Sample Content Type";s:4:"type";s:7:"example";s:11:"description";s:39:"Put your content type description here.";s:6:"status";s:1:"1";s:7:"promote";s:1:"1";s:11:"title_label";s:4:"Name";s:10:"body_label";s:11:"Description";s:8:"has_body";s:1:"0";s:7:"comment";s:1:"0";s:6:"upload";s:1:"0";}i:5;a:8:{s:3:"tag";s:5:"group";s:4:"type";s:7:"example";s:4:"name";s:13:"patterns_test";s:5:"label";s:19:"Patterns Test Group";s:6:"weight";s:2:"10";s:5:"style";s:18:"fieldset_collapsed";s:16:"form_description";s:39:"This description goes to the node form.";s:19:"display_description";s:42:"This description goes to the node display.";}i:6;a:10:{s:3:"tag";s:5:"field";s:4:"type";s:7:"example";s:4:"name";s:7:"country";s:5:"label";s:7:"Country";s:6:"option";s:4:"text";s:6:"widget";s:14:"text_textfield";s:4:"size";s:2:"80";s:6:"weight";s:2:"-2";s:10:"max_length";s:3:"128";s:15:"text_processing";s:1:"0";}i:7;a:10:{s:3:"tag";s:5:"field";s:4:"type";s:7:"example";s:4:"name";s:3:"bio";s:5:"label";s:9:"Biography";s:6:"option";s:4:"text";s:6:"widget";s:13:"text_textarea";s:6:"weight";s:1:"6";s:5:"group";s:13:"patterns_test";s:4:"rows";s:1:"2";s:15:"text_processing";s:1:"1";}i:8;a:8:{s:3:"tag";s:5:"field";s:4:"type";s:7:"example";s:4:"name";s:6:"colors";s:5:"label";s:6:"Colors";s:6:"option";s:4:"text";s:6:"widget";s:20:"optionwidgets_select";s:6:"weight";s:1:"7";s:14:"allowed_values";a:5:{i:0;s:7:"red|Red";i:1;s:9:"blue|Blue";i:2;s:14:"navy|Navy Blue";i:3;s:11:"green|Green";i:4;s:13:"yellow|Yellow";}}i:9;a:19:{s:3:"tag";s:5:"field";s:4:"type";s:7:"example";s:4:"name";s:6:"design";s:5:"label";s:6:"Design";s:6:"option";s:5:"image";s:6:"widget";s:17:"imagefield_widget";s:6:"weight";s:1:"8";s:5:"group";s:13:"patterns_test";s:15:"file_extensions";s:12:"jpg jpeg png";s:9:"file_path";s:6:"photos";s:21:"max_filesize_per_file";s:2:"4M";s:21:"max_filesize_per_node";s:3:"20M";s:14:"min_resolution";s:7:"640x480";s:14:"max_resolution";s:9:"1800x1800";s:10:"custom_alt";s:1:"1";s:12:"custom_title";s:1:"1";s:12:"list_default";s:1:"1";s:18:"force_list_default";s:1:"0";s:16:"show_description";s:1:"1";}i:10;a:12:{s:3:"tag";s:5:"field";s:4:"type";s:7:"example";s:4:"name";s:7:"arrival";s:5:"label";s:15:"Time of Arrival";s:6:"option";s:4:"date";s:6:"widget";s:10:"date_popup";s:6:"weight";s:1:"5";s:13:"default_value";s:3:"now";s:12:"input_format";s:11:"Y M j - H:i";s:10:"year_range";s:5:"-1:+1";s:18:"output_format_date";s:11:"Y M j - H:i";s:11:"tz_handling";s:4:"date";}i:11;a:5:{s:3:"tag";s:5:"field";s:4:"type";s:7:"example";s:4:"name";s:7:"country";s:5:"group";s:13:"patterns_test";s:6:"weight";s:2:"-1";}i:12;a:4:{s:3:"tag";s:7:"display";s:4:"type";s:7:"example";s:5:"field";s:13:"field_country";s:5:"label";s:6:"inline";}i:13;a:4:{s:3:"tag";s:7:"display";s:4:"type";s:7:"example";s:5:"field";s:12:"field_colors";s:5:"label";s:6:"inline";}i:14;a:7:{s:3:"tag";s:7:"display";s:4:"type";s:7:"example";s:5:"field";s:9:"field_bio";s:5:"label";s:6:"inline";s:6:"teaser";a:1:{s:7:"exclude";s:1:"1";}s:4:"full";s:7:"trimmed";s:3:"rss";a:2:{s:6:"format";s:5:"plain";s:7:"exclude";s:1:"1";}}i:15;a:7:{s:3:"tag";s:7:"display";s:4:"type";s:7:"example";s:5:"field";s:12:"field_design";s:5:"label";s:6:"hidden";s:6:"teaser";s:18:"photo_thumb_linked";s:4:"full";s:18:"photo_page_default";s:3:"rss";a:1:{s:6:"format";s:18:"photo_thumb_linked";}}i:16;a:7:{s:3:"tag";s:7:"display";s:4:"type";s:7:"example";s:5:"group";s:13:"patterns_test";s:5:"label";s:6:"hidden";s:6:"teaser";s:8:"no_style";s:4:"full";s:20:"fieldset_collapsible";s:3:"rss";a:2:{s:6:"format";s:6:"hidden";s:7:"exclude";s:1:"1";}}i:17;a:3:{s:3:"tag";s:4:"menu";s:4:"name";s:16:"store-categories";s:5:"title";s:10:"Categories";}i:18;a:5:{s:3:"tag";s:9:"menu_item";s:4:"menu";s:10:"Categories";s:5:"title";s:8:"Featured";s:4:"path";s:4:"user";s:6:"weight";s:2:"-4";}i:19;a:5:{s:3:"tag";s:9:"menu_item";s:4:"menu";s:10:"Categories";s:5:"title";s:5:"Music";s:4:"path";s:7:"[front]";s:6:"weight";s:2:"-3";}i:20;a:5:{s:3:"tag";s:9:"menu_item";s:4:"menu";s:10:"Categories";s:5:"title";s:7:"Apparel";s:4:"path";s:4:"user";s:6:"weight";s:2:"-2";}i:21;a:5:{s:3:"tag";s:9:"menu_item";s:4:"menu";s:10:"Categories";s:5:"title";s:12:"Collectibles";s:4:"path";s:4:"user";s:6:"weight";s:2:"-1";}i:22;a:5:{s:3:"tag";s:9:"menu_item";s:4:"menu";s:13:"Primary Links";s:5:"title";s:4:"Home";s:4:"path";s:7:"[front]";s:6:"weight";s:3:"-10";}i:23;a:5:{s:3:"tag";s:9:"menu_item";s:4:"menu";s:13:"Primary Links";s:5:"title";s:5:"About";s:4:"path";s:4:"user";s:6:"weight";s:2:"-8";}i:24;a:6:{s:3:"tag";s:9:"menu_item";s:4:"menu";s:13:"Primary Links";s:5:"title";s:3:"Bio";s:4:"path";s:4:"user";s:6:"weight";s:2:"-5";s:6:"parent";s:5:"About";}i:25;a:5:{s:3:"tag";s:9:"menu_item";s:4:"menu";s:13:"Primary Links";s:5:"title";s:5:"Media";s:4:"path";s:4:"user";s:6:"weight";s:2:"-7";}i:26;a:6:{s:3:"tag";s:9:"menu_item";s:4:"menu";s:13:"Primary Links";s:5:"title";s:6:"Photos";s:4:"path";s:4:"user";s:6:"weight";s:1:"0";s:6:"parent";s:5:"Media";}i:27;a:6:{s:3:"tag";s:9:"menu_item";s:4:"menu";s:13:"Primary Links";s:5:"title";s:6:"Videos";s:4:"path";s:4:"user";s:6:"weight";s:2:"-1";s:6:"parent";s:5:"Media";}i:28;a:2:{s:3:"tag";s:7:"pattern";s:5:"value";s:4:"news";}i:29;a:2:{s:3:"tag";s:4:"role";s:5:"value";s:9:"test role";}i:30;a:2:{s:3:"tag";s:4:"role";s:5:"value";s:6:"editor";}i:31;a:7:{s:3:"tag";s:4:"user";s:4:"name";s:5:"perry";s:8:"password";s:14:"securepassword";s:4:"mail";s:21:"testemail2@domain.com";s:5:"roles";a:2:{i:0;s:9:"test role";i:1;s:6:"editor";}s:7:"contact";s:1:"0";s:8:"timezone";s:5:"+0100";}i:32;a:5:{s:3:"tag";s:11:"permissions";s:4:"role";s:9:"test role";i:0;s:17:"administer blocks";i:1;s:15:"access comments";i:2;s:19:"administer imageapi";}i:33;a:7:{s:3:"tag";s:11:"permissions";s:4:"role";s:6:"editor";i:0;s:15:"access comments";i:1;s:17:"administer blocks";i:2;s:15:"access comments";i:3;s:28:"use PHP for block visibility";i:4;s:13:"post comments";}i:34;a:3:{s:3:"tag";s:11:"permissions";s:5:"value";s:34:"access comments, administer blocks";s:4:"role";s:6:"editor";}i:35;a:4:{s:3:"tag";s:11:"permissions";s:5:"value";s:69:"access comments, administer blocks, administer filters, post comments";s:3:"rid";s:6:"editor";s:9:"overwrite";s:1:"1";}i:36;a:5:{s:3:"tag";s:11:"permissions";s:4:"role";s:6:"editor";s:6:"delete";s:1:"1";i:0;s:17:"administer blocks";i:1;s:15:"access comments";}i:37;a:4:{s:3:"tag";s:10:"vocabulary";s:4:"name";s:4:"Food";s:5:"nodes";a:2:{s:4:"page";s:4:"page";s:7:"example";s:7:"example";}s:6:"weight";s:2:"-5";}i:38;a:3:{s:3:"tag";s:4:"term";s:5:"value";s:13:"Milk Products";s:10:"vocabulary";s:4:"Food";}i:39;a:3:{s:3:"tag";s:4:"term";s:5:"value";s:10:"Vegetables";s:10:"vocabulary";s:4:"Food";}i:40;a:3:{s:3:"tag";s:4:"term";s:5:"value";s:6:"Fruits";s:10:"vocabulary";s:4:"Food";}i:41;a:4:{s:3:"tag";s:4:"term";s:10:"vocabulary";s:4:"Food";s:4:"name";s:6:"Yogurt";s:6:"parent";s:13:"Milk Products";}i:42;a:6:{s:3:"tag";s:4:"term";s:10:"vocabulary";s:4:"Food";s:4:"name";s:4:"Milk";s:6:"parent";s:13:"Milk Products";s:8:"synonyms";a:3:{i:0;s:9:"synonym 1";i:1;s:9:"synonym 2";i:2;s:9:"synonym 3";}s:9:"relations";a:1:{s:5:"value";s:6:"Yogurt";}}i:43;a:4:{s:3:"tag";s:4:"term";s:10:"vocabulary";s:4:"Food";s:4:"name";s:6:"Banana";s:6:"parent";s:6:"Fruits";}i:44;a:4:{s:3:"tag";s:4:"term";s:10:"vocabulary";s:4:"Food";s:4:"name";s:6:"Orange";s:6:"parent";s:6:"Fruits";}i:45;a:4:{s:3:"tag";s:4:"term";s:10:"vocabulary";s:4:"Food";s:4:"name";s:6:"Tomato";s:6:"parent";s:10:"Vegetables";}i:46;a:5:{s:3:"tag";s:10:"vocabulary";s:4:"name";s:9:"Languages";s:5:"nodes";a:2:{s:4:"page";s:4:"page";s:7:"example";s:7:"example";}s:6:"weight";s:2:"-2";s:8:"multiple";s:1:"1";}i:47;a:3:{s:3:"tag";s:4:"term";s:5:"value";s:7:"English";s:10:"vocabulary";s:9:"Languages";}i:48;a:3:{s:3:"tag";s:4:"term";s:5:"value";s:7:"Spanish";s:10:"vocabulary";s:9:"Languages";}i:49;a:3:{s:3:"tag";s:4:"term";s:5:"value";s:7:"Italian";s:10:"vocabulary";s:9:"Languages";}i:50;a:3:{s:3:"tag";s:4:"term";s:5:"value";s:6:"German";s:10:"vocabulary";s:9:"Languages";}i:51;a:3:{s:3:"tag";s:4:"term";s:5:"value";s:6:"French";s:10:"vocabulary";s:9:"Languages";}i:52;a:5:{s:3:"tag";s:10:"vocabulary";s:4:"name";s:8:"Keywords";s:5:"nodes";a:1:{s:4:"page";s:4:"page";}s:6:"weight";s:1:"2";s:4:"tags";s:1:"1";}i:53;a:2:{s:3:"tag";s:5:"theme";s:5:"value";s:7:"garland";}i:54;a:11:{s:3:"tag";s:5:"block";s:5:"title";s:14:"Custom Block 1";s:4:"info";s:17:"Custom Test Block";s:4:"body";s:19:"This is a body text";s:5:"roles";a:2:{i:0;s:9:"test role";i:1;s:18:"authenticated user";}s:10:"visibility";s:1:"1";s:5:"pages";a:3:{i:0;s:7:"[front]";i:1;s:6:"user/*";i:2;s:7:"admin/*";}s:5:"theme";s:7:"garland";s:6:"status";s:1:"1";s:6:"weight";s:2:"-6";s:6:"region";s:4:"left";}i:55;a:5:{s:3:"tag";s:5:"block";s:2:"id";s:6:"user-3";s:5:"theme";s:7:"garland";s:6:"weight";s:2:"-4";s:6:"region";s:4:"left";}i:56;a:7:{s:3:"tag";s:5:"block";s:2:"id";s:10:"menu-devel";s:5:"theme";s:7:"garland";s:6:"status";s:1:"1";s:6:"weight";s:2:"-7";s:6:"region";s:5:"right";s:5:"title";s:12:"Custom Title";}i:57;a:4:{s:3:"tag";s:5:"block";s:2:"id";s:6:"user-1";s:5:"theme";s:7:"garland";s:6:"region";s:5:"right";}i:58;a:4:{s:3:"tag";s:5:"block";s:2:"id";s:6:"user-0";s:5:"theme";s:7:"garland";s:6:"status";s:1:"0";}i:59;a:2:{s:3:"tag";s:9:"variables";s:8:"variable";a:3:{i:0;a:2:{s:5:"value";s:26:"Patterns for Drupal 6 Demo";s:4:"name";s:9:"site_name";}i:1;a:2:{s:5:"value";s:25:"patterns@graviteklabs.com";s:4:"name";s:9:"site_mail";}i:2;a:3:{s:5:"value";s:48:"Project Management System - Drupal Patterns Demo";s:4:"name";s:11:"site_slogan";s:6:"delete";s:1:"1";}}}i:60;a:2:{s:3:"tag";s:9:"variables";s:8:"variable";a:2:{s:5:"value";s:4:"node";s:4:"name";s:14:"site_frontpage";}}i:61;a:3:{s:3:"tag";s:8:"variable";s:5:"value";s:35:"Porting Patterns module to Drupal 6";s:4:"name";s:12:"site_mission";}i:62;a:3:{s:3:"tag";s:8:"variable";s:5:"value";s:36:"Configured by Drupal Patterns Module";s:4:"name";s:11:"site_footer";}i:63;a:3:{s:3:"tag";s:8:"variable";s:4:"name";s:11:"site_footer";s:6:"delete";s:1:"1";}i:64;a:6:{s:3:"tag";s:8:"variable";s:4:"name";s:14:"theme_settings";s:21:"toggle_node_info_page";s:1:"0";s:24:"toggle_node_info_example";s:1:"0";s:21:"toggle_node_info_blog";s:1:"1";s:14:"toggle_favicon";s:1:"0";}i:65;a:2:{s:3:"tag";s:7:"modules";s:6:"module";a:2:{i:0;a:2:{s:5:"value";s:6:"number";s:6:"delete";s:1:"1";}i:1;a:2:{s:5:"value";s:13:"token_actions";s:6:"delete";s:1:"1";}}}i:66;a:6:{s:3:"tag";s:8:"pathauto";s:9:"separator";s:1:"-";s:22:"punctuation_underscore";s:1:"0";s:4:"node";a:3:{s:7:"default";s:17:"pages/[title-raw]";s:4:"blog";s:19:"journal/[title-raw]";s:4:"page";s:11:"[title-raw]";}s:8:"taxonomy";a:1:{s:7:"default";s:36:"categories/[vocab-raw]/[catpath-raw]";}s:12:"user_pattern";s:19:"profiles/[user-raw]";}i:67;a:12:{s:3:"tag";s:7:"profile";s:4:"type";s:9:"textfield";s:8:"category";s:8:"Personal";s:5:"title";s:9:"Last Name";s:4:"name";s:17:"profile_last_name";s:11:"explanation";s:85:"Enter your last name in this field. This field will be displayed on your profile page";s:10:"visibility";s:1:"2";s:4:"page";s:33:"People whose last name is: %value";s:6:"weight";s:2:"-2";s:12:"autocomplete";s:1:"0";s:8:"required";s:1:"1";s:8:"register";s:1:"0";}i:68;a:12:{s:3:"tag";s:7:"profile";s:4:"type";s:9:"selection";s:8:"category";s:8:"Personal";s:5:"title";s:12:"Favorite Car";s:4:"name";s:11:"profile_car";s:10:"visibility";s:1:"2";s:4:"page";s:36:"People whose favorite car is: %value";s:6:"weight";s:1:"5";s:12:"autocomplete";s:1:"0";s:8:"required";s:1:"0";s:8:"register";s:1:"1";s:7:"options";a:4:{i:0;s:8:"Mercedes";i:1;s:3:"BMW";i:2;s:4:"Audi";i:3;s:6:"Toyota";}}i:69;a:10:{s:3:"tag";s:4:"node";s:4:"type";s:4:"page";s:5:"title";s:6:"Page 1";s:9:"teaser_js";s:62:"Summary text that will not be displayed on the full node page.";s:4:"body";s:247:" By wrapping our text with CDATA, we are allowed to use <strong>HTML</strong> mark up. Enter text in the exactly same way as you would do it in the regular node edit form. <ul> <li>item 1</li> <li>item 2</li> <li>item 3</li> </ul> ";s:6:"format";s:1:"2";s:14:"teaser_include";s:1:"0";s:7:"promote";s:1:"1";s:8:"taxonomy";a:3:{i:0;a:3:{s:10:"vocabulary";s:9:"Languages";i:0;s:6:"German";i:1;s:7:"Spanish";}i:1;a:2:{s:5:"value";s:6:"Orange";s:10:"vocabulary";s:4:"Food";}i:2;a:2:{s:5:"value";s:26:"keyword1,keyword2,keyword3";s:10:"vocabulary";s:8:"Keywords";}}s:18:"taxonomy_overwrite";s:1:"1";}i:70;a:10:{s:3:"tag";s:4:"node";s:4:"type";s:7:"example";s:5:"title";s:9:"Example 1";s:6:"author";s:5:"perry";s:6:"status";s:1:"1";s:7:"promote";s:1:"0";s:6:"sticky";s:1:"1";s:7:"comment";s:1:"0";s:8:"taxonomy";a:2:{i:0;a:3:{s:10:"vocabulary";s:9:"Languages";i:0;s:7:"English";i:1;s:7:"Italian";}i:1;a:2:{s:5:"value";s:4:"Milk";s:10:"vocabulary";s:4:"Food";}}s:6:"fields";a:4:{s:3:"bio";a:2:{s:5:"value";s:16:"Short biography.";s:6:"format";s:1:"1";}s:6:"colors";s:4:"blue";s:7:"country";s:5:"Italy";s:7:"arrival";a:2:{s:5:"value";s:19:"2008-09-09 08:08:00";s:8:"timezone";s:11:"Europe/Rome";}}}}}") in /var/www/sparcs/sites/all/modules/patterns/patterns.module on line 694.

Comments

bpeter’s picture

Status: Active » Closed (duplicate)
Issue tags: +PostgreSQL