I get these errors when trying to add a factoid:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "bot_factoid" does not exist in /home/rmh3093/public_html/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT COUNT(*) FROM bot_factoid in /home/rmh3093/public_html/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "bot_factoid" does not exist in /home/rmh3093/public_html/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT subject, is_are, statement FROM bot_factoid ORDER BY subject LIMIT 25 OFFSET 0 in /home/rmh3093/public_html/includes/database.pgsql.inc on line 144.

Comments

rmh3093’s picture

rmh3093 commented

fixing the .install file for the factoid solves the problem... fix below is to add "PRIMARY" to key:

CREATE TABLE bot_factoid(
subject varchar(255) NOT NULL default '',
is_are varchar(3) NOT NULL default '',
statement text NOT NULL default '',
PRIMARY KEY (subject)
);

morbus iff’s picture

morbus iff
they/them
commented
Status: Active » Closed (won't fix)

I don't intend to maintain the 5.x branch anymore, and this isn't an issue in 6. Closing.