[Register]
Powered by Elgg

Plugins :: Blog :: Problem when installing Vanilla/Elgg plugin integration

August 31, 2007

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. 

Keywords: Elgg, installing Vanilla plugin, plugin, problem, Vanilla

Posted by Everton Zanella Alvarenga @ Plugins


Comments

  1. Maybe I have to add the Elgg database values for the admin on mod/vanillaforum/setup/mysql.sql, instead of  (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')") ?

    user iconTom on Friday, 31 August 2007, 16:02 UTC # |

  2. 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 ;)

     

    user iconDiego Andrés Ramírez Aragón on Friday, 31 August 2007, 20:12 UTC # |

Add a comment

Your comment text

Your name

 

Site supported by Curverider Ltd - powered by the awesome Elgg