Search found 2 matches

by macchickpro
Fri Apr 30, 2010 1:27 am
Forum: Bug reports
Topic: 2.6.4: Advanced search not finding sequence table
Replies: 1
Views: 2228

2.6.4: Advanced search not finding sequence table

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 ...
by macchickpro
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 ...