Dashboard Database Query Error - PostgreSQL

Created on 13 May 2011, almost 14 years ago
Updated 11 January 2024, over 1 year ago

Hi to everyone!

First of all I use PostgreSQL, PHP 5.1.

I tried to see this module and I had a problem with the install. After that I had another error with the Dashboard pages (but I think is because the same problem).

Query failed: ERROR: null value in column "conf" violates not-null constraint in ....

The problem was line 14 in dashboard.install

update_sql("INSERT INTO {dashboard_default} (id, title,description,thumbnail,tags,default_enabled,widget_type,subtype) VALUES ('1','Recent Comments Block', 'Recent Comments.', '0','comments','1','block','comment-0')");

In the database the field: conf is set as NOT NULL, so the DB expect some value.

The second error that I mentioned was in: www.Mysite.com/dashboard/widgets

warning: Invalid argument supplied for foreach() in
modules/dashboard/templates/dashboard-browse-widgets.tpl.php on line 3.

Thank you!

Alek

PS: It is not the place but the Recent Comments Block also has a query Warning:
warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select...
user warning: query: SELECT DISTINCT nc.nid FROM mysite_node_comment_statistics nc WHERE nc.comment_count > 0 ORDER BY nc.last_comment_timestamp DESC LIMIT 10 OFFSET 0 in modules/comment/comment.module on line 314.

🐛 Bug report
Status

Closed: won't fix

Version

2.1

Component

Code

Created by

🇦🇷Argentina alek123

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024