comprofiler installation problems

15 years 3 months ago #81980 by amykiel
comprofiler installation problems was created by amykiel
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.

Please Log in to join the conversation.

15 years 3 months ago #82668 by amykiel
Replied by amykiel on topic Re:comprofiler installation problems
Anyone? Help?

Please Log in to join the conversation.

15 years 2 months ago #85164 by amykiel
Replied by amykiel on topic Re:comprofiler installation problems
Anyone? This topic has been read over 200 times, so I'm guessing that maybe it's a fairly common problem...

Any suggestions at all? Do you need more info? Anything?

Please Log in to join the conversation.

15 years 2 months ago #85175 by deni_hanca
Replied by deni_hanca on topic Re:comprofiler installation problems
Seemed to me that u r trying to upgrade from version 1.0 beta to 1.0 RC 1. I guess not many people use version 1.0 anymore :).

The 1.2 RC 4 version is already available (1.2 stable is coming up soon), so why not upgrade to the newest version instead? And upgrade to Joomla 1.5.9 too;) . I think u'll likely to get more help with a newer version, when u encounter trouble.:)

Wadya Balad Lises Unpad di www.lises-unpad.com

Please Log in to join the conversation.

15 years 2 months ago #85205 by amykiel
Replied by amykiel on topic Re:comprofiler installation problems
If that's what you see happening (I'm seeing that now, too, since you pointed it out), that's not what I was trying to do... Definitely not upgrading, and I really thought I had the latest version.

Thank you so much for your reply, it's certainly given me a place to start (or start over).

Please Log in to join the conversation.

15 years 2 months ago #85215 by amykiel
Replied by amykiel on topic Re:comprofiler installation problems
I have un-installed the previous version (it was actually 1.1.. oddly) and have installed 1.2 but am still having the same issue.

Similar stuff came up in RED when installing, but I'm no longer sure that it indicates a problem, since it does say that it is successfully installed.

However, the same error still appears in the Tab Management, Field Management and List Management tabs:

Tab Management page:
known column 'a.useraccessgroupid' in 'where clause' SQL=SELECT COUNT(*)nFROM jos_comprofiler_tabs AS anWHERE a.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1)DB function failed with error number 1054
Unknown column 'a.useraccessgroupid' in 'where clause' SQL=SELECT a.*, p.name AS pluginname, p.published AS pluginpublished FROM jos_comprofiler_tabs AS a LEFT JOIN jos_comprofiler_plugin AS p ON p.id = a.pluginid WHERE a.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1) ORDER BY position, ordering LIMIT 0, 30

Field Management Tab:

New Field Edit Delete
Unknown column 't.fields' in 'where clause' SQL=SELECT COUNT(*)n FROM jos_comprofiler_fields AS f, jos_comprofiler_tabs AS tn WHERE (f.tabid = t.tabid) AND (t.fields = 1) AND t.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1)DB function failed with error number 1054
Unknown column 'f.description' 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 jos_comprofiler_fields AS f INNER JOIN jos_comprofiler_tabs AS t ON ( (f.tabid = t.tabid) AND (t.fields = 1) ) LEFT JOIN jos_comprofiler_plugin AS p ON p.id = t.pluginid LEFT JOIN jos_comprofiler_plugin AS pf ON pf.id = f.pluginid WHERE t.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1) ORDER BY t.ordering, f.ordering LIMIT 0, 30

List Management:
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, 30



Any thoughts as to what is causing these DB errors? Actually, it looks like maybe it's just one error - 1054.. ?

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 1.848 seconds

Facebook Twitter LinkedIn