I just copied vanillaforum to /mod and I have this error:
( ! ) Fatal error: mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', `CountComments`, `DateFirstVisit`, `DateLastActive`,`SendNewApplicantNotificat' at line 1] in EXECUTE("INSERT INTO `LUM_User`(`RoleID`, `StyleID`, `FirstName`, `LastName`, `Name`, `Password`, `Email`, `UtilizeEmail`, `ShowName`, `CountVisit`, CountDiscussions`, `CountComments`, `DateFirstVisit`, `DateLastActive`,`SendNewApplicantNotifications`)values (4,1,'Administrative','User','Admin','Admin','admin@forum.com','1','1',0,0,0,'1975-09-16 08:39:00','2006-04-25 17:38:44','1')") in /home/everton/Work/demi/elgg/lib/adodb/adodb-errorhandler.inc.php on line 77 Call Stack
# Time Memory Function Location
1 0,0199 56060 {main}( ) ../index.php:0
2 0,0355 123440 require_once( '/home/everton/Work/demi/elgg/includes.php' ) ../index.php:5
3 6,8397 10821468 vanillaforum_init( )../includes.php:148
4 6,8850 10821596 modify_database( ) ../lib.php:38
5 8,8773 10842464 execute_sql( ) ../datalib.php:188
6 8,8773 10842464ADO Connection->Execute( ) ../datalib.php:38
7 8,8773 10842464ADO Connection->_Execute( ) ../adodb.inc.php:889
8 8,8775 10842700ADO DB_Error_Handler( ) ../adodb.inc.php:914
9 8,8776 10843544 trigger_error ( ) ../adodb-errorhandler.inc.php:77
After reaload the browser, I had this other error:
( ! ) Fatal error: mysql error: [1050: Table 'LUM_Category' already exists] in EXECUTE("CREATE TABLE `LUM_Category` ( `CategoryID` int(2) NOT NULL auto_increment, `Name` varchar(100) NOT NULL default '', `Description` text NULL, `Priority` int(11) NOT NULL default '0', PRIMARY KEY (`CategoryID`))") in /home/everton/Work/demi/elgg/lib/adodb/adodb-errorhandler.inc.php on line 77 Call Stack
# Time Memory Function Location
1 0,000655816 {main}( )../index.php:0
2 0,0368123196require_once( '/home/everton/Work/demi/elgg/includes.php' )../index.php:5
3 2,124310823812vanillaforum_init( )../includes.php:1
4 8 42,124710823940modify_database( )../lib.php:38
5 2,125110842308 execute_sql( ) ../datalib.php:188
6 2,125110842308 ADOConnection->Execute( ) ../datalib.php:38
7 2,125110842308 ADOConnection->_Execute( ) ../adodb.inc.php:889
8 2,125410842404 ADODB_Error_Handler( ) ../adodb.inc.php:914 92,125410843212trigger_error ( )
I'm using php5 (5.2.1-0ubuntu1.2) and mysql-server-5.0 (5.0.38-0ubuntu1).
Does someone know what is happening?
Thanks in advance.

Comments
You can try to uninstalled it (dropping database tables too), then up your memory size and the try it again.
The firs error is related with that ;)