[Skip to main content](#vessel-content)

#   Error when downloading image file that client sent

##

- **[ghk](/forum/user/35069-ghk "View ghk's Profile")**
- [![ghk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35069-ghk "View ghk's Profile") Topic Author
- [ Offline](/forum/user/35069-ghk)

Less More

- Posts: 2
- Thank you received: 0
-
-

11 years 11 months ago [\#180864](#180864) by [ghk](/forum/user/35069-ghk "View ghk's Profile")  *[Error when downloading image file that client sent](/forum/35-orders-management/873205-error-when-downloading-image-file-that-client-sent#180864 "-- Joomla version -- : 3.3.6 -- Error-message(debug-mod must be tuned on) -- : Error: 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 'AND file&#95;upload = 'penguins&#95;2114164670.jpg'' at line 1 SQL=SELECT order&#95;id FROM p1v3y&#95;hikashop&#95;order WHERE order&#95;user&#95;id= AND file&#95;upload = 'penguins&#95;2114164670.jpg'  Hi. I am buliding site with hikashop, and recently I created custom field for file uploads. When we recieve order from user and we want to click and download the image he uploaded, we redirected to our website and recieve this error message:")* was created by *[ghk](/forum/user/35069-ghk "View ghk's Profile")*

-- Joomla version -- : 3.3.6
-- Error-message(debug-mod must be tuned on) -- : Error: 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 'AND file_upload = 'penguins_2114164670.jpg'' at line 1 SQL=SELECT order_id FROM p1v3y_hikashop_order WHERE order_user_id= AND file_upload = 'penguins_2114164670.jpg'

Hi.
I am buliding site with hikashop, and recently I created custom field for file uploads.
When we recieve order from user and we want to click and download the image he uploaded, we redirected to our website and recieve this error message:

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3MzIwNS1lcnJvci13aGVuLWRvd25sb2FkaW5nLWltYWdlLWZpbGUtdGhhdC1jbGllbnQtc2VudD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")**
- [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")
- [ Offline](/forum/user/6861-mohamed-thelji)

Less More

- Posts: 12953
- Thank you received: 1778
-
-
-

11 years 11 months ago [\#180913](#180913) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")  Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Error when downloading image file that client sent](/forum/35-orders-management/873205-error-when-downloading-image-file-that-client-sent#180913 "-- Joomla version -- : 3.3.6 -- Error-message(debug-mod must be tuned on) -- : Error: 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 'AND file&#95;upload = 'penguins&#95;2114164670.jpg'' at line 1 SQL=SELECT order&#95;id FROM p1v3y&#95;hikashop&#95;order WHERE order&#95;user&#95;id= AND file&#95;upload = 'penguins&#95;2114164670.jpg'  Hi. I am buliding site with hikashop, and recently I created custom field for file uploads. When we recieve order from user and we want to click and download the image he uploaded, we redirected to our website and recieve this error message:")*

Hello,
Firstly, can you download the last Hikashop version through our website, install it and test it again ?
Thanks.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3MzIwNS1lcnJvci13aGVuLWRvd25sb2FkaW5nLWltYWdlLWZpbGUtdGhhdC1jbGllbnQtc2VudD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[ghk](/forum/user/35069-ghk "View ghk's Profile")**
- [![ghk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35069-ghk "View ghk's Profile") Topic Author
- [ Offline](/forum/user/35069-ghk)

Less More

- Posts: 2
- Thank you received: 0
-
-

11 years 11 months ago [\#180968](#180968) by [ghk](/forum/user/35069-ghk "View ghk's Profile")  Replied by *[ghk](/forum/user/35069-ghk "View ghk's Profile")* on topic *[Error when downloading image file that client sent](/forum/35-orders-management/873205-error-when-downloading-image-file-that-client-sent#180968 "-- Joomla version -- : 3.3.6 -- Error-message(debug-mod must be tuned on) -- : Error: 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 'AND file&#95;upload = 'penguins&#95;2114164670.jpg'' at line 1 SQL=SELECT order&#95;id FROM p1v3y&#95;hikashop&#95;order WHERE order&#95;user&#95;id= AND file&#95;upload = 'penguins&#95;2114164670.jpg'  Hi. I am buliding site with hikashop, and recently I created custom field for file uploads. When we recieve order from user and we want to click and download the image he uploaded, we redirected to our website and recieve this error message:")*

No, because my client forgotten his hikashop account that he purchased with. So I need to stick to this version of hikashop. So pleasehelp me with this situation.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3MzIwNS1lcnJvci13aGVuLWRvd25sb2FkaW5nLWltYWdlLWZpbGUtdGhhdC1jbGllbnQtc2VudD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14268
-
-

11 years 11 months ago [\#181219](#181219) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error when downloading image file that client sent](/forum/35-orders-management/873205-error-when-downloading-image-file-that-client-sent#181219 "-- Joomla version -- : 3.3.6 -- Error-message(debug-mod must be tuned on) -- : Error: 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 'AND file&#95;upload = 'penguins&#95;2114164670.jpg'' at line 1 SQL=SELECT order&#95;id FROM p1v3y&#95;hikashop&#95;order WHERE order&#95;user&#95;id= AND file&#95;upload = 'penguins&#95;2114164670.jpg'  Hi. I am buliding site with hikashop, and recently I created custom field for file uploads. When we recieve order from user and we want to click and download the image he uploaded, we redirected to our website and recieve this error message:")*

This will really require an update of HikaShop in order to fix the issue.

We'll be happy to look for your client's account. Please ask him (or do it for him) to contact us via our contact form and provide as much information as possible on his order of HikaShop for us to be able to find it and verify it (order number, email address, name, address, paypal transaction number, etc) and we'll be able to give him back his access to his account.
Here is the contact form:
[ www.hikashop.com/support/contact-us.html](http://www.hikashop.com/support/contact-us.html)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3MzIwNS1lcnJvci13aGVuLWRvd25sb2FkaW5nLWltYWdlLWZpbGUtdGhhdC1jbGllbnQtc2VudD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop- Install &amp; Update- Product &amp; Category Display- Content Creation- Sales and Orders- - Orders management- - Reports &amp; Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import &amp; Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel &amp; Slider- - Mass Actions- - Filters &amp; Search- - Discount &amp; 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.217 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)

[](#top)
