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:
Query failed: ERROR: relation "faqsearches_id_seq" does not exist LINE 1: SELECT nextval('faqsearches ...
Search found 2 matches
- Fri Apr 30, 2010 1:27 am
- Forum: Bug reports
- Topic: 2.6.4: Advanced search not finding sequence table
- Replies: 1
- Views: 2228
- Fri Apr 30, 2010 1:23 am
- Forum: Bug reports
- Topic: 2.6.4 upgrade error in update.php
- Replies: 1
- Views: 2364
2.6.4 upgrade error in update.php
From 2.0.15
PGSQL 8.4
PHP 5.3
macosx 10.6.3
update.php has an error in one of the query line 365/366
$query[] = "ALTER TABLE ".SQLPREFIX."faqdata ADD sticky INTEGER NOT NULL AFTER active";
$query[] = "ALTER TABLE ".SQLPREFIX."faqdata_revisions ADD sticky INTEGER NOT NULL AFTER active";
AFTER ...
PGSQL 8.4
PHP 5.3
macosx 10.6.3
update.php has an error in one of the query line 365/366
$query[] = "ALTER TABLE ".SQLPREFIX."faqdata ADD sticky INTEGER NOT NULL AFTER active";
$query[] = "ALTER TABLE ".SQLPREFIX."faqdata_revisions ADD sticky INTEGER NOT NULL AFTER active";
AFTER ...