[Skip to main content](#vessel-content) # Don't receive confirmation email, just created and Error 1064 ## - **[ChristopheMG](/forum/user/46533-christophemg "View ChristopheMG's Profile")** - [![ChristopheMG's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/46533-christophemg "View ChristopheMG's Profile") Topic Author - [ Offline](/forum/user/46533-christophemg) Less More - Posts: 99 - Thank you received: 0 - - 8 years 9 months ago [\#286340](#286340) by [ChristopheMG](/forum/user/46533-christophemg "View ChristopheMG's Profile") *[Don't receive confirmation email, just created and Error 1064](/forum/2-general-talk-about-hikashop/893545-dont-receive-confirmation-email-just-created-and-error-1064#286340 "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.1.7 -- Browser(s) name and version -- : CHROME -- Error-message(debug-mod must be tuned on) -- : 1064 Hello, After the checkout, the buyer receive only the "Order created" email, not the "confirmed" one. In Hikashop backend > Orders > Order status : confirmed. I would like the opposite, the buyer (and the store because I use Hikamarket) to receive only the confirmation email, I tried to unpublish the "order creation notification" via the menu System->Emails But I still receive only the "Order created" email. I use SMTP as Mailer in the General Joomla Configuration Send Test Mail > OK I try to modify an order in the HikaShop backend, but I get an error 1064: Could you please help me ? Best regards,")* was created by *[ChristopheMG](/forum/user/46533-christophemg "View ChristopheMG's Profile")* -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.1.7 -- Browser(s) name and version -- : CHROME -- Error-message(debug-mod must be tuned on) -- : 1064 Hello, After the checkout, the buyer receive only the "Order created" email, not the "confirmed" one. In Hikashop backend > Orders > Order status : confirmed. I would like the opposite, the buyer (and the store because I use Hikamarket) to receive only the confirmation email, I tried to unpublish the "order creation notification" via the menu System->Emails But I still receive only the "Order created" email. I use SMTP as Mailer in the General Joomla Configuration Send Test Mail > OK I try to modify an order in the HikaShop backend, but I get an error 1064: This message contains confidential information Could you please help me ? Best regards, Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MzU0NS1kb250LXJlY2VpdmUtY29uZmlybWF0aW9uLWVtYWlsLWp1c3QtY3JlYXRlZC1hbmQtZXJyb3ItMTA2ND90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 8 years 9 months ago [\#286383](#286383) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Don't receive confirmation email, just created and Error 1064](/forum/2-general-talk-about-hikashop/893545-dont-receive-confirmation-email-just-created-and-error-1064#286383 "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.1.7 -- Browser(s) name and version -- : CHROME -- Error-message(debug-mod must be tuned on) -- : 1064 Hello, After the checkout, the buyer receive only the "Order created" email, not the "confirmed" one. In Hikashop backend > Orders > Order status : confirmed. I would like the opposite, the buyer (and the store because I use Hikamarket) to receive only the confirmation email, I tried to unpublish the "order creation notification" via the menu System->Emails But I still receive only the "Order created" email. I use SMTP as Mailer in the General Joomla Configuration Send Test Mail > OK I try to modify an order in the HikaShop backend, but I get an error 1064: Could you please help me ? Best regards,")* Hi, Regarding the error in the popup, I don't think it comes from HikaShop. Edit the file libraries/joomla/database/exception/executing.php and change the line : parent::__construct($message, $code, $previous); by: parent::__construct($message.' '.$query, $code, $previous); And you'll get the full MySQL query in the error message. Also, activate the "debug mode" and "error reporting" settings of the Joomla configuration and that way, when you get that error, it should provide more information on where that MySQL query error comes from. Regarding the email: HikaShop actually sends two emails by default, the order creation notification and the order status notification. If the order is directly created with the order status "confirmed", then it's possible that only the order creation notification email is sent. But usually, the order is first created, the email order creation notification is sent, and then the order is confirmed and the email order status notification is sent. So I don't see why you would get only the created one besides that. It might be related to the payment method you're using or how you configured it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MzU0NS1kb250LXJlY2VpdmUtY29uZmlybWF0aW9uLWVtYWlsLWp1c3QtY3JlYXRlZC1hbmQtZXJyb3ItMTA2ND90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[ChristopheMG](/forum/user/46533-christophemg "View ChristopheMG's Profile")** - [![ChristopheMG's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/46533-christophemg "View ChristopheMG's Profile") Topic Author - [ Offline](/forum/user/46533-christophemg) Less More - Posts: 99 - Thank you received: 0 - - 8 years 7 months ago [\#289308](#289308) by [ChristopheMG](/forum/user/46533-christophemg "View ChristopheMG's Profile") Replied by *[ChristopheMG](/forum/user/46533-christophemg "View ChristopheMG's Profile")* on topic *[Don't receive confirmation email, just created and Error 1064](/forum/2-general-talk-about-hikashop/893545-dont-receive-confirmation-email-just-created-and-error-1064#289308 "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.1.7 -- Browser(s) name and version -- : CHROME -- Error-message(debug-mod must be tuned on) -- : 1064 Hello, After the checkout, the buyer receive only the "Order created" email, not the "confirmed" one. In Hikashop backend > Orders > Order status : confirmed. I would like the opposite, the buyer (and the store because I use Hikamarket) to receive only the confirmation email, I tried to unpublish the "order creation notification" via the menu System->Emails But I still receive only the "Order created" email. I use SMTP as Mailer in the General Joomla Configuration Send Test Mail > OK I try to modify an order in the HikaShop backend, but I get an error 1064: Could you please help me ? Best regards,")* Hi Nicolas, Sorry for the delay, - Regarding the error in the popup, yes it's coming from a custom dev and I will try to fix it, thank you. So the problem here is: no confirmation email. - I did a few tests, the buyer still receive only the Order created email “Your order No. J2Y05 is now created at ...” (ORDER_CREATION_NOTIFICATION_SUBJECT). In Hikashop > Orders, the status is “confirmed”. - In the vendor panel, when I change the status, then use the Send email picto to advise the buyer, it’s working as well. (ORDER_STATUS_NOTIFICATION_SUBJECT) - About the payment, I use the Hikashop (market) Paypal Adaptive Payment Plugin, I’m still testing with sandbox accounts. In Hikashop > Systems > Emails, what is the E-mail used for the confirmation actually ? Best regards, Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MzU0NS1kb250LXJlY2VpdmUtY29uZmlybWF0aW9uLWVtYWlsLWp1c3QtY3JlYXRlZC1hbmQtZXJyb3ItMTA2ND90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 8 years 7 months ago [\#289313](#289313) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Don't receive confirmation email, just created and Error 1064](/forum/2-general-talk-about-hikashop/893545-dont-receive-confirmation-email-just-created-and-error-1064#289313 "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.1.7 -- Browser(s) name and version -- : CHROME -- Error-message(debug-mod must be tuned on) -- : 1064 Hello, After the checkout, the buyer receive only the "Order created" email, not the "confirmed" one. In Hikashop backend > Orders > Order status : confirmed. I would like the opposite, the buyer (and the store because I use Hikamarket) to receive only the confirmation email, I tried to unpublish the "order creation notification" via the menu System->Emails But I still receive only the "Order created" email. I use SMTP as Mailer in the General Joomla Configuration Send Test Mail > OK I try to modify an order in the HikaShop backend, but I get an error 1064: Could you please help me ? Best regards,")* Hi, The confirmation email is actually called "order status notification". That's the email sent when the status of the order is changed. Note that the email will only be sent if the status set by the payment plugin when receiving the payment notification from PayPal is the same as the one selected in the "confirmed" column of the menu System>Order Statuses. Also, if the order is already created as confirmed, then the status won't be changed and thus the order status notification email won't be sent either. So check that the status selected in the "created" column of the System>Order statuses menu is "created" and not "confirmed". Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MzU0NS1kb250LXJlY2VpdmUtY29uZmlybWF0aW9uLWVtYWlsLWp1c3QtY3JlYXRlZC1hbmQtZXJyb3ItMTA2ND90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[ChristopheMG](/forum/user/46533-christophemg "View ChristopheMG's Profile")** - [![ChristopheMG's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/46533-christophemg "View ChristopheMG's Profile") Topic Author - [ Offline](/forum/user/46533-christophemg) Less More - Posts: 99 - Thank you received: 0 - - 8 years 7 months ago [\#289589](#289589) by [ChristopheMG](/forum/user/46533-christophemg "View ChristopheMG's Profile") Replied by *[ChristopheMG](/forum/user/46533-christophemg "View ChristopheMG's Profile")* on topic *[Don't receive confirmation email, just created and Error 1064](/forum/2-general-talk-about-hikashop/893545-dont-receive-confirmation-email-just-created-and-error-1064#289589 "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.1.7 -- Browser(s) name and version -- : CHROME -- Error-message(debug-mod must be tuned on) -- : 1064 Hello, After the checkout, the buyer receive only the "Order created" email, not the "confirmed" one. In Hikashop backend > Orders > Order status : confirmed. I would like the opposite, the buyer (and the store because I use Hikamarket) to receive only the confirmation email, I tried to unpublish the "order creation notification" via the menu System->Emails But I still receive only the "Order created" email. I use SMTP as Mailer in the General Joomla Configuration Send Test Mail > OK I try to modify an order in the HikaShop backend, but I get an error 1064: Could you please help me ? Best regards,")* Hi, "order status notification" is published The verified status in the Paypal Adaptive payment plugin is "confirmed" Here is the screenshot of the System>Order statuses menu: image missing https://www.bchef2me.com/divers/System-order-statuses.jpg I'll test again and let you know, Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MzU0NS1kb250LXJlY2VpdmUtY29uZmlybWF0aW9uLWVtYWlsLWp1c3QtY3JlYXRlZC1hbmQtZXJyb3ItMTA2ND90bXBsPW1hcmtkb3du) or [Create an account](/register) 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.100 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)