Joomla Extensions Club 20,483 posts

[ttcv Friend ttcvJoin date: October 2011Posts: 5Downloads:0Uploads:1 Thanks: 4]

#170158

I just tried to install the JACommnet component by uploading the latest package file: com_jacomment.v1.0.0.zip.
It failed with this message.
Please help. Thanks

1 – An error has occurred.
Not run INSERT INTO `#__jacomment_configs` VALUES (22, ‘general’, ‘display_message=nis_notify_admin=1nis_notify_author=1nis_enabled_email=0nccemail=naccess=0nis_comment_offline=0nmail_view_only=0nis_use_ja_login_form=0nn’)
Not run INSERT INTO `#__jacomment_configs` VALUES (23, ‘comments’, ‘is_enable_threads=1nis_allow_voting=1ntotal_attach_file=5nmax_size_attach_file=2nattach_file_type=doc,docx,pdf,txt,zip,rar,jpg,bmp,gif,pngnis_enable_website_field=1nis_enable_autoexpanding=1nis_extra_fields_expand=1nis_enable_email_subscription=1nis_allow_report=1nis_allow_approve_new_comment=1nmaximum_comment_in_item=100nis_enable_rss=1nn’)
Not run INSERT INTO `#__jacomment_configs` VALUES (24, ‘spamfilters’, ‘terms_of_usage=Registration to this forum is free! We do insist that you abide by the rules and policies detailed below. If you agree to the terms, please check the ”I agree” checkbox and press the ”Register” button below. If you would like to cancel the registration, click here to return to the forums index.\n\nForum Rules\n\nRegistration to this forum is free! We do insist that you abide by the rules and policies detailed below. If you agree to the terms, please check the ”I agree” checkbox and press the ”Register” button below. If you would like to cancel the registration, click here to return to the forums index.nmin_length=10nmax_length=1000ncensored_words=ncensored_words_replace=nis_nofollow=1nnumber_of_links=5nis_enable_captcha_user=0nis_use_akismet=0nn’)
Not run INSERT INTO `#__jacomment_configs` VALUES (25, ‘blocked_word_list’, ‘ndamn’)
Not run INSERT INTO `#__jacomment_configs` VALUES (26, ‘blacklist_word_list’, ‘n****’)
Not run INSERT INTO `#__jacomment_configs` VALUES (27, ‘permissions’, ‘view=allnpost=allnvote=allntype_voting=1nreport=allntotal_to_report_spam=10ntype_editing=1nn’)
Not run INSERT INTO `#__jacomment_configs` VALUES (28, ‘layout’, ‘theme=defaultnenable_avatar=1ntype_avatar=0navatar_size=3nenable_youtube=1nis_enable_website_field=0nform_position=1nenable_sorting_options=1ndefault_sort=datendefault_sort_type=ASCnenable_timestamp=1nfooter_text=Copyright JACommentncustom_css=nenable_login_rpx=1nenable_addthis=1ncustom_addthis=ncustom_addtoany=ncustom_tweetmeme=nenable_bbcode=1nenable_smileys=1nuse_default_avatar=0nenable_login_button=0nenable_subscribe_menu=0nenable_user_rep_indicator=0nenable_comment_form=0nenable_addtoany=1nenable_polldaddy=0nenable_seesmic=0nenable_tweetmeme=1nenable_activity_stream=1nn’)
Not run INSERT INTO `#__jacomment_email_templates` (`id`, `name`, `title`, `subject`, `content`, `email_from_address`, `email_from_name`, `published`, `group`, `language`, `system`) VALUES (10, ‘mailheader’, ‘Header’, ‘Header’, ”, ”, ”, 1, 1, ‘en-GB’, 1), (11, ‘mailfooter’, ‘Footer’, ‘Footer’, ‘

powered by JAComment
‘, ”, ”, 1, 1, ‘en-GB’, 1), (35, ‘Jacommentconfirmation_sent_to_new_comment_creator_need_admin_approved’, ‘Confirmation sent to new comment creator – In cases where admin approval is Required’, ‘Your comment is pending approval…’, ‘
Dear {USERS_USERNAME},

This email is to inform that you have just created a new comment on the issue {ITEM_TITLE_WITH_LINK} at {CONFIG.SITE_TITLE} with the following details:

Comment URL: {ITEM_LINK}

Comment details: {ITEM_DETAILS}.

Your comment shall be posted after being approved by administrator. Please check your mailbox periodically for updated information.

Sincerely, {CONFIG.SITE_TITLE}

‘, ”, ”, 1, 0, ‘en-GB’, 0), (12, ‘Jacommentnotify_to_user_new_voice_daily’, ‘Dailly NEW Comment statistics (to those who subscribe)’, ‘[JA Comment] Daily statistics’, ‘
Hi {USERS_USERNAME},

Here are a quick overview of what has been going on at JA Comment during the last 24 hours:

{ITEM_DETAILS}’, ”, ”, 1, 0, ‘en-GB’, 1), (19, ‘Jacommentnotify_when_new_item_was_post’, ‘Notify when new item was post’, ‘Have a new comment!’, ‘
Dear {USERS_USERNAME},

This email is to inform that a comment has been newly added into the issue {ITEM_TITLE_WITH_LINK} at {CONFIG.SITE_TITLE} with the following details:

Comment URL: {ITEM_LINK}

Comment details: {ITEM_DETAILS}

Please click on the link above to view the full details.

Sincerely, {CONFIG.SITE_TITLE}

‘, ”, ”, 1, 0, ‘en-GB’, 0), (22, ‘Jacommentnotifying_admin_on_a_new_comment_posted’, ‘Notifying admin on a new comment posted’, ‘A new comment has been newly added’, ‘
Dear {USERS_USERNAME},

This email is to inform you that a new comment on {ITEM_TITLE_WITH_LINK} has newly been added at {CONFIG.SITE_TITLE} with the following details:

Comment URL: {ITEM_LINK}

Comment details: {ITEM_DETAILS}

Comment creator: {ITEM_CREATE_BY}

Please review the above comments and take appropriate actions as soon as possible.

Yours sincerely, {CONFIG.SITE_TITLE}

‘, ”, ”, 1, 0, ‘en-GB’, 0), (34, ‘Jacommentconfirmation_sent_to_new_comment_creator_dont_need_admin_approved’, ‘Confirmation sent to new comment creator – In cases where admin approval is NOT required’, ‘We confirm your comment’, ‘
Dear {USERS_USERNAME},

This email is to confirm that you have successfully created a new comment on the issue {ITEM_TITLE_WITH_LINK} at {CONFIG.SITE_TITLE} with the following details:

Comment URL: {ITEM_LINK}

Comment details: {ITEM_DETAILS}.

Please check your mailbox periodically as we shall notify you if there is any new reply on this issue.

Sincerely, {CONFIG.SITE_TITLE}

‘, ”, ”, 1, 0, ‘en-GB’, 0), (24, ‘Jacommentnotifying_comment_creator_if_there_is_a_new_reply_to_his_comment’, ‘Notifying comment creator if there is a new reply to his comment’, ‘A new reply has just been posted on your comment’, ‘
Dear {USERS_USERNAME},

This email is to inform that a new reply has just been posted on the issue {ITEM_TITLE_WITH_LINK} at {CONFIG.SITE_TITLE} with the following details:

Reply URL: {ITEM_LINK}

Reply details: {ITEM_DETAILS}

Reply creator: {REPLY_OWNER} .

Yours sincerely, {CONFIG.SITE_TITLE}

‘, ”, ”, 1, 0, ‘en-GB’, 0), (25, ‘Jacommentnotifying_those_whose_comment_has_been_deleted’, ‘Notifying those whose comment has been deleted’, ‘Your comment has been deleted’, ‘
Dear {USERS_USERNAME},

We are sorry to inform that your comment on the issue “{ITEM_TITLE_WITH_LINK}� at {CONFIG.SITE_TITLE} has been deleted by {SITE_ADMIN} with the following reasons:

Comment URL: {ITEM_LINK}

Comment details: {ITEM_DETAILS}

Moderate reasons: {MOD_REASONS}

Thank you for your understanding and do hope you carefully read the instructions and strictly follow the Terms of Use before posting any comments at {CONFIG.SITE_TITLE} in the time to come.

Yours sincerely, {CONFIG.SITE_TITLE}

‘, ”, ”, 1, 0, ‘en-GB’, 0), (26, ‘Jacommentnotifying_those_whose_comment_has_been_approved’, ‘Notifying those whose comment has been approved’, ‘Your Comment has been approved’, ‘
Dear {USERS_USERNAME},

This email is to inform that your comment on the issue {ITEM_TITLE_WITH_LINK} at {CONFIG.SITE_TITLE} has been approved and published by {SITE_ADMIN} with the following details:

Comment URL: {ITEM_LINK}

Comment details: {ITEM_DETAILS}

Please check your mailbox periodically as we shall notify you if there is any reply on this issue Yours. sincerely, {CONFIG.SITE_TITLE}

‘, ”, ”, 1, 0, ‘en-GB’, 0), (27, ‘Jacommentnotifying_admin_of_a_spam_report_on_a_comment’, ‘Notifying admin of a spam report on a comment’, ‘A comment has been reported as spam’, ‘
Dear {USERS_USERNAME},

This email is to inform that the comment on the issue {ITEM_TITLE_WITH_LINK} at {CONFIG.SITE_TITLE} has been reported as spam recently.

Comment URL: {ITEM_LINK}

Comment details: {ITEM_DETAILS}

Spam reporter: {SPAM_REPORTER}

Kindly review the above comment to see if it is a spam as report or not for further action at your soonest time.

Yours sincerely, {CONFIG.SITE_TITLE}

‘, ”, ”, 1, 0, ‘en-GB’, 0), (28, ‘Jacommentnotifying_those_whose_comment_is_reported_as_spam’, ‘Notifying those whose comment is reported as spam’, ‘You have comment reported as spam’, ‘
Dear {USERS_USERNAME},

This email is to inform that your comment on the issue {ITEM_TITLE_WITH_LINK} at {CONFIG.SITE_TITLE} has been reported as spam by other user recently.

Comment URL: {ITEM_LINK}

Comment details: {ITEM_DETAILS}

Spam reporter: {SPAM_REPORTER}

The spam report shall be thoroughly and fairly reviewed by {SITE_ADMIN} before any further action. Kindly continue using our site normally and sorry for any inconveniences that may have caused.

Yours sincerely, {CONFIG.SITE_TITLE}

‘, ”, ”, 1, 0, ‘en-GB’, 0), (29, ‘Jacommentnotifying_those_whose_comment_is_removed_as_spam_by_admin’, ‘Notifying those whose comment is removed as spam by admin’, ‘Your comment has been removed as spam by administrator’, ‘
Dear {USERS_USERNAME},

This email is to inform that your comment on the issue {ITEM_TITLE_WITH_LINK} at {CONFIG.SITE_TITLE} has been removed as spam by {SITE_ADMIN}.

Comment URL: {ITEM_LINK}

Comment details: {ITEM_DETAILS}

Moderate Reasons: {MOD_REASONS}

Thank you for your understanding and do hope you carefully read the instructions and strictly follow the Terms of Use before posting any comments at {CONFIG.SITE_TITLE} in the time to come.

Yours sincerely, {CONFIG.SITE_TITLE}

‘, ”, ”, 1, 0, ‘en-GB’, 0), (30, ‘Jacommentnotifying_those_whose_comment_has_been_unapproved’, ‘Notifying those whose comment has been unapproved’, ‘You have a comment unapproved’, ‘
Dear {USERS_USERNAME},

This email is to inform that your comment on the issue {ITEM_TITLE_WITH_LINK} at {CONFIG.SITE_TITLE} has been unapproved by {SITE_ADMIN} due to the following reasons:

Comment URL: {ITEM_LINK}

Comment details: {ITEM_DETAILS}

Unapproved reasons: {UNAPPROVE_REASONS}

Thank you for your understanding and do hope you carefully read the instructions and strictly follow the Terms of Use before posting any comments at {CONFIG.SITE_TITLE} in the time to come.

Yours sincerely, {CONFIG.SITE_TITLE}

‘, ”, ”, 1, 0, ‘en-GB’, 0), (32, ‘Jacommentnotifying_comment_creator_if_there_is_a_new_comment_on_the_issue’, ‘Notifying comment creator if there is a new comment on the issue’, ‘A new comment has been added’, ‘
Dear {USERS_USERNAME},

This email is to inform that a comment has been newly added into the issue {ITEM_TITLE_WITH_LINK} at {CONFIG.SITE_TITLE} with the following details:

Comment URL: {ITEM_LINK}

Comment details: {ITEM_DETAILS}

Please click on the link above to view the full details.

Sincerely, {CONFIG.SITE_TITLE}

‘, ”, ”, 1, 0, ‘en-GB’, 0);

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#422283

