[Skip to main content](#vessel-content) # Possible Bugs in Akeeba Subscriptions plugins ## - **[niyi2010](/forum/user/34603-niyi2010 "View niyi2010's Profile")** - [![niyi2010's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34603-niyi2010 "View niyi2010's Profile") Topic Author - [ Offline](/forum/user/34603-niyi2010) Less More - Posts: 3 - Thank you received: 0 - - 12 years 1 week ago [\#175899](#175899) by [niyi2010](/forum/user/34603-niyi2010 "View niyi2010's Profile") *[Possible Bugs in Akeeba Subscriptions plugins](/forum/30-integrations/872380-possible-bugs-in-akeeba-subscriptions-plugins#175899 "-- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.7 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Anywhere price is listed for the second Akeeba Subscriptions plugin, the error below shows up: Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\mysite\templates\ats\html\com_hikashop\product\listing_price.php on line 204 $50.00 When using check plugin and after pressing the finish button, this message comes up - Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\mystore\libraries\joomla\database\driver\mysqli.php on line 346 Hello Thank you for this beautiful software and for providing integration for Akeeba Subscription. I am planning to use both extensions and my test revealed some issues: The first and second Akeeba Subscriptions plugins work perfectly except for the error messages I already included in this post and the following issues: 1. If I cancelled an order on Hikashop, it is also disabled in Akeeba Subscription which is good but I noticed the Valid To date changes to 1969-01-01 00:00 even though the Valid From date is for example 2014-10-17 00:17. 2. If that same order is changed from cancelled back to confirmed or shipped, instead of Akeeba Subscription to enable it back, it creates a new copy of the subscription making two subscriptions for the same user but with different IDs. Both subscriptions remain unpublished and their Valid From and Valid To dates are messed up. E.g. The dates for the second copy becomes 1968-12-31 23:00 to 1969-12-31 23:00 while the original subscription is 2014-10-17 00:17 to 1969-01-01 00:00 This can be a major issues if by chance a customer's order gets cancelled and later confirmed. I also observed that for the first Akeeba Subscriptions plugin, orders set to "confirm" are not published in akeeba Subscription except you set it to "shipped". Are these the way the plugins are setup so that once an order is cancelled, it should not be confirmed again? All the issues listed here happens for offline payment. I am not sure if it can happen for online payment. These are my observation for now. I hope it makes sense. Thank you")* was created by *[niyi2010](/forum/user/34603-niyi2010 "View niyi2010's Profile")* -- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.7 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Anywhere price is listed for the second Akeeba Subscriptions plugin, the error below shows up: Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\mysite\templates\ats\html\com_hikashop\product\listing_price.php on line 204 $50.00 When using check plugin and after pressing the finish button, this message comes up - Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\mystore\libraries\joomla\database\driver\mysqli.php on line 346 Hello Thank you for this beautiful software and for providing integration for Akeeba Subscription. I am planning to use both extensions and my test revealed some issues: The first and second Akeeba Subscriptions plugins work perfectly except for the error messages I already included in this post and the following issues: 1. If I cancelled an order on Hikashop, it is also disabled in Akeeba Subscription which is good but I noticed the Valid To date changes to 1969-01-01 00:00 even though the Valid From date is for example 2014-10-17 00:17. 2. If that same order is changed from cancelled back to confirmed or shipped, instead of Akeeba Subscription to enable it back, it creates a new copy of the subscription making two subscriptions for the same user but with different IDs. Both subscriptions remain unpublished and their Valid From and Valid To dates are messed up. E.g. The dates for the second copy becomes 1968-12-31 23:00 to 1969-12-31 23:00 while the original subscription is 2014-10-17 00:17 to 1969-01-01 00:00 This can be a major issues if by chance a customer's order gets cancelled and later confirmed. I also observed that for the first Akeeba Subscriptions plugin, orders set to "confirm" are not published in akeeba Subscription except you set it to "shipped". Are these the way the plugins are setup so that once an order is cancelled, it should not be confirmed again? All the issues listed here happens for offline payment. I am not sure if it can happen for online payment. These are my observation for now. I hope it makes sense. Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy84NzIzODAtcG9zc2libGUtYnVncy1pbi1ha2VlYmEtc3Vic2NyaXB0aW9ucy1wbHVnaW5zP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 1 week ago [\#175939](#175939) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Possible Bugs in Akeeba Subscriptions plugins](/forum/30-integrations/872380-possible-bugs-in-akeeba-subscriptions-plugins#175939 "-- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.7 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Anywhere price is listed for the second Akeeba Subscriptions plugin, the error below shows up: Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\mysite\templates\ats\html\com_hikashop\product\listing_price.php on line 204 $50.00 When using check plugin and after pressing the finish button, this message comes up - Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\mystore\libraries\joomla\database\driver\mysqli.php on line 346 Hello Thank you for this beautiful software and for providing integration for Akeeba Subscription. I am planning to use both extensions and my test revealed some issues: The first and second Akeeba Subscriptions plugins work perfectly except for the error messages I already included in this post and the following issues: 1. If I cancelled an order on Hikashop, it is also disabled in Akeeba Subscription which is good but I noticed the Valid To date changes to 1969-01-01 00:00 even though the Valid From date is for example 2014-10-17 00:17. 2. If that same order is changed from cancelled back to confirmed or shipped, instead of Akeeba Subscription to enable it back, it creates a new copy of the subscription making two subscriptions for the same user but with different IDs. Both subscriptions remain unpublished and their Valid From and Valid To dates are messed up. E.g. The dates for the second copy becomes 1968-12-31 23:00 to 1969-12-31 23:00 while the original subscription is 2014-10-17 00:17 to 1969-01-01 00:00 This can be a major issues if by chance a customer's order gets cancelled and later confirmed. I also observed that for the first Akeeba Subscriptions plugin, orders set to "confirm" are not published in akeeba Subscription except you set it to "shipped". Are these the way the plugins are setup so that once an order is cancelled, it should not be confirmed again? All the issues listed here happens for offline payment. I am not sure if it can happen for online payment. These are my observation for now. I hope it makes sense. Thank you")* Hi, The first error message seems to be coming from your "ats" template. It's not a big issue, potentially a "&" which should be removed. For the second one, it seems to be a bit more important, please give us a screenshot of the full error message. For the dates, is this happening with both plugins ? Do you have both plugins enabled at the same time ? If it is, please use them one by one. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMwLWludGVncmF0aW9ucy84NzIzODAtcG9zc2libGUtYnVncy1pbi1ha2VlYmEtc3Vic2NyaXB0aW9ucy1wbHVnaW5zP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.238 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)