After updating 1.6.0 starter, vote/comments not wo

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

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'

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".

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

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 ?

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

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

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 ?

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

Thanks, Fazlay

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.

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

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