Yuriy Strigun Posted March 21, 2010 at 09:01 PM Share Posted March 21, 2010 at 09:01 PM Good time of day! I installed a trial version of your program and I have a problem. First in the community builder on the profile page I had an error message in the database mysql. As I understand it, this is due to the fact that I use on my site instead of jcomments jomcomments. I'm going to buy jreviews, but I then have a lot to redo. At jcomments me and myblog and many more extensions. Second on the same page profile in CB I have the other inscriptions. How do I fix this? Thanks in advance and sorry for my English. Here is the full text of errors in CB: No valid database connection Unknown column 'CommunityBuilder.cb_membertype' in 'on clause' SQL=SELECT Listing.id AS `Listing.listing_id`, Listing.username AS `Listing.title`, CommunityBuilder.avatar AS `Listing.images`, CommunityBuilder.avatarapproved AS `Listing.images_approved`, 'com_comprofiler' AS `Listing.extension`, JreviewsCategory.id AS `Listing.cat_id`, Category.fieldtitle AS `Category.title`, JreviewsCategory.id AS `Category.cat_id`, Criteria.id AS `Criteria.criteria_id`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.state AS `Criteria.state`, 'Member' AS `Listing.tag` FROM jos_users AS Listing INNER JOIN jos_comprofiler AS CommunityBuilder ON Listing.id = CommunityBuilder.id LEFT JOIN jos_comprofiler_field_values AS Category ON CommunityBuilder.cb_membertype = Category.fieldtitle INNER JOIN jos_jreviews_categories AS JreviewsCategory ON Category.fieldvalueid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_comprofiler' LEFT JOIN jos_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id WHERE 1 = 1 AND ( Listing.id = 62 ) No valid database connection Table 'netsitesru_joom1.jos_jomcomment' doesn't exist SQL=SELECT COUNT(*) FROM jos_jomcomment jc WHERE jc.contentid = '68' No valid database connection Table 'netsitesru_joom1.jos_jomcomment' doesn't exist SQL=SELECT COUNT(*) FROM jos_jomcomment jc WHERE jc.contentid = '67' No valid database connection Table 'netsitesru_joom1.jos_jomcomment' doesn't exist SQL=SELECT COUNT(*) FROM jos_jomcomment jc WHERE jc.contentid = '66' No valid database connection Table 'netsitesru_joom1.jos_jomcomment' doesn't exist SQL=SELECT COUNT(*) FROM jos_jomcomment jc WHERE jc.contentid = '65' No valid database connection Table 'netsitesru_joom1.jos_jomcomment' doesn't exist SQL=SELECT COUNT(*) FROM jos_jomcomment jc WHERE jc.contentid = '64' No valid database connection Unknown column 'CommunityBuilder.cb_membertype' in 'on clause' SQL=SELECT Listing.id AS `Listing.listing_id`, Listing.username AS `Listing.title`, CommunityBuilder.avatar AS `Listing.images`, CommunityBuilder.avatarapproved AS `Listing.images_approved`, 'com_comprofiler' AS `Listing.extension`, JreviewsCategory.id AS `Listing.cat_id`, Category.fieldtitle AS `Category.title`, JreviewsCategory.id AS `Category.cat_id`, Criteria.id AS `Criteria.criteria_id`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.state AS `Criteria.state`, 'Member' AS `Listing.tag` FROM jos_users AS Listing INNER JOIN jos_comprofiler AS CommunityBuilder ON Listing.id = CommunityBuilder.id LEFT JOIN jos_comprofiler_field_values AS Category ON CommunityBuilder.cb_membertype = Category.fieldtitle INNER JOIN jos_jreviews_categories AS JreviewsCategory ON Category.fieldvalueid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_comprofiler' LEFT JOIN jos_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id WHERE 1 = 1 AND ( Listing.id = 62 ) Аnd in myblog: No valid database connection Table 'netsitesru_joom1.jos_jomcomment' doesn't exist SQL=SELECT COUNT(*) FROM jos_jomcomment AS a WHERE a.contentid='68' AND a.option='com_myblog' No valid database connection Table 'netsitesru_joom1.jos_jomcomment' doesn't exist SQL=SELECT COUNT(*) FROM jos_jomcomment AS a WHERE a.contentid='67' AND a.option='com_myblog' No valid database connection Table 'netsitesru_joom1.jos_jomcomment' doesn't exist SQL=SELECT COUNT(*) FROM jos_jomcomment AS a WHERE a.contentid='66' AND a.option='com_myblog' No valid database connection Table 'netsitesru_joom1.jos_jomcomment' doesn't exist SQL=SELECT COUNT(*) FROM jos_jomcomment AS a WHERE a.contentid='65' AND a.option='com_myblog' No valid database connection Table 'netsitesru_joom1.jos_jomcomment' doesn't exist SQL=SELECT COUNT(*) FROM jos_jomcomment AS a WHERE a.contentid='64' AND a.option='com_myblog' Link to comment
Alejandro Posted March 21, 2010 at 10:14 PM Share Posted March 21, 2010 at 10:14 PM This section is only visible with a valid subscription. If you have a valid subscription, please login. Link to comment
Recommended Posts