ERROR: parser : parse error at or near "dialoguename" at character 15

ERROR: parser : parse error at or near "dialoguename" at character 15

by Worth Bishop -
Number of replies: 1

I am getting the error:

ERROR: parser : parse error at or near "dialoguename" at character 15

posted to my pgsql log every few seconds to every minute or two. Created a 600 Mb log file.

I'm running:

Moodle release 1.4, Version 2004083100
Dialogue version 2004060400
PostgreSQL 7.2
PHP 4.32
Apache 2.0
FreeBSD 4.6

Any thoughts?

Thanks!

Average of ratings: -
In reply to Worth Bishop

Re: ERROR: parser : parse error at or near "dialoguename" at character 15

by Worth Bishop -

Looked at .../mod/dialogue/db/postgres7.sql and found suspects (these the same in versions 1.3, 1.4 & 1.5 as near as I can tell...):

CREATE TABLE prefix_dialogue (
id SERIAL8 PRIMARY KEY,
course INT8 NOT NULL default '0',
deleteafter INT8 NOT NULL default '14',
dialoguetype INT NOT NULL default '0',
multipleconversations INT NOT NULL default '0',
maildefault INT NOT NULL default '0',
timemodified INT8 NOT NULL default '0',
name varchar(255) default NULL,
intro text
) ;

Can anyone tell me if/where the syntax here is off (bolding mine)? Should it be something like:

name varchar(255) NULL,

And also:

INSERT INTO prefix_log_display VALUES ('dialogue', 'view', 'dialogue', 'name');

Thanks!

Average of ratings: -