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

#   1064 SQL syntax error

##

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

Less More

- Posts: 12
- Thank you received: 1
-
-

12 years 3 weeks ago [\#176557](#176557) by [valeriejhz](/forum/user/34683-valeriejhz "View valeriejhz's Profile")  *[1064 SQL syntax error](/forum/27-checkout/872512-1064-sql-syntax-error#176557 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome Version 38.0.2125.104 m (also Firefox on both Windows and Unix - not sure what versions) -- Error-message(debug-mod must be tuned on) -- : 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 SQL=SELECT a.&#42; FROM erud9&#95;hikashop&#95;order&#95;product AS a WHERE a.order&#95;id =  I get this error on the front end when I click the Finish button on the checkout page - it is supposed to go to the Authorize.net plugin next. I also get the same error on the backend when I go to the Order table and click the New button. I can get it cleared up by deleting all my HikaShop files and reinstalling HikaShop. After that, I can click New in the table all day long and it will create a new line item in the table. Once I go to the front end checkout, put something in the cart, and select Finish, the error is back and will happen in the Order table from that point forward. The site is timelesshomeschoolevents.org.  Help, please!  Thanks.")* was created by *[valeriejhz](/forum/user/34683-valeriejhz "View valeriejhz's Profile")*

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.4.32
-- Browser(s) name and version -- : Chrome Version 38.0.2125.104 m (also Firefox on both Windows and Unix - not sure what versions)
-- Error-message(debug-mod must be tuned on) -- : 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 SQL=SELECT a.* FROM erud9_hikashop_order_product AS a WHERE a.order_id =

I get this error on the front end when I click the Finish button on the checkout page - it is supposed to go to the Authorize.net plugin next. I also get the same error on the backend when I go to the Order table and click the New button. I can get it cleared up by deleting all my HikaShop files and reinstalling HikaShop. After that, I can click New in the table all day long and it will create a new line item in the table. Once I go to the front end checkout, put something in the cart, and select Finish, the error is back and will happen in the Order table from that point forward.
The site is timelesshomeschoolevents.org.

Help, please!

Thanks.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MjUxMi0xMDY0LXNxbC1zeW50YXgtZXJyb3I/dG1wbD1tYXJrZG93bg==) 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: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

