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

greggles’s picture

Issue summary: View changes
Status: Active » Closed (outdated)

Marking 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!