* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "nodeapproval" does not exist in /home/herni/public_html/test/includes/database.pgsql.inc on line 84.
* user warning: query: SELECT COUNT(*) FROM node n LEFT JOIN nodeapproval app ON n.nid = app.nid WHERE app.approved IS NULL AND n.type IN ('book page', 'fileshare', 'Event Calendar', 'image', 'page', 'story') in /home/herni/public_html/test/includes/database.pgsql.inc on line 103.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "nodeapproval" does not exist in /home/herni/public_html/test/includes/database.pgsql.inc on line 84.
* user warning: query: SELECT n.nid, app.approved FROM node n LEFT JOIN nodeapproval app ON n.nid = app.nid WHERE app.approved IS NULL AND n.type IN ('book page', 'fileshare', 'Event Calendar', 'image', 'page', 'story') ORDER BY created DESC LIMIT 30 OFFSET 0 in /home/herni/public_html/test/includes/database.pgsql.inc on line 103.

Comments

robertdouglass’s picture

robertdouglass commented
Assigned: Unassigned » robertdouglass

The postgres tables aren't created in nodeapproval.info. Please provide a tested pg schema and I'll update.

herni7881’s picture

herni7881 commented

did u mean a database schema?

robertdouglass’s picture

robertdouglass commented

Yes, I meant "a tested PostGres schema" =)

herni7881’s picture

herni7881 commented

this is the amendment but have the errors :(

function nodeapproval_install() {
drupal_set_message('Installing node approval');
switch ($GLOBALS['db_type']) {
case 'mysql':
case 'mysqli':
db_query("CREATE TABLE nodeapproval (
nid INT NOT NULL ,
uid INT NOT NULL ,
time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
approved TINYINT NOT NULL ,
PRIMARY KEY ( nid ) ,
INDEX ( approved );
);");
break;
case 'pgsql':
$query = db_query("CREATE TABLE nodeapproval (
nid integer NOT NULL,
uid integer NOT NULL,
'time' timestamp with time zone NOT NULL,
approved smallint NOT NULL,
PRIMARY KEY (nid)
); CREATE INDEX {nodeapproval}_approved_key ON {nodeapproval} (approved);");
break;
}
}

herni7881’s picture

herni7881 commented

correction:

above is the amendment..but have the SAME errors.