Hi from a relative newbie to CB and Joomla
Using Joomla 2.5.8 and Jfusion 1.7.10 to bridge to a phpbb3 forum.
When I installed community builder it showed the following errors:
TAB management:
DB function failed with error number 1054
Unknown column 'a.viewaccesslevel' in 'on clause' SQL=SELECT a.*, p.name AS pluginname, p.published AS pluginpublished, al.title AS viewaccesslevelname FROM Truejos_comprofiler_tabs AS a LEFT JOIN Truejos_comprofiler_plugin AS p ON p.id = a.pluginid LEFT JOIN Truejos_viewlevels AS al ON al.id = a.viewaccesslevel ORDER BY position, ordering LIMIT 0, 200
FIELD management:
DB function failed with error number 1054
Unknown column 'f.searchable' in 'field list' SQL=SELECT f.fieldid, f.title, f.name, f.description, f.type, f.required, f.published, f.profile, f.ordering, f.registration, f.searchable, f.pluginid, f.sys, f.tablecolumns, t.title AS 'tab', t.enabled AS 'tabenabled', t.pluginid AS 'tabpluginid', p.name AS pluginname, p.published AS pluginpublished, pf.name AS fieldpluginname, pf.published AS fieldpluginpublished FROM Truejos_comprofiler_fields AS f INNER JOIN Truejos_comprofiler_tabs AS t ON ( (f.tabid = t.tabid) AND (t.fields = 1) ) LEFT JOIN Truejos_comprofiler_plugin AS p ON p.id = t.pluginid LEFT JOIN Truejos_comprofiler_plugin AS pf ON pf.id = f.pluginid ORDER BY t.ordering, f.ordering LIMIT 0, 200
LIST management
DB function failed with error number 1054
Unknown column 'a.viewaccesslevel' in 'field list' SQL=SELECT a.listid, a.title, a.description, a.published, a.`default`, a.ordering, a.viewaccesslevel, al.title AS viewaccesslevelname, a.useraccessgroupid FROM Truejos_comprofiler_lists a LEFT JOIN Truejos_viewlevels AS al ON al.id = a.viewaccesslevel ORDER BY ordering LIMIT 0, 200
I have done some searching through this forum and read posts like this one:
www.joomlapolis.com/forum/64-rc3-general-discussions/76847-tab-field-and-list-management-not-showing
Most seem to have been solved by running the database fix tool but that doesn't seem to work on mine. It says:
"Core CB mandatory basics Database adjustments have been performed successfully."
Then goes on underneath it to say
Core CB Database adjustments errors:
CBSQLupgrader::createTableof Table #__comprofiler failed with SQL error: Table 'truejos_comprofiler' already exists SQL=CREATE TABLE `Truejos_comprofiler` ( `id` int(11) NOT NULL DEFAULT 0, `user_id` int(11) NOT NULL DEFAULT 0, `firstname` varchar(100) DEFAULT NULL, `middlename` varchar(100) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL, `hits` int(11) NOT NULL DEFAULT 0, `message_last_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `message_number_sent` int(11) NOT NULL DEFAULT 0, `avatar` varchar(255) DEFAULT NULL, `avatarapproved` tinyint(4) NOT NULL DEFAULT 1, `approved` tinyint(4) NOT NULL DEFAULT 1, `confirmed` tinyint(4) NOT NULL DEFAULT 1, `lastupdatedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `registeripaddr` varchar(50) NOT NULL DEFAULT '', `cbactivation` varchar(50) NOT NULL DEFAULT '', `banned` tinyint(4) NOT NULL DEFAULT 0, `banneddate` datetime DEFAULT NULL, `unbanneddate` datetime DEFAULT NULL, `bannedby` int(11) DEFAULT NULL, `unbannedby` int(11) DEFAULT NULL, `bannedreason` mediumtext, `acceptedterms` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`), KEY `apprconfbanid` (`approved`, `confirmed`, `banned`, `id`), KEY `avatappr_apr_conf_ban_avatar` (`avatarapproved`, `approved`, `confirmed`, `banned`, `avatar`), KEY `lastupdatedate` (`lastupdatedate`) )ENGINE=MyISAM...
plus about 10 more paragraphs of the same all in red.
I've also tried installing the CB connector plugin. This also gives me the following error:
SQL error: moscomprofilerTabs::store failed
Unknown column 'viewaccesslevel' in 'field list' SQL=INSERT INTO `Truejos_comprofiler_tabs` (`title`,`description`,`ordering`,`pluginclass`,`pluginid`,`displaytype`,`position`,`viewaccesslevel`,`useraccessgroupid`) VALUES ('_CBC_DEFAULTFORUMTAB','','100','getCBconnectorTab','504','tab','cb_tabmain','1','-2')
I get the impression there is something wrong with my database? I'm a bit stuck now - any help much appreciated!
Thanks
