I received the following error on trying edit my template:
Unknown column 'camera' in 'where clause' SQL=SELECT order_product_id AS value,order_product_name AS text FROM #__hikashop_order_product WHERE order_product_id IN (camera) ORDER BY order_product_name
Then when I left the template page and came back the template completely disappeared.
This action was caused when trying to specify a product in Order Product options. The report also came up empty for the product selected.
Hello,
Thank you for reporting on this, it would be of good help if you can mentioned the CSVI version you are using. Try to load the patch file attached and see if the order product issue is solved.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Fixed it. Thank you.
Glad to know it is fixed.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Actually it may not be fixed. The SQL error isn't displaying but my templates have disappeared again from the Templates page. The template fields still exist and I can export the template but there is nothing under the main tab to edit it. I didn't know if the problem is related to this thread or not so I didn't post a new thread.
Hello,
If you go to CSVI Pro -> Templates and click on the Reset button or logout/login, do the templates show up in that case?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
There is no reset button, but logoff/login brought them back.
There is no reset button
It is the X next to the search field.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
I see. So is there a patch for this? Or do I just tell my client to do this each time their template disappears?
Hello,
Tharuna will have a look at that tomorrow as to why they are filtered out.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Ok, thank you. Please let me know on this.
Hello,
I am not able to see this issue in my local site, Can you send me your site administrator login details to check on this?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.