Hi
Please give me your backend / phpmyadmin access than i can help you.
Thank you
Viet Vu

[ttcv Friend ttcvJoin date: October 2011Posts: 5Downloads:0Uploads:1 Thanks: 4]

#422294

Hi,
My back end details are in my post. To log in to my hosting control panel use the same username and password as FTP here:
https://gator1739.hostgator.com:2083
Thanks

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#422300

Hi
I’ve done please try.
Note: I just only installed JA Comment component. If you need plg please go w/ install.
Thank you
Viet Vu

1 user says Thank You to jooservices for this useful post

1. ttcv

[dracoteam Friend dracoteamJoin date: April 2011Posts: 13Downloads:0Uploads:3 Thanks: 2]

#447829

Hi

I get exactly the same error message. Can you tell us the way to fix it so we can solve it ourselves?

Thanks

[hyperbros Friend hyperbrosJoin date: April 2012Posts: 5Downloads:0Uploads:0]

#450549

I have the same problem too. Now the support forum is closed and i need to install the component!!!
Just tell us why you don’t publish the solution so we can resolve?

Very disappointed >:(

[Ninja Lead Moderator Ninja LeadJoin date: November 2014Posts: 16064Downloads:310Uploads:2864 Thanks: 341 Thanked: 3854 times in 3563 posts]

#450740

<em>@hyperbros 316523 wrote:</em><blockquote>I have the same problem too. Now the support forum is closed and i need to install the component!!!
Just tell us why you don’t publish the solution so we can resolve?

Very disappointed >:(</blockquote>

This is old bug our system some case sql file can not install on your hosting. You can update latest JA Comment version install again or send to me backend site and phpmyadmin, i will check it and give detail solution error on your site.

[pandey909 Friend pandey909Join date: September 2007Posts: 2Downloads:1Uploads:0]

#507947

I installed the latest version 2.5.3 but it is giving me same error while installing the component

Unknown column ‘p0’ in ‘joom_jacomment_items’ SQL=ALTER TABLE `joom_jacomment_items` ADD `latitude` CHAR(255

[Ninja Lead Moderator Ninja LeadJoin date: November 2014Posts: 16064Downloads:310Uploads:2864 Thanks: 341 Thanked: 3854 times in 3563 posts]

#507981

@pandey909: In this case, I would need to take a closer look at your site. Please pm me URL of your site and admin access. I shall help you to check this problem.

[Author]

Posts