Jump to content
The Krotek Support Forum
  • Sign Up

Shaigan

Members
  • Content Count

    13
  • Joined

  • Last visited

About Shaigan

  • Rank
    Member

Profile Information

  • Gender
    Male
  • Location
    France
  1. My hosting service refuses to help me on that, it's not in my "contract". This server error does not appear with the 2.2.2 version of the Reference Program plugin, it should be in the differences with the 2.2.3 version.
  2. The setting was already set to Yes. There is no entry in the Error log .
  3. Just uninstalled the 2.2.2 version and deleted all the files, copied the 2.2.3 files to my ftp and got a 500 server error when I want to install it via the extension - > order totals menu. Also, in the vqmod error log, I can see ******************************3_Wed.log******************************* ---------- Date: 2016-11-23 09:06:29 ~ IP : 90.5.41.28 ---------- REQUEST URI : /dev/opencart/ MOD DETAILS: modFile : /www/vqmod/xml/refprogram_2.0.vqmod.xml id : Reference Program version : 2.2.3 vqmver : 2.1.5 author : The Krotek VQModObject::parseMods - Could not resolve path for [admin/model/sale/customer.php] (SKIPPED) VQModObject::parseMods - Could not resolve path for [admin/controller/sale/customer.php] (SKIPPED) VQModObject::parseMods - Could not resolve path for [admin/view/template/sale/customer_form.tpl] (SKIPPED) VQModObject::parseMods - Could not resolve path for [catalog/controller/payment/amazon_checkout.php] (SKIPPED) ----------------------------------------------------------------------
  4. As I understood : 1) The referrer places an order, then after that he gets the code displayed. 2) The referree places an order using the referrer's code. 3) The referrer should be able to place a second order with an automatic discount. In my two setups, this referrer's second order never get the automatic discount. Edit : I've set up a third opencart 2.3.0.2 installation (fresh one) with only vqmod and the reference-program installed. 5€ discount for both referrer and referree. Activation after the 1st order. No status assigned. It doesn't work : referrer doesn't get its discount after the referree placed an order (and after the referrer unlocked it with a 1st order)
  5. Yes I understood that and this is exactly what I would. But, if I set it to 1, the referrer never see the discount after the referred's order get the assigned status. Never mind, it's a good deal
  6. OK. I managed to get it working. But it stops if Is set the Minimum Orders to 1. If I let it empty, it's OK. Thanks a lot for your help.
  7. After the referree completed it's first order (and the order pass on "shipped", as I set it up), I'm looking for an automatic discount on the cart or on the checkout page; on the referrer's account, no ?
  8. Thanks a lot for your help. The installation goes without any error, the reference_id are now correctly populated. But after some tests with the setup as in the first image (in an older post), my referer don't get the discount after all the right steps Regards.
  9. I've installed the extension in the VQMod Manager. I've enabled the extension in the Total Order menu (it took some time). Nothing changed : the same errors in the error log and the reference_id column in the customer table is filled with 0.
  10. Thank for your help. I've disabled the extension in the Total Order menu. I've uninstalled the extension in the VQMod Manager. I've edited the admin/controller/total/refprogram.php file to match the regex ^[0-9]{8,8}$ I've deleted the reference_id column from the order and the cutomer tables.
  11. I've got errors in the error log of opencart : 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM oc_customer_group cg LEFT JOIN oc_customer_group_description cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cgd.language_id = '2' ORDER BY cgd.name ASC in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/sale/customer_group.php on line 71 2016-11-20 23:25:04 - PHP Warning: Invalid argument supplied for foreach() in /home/thefourmcd/www/admin/controller/total/refprogram.php on line 186 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SHOW FIELDS FROM oc_customer WHERE Field ='reference_id' in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/controller/total/refprogram.php on line 490 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />ALTER TABLE oc_customer ADD reference_id INT(11) NOT NULL DEFAULT '0' in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SHOW FIELDS FROM `oc_order` WHERE Field ='reference_id' in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/controller/total/refprogram.php on line 496 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />ALTER TABLE `oc_order` ADD reference_id INT(11) NOT NULL DEFAULT '0' in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT customer_id FROM `oc_customer` WHERE reference_id REGEXP '^[0-9]{8,8}$' in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/controller/total/refprogram.php on line 502 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM oc_extension WHERE `type` = 'total' ORDER BY code in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/extension/extension.php on line 8 2016-11-20 23:25:04 - PHP Warning: Invalid argument supplied for foreach() in /home/thefourmcd/www/admin/model/extension/extension.php on line 8 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT COUNT(*) AS total FROM `oc_order` WHERE (order_status_id = '2') in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/sale/order.php on line 315 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT COUNT(*) AS total FROM `oc_order` WHERE (order_status_id = '5' OR order_status_id = '15' OR order_status_id = '2' OR order_status_id = '3') in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/sale/order.php on line 315 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT COUNT(*) AS total FROM `oc_return`r WHERE r.return_status_id = '2' in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/sale/return.php on line 146 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT COUNT(*) AS total FROM `oc_customer_online` co LEFT JOIN oc_customer c ON (co.customer_id = c.customer_id) in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/report/customer.php on line 314 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT COUNT(*) AS total FROM oc_customer WHERE approved = '0' in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/vqmod/vqcache/vq2-admin_model_sale_customer.php on line 338 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '2' AND p.quantity = '0' in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/catalog/product.php on line 631 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT COUNT(*) AS total FROM oc_review r LEFT JOIN oc_product_description pd ON (r.product_id = pd.product_id) WHERE pd.language_id = '2' AND r.status = '0' in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/catalog/review.php on line 120 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT COUNT(*) AS total FROM oc_affiliate WHERE approved = '0' in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/marketing/affiliate.php on line 194 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM oc_store ORDER BY url in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/setting/store.php on line 57 2016-11-20 23:25:04 - PHP Warning: Invalid argument supplied for foreach() in /home/thefourmcd/www/system/modification/admin/controller/common/header.php on line 128 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT *, (SELECT ug.name FROM `oc_user_group` ug WHERE ug.user_group_id = u.user_group_id) AS user_group FROM `oc_user` u WHERE u.user_id = '2' in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/user/user.php on line 30 2016-11-20 23:25:04 - PHP Notice: Undefined variable: firstname in /home/thefourmcd/www/admin/view/template/common/profile.tpl on line 2 2016-11-20 23:25:04 - PHP Notice: Undefined variable: lastname in /home/thefourmcd/www/admin/view/template/common/profile.tpl on line 2 2016-11-20 23:25:04 - PHP Notice: Undefined variable: firstname in /home/thefourmcd/www/admin/view/template/common/profile.tpl on line 4 2016-11-20 23:25:04 - PHP Notice: Undefined variable: lastname in /home/thefourmcd/www/admin/view/template/common/profile.tpl on line 4 2016-11-20 23:25:04 - PHP Notice: Undefined variable: user_group in /home/thefourmcd/www/admin/view/template/common/profile.tpl on line 5 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT COUNT(*) AS total FROM `oc_order` WHERE order_status_id > '0' in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/sale/order.php on line 315 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT COUNT(*) AS total FROM `oc_order` WHERE (order_status_id = '5' OR order_status_id = '15' OR order_status_id = '2' OR order_status_id = '3') in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/sale/order.php on line 315 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT COUNT(*) AS total FROM `oc_order` WHERE (order_status_id = '2') in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/sale/order.php on line 315 2016-11-20 23:25:04 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT COUNT(*) AS total FROM `oc_order` WHERE (order_status_id = '7' OR order_status_id = '13' OR order_status_id = '10' OR order_status_id = '1' OR order_status_id = '16' OR order_status_id = '14' OR order_status_id = '8' OR order_status_id = '11' OR order_status_id = '9' OR order_status_id = '12') in /home/thefourmcd/www/system/library/db/mysqli.php on line 41 2016-11-20 23:25:04 - PHP Notice: Trying to get property of non-object in /home/thefourmcd/www/admin/model/sale/order.php on line 315 2016-11-20 23:25:04 - PHP Notice: Undefined variable: customer_groups in /home/thefourmcd/www/admin/view/template/total/refprogram.tpl on line 126 2016-11-20 23:25:04 - PHP Warning: Invalid argument supplied for foreach() in /home/thefourmcd/www/admin/view/template/total/refprogram.tpl on line 126 It could be the source of all my problems, assuming a bad install will break the normal function ?
  12. OK. So I've got a problem because the referrer never get any discount on its order On a 2.2.0.0 and on a 2.0.3.1, all my customers have a 0 in the reference_id column of the oc_customer DB -> Assuming that, I did something wrong or the installation partly failed. Now about the "small" remarks : Yes in the admin section of the sharing parameters, the only way to share an ID by mail is to configure an entry with mailto:?subject=##title##&body=##message##. A true mail sharing option should be nicer, because of the poor capacity to pass a beautiful ##message## value in the url. It's not a first view we need to let the mouse on the ID to get the box, or to click on it, this is what I sadly called "hidden". Just a list of links, maybe with font-awesome graphics. Yes, always visible. Can it be an option in future update ?
  13. Hi, I've just bought and installed the plugin but I don't understand how it works. My needs are the following : - a customer need to place at leat one order without any minmum to be allowed to refer a friend - a valid referee can use only one time the discount, at its first order if he wants - a valid referer can use only one time the "referer discount" at the first order after the referee's one Here what and how I'm doing : 1) a new customer place an order and its reference ID is displayed when the order become "terminated" (it's OK) 2) this customer share its ID 3) an other register and place an order with the ID. He get the discount (it's OK) 4) . . . I'm stuck here. How can the referer receive its discount ? I've attached a screenshot of my parameters (I've translated it into french, the place of the parameters are the same). If you could point me what param is wrong; or explain me how is the step-by-step functionment of the reference program, you'll save my day Other some little things : - The shared message is so "text only". Should it be possible to add a true mail sharing option, with the default opencart format ? (like the bill sent by the store) - The popup for the sharing links are a bit "hidden". Maybe an option to make them as "normal clickable links" could solve this small issue. Just a visible list of share links. - Older customers will never see their ID because the column is not filled. A function to fill them during the installation may solve this. Thank for your help. Best regards
×
×
  • Create New...