12 years 3 weeks ago [\#176625](#176625) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1064 SQL syntax error](/forum/27-checkout/872512-1064-sql-syntax-error#176625 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome Version 38.0.2125.104 m (also Firefox on both Windows and Unix - not sure what versions) -- Error-message(debug-mod must be tuned on) -- : 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 SQL=SELECT a.&#42; FROM erud9&#95;hikashop&#95;order&#95;product AS a WHERE a.order&#95;id =  I get this error on the front end when I click the Finish button on the checkout page - it is supposed to go to the Authorize.net plugin next. I also get the same error on the backend when I go to the Order table and click the New button. I can get it cleared up by deleting all my HikaShop files and reinstalling HikaShop. After that, I can click New in the table all day long and it will create a new line item in the table. Once I go to the front end checkout, put something in the cart, and select Finish, the error is back and will happen in the Order table from that point forward. The site is timelesshomeschoolevents.org.  Help, please!  Thanks.")*

Hi,

Do you have falang installled in your website ?

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

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

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

Less More

- Posts: 12
- Thank you received: 1
-
-

12 years 3 weeks ago [\#176639](#176639) by [valeriejhz](/forum/user/34683-valeriejhz "View valeriejhz's Profile")  Replied by *[valeriejhz](/forum/user/34683-valeriejhz "View valeriejhz's Profile")* on topic *[1064 SQL syntax error](/forum/27-checkout/872512-1064-sql-syntax-error#176639 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome Version 38.0.2125.104 m (also Firefox on both Windows and Unix - not sure what versions) -- Error-message(debug-mod must be tuned on) -- : 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 SQL=SELECT a.&#42; FROM erud9&#95;hikashop&#95;order&#95;product AS a WHERE a.order&#95;id =  I get this error on the front end when I click the Finish button on the checkout page - it is supposed to go to the Authorize.net plugin next. I also get the same error on the backend when I go to the Order table and click the New button. I can get it cleared up by deleting all my HikaShop files and reinstalling HikaShop. After that, I can click New in the table all day long and it will create a new line item in the table. Once I go to the front end checkout, put something in the cart, and select Finish, the error is back and will happen in the Order table from that point forward. The site is timelesshomeschoolevents.org.  Help, please!  Thanks.")*

I don't.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MjUxMi0xMDY0LXNxbC1zeW50YXgtZXJyb3I/dG1wbD1tYXJrZG93bg==) 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 3 weeks ago [\#176662](#176662) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[1064 SQL syntax error](/forum/27-checkout/872512-1064-sql-syntax-error#176662 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome Version 38.0.2125.104 m (also Firefox on both Windows and Unix - not sure what versions) -- Error-message(debug-mod must be tuned on) -- : 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 SQL=SELECT a.&#42; FROM erud9&#95;hikashop&#95;order&#95;product AS a WHERE a.order&#95;id =  I get this error on the front end when I click the Finish button on the checkout page - it is supposed to go to the Authorize.net plugin next. I also get the same error on the backend when I go to the Order table and click the New button. I can get it cleared up by deleting all my HikaShop files and reinstalling HikaShop. After that, I can click New in the table all day long and it will create a new line item in the table. Once I go to the front end checkout, put something in the cart, and select Finish, the error is back and will happen in the Order table from that point forward. The site is timelesshomeschoolevents.org.  Help, please!  Thanks.")*

Hi,

Please provide a test account in order to reproduce the issue and see from where the error come.
Turning on the Joomla debug mode and setting the error reporting level to "maximum" will be top.

This way we will see a more detailed error.

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

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

Less More

- Posts: 12
- Thank you received: 1
-
-

12 years 3 weeks ago [\#176838](#176838) by [valeriejhz](/forum/user/34683-valeriejhz "View valeriejhz's Profile")  Replied by *[valeriejhz](/forum/user/34683-valeriejhz "View valeriejhz's Profile")* on topic *[1064 SQL syntax error](/forum/27-checkout/872512-1064-sql-syntax-error#176838 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome Version 38.0.2125.104 m (also Firefox on both Windows and Unix - not sure what versions) -- Error-message(debug-mod must be tuned on) -- : 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 SQL=SELECT a.&#42; FROM erud9&#95;hikashop&#95;order&#95;product AS a WHERE a.order&#95;id =  I get this error on the front end when I click the Finish button on the checkout page - it is supposed to go to the Authorize.net plugin next. I also get the same error on the backend when I go to the Order table and click the New button. I can get it cleared up by deleting all my HikaShop files and reinstalling HikaShop. After that, I can click New in the table all day long and it will create a new line item in the table. Once I go to the front end checkout, put something in the cart, and select Finish, the error is back and will happen in the Order table from that point forward. The site is timelesshomeschoolevents.org.  Help, please!  Thanks.")*

I created a an account - login is test password is Passw0rd

Thanks!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MjUxMi0xMDY0LXNxbC1zeW50YXgtZXJyb3I/dG1wbD1tYXJrZG93bg==) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86560
- Thank you received: 14307
-
-

12 years 3 weeks ago [\#176858](#176858) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1064 SQL syntax error](/forum/27-checkout/872512-1064-sql-syntax-error#176858 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome Version 38.0.2125.104 m (also Firefox on both Windows and Unix - not sure what versions) -- Error-message(debug-mod must be tuned on) -- : 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 SQL=SELECT a.&#42; FROM erud9&#95;hikashop&#95;order&#95;product AS a WHERE a.order&#95;id =  I get this error on the front end when I click the Finish button on the checkout page - it is supposed to go to the Authorize.net plugin next. I also get the same error on the backend when I go to the Order table and click the New button. I can get it cleared up by deleting all my HikaShop files and reinstalling HikaShop. After that, I can click New in the table all day long and it will create a new line item in the table. Once I go to the front end checkout, put something in the cart, and select Finish, the error is back and will happen in the Order table from that point forward. The site is timelesshomeschoolevents.org.  Help, please!  Thanks.")*

Hi,

Change the code: Code:

$query = 'SELECT a.* FROM '.hikashop_table('order_product').' AS a WHERE a.order_id = '.$order-&gt;order_id;

to:
Code:

$query = 'SELECT a.* FROM '.hikashop_table('order_product').' AS a WHERE a.order_id = '.(int)$order-&gt;order_id;

in the file administrator/components/com_hikashop/classes/order.php and that will fix the problem.

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

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

Less More

- Posts: 12
- Thank you received: 1
-
-

12 years 2 weeks ago [\#177437](#177437) by [valeriejhz](/forum/user/34683-valeriejhz "View valeriejhz's Profile")  Replied by *[valeriejhz](/forum/user/34683-valeriejhz "View valeriejhz's Profile")* on topic *[1064 SQL syntax error](/forum/27-checkout/872512-1064-sql-syntax-error#177437 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome Version 38.0.2125.104 m (also Firefox on both Windows and Unix - not sure what versions) -- Error-message(debug-mod must be tuned on) -- : 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 SQL=SELECT a.&#42; FROM erud9&#95;hikashop&#95;order&#95;product AS a WHERE a.order&#95;id =  I get this error on the front end when I click the Finish button on the checkout page - it is supposed to go to the Authorize.net plugin next. I also get the same error on the backend when I go to the Order table and click the New button. I can get it cleared up by deleting all my HikaShop files and reinstalling HikaShop. After that, I can click New in the table all day long and it will create a new line item in the table. Once I go to the front end checkout, put something in the cart, and select Finish, the error is back and will happen in the Order table from that point forward. The site is timelesshomeschoolevents.org.  Help, please!  Thanks.")*

Now I have more errors ![:(](/media/kunena/emoticons/22.png ":(")

Notice: Undefined property: stdClass::$order_id in /home2/sparklk0/public_html/timelesshomeschoolevents/administrator/components/com_hikashop/classes/order.php on line 1065

Notice: Undefined property: hikashopProductClass::$products in /home2/sparklk0/public_html/timelesshomeschoolevents/plugins/hikashop/massaction_order/massaction_order.php on line 431

Warning: Invalid argument supplied for foreach() in /home2/sparklk0/public_html/timelesshomeschoolevents/plugins/hikashop/massaction_order/massaction_order.php on line 431

Fatal error: __clone method called on non-object in /home2/sparklk0/public_html/timelesshomeschoolevents/administrator/components/com_hikashop/classes/order.php on line 474

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MjUxMi0xMDY0LXNxbC1zeW50YXgtZXJyb3I/dG1wbD1tYXJrZG93bg==) 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: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

12 years 2 weeks ago [\#177474](#177474) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[1064 SQL syntax error](/forum/27-checkout/872512-1064-sql-syntax-error#177474 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome Version 38.0.2125.104 m (also Firefox on both Windows and Unix - not sure what versions) -- Error-message(debug-mod must be tuned on) -- : 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 SQL=SELECT a.&#42; FROM erud9&#95;hikashop&#95;order&#95;product AS a WHERE a.order&#95;id =  I get this error on the front end when I click the Finish button on the checkout page - it is supposed to go to the Authorize.net plugin next. I also get the same error on the backend when I go to the Order table and click the New button. I can get it cleared up by deleting all my HikaShop files and reinstalling HikaShop. After that, I can click New in the table all day long and it will create a new line item in the table. Once I go to the front end checkout, put something in the cart, and select Finish, the error is back and will happen in the Order table from that point forward. The site is timelesshomeschoolevents.org.  Help, please!  Thanks.")*

Hi,

It looks like you have a mass-action.
Could you please unpublish this mass action and tell us more about it ?

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

The following user(s) said Thank You: [valeriejhz](/forum/user/34683-valeriejhz "View valeriejhz's Profile")

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

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

Less More

- Posts: 12
- Thank you received: 1
-
-

12 years 2 weeks ago [\#177853](#177853) by [valeriejhz](/forum/user/34683-valeriejhz "View valeriejhz's Profile")  Replied by *[valeriejhz](/forum/user/34683-valeriejhz "View valeriejhz's Profile")* on topic *[1064 SQL syntax error](/forum/27-checkout/872512-1064-sql-syntax-error#177853 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome Version 38.0.2125.104 m (also Firefox on both Windows and Unix - not sure what versions) -- Error-message(debug-mod must be tuned on) -- : 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 SQL=SELECT a.&#42; FROM erud9&#95;hikashop&#95;order&#95;product AS a WHERE a.order&#95;id =  I get this error on the front end when I click the Finish button on the checkout page - it is supposed to go to the Authorize.net plugin next. I also get the same error on the backend when I go to the Order table and click the New button. I can get it cleared up by deleting all my HikaShop files and reinstalling HikaShop. After that, I can click New in the table all day long and it will create a new line item in the table. Once I go to the front end checkout, put something in the cart, and select Finish, the error is back and will happen in the Order table from that point forward. The site is timelesshomeschoolevents.org.  Help, please!  Thanks.")*

I had a lot of issues on my website not related to HikaShop - I don't think I had a mass action or anything, but I don't know. I think I really screwed some stuff up trying different extensions and just trying to learn Joomla for the first time. I started with a fresh install of Joomla and rebuilt everything. Everything is working except for Authorize.net payment plugin. When I click finish to pay, it says Pay Now - I click that, and get this:

This XML file does not appear to have any style information associated with it. The document tree is shown below.
&lt;response&gt;
&lt;ResponseCode&gt;3&lt;/ResponseCode&gt;
&lt;Errors&gt;
&lt;Error&gt;
&lt;ErrorCode&gt;87&lt;/ErrorCode&gt;
&lt;ErrorText&gt;
&lt;![CDATA[
Transactions of this market type cannot be processed on this system.
]]&gt;
&lt;/ErrorText&gt;
&lt;/Error&gt;
&lt;/Errors&gt;
&lt;AuthCode&gt;
&lt;![CDATA[ ]]&gt;
&lt;/AuthCode&gt;
&lt;AVSResultCode&gt;P&lt;/AVSResultCode&gt;
&lt;CVVResultCode/&gt;
&lt;TransID&gt;0&lt;/TransID&gt;
&lt;RefTransID/&gt;
&lt;TransHash&gt;3B3A2E4F34BA45A2D31362393480CEF0&lt;/TransHash&gt;
&lt;TestMode&gt;0&lt;/TestMode&gt;
&lt;UserRef/&gt;
&lt;AccountNumber/&gt;
&lt;AccountType/&gt;
&lt;/response&gt;

This may be an issue with Authorize.net, and not HikaShop at all, but I wanted to make sure.

Thanks for all your help!!

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

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

Less More

- Posts: 12
- Thank you received: 1
-
-

12 years 2 weeks ago [\#177854](#177854) by [valeriejhz](/forum/user/34683-valeriejhz "View valeriejhz's Profile")  Replied by *[valeriejhz](/forum/user/34683-valeriejhz "View valeriejhz's Profile")* on topic *[1064 SQL syntax error](/forum/27-checkout/872512-1064-sql-syntax-error#177854 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome Version 38.0.2125.104 m (also Firefox on both Windows and Unix - not sure what versions) -- Error-message(debug-mod must be tuned on) -- : 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 SQL=SELECT a.&#42; FROM erud9&#95;hikashop&#95;order&#95;product AS a WHERE a.order&#95;id =  I get this error on the front end when I click the Finish button on the checkout page - it is supposed to go to the Authorize.net plugin next. I also get the same error on the backend when I go to the Order table and click the New button. I can get it cleared up by deleting all my HikaShop files and reinstalling HikaShop. After that, I can click New in the table all day long and it will create a new line item in the table. Once I go to the front end checkout, put something in the cart, and select Finish, the error is back and will happen in the Order table from that point forward. The site is timelesshomeschoolevents.org.  Help, please!  Thanks.")*

I see that the address at this point is [ secure.authorize.net/gateway/transact.dll](https://secure.authorize.net/gateway/transact.dll), so I guess it is authorize.net, or maybe I don't have some of my settings in my Authorize.net plugin right to make them happy. I'll contact their support and see if they can help me work it out.

The following user(s) said Thank You: [Jerome](/forum/user/80-jerome "View Jerome's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MjUxMi0xMDY0LXNxbC1zeW50YXgtZXJyb3I/dG1wbD1tYXJrZG93bg==) 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.074 seconds

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