Closed (won't fix)
Project:
Drupal core
Version:
5.10
Component:
aggregator.module
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
7 Oct 2008 at 10:48 UTC
Updated:
22 Jun 2011 at 00:08 UTC
I was trying to use agregator module but got following error when tried to add feed (admin/content/aggregator/add/feed):
user warning: Field 'description' doesn't have a default value query: INSERT INTO aggregator_feed (fid, title, url, refresh, block) VALUES (2, '3dnews.ru', 'http://3dnews.ru/news/rss/', 10800, 5) in .../database.mysql.inc on line 172.
If we'll check SQL scheme we'll see that 2 fields has NOT NULL options but isn't filled within queries.
db_query("CREATE TABLE {aggregator_feed} (
fid int NOT NULL auto_increment,
title varchar(255) NOT NULL default '',
url varchar(255) NOT NULL default '',
refresh int NOT NULL default '0',
checked int NOT NULL default '0',
link varchar(255) NOT NULL default '',
description longtext NOT NULL,
image longtext NOT NULL,
etag varchar(255) NOT NULL default '',
modified int NOT NULL default '0',
block tinyint NOT NULL default '0',
PRIMARY KEY (fid),
UNIQUE KEY link (url),
UNIQUE KEY title (title)
) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
There are also more tables that need to be updated, "aggregator_feed" is just an example which completely braking agregator functionality - I'm unable to add feed. I'm using latest Mysql server community edition.
Comments
Comment #1
dpearcefl commentedConsidering the time elapsed between now and the last comment plus the fact that D5 is no longer supported, I am closing this ticket.