Adding feed freezes - image field wrong type in table aggregator_feed

rseiser - July 1, 2007 - 21:34
Project:Feedparser
Version:5.x-1.x-dev
Component:Miscellaneous
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed
Description

I could not add a feed since the browser just froze. I tracked it down to the database table "aggregator_feed". Here, it couldn't insert an entry if image was not given. The setting for field "image" seems to be conflicting. On the one hand it is checked "Not Null". On the other hand no default value can be given for type "blob/text". This might be a mysql thing.
I fixed it by removing the "Not Null" criteria.

If anyone else has the same problem, this might be the place to fix in feedmanager.install:

    case 'mysqli':
:
:
      db_query("CREATE TABLE IF NOT EXISTS {aggregator_feed} (
:
:
-        image longtext NOT NULL,
+        image longtext,

#1

budda - July 3, 2007 - 09:56
Status:needs review» fixed

Updated install file in CVS.

#2

Anonymous - July 17, 2007 - 10:15
Status:fixed» closed
 
 

Drupal is a registered trademark of Dries Buytaert.