2.6.4: Advanced search not finding sequence table

[macchickpro]

From 2.0.15
PGSQL 8.4
PHP 5.3
macosx 10.6.3

When click on advanced search with empty string the results are displayed normally; When putting a value into the search string Postgres returns error:

Code: Select all

Query failed: ERROR: relation "faqsearches_id_seq" does not exist LINE 1: SELECT nextval('faqsearches_id_seq') as current_id; ^ in Pgsql.php on line 91

Which is correct, this table hasn't been created when the database was updated with the update.php script. Here is the list of the relations I have after the update:

Code: Select all

                   List of relations
 Schema |            Name            |   Type   | Owner 
--------+----------------------------+----------+-------
 public | faqadminlog                | table    | www
 public | faqadminlog_id_seq         | sequence | www
 public | faqattachment              | table    | www
 public | faqattachment_file         | table    | www
 public | faqattachment_id_seq       | sequence | www
 public | faqcaptcha                 | table    | www
 public | faqcategories              | table    | www
 public | faqcategories_id_seq       | sequence | www
 public | faqcategory_group          | table    | www
 public | faqcategory_user           | table    | www
 public | faqcategoryrelations       | table    | www
 public | faqchanges                 | table    | www
 public | faqchanges_id_seq          | sequence | www
 public | faqcomments                | table    | www
 public | faqcomments_id_comment_seq | sequence | www
 public | faqconfig                  | table    | www
 public | faqdata                    | table    | www
 public | faqdata_group              | table    | www
 public | faqdata_id_seq             | sequence | www
 public | faqdata_revisions          | table    | www
 public | faqdata_revisions_id_seq   | sequence | www
 public | faqdata_tags               | table    | www
 public | faqdata_user               | table    | www
 public | faqglossary                | table    | www
 public | faqglossary_id_seq         | sequence | www
 public | faqgroup                   | table    | www
 public | faqgroup_group_id_seq      | sequence | www
 public | faqgroup_right             | table    | www
 public | faqlinkverifyrules         | table    | www
 public | faqlinkverifyrules_id_seq  | sequence | www
 public | faqnews                    | table    | www
 public | faqnews_id_seq             | sequence | www
 public | faqquestions               | table    | www
 public | faqquestions_id_seq        | sequence | www
 public | faqright                   | table    | www
 public | faqright_right_id_seq      | sequence | www
 public | faqsearches                | table    | www
 public | faqsessions                | table    | www
 public | faqsessions_sid_seq        | sequence | www
 public | faqstopwords               | table    | www
 public | faqtags                    | table    | www
 public | faqtags_tagging_id_seq     | sequence | www
 public | faquser                    | table    | www
 public | faquser_group              | table    | www
 public | faquser_right              | table    | www
 public | faquser_user_id_seq        | sequence | www
 public | faquserdata                | table    | www
 public | faquserdata_user_id_seq    | sequence | www
 public | faquserlogin               | table    | www
 public | faqvisits                  | table    | www
 public | faqvisits_id_seq           | sequence | www
 public | faqvoting                  | table    | www
 public | faqvoting_id_seq           | sequence | www
(53 rows)

[Thorsten]

Hi,

I'll check this issue.

bye
Thorsten