[Skip to main content](#vessel-content) # Profile for inform ## [![inform's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31595-inform "View inform's Profile") **[ Offline](/forum/user/31595-inform)** - **User Type:** User - **Register Date:** 10 Mar 2014 - **Last login:** 10 years 3 months ago - **Time Zone:** UTC +0:00 - **Local Time:** 16:06 - **Posts:** 15 - **Profile views:** 34 - **Gender:** Unknown - **Birthdate:** Unknown - Posts # inform's recent posts (15 messages ) All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year | [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) | |---|---|---|---|---| | [](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#225636) | [SQL Syntax Error in "State" Field After Updating](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#225636 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.7 -- PHP version -- : 5.4.43 -- Browser(s) name and version -- : Chrome 47.0.2526.106 (64-bit) -- Error-message(debug-mod must be tuned on) -- : After updating Joomla and Hikashop Business to the latest versions, we're now getting an error. On the checkout page only under the "State" field I'm getting the following 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 'FROM jml_menu WHERE = '1' AND = 'component' AND LIKE '%=%' AND LIKE ' at line 1 SQL=SELECT FROM jml_menu WHERE = '1' AND = 'component' AND LIKE '%=%' AND LIKE '%=%' LIMIT 1") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 10 years 10 months ago, by [inform](/forum/user/31595-inform "View inform's Profile") [Last Post](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#225636 "Thank you very much for your assistance with this problem. I've disabled the "jvfixitemid" plugin and it has solved the problem. Looks like this is a plugin that comes packed with the Extended...") 10 years 9 months ago by [inform](/forum/user/31595-inform "View inform's Profile") | Replies:7 Views:463 | [Last Post](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#225636 "Thank you very much for your assistance with this problem. I've disabled the "jvfixitemid" plugin and it has solved the problem. Looks like this is a plugin that comes packed with the Extended...") by [inform](/forum/user/31595-inform "View inform's Profile") 10 years 9 months ago | | [](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#225555) | [SQL Syntax Error in "State" Field After Updating](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#225555 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.7 -- PHP version -- : 5.4.43 -- Browser(s) name and version -- : Chrome 47.0.2526.106 (64-bit) -- Error-message(debug-mod must be tuned on) -- : After updating Joomla and Hikashop Business to the latest versions, we're now getting an error. On the checkout page only under the "State" field I'm getting the following 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 'FROM jml_menu WHERE = '1' AND = 'component' AND LIKE '%=%' AND LIKE ' at line 1 SQL=SELECT FROM jml_menu WHERE = '1' AND = 'component' AND LIKE '%=%' AND LIKE '%=%' LIMIT 1") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 10 years 10 months ago, by [inform](/forum/user/31595-inform "View inform's Profile") [Last Post](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#225636 "Thank you very much for your assistance with this problem. I've disabled the "jvfixitemid" plugin and it has solved the problem. Looks like this is a plugin that comes packed with the Extended...") 10 years 9 months ago by [inform](/forum/user/31595-inform "View inform's Profile") | Replies:7 Views:463 | [Last Post](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#225636 "Thank you very much for your assistance with this problem. I've disabled the "jvfixitemid" plugin and it has solved the problem. Looks like this is a plugin that comes packed with the Extended...") by [inform](/forum/user/31595-inform "View inform's Profile") 10 years 9 months ago | | [](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#225012) | [SQL Syntax Error in "State" Field After Updating](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#225012 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.7 -- PHP version -- : 5.4.43 -- Browser(s) name and version -- : Chrome 47.0.2526.106 (64-bit) -- Error-message(debug-mod must be tuned on) -- : After updating Joomla and Hikashop Business to the latest versions, we're now getting an error. On the checkout page only under the "State" field I'm getting the following 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 'FROM jml_menu WHERE = '1' AND = 'component' AND LIKE '%=%' AND LIKE ' at line 1 SQL=SELECT FROM jml_menu WHERE = '1' AND = 'component' AND LIKE '%=%' AND LIKE '%=%' LIMIT 1") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 10 years 10 months ago, by [inform](/forum/user/31595-inform "View inform's Profile") [Last Post](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#225636 "Thank you very much for your assistance with this problem. I've disabled the "jvfixitemid" plugin and it has solved the problem. Looks like this is a plugin that comes packed with the Extended...") 10 years 9 months ago by [inform](/forum/user/31595-inform "View inform's Profile") | Replies:7 Views:463 | [Last Post](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#225636 "Thank you very much for your assistance with this problem. I've disabled the "jvfixitemid" plugin and it has solved the problem. Looks like this is a plugin that comes packed with the Extended...") by [inform](/forum/user/31595-inform "View inform's Profile") 10 years 9 months ago | | [](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#224899) | [SQL Syntax Error in "State" Field After Updating](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#224899 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.7 -- PHP version -- : 5.4.43 -- Browser(s) name and version -- : Chrome 47.0.2526.106 (64-bit) -- Error-message(debug-mod must be tuned on) -- : After updating Joomla and Hikashop Business to the latest versions, we're now getting an error. On the checkout page only under the "State" field I'm getting the following 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 'FROM jml_menu WHERE = '1' AND = 'component' AND LIKE '%=%' AND LIKE ' at line 1 SQL=SELECT FROM jml_menu WHERE = '1' AND = 'component' AND LIKE '%=%' AND LIKE '%=%' LIMIT 1") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 10 years 10 months ago, by [inform](/forum/user/31595-inform "View inform's Profile") [Last Post](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#225636 "Thank you very much for your assistance with this problem. I've disabled the "jvfixitemid" plugin and it has solved the problem. Looks like this is a plugin that comes packed with the Extended...") 10 years 9 months ago by [inform](/forum/user/31595-inform "View inform's Profile") | Replies:7 Views:463 | [Last Post](/forum/25-install-update/881235-sql-syntax-error-in-state-field-after-updating#225636 "Thank you very much for your assistance with this problem. I've disabled the "jvfixitemid" plugin and it has solved the problem. Looks like this is a plugin that comes packed with the Extended...") by [inform](/forum/user/31595-inform "View inform's Profile") 10 years 9 months ago | | [](/forum/27-checkout/868200-checkout-not-processing-orders#155957) | [Checkout Not Processing Orders](/forum/27-checkout/868200-checkout-not-processing-orders#155957 "-- url of the page with the problem -- : XXX -- HikaShop version -- : HikaShop Essential: 2.3.0 -- Joomla version -- : 2.5.17 -- PHP version -- : 5.4 -- Browser(s) name and version -- : Chrome 34.0.1847.116 -- Error-message(debug-mod must be tuned on) -- : N/A We have two methods of ordering two separate products. One of these methods is through our "registered" users only area, and I'm having no problems with that process. User logs in, adds product to cart, and purchases. Order creation and notification e-mails are sent fine. They payment method is collect on delivery which we've modified to look like an invoice. The other method is available to the public and I've set it up as a guest checkout. The payment method is via credit card through payjunction. When you visit the URL above, click the "Sign Up Today" button and go through the checkout process, it hangs up at each step in the checkout. First after entering my billing address and click "Next" it goes to a strange page with no css (see attached). If I click the "Payment" link to move on to the next step I fill out my CC info, click the "Process Order" button, then I'm taken to a completely blank page. The credit card is charged, but there is no confirmation page and there are no confirmation or notification e-mails sent. We do receive a payjunction payment notification email however. If I refresh this blank page I'm kicked back out to the last step and if I try to enter my payment information again I'm told it is a duplicate transaction and denied. I'm confused as to why one of my checkout processes is working just fine and the other is not. Any help you can offer is greatly appreciated. Thanks! I'm using all of the test credit card and test payjunction information to try and do this. Here are the required fields for a credit card order if you want to try and test yourself: Address: 8320 Zip: 85284 Card Number: 4444333322221111 Exp: 01/15 CVC: 999") Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop") Topic started 12 years 5 months ago, by [inform](/forum/user/31595-inform "View inform's Profile") [Last Post](/forum/27-checkout/868200-checkout-not-processing-orders#155957 "I sincerely apologize, there was an error found in some PHP code that was inserted. Please disregard this post.") 12 years 5 months ago by [inform](/forum/user/31595-inform "View inform's Profile") | Replies:2 Views:428 | [Last Post](/forum/27-checkout/868200-checkout-not-processing-orders#155957 "I sincerely apologize, there was an error found in some PHP code that was inserted. Please disregard this post.") by [inform](/forum/user/31595-inform "View inform's Profile") 12 years 5 months ago | | [](/forum/27-checkout/868200-checkout-not-processing-orders#155944) | [Checkout Not Processing Orders](/forum/27-checkout/868200-checkout-not-processing-orders#155944 "-- url of the page with the problem -- : XXX -- HikaShop version -- : HikaShop Essential: 2.3.0 -- Joomla version -- : 2.5.17 -- PHP version -- : 5.4 -- Browser(s) name and version -- : Chrome 34.0.1847.116 -- Error-message(debug-mod must be tuned on) -- : N/A We have two methods of ordering two separate products. One of these methods is through our "registered" users only area, and I'm having no problems with that process. User logs in, adds product to cart, and purchases. Order creation and notification e-mails are sent fine. They payment method is collect on delivery which we've modified to look like an invoice. The other method is available to the public and I've set it up as a guest checkout. The payment method is via credit card through payjunction. When you visit the URL above, click the "Sign Up Today" button and go through the checkout process, it hangs up at each step in the checkout. First after entering my billing address and click "Next" it goes to a strange page with no css (see attached). If I click the "Payment" link to move on to the next step I fill out my CC info, click the "Process Order" button, then I'm taken to a completely blank page. The credit card is charged, but there is no confirmation page and there are no confirmation or notification e-mails sent. We do receive a payjunction payment notification email however. If I refresh this blank page I'm kicked back out to the last step and if I try to enter my payment information again I'm told it is a duplicate transaction and denied. I'm confused as to why one of my checkout processes is working just fine and the other is not. Any help you can offer is greatly appreciated. Thanks! I'm using all of the test credit card and test payjunction information to try and do this. Here are the required fields for a credit card order if you want to try and test yourself: Address: 8320 Zip: 85284 Card Number: 4444333322221111 Exp: 01/15 CVC: 999") Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop") Topic started 12 years 5 months ago, by [inform](/forum/user/31595-inform "View inform's Profile") [Last Post](/forum/27-checkout/868200-checkout-not-processing-orders#155957 "I sincerely apologize, there was an error found in some PHP code that was inserted. Please disregard this post.") 12 years 5 months ago by [inform](/forum/user/31595-inform "View inform's Profile") | Replies:2 Views:428 | [Last Post](/forum/27-checkout/868200-checkout-not-processing-orders#155957 "I sincerely apologize, there was an error found in some PHP code that was inserted. Please disregard this post.") by [inform](/forum/user/31595-inform "View inform's Profile") 12 years 5 months ago | | [](/forum/27-checkout/868200-checkout-not-processing-orders#155941) | [Checkout Not Processing Orders](/forum/27-checkout/868200-checkout-not-processing-orders#155941 "-- url of the page with the problem -- : XXX -- HikaShop version -- : HikaShop Essential: 2.3.0 -- Joomla version -- : 2.5.17 -- PHP version -- : 5.4 -- Browser(s) name and version -- : Chrome 34.0.1847.116 -- Error-message(debug-mod must be tuned on) -- : N/A We have two methods of ordering two separate products. One of these methods is through our "registered" users only area, and I'm having no problems with that process. User logs in, adds product to cart, and purchases. Order creation and notification e-mails are sent fine. They payment method is collect on delivery which we've modified to look like an invoice. The other method is available to the public and I've set it up as a guest checkout. The payment method is via credit card through payjunction. When you visit the URL above, click the "Sign Up Today" button and go through the checkout process, it hangs up at each step in the checkout. First after entering my billing address and click "Next" it goes to a strange page with no css (see attached). If I click the "Payment" link to move on to the next step I fill out my CC info, click the "Process Order" button, then I'm taken to a completely blank page. The credit card is charged, but there is no confirmation page and there are no confirmation or notification e-mails sent. We do receive a payjunction payment notification email however. If I refresh this blank page I'm kicked back out to the last step and if I try to enter my payment information again I'm told it is a duplicate transaction and denied. I'm confused as to why one of my checkout processes is working just fine and the other is not. Any help you can offer is greatly appreciated. Thanks! I'm using all of the test credit card and test payjunction information to try and do this. Here are the required fields for a credit card order if you want to try and test yourself: Address: 8320 Zip: 85284 Card Number: 4444333322221111 Exp: 01/15 CVC: 999") Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop") Topic started 12 years 5 months ago, by [inform](/forum/user/31595-inform "View inform's Profile") [Last Post](/forum/27-checkout/868200-checkout-not-processing-orders#155957 "I sincerely apologize, there was an error found in some PHP code that was inserted. Please disregard this post.") 12 years 5 months ago by [inform](/forum/user/31595-inform "View inform's Profile") | Replies:2 Views:428 | [Last Post](/forum/27-checkout/868200-checkout-not-processing-orders#155957 "I sincerely apologize, there was an error found in some PHP code that was inserted. Please disregard this post.") by [inform](/forum/user/31595-inform "View inform's Profile") 12 years 5 months ago | | [](/forum/35-orders-management/868089-order-dashboard-add-custom-field-as-a-column#155938) | [Order Dashboard - Add Custom Field as a Column](/forum/35-orders-management/868089-order-dashboard-add-custom-field-as-a-column#155938 "-- url of the page with the problem -- : N/A -- HikaShop version -- : HikaShop Essential: 2.3.0 -- Joomla version -- : 2.5.17 -- PHP version -- : 5.4 -- Browser(s) name and version -- : Chrome 34.0.1847.116 -- Error-message(debug-mod must be tuned on) -- : N/A I have a custom field that I'd like to be visible from the orders dashboard page in the backend. The reason is that I would like to be able to use the search field to filter by this custom field and find specific orders. How can I go about adding another column to this dashboard view? Thanks!") Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management") Topic started 12 years 5 months ago, by [inform](/forum/user/31595-inform "View inform's Profile") [Last Post](/forum/35-orders-management/868089-order-dashboard-add-custom-field-as-a-column#155938 "Okay, give me some time and I'll get this to you.") 12 years 5 months ago by [inform](/forum/user/31595-inform "View inform's Profile") | Replies:7 Views:591 | [Last Post](/forum/35-orders-management/868089-order-dashboard-add-custom-field-as-a-column#155938 "Okay, give me some time and I'll get this to you.") by [inform](/forum/user/31595-inform "View inform's Profile") 12 years 5 months ago | | [](/forum/35-orders-management/868089-order-dashboard-add-custom-field-as-a-column#155772) | [Order Dashboard - Add Custom Field as a Column](/forum/35-orders-management/868089-order-dashboard-add-custom-field-as-a-column#155772 "-- url of the page with the problem -- : N/A -- HikaShop version -- : HikaShop Essential: 2.3.0 -- Joomla version -- : 2.5.17 -- PHP version -- : 5.4 -- Browser(s) name and version -- : Chrome 34.0.1847.116 -- Error-message(debug-mod must be tuned on) -- : N/A I have a custom field that I'd like to be visible from the orders dashboard page in the backend. The reason is that I would like to be able to use the search field to filter by this custom field and find specific orders. How can I go about adding another column to this dashboard view? Thanks!") Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management") Topic started 12 years 5 months ago, by [inform](/forum/user/31595-inform "View inform's Profile") [Last Post](/forum/35-orders-management/868089-order-dashboard-add-custom-field-as-a-column#155938 "Okay, give me some time and I'll get this to you.") 12 years 5 months ago by [inform](/forum/user/31595-inform "View inform's Profile") | Replies:7 Views:591 | [Last Post](/forum/35-orders-management/868089-order-dashboard-add-custom-field-as-a-column#155938 "Okay, give me some time and I'll get this to you.") by [inform](/forum/user/31595-inform "View inform's Profile") 12 years 5 months ago | | [](/forum/35-orders-management/868089-order-dashboard-add-custom-field-as-a-column#155607) | [Order Dashboard - Add Custom Field as a Column](/forum/35-orders-management/868089-order-dashboard-add-custom-field-as-a-column#155607 "-- url of the page with the problem -- : N/A -- HikaShop version -- : HikaShop Essential: 2.3.0 -- Joomla version -- : 2.5.17 -- PHP version -- : 5.4 -- Browser(s) name and version -- : Chrome 34.0.1847.116 -- Error-message(debug-mod must be tuned on) -- : N/A I have a custom field that I'd like to be visible from the orders dashboard page in the backend. The reason is that I would like to be able to use the search field to filter by this custom field and find specific orders. How can I go about adding another column to this dashboard view? Thanks!") Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management") Topic started 12 years 5 months ago, by [inform](/forum/user/31595-inform "View inform's Profile") [Last Post](/forum/35-orders-management/868089-order-dashboard-add-custom-field-as-a-column#155938 "Okay, give me some time and I'll get this to you.") 12 years 5 months ago by [inform](/forum/user/31595-inform "View inform's Profile") | Replies:7 Views:591 | [Last Post](/forum/35-orders-management/868089-order-dashboard-add-custom-field-as-a-column#155938 "Okay, give me some time and I'll get this to you.") by [inform](/forum/user/31595-inform "View inform's Profile") 12 years 5 months ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.128 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)