[Skip to main content](#vessel-content) # no PDF in email ## - **[seitenspieler](/forum/user/48087-seitenspieler "View seitenspieler's Profile")** - [![seitenspieler's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/48087-seitenspieler "View seitenspieler's Profile") Topic Author - [ Offline](/forum/user/48087-seitenspieler) Less More - Posts: 64 - Thank you received: 3 - - 8 years 4 months ago - 8 years 4 months ago [\#293670](#293670) by [seitenspieler](/forum/user/48087-seitenspieler "View seitenspieler's Profile") *[no PDF in email](/forum/14-hikaserial/894923-no-pdf-in-email#293670 "-- url of the page with the problem -- : www.picton.place -- HikaShop version -- : 3.4.0 -- HikaSerial version -- : 2.1.1 -- Joomla version -- : 3.8.8 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : SQL syntax error Hi there, I've linked serial numbers with some products like tickets or coupons.. I use PDFserial to attach a PDF to the confirmation email. That worked very well till now. And that stopped working now. A serial is still generated and linked with the product, but there is no PDF in the email. When i send an email again from the backend the error message appears. After reading some posts i followed some of your instructions to find out the details of what happens. Here is the debug-information: Es ist ein Fehler aufgetreten! 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SELECT * FROM a48ra_hikamarket_vendor AS v INNER JOIN a48ra_hikashop_product AS p ON p.product_vendor_id = v.vendor_id WHERE p.product_id = /home/.sites/289/site7648830/web/libraries/joomla/database/driver/mysqli.php:650 Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 3 JDatabaseDriver->loadObject() JROOT/administrator/components/com_hikaserial/classes/order.php:1232 4 hikaserialOrderClass->retrieveConvertedData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:268 5 plgHikaserialPdfserial->loadData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:216 6 plgHikaserialPdfserial->generateData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:135 7 plgHikaserialPdfserial->onBeforeSerialMailSend() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/administrator/components/com_hikaserial/classes/mail.php:118 10 hikaserialMailClass->beforeMailSend() JROOT/plugins/hikashop/serials/serials.php:377 11 plgHikashopSerials->onBeforeMailSend() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/administrator/components/com_hikashop/classes/mail.php:765 14 hikashopMailClass->preProcessMail() JROOT/administrator/components/com_hikashop/classes/mail.php:787 15 hikashopMailClass->sendMail() JROOT/administrator/components/com_hikashop/controllers/order.php:347 16 OrderController->savemail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 17 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 18 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 19 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382 20 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 21 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 22 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 23 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 24 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Hope you can help greetings Peter")* was created by *[seitenspieler](/forum/user/48087-seitenspieler "View seitenspieler's Profile")* -- url of the page with the problem -- : [ www.picton.place](https://www.picton.place) -- HikaShop version -- : 3.4.0 -- HikaSerial version -- : 2.1.1 -- Joomla version -- : 3.8.8 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : SQL syntax error Hi there, I've linked serial numbers with some products like tickets or coupons.. I use PDFserial to attach a PDF to the confirmation email. That worked very well till now. And that stopped working now. A serial is still generated and linked with the product, but there is no PDF in the email. When i send an email again from the backend the error message appears. [ ![Bildschirmfoto2018-06-06um10.39.17.png](/forum/attachment/43866) ](/forum/attachment/43866 "...um10.39.17.png") After reading some posts i followed some of your instructions to find out the details of what happens. Here is the debug-information: Es ist ein Fehler aufgetreten! 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SELECT * FROM a48ra_hikamarket_vendor AS v INNER JOIN a48ra_hikashop_product AS p ON p.product_vendor_id = v.vendor_id WHERE p.product_id = /home/.sites/289/site7648830/web/libraries/joomla/database/driver/mysqli.php:650 Call stack \# Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 3 JDatabaseDriver->loadObject() JROOT/administrator/components/com_hikaserial/classes/order.php:1232 4 hikaserialOrderClass->retrieveConvertedData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:268 5 plgHikaserialPdfserial->loadData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:216 6 plgHikaserialPdfserial->generateData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:135 7 plgHikaserialPdfserial->onBeforeSerialMailSend() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/administrator/components/com_hikaserial/classes/mail.php:118 10 hikaserialMailClass->beforeMailSend() JROOT/plugins/hikashop/serials/serials.php:377 11 plgHikashopSerials->onBeforeMailSend() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/administrator/components/com_hikashop/classes/mail.php:765 14 hikashopMailClass->preProcessMail() JROOT/administrator/components/com_hikashop/classes/mail.php:787 15 hikashopMailClass->sendMail() JROOT/administrator/components/com_hikashop/controllers/order.php:347 16 OrderController->savemail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 17 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 18 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 19 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382 20 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 21 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 22 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 23 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 24 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Hope you can help greetings Peter - [ ![Bildschirmfoto2018-06-06um10.39.17.png](/forum/attachment/43866) ](/forum/attachment/43866 "...um10.39.17.png") [ ](/forum/attachment/43866?download=1 "...um10.39.17.png") Last edit: 8 years 4 months ago by [seitenspieler](/forum/user/48087-seitenspieler "View seitenspieler's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODk0OTIzLW5vLXBkZi1pbi1lbWFpbD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 8 years 4 months ago [\#293687](#293687) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[no PDF in email](/forum/14-hikaserial/894923-no-pdf-in-email#293687 "-- url of the page with the problem -- : www.picton.place -- HikaShop version -- : 3.4.0 -- HikaSerial version -- : 2.1.1 -- Joomla version -- : 3.8.8 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : SQL syntax error Hi there, I've linked serial numbers with some products like tickets or coupons.. I use PDFserial to attach a PDF to the confirmation email. That worked very well till now. And that stopped working now. A serial is still generated and linked with the product, but there is no PDF in the email. When i send an email again from the backend the error message appears. After reading some posts i followed some of your instructions to find out the details of what happens. Here is the debug-information: Es ist ein Fehler aufgetreten! 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SELECT * FROM a48ra_hikamarket_vendor AS v INNER JOIN a48ra_hikashop_product AS p ON p.product_vendor_id = v.vendor_id WHERE p.product_id = /home/.sites/289/site7648830/web/libraries/joomla/database/driver/mysqli.php:650 Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 3 JDatabaseDriver->loadObject() JROOT/administrator/components/com_hikaserial/classes/order.php:1232 4 hikaserialOrderClass->retrieveConvertedData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:268 5 plgHikaserialPdfserial->loadData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:216 6 plgHikaserialPdfserial->generateData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:135 7 plgHikaserialPdfserial->onBeforeSerialMailSend() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/administrator/components/com_hikaserial/classes/mail.php:118 10 hikaserialMailClass->beforeMailSend() JROOT/plugins/hikashop/serials/serials.php:377 11 plgHikashopSerials->onBeforeMailSend() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/administrator/components/com_hikashop/classes/mail.php:765 14 hikashopMailClass->preProcessMail() JROOT/administrator/components/com_hikashop/classes/mail.php:787 15 hikashopMailClass->sendMail() JROOT/administrator/components/com_hikashop/controllers/order.php:347 16 OrderController->savemail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 17 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 18 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 19 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382 20 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 21 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 22 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 23 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 24 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Hope you can help greetings Peter")* Hello, In the HikaSerial order class you have to replace the line Code: $query = 'SELECT * FROM '.hikamarket::table('vendor').' AS v INNER JOIN '.hikamarket::table('shop.product').' AS p ON p.product_vendor_id = v.vendor_id WHERE p.product_id = '.$serial->product_id; By Code: $query = 'SELECT * FROM '.hikamarket::table('vendor').' AS v INNER JOIN '.hikamarket::table('shop.product').' AS p ON p.product_vendor_id = v.vendor_id WHERE p.product_id = '.(int)$object->product_id; We will also include that patch in the next build. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODk0OTIzLW5vLXBkZi1pbi1lbWFpbD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[seitenspieler](/forum/user/48087-seitenspieler "View seitenspieler's Profile")** - [![seitenspieler's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/48087-seitenspieler "View seitenspieler's Profile") Topic Author - [ Offline](/forum/user/48087-seitenspieler) Less More - Posts: 64 - Thank you received: 3 - - 8 years 4 months ago [\#293710](#293710) by [seitenspieler](/forum/user/48087-seitenspieler "View seitenspieler's Profile") Replied by *[seitenspieler](/forum/user/48087-seitenspieler "View seitenspieler's Profile")* on topic *[no PDF in email](/forum/14-hikaserial/894923-no-pdf-in-email#293710 "-- url of the page with the problem -- : www.picton.place -- HikaShop version -- : 3.4.0 -- HikaSerial version -- : 2.1.1 -- Joomla version -- : 3.8.8 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : SQL syntax error Hi there, I've linked serial numbers with some products like tickets or coupons.. I use PDFserial to attach a PDF to the confirmation email. That worked very well till now. And that stopped working now. A serial is still generated and linked with the product, but there is no PDF in the email. When i send an email again from the backend the error message appears. After reading some posts i followed some of your instructions to find out the details of what happens. Here is the debug-information: Es ist ein Fehler aufgetreten! 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SELECT * FROM a48ra_hikamarket_vendor AS v INNER JOIN a48ra_hikashop_product AS p ON p.product_vendor_id = v.vendor_id WHERE p.product_id = /home/.sites/289/site7648830/web/libraries/joomla/database/driver/mysqli.php:650 Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 3 JDatabaseDriver->loadObject() JROOT/administrator/components/com_hikaserial/classes/order.php:1232 4 hikaserialOrderClass->retrieveConvertedData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:268 5 plgHikaserialPdfserial->loadData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:216 6 plgHikaserialPdfserial->generateData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:135 7 plgHikaserialPdfserial->onBeforeSerialMailSend() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/administrator/components/com_hikaserial/classes/mail.php:118 10 hikaserialMailClass->beforeMailSend() JROOT/plugins/hikashop/serials/serials.php:377 11 plgHikashopSerials->onBeforeMailSend() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/administrator/components/com_hikashop/classes/mail.php:765 14 hikashopMailClass->preProcessMail() JROOT/administrator/components/com_hikashop/classes/mail.php:787 15 hikashopMailClass->sendMail() JROOT/administrator/components/com_hikashop/controllers/order.php:347 16 OrderController->savemail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 17 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 18 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 19 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382 20 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 21 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 22 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 23 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 24 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Hope you can help greetings Peter")* Thank you Jerome for your answer. Can you give me please an assistance, where to find the right php file? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODk0OTIzLW5vLXBkZi1pbi1lbWFpbD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 8 years 4 months ago [\#293711](#293711) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[no PDF in email](/forum/14-hikaserial/894923-no-pdf-in-email#293711 "-- url of the page with the problem -- : www.picton.place -- HikaShop version -- : 3.4.0 -- HikaSerial version -- : 2.1.1 -- Joomla version -- : 3.8.8 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : SQL syntax error Hi there, I've linked serial numbers with some products like tickets or coupons.. I use PDFserial to attach a PDF to the confirmation email. That worked very well till now. And that stopped working now. A serial is still generated and linked with the product, but there is no PDF in the email. When i send an email again from the backend the error message appears. After reading some posts i followed some of your instructions to find out the details of what happens. Here is the debug-information: Es ist ein Fehler aufgetreten! 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SELECT * FROM a48ra_hikamarket_vendor AS v INNER JOIN a48ra_hikashop_product AS p ON p.product_vendor_id = v.vendor_id WHERE p.product_id = /home/.sites/289/site7648830/web/libraries/joomla/database/driver/mysqli.php:650 Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 3 JDatabaseDriver->loadObject() JROOT/administrator/components/com_hikaserial/classes/order.php:1232 4 hikaserialOrderClass->retrieveConvertedData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:268 5 plgHikaserialPdfserial->loadData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:216 6 plgHikaserialPdfserial->generateData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:135 7 plgHikaserialPdfserial->onBeforeSerialMailSend() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/administrator/components/com_hikaserial/classes/mail.php:118 10 hikaserialMailClass->beforeMailSend() JROOT/plugins/hikashop/serials/serials.php:377 11 plgHikashopSerials->onBeforeMailSend() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/administrator/components/com_hikashop/classes/mail.php:765 14 hikashopMailClass->preProcessMail() JROOT/administrator/components/com_hikashop/classes/mail.php:787 15 hikashopMailClass->sendMail() JROOT/administrator/components/com_hikashop/controllers/order.php:347 16 OrderController->savemail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 17 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 18 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 19 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382 20 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 21 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 22 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 23 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 24 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Hope you can help greetings Peter")* Hello, From your call stack, you can find it : Code: JROOT/administrator/components/com_hikaserial/classes/order.php:1232 So the line I'm talking about is just before the line 1232 of that file. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [seitenspieler](/forum/user/48087-seitenspieler "View seitenspieler's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODk0OTIzLW5vLXBkZi1pbi1lbWFpbD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[seitenspieler](/forum/user/48087-seitenspieler "View seitenspieler's Profile")** - [![seitenspieler's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/48087-seitenspieler "View seitenspieler's Profile") Topic Author - [ Offline](/forum/user/48087-seitenspieler) Less More - Posts: 64 - Thank you received: 3 - - 8 years 4 months ago [\#293732](#293732) by [seitenspieler](/forum/user/48087-seitenspieler "View seitenspieler's Profile") Replied by *[seitenspieler](/forum/user/48087-seitenspieler "View seitenspieler's Profile")* on topic *[no PDF in email](/forum/14-hikaserial/894923-no-pdf-in-email#293732 "-- url of the page with the problem -- : www.picton.place -- HikaShop version -- : 3.4.0 -- HikaSerial version -- : 2.1.1 -- Joomla version -- : 3.8.8 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : SQL syntax error Hi there, I've linked serial numbers with some products like tickets or coupons.. I use PDFserial to attach a PDF to the confirmation email. That worked very well till now. And that stopped working now. A serial is still generated and linked with the product, but there is no PDF in the email. When i send an email again from the backend the error message appears. After reading some posts i followed some of your instructions to find out the details of what happens. Here is the debug-information: Es ist ein Fehler aufgetreten! 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SELECT * FROM a48ra_hikamarket_vendor AS v INNER JOIN a48ra_hikashop_product AS p ON p.product_vendor_id = v.vendor_id WHERE p.product_id = /home/.sites/289/site7648830/web/libraries/joomla/database/driver/mysqli.php:650 Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 3 JDatabaseDriver->loadObject() JROOT/administrator/components/com_hikaserial/classes/order.php:1232 4 hikaserialOrderClass->retrieveConvertedData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:268 5 plgHikaserialPdfserial->loadData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:216 6 plgHikaserialPdfserial->generateData() JROOT/plugins/hikaserial/pdfserial/pdfserial.php:135 7 plgHikaserialPdfserial->onBeforeSerialMailSend() JROOT/libraries/joomla/event/event.php:70 8 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/administrator/components/com_hikaserial/classes/mail.php:118 10 hikaserialMailClass->beforeMailSend() JROOT/plugins/hikashop/serials/serials.php:377 11 plgHikashopSerials->onBeforeMailSend() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/administrator/components/com_hikashop/classes/mail.php:765 14 hikashopMailClass->preProcessMail() JROOT/administrator/components/com_hikashop/classes/mail.php:787 15 hikashopMailClass->sendMail() JROOT/administrator/components/com_hikashop/controllers/order.php:347 16 OrderController->savemail() JROOT/libraries/src/MVC/Controller/BaseController.php:710 17 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1885 18 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 19 require_once() JROOT/libraries/src/Component/ComponentHelper.php:382 20 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 21 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 22 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 23 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 24 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Hope you can help greetings Peter")* Thanks for the quick support - it works again. greetings Peter Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE0LWhpa2FzZXJpYWwvODk0OTIzLW5vLXBkZi1pbi1lbWFpbD90bXBsPW1hcmtkb3du) 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? Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile") [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.113 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)