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 |
Jump to:
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
Updated install file in CVS.
#2