I am attempting to install cb1.1 on a joomla 1.0.13 site. Have spent hours searching these forums, found similar problems, but no solutions. Would greatly appreciate help.
I have successfully installed CB on same Joomla version previously with no modifications, no problems.
Here is what is happening:
component install >> com_comprofiler.zip
The installation process shows 6 green "finished" processes, then starts the errors.. which go on and on..
The first of many:
1.0 Beta 4 to 1.0 RC 1 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'qhnewsjo'@'banker.groupz.net' for table 'jos_comprofiler_tabs' SQL=ALTER TABLE jos_comprofiler_tabs ADD `plugin_include` VARCHAR( 255 ) AFTER `plugin` , ADD `fields` TINYINT( 1 ) DEFAULT '1' NOT NULL AFTER `plugin_include`
SQL =
ALTER TABLE jos_comprofiler_tabs ADD `plugin_include` VARCHAR( 255 ) AFTER `plugin` ,
ADD `fields` TINYINT( 1 ) DEFAULT '1' NOT NULL AFTER `plugin_include`
1.0 Beta 4 to 1.0 RC 1 failed! SQL error:DB function failed with error number 1054
Unknown column 'plugin_include' in 'field list' SQL=INSERT INTO `jos_comprofiler_tabs` ( `title`, `description`, `ordering`, `width`, `enabled`, `plugin`, `plugin_include`, `fields`, `sys`) VALUES ( '_UE_CONTACT_INFO_HEADER', '', -4, '1', 1, 'getContactTab', NULL, 1, 1), ( '_UE_AUTHORTAB', '', -3, '1', 0, 'getAuthorTab', NULL, 0, 1), ( '_UE_FORUMTAB', '', -2, '1', 0, 'getForumTab', NULL, 0, 1), ( '_UE_BLOGTAB', '', -1, '1', 0, 'getBlogTab', NULL, 0, 1);
SQL =
INSERT INTO `jos_comprofiler_tabs` ( `title`, `description`, `ordering`, `width`, `enabled`, `plugin`, `plugin_include`, `fields`, `sys`) VALUES
( '_UE_CONTACT_INFO_HEADER', '', -4, '1', 1, 'getContactTab', NULL, 1, 1),
( '_UE_AUTHORTAB', '', -3, '1', 0, 'getAuthorTab', NULL, 0, 1),
( '_UE_FORUMTAB', '', -2, '1', 0, 'getForumTab', NULL, 0, 1),
( '_UE_BLOGTAB', '', -1, '1', 0, 'getBlogTab', NULL, 0, 1);
1.0 Beta 4 to 1.0 RC 1 failed! SQL error:DB function failed with error number 1142
ALTER command denied to user 'qhnewsjo'@'banker.groupz.net' for table 'jos_comprofiler_lists' SQL=ALTER TABLE `jos_comprofiler_lists` ADD `filterfields` VARCHAR( 255 ) AFTER `sortfields`;
SQL =
ALTER TABLE `jos_comprofiler_lists` ADD `filterfields` VARCHAR( 255 ) AFTER `sortfields`;
1.0 Beta 4 to 1.0 RC 1 Upgrade Applied Successfully!
This goes on and on but finally a Success! message is given.
I assumed (apparently mistakenly) that this meant that the thing was installed until finished installing the other modules (with no problems) and went to the "tree" to the Fields/Tabs/List options where I get some variant of this error message on each one:
DB function failed with error number 1054
Unknown column 'useraccessgroupid' in 'field list' SQL=SELECT listid, title, description, published,`default`,ordering,useraccessgroupid FROM jos_comprofiler_lists a ORDER BY ordering LIMIT 0, 50
I'm at a loss as to what's causing this problem. I am fairly proficient in Joomla but do not have any database knowledge (or access).
It is also probably worth mentioning that someone else has already installed the following Components on this site (could there be a conflict?):
mosCom (comments)
mosDirectory (directory)
Thanks in advance for any help or advice you can give.