Closed (fixed)
Project:
RelatedContent
Version:
5.x-1.0
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
26 Mar 2007 at 22:17 UTC
Updated:
23 Apr 2007 at 23:45 UTC
Installing this module gave me the following error:
* user warning: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead query: CREATE TABLE if not exists relatedcontent ( nid int, include_nid int, PRIMARY KEY (nid, include_nid) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in .../drupal/includes/database.mysql.inc on line 172.
* Failed to create database table for RelatedContent.
Adding NOT NULL to each column and running the query manually seemed to fix the problem:
CREATE TABLE if not exists relatedcontent ( nid int NOT NULL, include_nid int NOT NULL, PRIMARY KEY (nid, include_nid) )
Comments
Comment #1
TBarregren commentedI'm sorry that I haven't respond earlier. I will look into and hopefully fix this bug later this week. Thank you for your patience.
Comment #2
TBarregren commentedFixed in version 1.1.
Thank you for pointing it out. For some reason unclear to me, my MySQL installation didn't complain on the odiously error.
Comment #3
(not verified) commented