After updating 1.6.0 starter, vote/comments not wo

  • Posts: 22
  • Thank you received: 0
12 years 2 months ago #63405

Hi following are the problem I am facing after updating the hikashop starter to latest version yesterday:

1. All old comments/vote disaperared from the product page. Though the input box for comments are there but new comments also not showing in the product page. I can see the comments in dashboard but not in frontend.

2. There is no "Add to Cart" button in the product front page.


Thanks.
Fazlay
www.peak69.com

Last edit: 12 years 2 months ago by s21rc. Reason: more bug report added

Please Log in or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
12 years 2 months ago #63408

here is the debug:

Notice: Undefined variable: hikashop_vote_product_id in /home/peak69/public_html/components/com_hikashop/views/vote/view.html.php on line 67

500
Oops... JDatabaseMySQLi::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND vote_type = 'product'' at line 1 SQL=SELECT count(vote_id) FROM `jml17_hikashop_vote` WHERE vote_ref_id = AND vote_type = 'product'

Please Log in or Create an account to join the conversation.

  • Posts: 82866
  • Thank you received: 13373
  • MODERATOR
12 years 2 months ago #63560

Hi,

1. edit the file components/com_hikashop/views/vote/view.html.php and change the line:
$query = 'SELECT count(vote_id) FROM `#__hikashop_vote` WHERE vote_ref_id = '.$hikashop_vote_product_id.' AND vote_type = '.$db->quote('product').'';
to:
$query = 'SELECT count(vote_id) FROM `#__hikashop_vote` WHERE vote_ref_id = '.(int)$hikashop_vote_product_id.' AND vote_type = '.$db->quote('product').'';

and that will fix the problem.

2. For the add to cart button, in the Display tab of the configuration, turn on the option "display add to cart button".

The following user(s) said Thank You: s21rc

Please Log in or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
12 years 2 months ago #63672

Hi Nicolas,
Thanks, The add to cart came back. The stars showing properly on product. Still comments is not showing (both old and new).

Here is the bug report:

Notice: Undefined variable: hikashop_vote_product_id in /home/peak69/public_html/components/com_hikashop/views/vote/view.html.php on line 67
Notice: Undefined variable: hikashop_vote_product_id in /home/peak69/public_html/components/com_hikashop/views/vote/view.html.php on line 157

Notice: Undefined variable: hikashop_vote_product_id in /home/peak69/public_html/components/com_hikashop/views/vote/view.html.php on line 169

Notice: Trying to get property of non-object in /home/peak69/public_html/components/com_hikashop/views/vote/view.html.php on line 172

Notice: Trying to get property of non-object in /home/peak69/public_html/components/com_hikashop/views/vote/view.html.php on line 173

Notice: Undefined variable: hikashop_vote_product_id in /home/peak69/public_html/components/com_hikashop/views/vote/view.html.php on line 200


Tried to remove the space between the . (int) $hikashop_vote_product_id but no luck. Thanks for your support in advance.

Fazlay

Please Log in or Create an account to join the conversation.

  • Posts: 82866
  • Thank you received: 13373
  • MODERATOR
12 years 2 months ago #63858

Are you able to post new comments ?
These messages are not relevant to the fact that the comments don't show.
You can easily hide them by changing the "error reporting" option of the joomla configuration to "production".

Could you provide a back end access to your website so that we could check your settings ?

The following user(s) said Thank You: s21rc

Please Log in or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
12 years 2 months ago #63897

Hi Nicolas,
1. Old comments disapered
2. New comments doesnt show up, but can be seen in backend

Login credential sent to you in private message.
Thanks a lot
Fazlay

Please Log in or Create an account to join the conversation.

  • Posts: 82866
  • Thank you received: 13373
  • MODERATOR
12 years 2 months ago #64072

Hi,

I didn't get your private message.

Instead, could you use our contact form to send that?

www.hikashop.com/en/contact-us.html

Please Log in or Create an account to join the conversation.

  • Posts: 82866
  • Thank you received: 13373
  • MODERATOR
12 years 2 months ago #64258

The back end access your provided doesn't allow us to access the joomla configuration. We would need that in order to be able to activate the debug mode option. Would it be possible to grant our user such access or turn on that option until we can check your website ?

The following user(s) said Thank You: s21rc

Please Log in or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
12 years 2 months ago #64326

Hi Nicolas,
Manager access been provided in addition to Admin rights. cpanel also been provided for easy access.
thanks for wonderfull support.

Thanks, Fazlay

Please Log in or Create an account to join the conversation.

  • Posts: 82866
  • Thank you received: 13373
  • MODERATOR
12 years 2 months ago #64512

Hi,

I checked your website and the problem was coming from the customization you had done in the file "show" of the view "product". The $params of the hikashop_getLayout was missing the product_id and thus the vote layout didn't know for which product to load the votes/comments.

I've added the missing bits and it's working now.

The following user(s) said Thank You: s21rc

Please Log in or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
12 years 2 months ago #64526

Thanks a lot Nicolas, much appreciated. The vote and comments are working perfectly now.

Another bug report though not important for me but I think you should be aware: after this update the backend dashboard shows all old entries/orders in the last 7 order portion.

Sorry for still using the starter version, hopefully we will migrate soon.

Fazlay
peak69.com

Please Log in or Create an account to join the conversation.

  • Posts: 82866
  • Thank you received: 13373
  • MODERATOR
12 years 2 months ago #64611

Thank you for your report. If you update, you'll be able to configure the widgets the way you want.

Please Log in or Create an account to join the conversation.

Time to create page: 0.066 seconds
Powered by Kunena Forum