SQL syntax error on install
jptavan - July 1, 2007 - 13:47
| Project: | Private |
| Version: | 5.x-1.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
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