Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
SQL help, anyone?
One user was having trouble with my User Wall extension; it turned out to be an SQL error that occurred while it was creating its database table. The SQL used to do so is as follows:
CREATE TABLE `LUM_UserWall` ( `WallCommentID` int(8) NOT NULL auto_increment PRIMARY KEY, `UserID` int(10) NOT NULL default '0', `Date` datetime NOT NULL default '0000-00-00 00:00:00', `FromUserID` int(10) NOT NULL default '0', `Body` text NOT NULL default '', `RemoteIp` varchar(100) default NULL, KEY `UserID` (`UserID`) );Can anyone see any problems with this? For what it's worth, it says the error is near ';' at the end. And the extension seems to have worked fine for everyone else (or, at least, nobody else has reported this problem to me).
This discussion has been closed.