Jump to content

jreviews conflict with cb & jcomments


Yuriy Strigun

Recommended Posts

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
×
×
  • Create New...