Blog Documentation Book a Demo
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Joomla Integration Failed

lesclesc
edited September 2007 in Vanilla 1.0 Help
I am having difficulty installing JoomlaVanillav1.0.3b as a component. When attempting the install I receive the following message (see below). The installation process does setup com_vanilla in the Administrator & Component directories of Joomla. The Vanilla database is setup in the Joomla database but the Joomla Vanilla Bridge is not setup as a component in the Administrator menu. I have tried numerous attempts at installing again but cannot get the past the following message that Joomla generates when installing the component. Any suggestions? SQL Error DB function failed with error number 1060 Duplicate column name 'RoleID' SQL=ALTER TABLE boo_users ADD `RoleID` int(2) NOT NULL DEFAULT '3', ADD `StyleID` int(3) NOT NULL DEFAULT '1', ADD `CustomStyle` varchar(255) DEFAULT NULL, ADD `FirstName` varchar(50) NOT NULL DEFAULT '', ADD `LastName` varchar(50) NOT NULL DEFAULT '', ADD `VerificationKey` varchar(50) NOT NULL DEFAULT '', ADD `EmailVerificationKey` varchar(50) DEFAULT NULL, ADD `UtilizeEmail` enum('1','0') NOT NULL DEFAULT '0', ADD `ShowName` enum('1','0') NOT NULL DEFAULT '1', ADD `Icon` varchar(255) DEFAULT NULL, ADD `Picture` varchar(255) DEFAULT NULL, ADD `Attributes` text NULL, ADD `CountVisit` int(8) NOT NULL DEFAULT '0', ADD `CountDiscussions` int(8) NOT NULL DEFAULT '0', ADD `CountComments` int(8) NOT NULL DEFAULT '0', ADD `DateLastActive` datetime NOT NULL DEFAULT '2006-06-06 00:00:00', ADD `RemoteIp` varchar(100) NOT NULL DEFAULT '', ADD `LastDiscussionPost` datetime DEFAULT NULL, ADD `DiscussionSpamCheck` int(11) NOT NULL DEFAULT '0', ADD `LastCommentPost` datetime DEFAULT NULL, ADD `CommentSpamCheck` int(11) NOT NULL DEFAULT '0', ADD `UserBlocksCategories` enum('1','0') NOT NULL DEFAULT '0', ADD `DefaultFormatType` varchar(20) DEFAULT NULL, ADD `Discovery` text, ADD `Preferences` text, ADD `SendNewApplicantNotifications` enum('1','0') NOT NULL DEFAULT '0'; SQL = ALTER TABLE boo_users ADD `RoleID` int(2) NOT NULL DEFAULT '3', ADD `StyleID` int(3) NOT NULL DEFAULT '1', ADD `CustomStyle` varchar(255) DEFAULT NULL, ADD `FirstName` varchar(50) NOT NULL DEFAULT '', ADD `LastName` varchar(50) NOT NULL DEFAULT '', ADD `VerificationKey` varchar(50) NOT NULL DEFAULT '', ADD `EmailVerificationKey` varchar(50) DEFAULT NULL, ADD `UtilizeEmail` enum('1','0') NOT NULL DEFAULT '0', ADD `ShowName` enum('1','0') NOT NULL DEFAULT '1', ADD `Icon` varchar(255) DEFAULT NULL, ADD `Picture` varchar(255) DEFAULT NULL, ADD `Attributes` text NULL, ADD `CountVisit` int(8) NOT NULL DEFAULT '0', ADD `CountDiscussions` int(8) NOT NULL DEFAULT '0', ADD `CountComments` int(8) NOT NULL DEFAULT '0', ADD `DateLastActive` datetime NOT NULL DEFAULT '2006-06-06 00:00:00', ADD `RemoteIp` varchar(100) NOT NULL DEFAULT '', ADD `LastDiscussionPost` datetime DEFAULT NULL, ADD `DiscussionSpamCheck` int(11) NOT NULL DEFAULT '0', ADD `LastCommentPost` datetime DEFAULT NULL, ADD `CommentSpamCheck` int(11) NOT NULL DEFAULT '0', ADD `UserBlocksCategories` enum('1','0') NOT NULL DEFAULT '0', ADD `DefaultFormatType` varchar(20) DEFAULT NULL, ADD `Discovery` text, ADD `Preferences` text, ADD `SendNewApplicantNotifications` enum('1','0') NOT NULL DEFAULT '0';

Comments

  • docweathersdocweathers
    I noticed your comments. I would like to use this bridge, but the www.open4g.com has been down for some time, so I cannot download it from the author. Do you have a copy that you could send me? Thanks Larry
This discussion has been closed.