Categories
View Replies (11)

Resolved SQL Error at Template edit, template disappeared

  1. simplecms
    simplecms
  2. RO CSVI
  3. Tuesday, 10 May 2016
  4.  Subscribe via email
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.
0
Responses (11)
tharuna
tharuna
Accepted Answer Pending Moderation
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.


patch_hikashop_order_2016-05-11.zip
Attachments (1)
patch_hikashop_order_2016-05-11.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
simplecms
simplecms
Accepted Answer Pending Moderation
Fixed it. Thank you.
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
simplecms
simplecms
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 5
simplecms
simplecms
Accepted Answer Pending Moderation
There is no reset button, but logoff/login brought them back.
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 7
simplecms
simplecms
Accepted Answer Pending Moderation
I see. So is there a patch for this? Or do I just tell my client to do this each time their template disappears?
  1. more than a month ago
  2. RO CSVI
  3. # 8
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 9
simplecms
simplecms
Accepted Answer Pending Moderation
Ok, thank you. Please let me know on this.
  1. more than a month ago
  2. RO CSVI
  3. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 11
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!