Closed (outdated)
Project:
Private
Version:
5.x-1.0
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
1 Jul 2007 at 13:47 UTC
Updated:
26 Sep 2016 at 15:43 UTC
Jump to comment: Most recent
On install, the private table is not created :
user warning: You have an error in your SQL syntax near '; ' at line 6 query:
CREATE TABLE private ( nid int(10) unsigned NOT NULL default '0' PRIMARY KEY,
private int, KEY private_nid (nid) ) /*!40100 DEFAULT CHARACTER SET utf8 */;
in /home/httpd/xxxxxx/drupal/includes/database.mysql.inc on line 172.I finally resolve this problem by editing "private.install", line 13...
break on install :
) /*!40100 DEFAULT CHARACTER SET utf8 */;
install ok :
) /*!40100 DEFAULT CHARACTER SET utf8 */
Removing the trailing ; make the module install correctly.
mySQL : 3.23.58
PHP : 4.3.10
Comments
Comment #1
gregglesMarking this as closed-outdated as the 5.x version is no longer supported and I don't think this issue affects the 6.x and later versions.
If the problem persists on newer versions, please reopen this issue.
Thanks!