Home » Download » Modules » Custom filter » Issues

PostgreSQL installation errors

kohlerj - December 27, 2007 - 19:42
Project:Custom filter
Version:5.x-1.2
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed
Description

Hi,
Not sure if this is a real bug, but I'll mention it. The first time I visited the url en/admin/settings/customfilter I got the following warnings:

warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT sid, name, description FROM customfilter_set WHERE 1=1 ORDER BY name in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT sid, name, description FROM customfilter_set WHERE 1=1 ORDER BY name in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.

I then proceeded to import the sample file and got these:

warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set_sid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_set_sid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set_sid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_set_sid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set_sid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_set_sid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: INSERT INTO customfilter_set (sid, name, cache, description, shorttips, longtips) VALUES(0, 'MediaWiki', 1, 'Allows user to use MediaWiki syntax (incomplete).', 'You can use MediaWiki syntax (incomplete).', 'You can use MediaWiki syntax. This filter is for demonstration purpose only, not a complete mediawiki parser. You write You get ''''italic'''' italic ''''''bold'''''' bold ''''''''''bold-italic'''''''''' bold-italic =Heading 1=
==Heading 2==
===Heading 3===

Heading 1

Heading 2

Heading 3

(space)some preformatted text some preformatted text [http://drupal.org Drupal] Drupal * List 1
* List 2
** List 2.1

  • List 1
  • List 2
    • List 2.1

# List 1
# List 2
## List 2.1

  1. List 1
  2. List 2
    1. List 2.1

'); in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
user warning: query: INSERT INTO customfilter_filter (fid, sid, parentid, name, description, matches, pattern, replacement, func, weight) VALUES(0, 0, 0, 'TOC', 'Table of Contents', 0, '/^/', 'if (is_array($vars->headings) && count($vars->headings) > 0) { $result = ''''; $result .= ''

Table of contents

''; $lastlevel = 0; foreach ($vars->headings as $heading) { if ($heading[''level''] > $lastlevel) { for ($i = $heading[''level'']; $i > $lastlevel; $i--) { $result .= ''

    ''; } } elseif ($heading[''level''] < $lastlevel) { for ($i = $heading[''level'']; $i < $lastlevel; $i++) { $result .= ''

''; } } else { $result .= ''

''; } $result .= "

  • {$heading[''text'']}"; $lastlevel = $heading[''level'']; } for ($i = 0; $i < $lastlevel; $i++) $result .= ''

    • ''; $result .= ''''; } else $result = ''''; return $result;', 1, 10); in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.

    The import did not warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set_sid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_set_sid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set_sid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_set_sid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set_sid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_set_sid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter_fid_seq" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: SELECT nextval('customfilter_filter_fid_seq') in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_set" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: INSERT INTO customfilter_set (sid, name, cache, description, shorttips, longtips) VALUES(0, 'MediaWiki', 1, 'Allows user to use MediaWiki syntax (incomplete).', 'You can use MediaWiki syntax (incomplete).', 'You can use MediaWiki syntax. This filter is for demonstration purpose only, not a complete mediawiki parser. You write You get ''''italic'''' italic ''''''bold'''''' bold ''''''''''bold-italic'''''''''' bold-italic =Heading 1=
    ==Heading 2==
    ===Heading 3===

    Heading 1

    Heading 2

    Heading 3

    (space)some preformatted text some preformatted text [http://drupal.org Drupal] Drupal * List 1
    * List 2
    ** List 2.1

    • List 1
    • List 2
      • List 2.1

    # List 1
    # List 2
    ## List 2.1

    1. List 1
    2. List 2
      1. List 2.1

    '); in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.
    warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "customfilter_filter" does not exist in /var/drupal-esperanto/includes/database.pgsql.inc on line 125.
    user warning: query: INSERT INTO customfilter_filter (fid, sid, parentid, name, description, matches, pattern, replacement, func, weight) VALUES(0, 0, 0, 'TOC', 'Table of Contents', 0, '/^/', 'if (is_array($vars->headings) && count($vars->headings) > 0) { $result = ''''; $result .= ''

    Table of contents

    ''; $lastlevel = 0; foreach ($vars->headings as $heading) { if ($heading[''level''] > $lastlevel) { for ($i = $heading[''level'']; $i > $lastlevel; $i--) { $result .= ''

      ''; } } elseif ($heading[''level''] < $lastlevel) { for ($i = $heading[''level'']; $i < $lastlevel; $i++) { $result .= ''

    ''; } } else { $result .= ''

    ''; } $result .= "

  • {$heading[''text'']}"; $lastlevel = $heading[''level'']; } for ($i = 0; $i < $lastlevel; $i++) $result .= ''

    • ''; $result .= ''''; } else $result = ''''; return $result;', 1, 10); in /var/drupal-esperanto/includes/database.pgsql.inc on line 144.

    I didn't see any filter in the list after this.

    » Login or register to post comments

    #1

    kohlerj - December 27, 2007 - 19:45

    Umm... apologies for the formatting. I'll use Preview in future :-/ .

    Login or register to post comments

    #2

    arhip - January 1, 2008 - 09:13

    Please try again with the newest development snapshot.

    Login or register to post comments

    #3

    kohlerj - January 5, 2008 - 10:51

    I tried the latest development snapshot on my existing db and didn't have any problems. However, before that I managed to modify the .install to add support for pgsql through trial and error. One difference between what I did and the dev version is CREATE SEQUENCE (see attached). I'll try to use dev on a clean db, but for now I'm content.

    AttachmentSize
    diff-5.x-1.2-dev.txt 3.02 KB
    Login or register to post comments

    #4

    KiamLaLuno - July 1, 2009 - 15:31
    Status:active» fixed

    I am setting this report as fixed because it has been fixed in the development snapshot.

    Login or register to post comments

    #5

    KiamLaLuno - July 1, 2009 - 15:31
    Title:First use warnings with pgsql» PostgreSQL installation errors
    Login or register to post comments

    #6

    System Message - July 15, 2009 - 15:40
    Status:fixed» closed

    Automatically closed -- issue fixed for 2 weeks with no activity.

    Login or register to post comments
     
     

    Drupal is a registered trademark of Dries Buytaert.