[Skip to main content](#vessel-content) # Profile for southpaw3229 ## [![southpaw3229's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") **[ Offline](/forum/user/32732-southpaw3229)** - **User Type:** User - **Register Date:** 22 May 2014 - **Last login:** 9 years 11 months ago - **Time Zone:** UTC +0:00 - **Local Time:** 19:02 - **Posts:** 11 - **Profile views:** 61 - **Gender:** Unknown - **Birthdate:** Unknown - Posts # southpaw3229's recent posts (11 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/872812-mysql-error-after-updating-from-essentials-to-bus#178572) | [MYSQL Error after updating from Essentials to Bus](/forum/25-install-update/872812-mysql-error-after-updating-from-essentials-to-bus#178572 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Firefox 33.0.2 -- Error-message(debug-mod must be tuned on) -- : 1253 COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name COLLATE utf8_general_ci,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM leca0_hikashop_order AS b LEFT JOIN leca0_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN leca0_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN leca0_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 30 I am getting the MYSQL error after upgrading from Essentials to Business on the ORDERS Page. The Orders page worked fine before on Essnetials. If i re-install essentials I can get the Orders page to work, but I purchased the Business version upgrade and need it for email settings and such. Thanks 1253 COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name COLLATE utf8_general_ci,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM leca0_hikashop_order AS b LEFT JOIN leca0_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN leca0_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN leca0_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 30") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 11 years 11 months ago, by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") [Last Post](/forum/25-install-update/872812-mysql-error-after-updating-from-essentials-to-bus#180128 "Hi, just fixed it by reloading the original file and for some reason it works now. Very strange....") 11 years 11 months ago by [Rokell](/forum/user/32710-rokell "View Rokell's Profile") | Replies:5 Views:951 | [Last Post](/forum/25-install-update/872812-mysql-error-after-updating-from-essentials-to-bus#180128 "Hi, just fixed it by reloading the original file and for some reason it works now. Very strange....") by [Rokell](/forum/user/32710-rokell "View Rokell's Profile") 11 years 11 months ago | | [](/forum/25-install-update/872812-mysql-error-after-updating-from-essentials-to-bus#178366) | [MYSQL Error after updating from Essentials to Bus](/forum/25-install-update/872812-mysql-error-after-updating-from-essentials-to-bus#178366 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Firefox 33.0.2 -- Error-message(debug-mod must be tuned on) -- : 1253 COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name COLLATE utf8_general_ci,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM leca0_hikashop_order AS b LEFT JOIN leca0_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN leca0_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN leca0_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 30 I am getting the MYSQL error after upgrading from Essentials to Business on the ORDERS Page. The Orders page worked fine before on Essnetials. If i re-install essentials I can get the Orders page to work, but I purchased the Business version upgrade and need it for email settings and such. Thanks 1253 COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name COLLATE utf8_general_ci,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM leca0_hikashop_order AS b LEFT JOIN leca0_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN leca0_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN leca0_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 30") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 11 years 11 months ago, by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") [Last Post](/forum/25-install-update/872812-mysql-error-after-updating-from-essentials-to-bus#180128 "Hi, just fixed it by reloading the original file and for some reason it works now. Very strange....") 11 years 11 months ago by [Rokell](/forum/user/32710-rokell "View Rokell's Profile") | Replies:5 Views:951 | [Last Post](/forum/25-install-update/872812-mysql-error-after-updating-from-essentials-to-bus#180128 "Hi, just fixed it by reloading the original file and for some reason it works now. Very strange....") by [Rokell](/forum/user/32710-rokell "View Rokell's Profile") 11 years 11 months ago | | [](/forum/29-payment-methods/872789-authorize-net-question#178361) | [Authorize.net question](/forum/29-payment-methods/872789-authorize-net-question#178361 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Firefox 33.0.2 I am using Authorize.net and right now when i check out it automatically sends the customer a created and or confirmed order email. I don't want this to go out until they've actually paid via authorize.net. What prevents someone from bringing in the email and saying they want the product but they never paid. Thanks") Category: [Payment Methods](/forum/29-payment-methods "Discussions about the different payment methods for Hikashop") Topic started 11 years 11 months ago, by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") [Last Post](/forum/29-payment-methods/872789-authorize-net-question#178361 "I figured out i had to check YES on the Authorize.net plugin to send payment email. Thanks") 11 years 11 months ago by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") | Replies:2 Views:520 | [Last Post](/forum/29-payment-methods/872789-authorize-net-question#178361 "I figured out i had to check YES on the Authorize.net plugin to send payment email. Thanks") by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") 11 years 11 months ago | | [](/forum/35-orders-management/872785-getting-admin-emails-but-no-emails-to-customers#178359) | [Getting Admin emails but No emails to customers](/forum/35-orders-management/872785-getting-admin-emails-but-no-emails-to-customers#178359 "-- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Firefox 33.0.2 As the admin I am getting the admin confirmation email when the order is placed, but the customer is not getting a order confirmation email. I have tested by Joomla email settings and I am able to send messages via joomla. Here is a screen shot of my config.") Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management") Topic started 11 years 11 months ago, by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") [Last Post](/forum/35-orders-management/872785-getting-admin-emails-but-no-emails-to-customers#178359 "I upgraded to Business so I now see the email config area. Thanks") 11 years 11 months ago by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") | Replies:2 Views:827 | [Last Post](/forum/35-orders-management/872785-getting-admin-emails-but-no-emails-to-customers#178359 "I upgraded to Business so I now see the email config area. Thanks") by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") 11 years 11 months ago | | [](/forum/25-install-update/872661-get-a-loop-in-the-checkout-error#178354) | [Get a loop in the checkout - error](/forum/25-install-update/872661-get-a-loop-in-the-checkout-error#178354 "-- url of the page with the problem -- : productosnuevaera.com/ -- HikaShop version -- : 2.3.3 -- Joomla version -- : 2.5.24 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome 38.0.2125.111 m I just upgraded to the new version but I get a loop when the checkout is done. So I had to go back to version 2.3.3 Business. Also lost an amendment on the bill and the cart, he had done so the subtotal is displayed without the tax and add the discount before tax, now the codes do not work and give error.") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 11 years 11 months ago, by [nuevaera](/forum/user/31146-nuevaera "View nuevaera's Profile") [Last Post](/forum/25-install-update/872661-get-a-loop-in-the-checkout-error#178407 "Hi, @southpaw3229 Depending your Joomla configuration, the user creation might require a email validation. At this moment it's not possible to login the user because it has not been activated. HikaShop read the Joomla configuration in order to know if he can (or not) login the user otherwise it will try to login ; but it is possible that the login made by HikaShop fails (but I don't know what could be the reasons exactly ; I just know that we call the Joomla login function so we can't be sure with the rest of plugins, etc). @nuevaera The system plugin "hikashop registration" which redirect the Joomla registration page to the HikaShop one got some errors that should be all fixed now. We updated the package so you can re-download HikaShop 2.3.4 to get the modifications. Regards,") 11 years 11 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:10 Views:1026 | [Last Post](/forum/25-install-update/872661-get-a-loop-in-the-checkout-error#178407 "Hi, @southpaw3229 Depending your Joomla configuration, the user creation might require a email validation. At this moment it's not possible to login the user because it has not been activated. HikaShop read the Joomla configuration in order to know if he can (or not) login the user otherwise it will try to login ; but it is possible that the login made by HikaShop fails (but I don't know what could be the reasons exactly ; I just know that we call the Joomla login function so we can't be sure with the rest of plugins, etc). @nuevaera The system plugin "hikashop registration" which redirect the Joomla registration page to the HikaShop one got some errors that should be all fixed now. We updated the package so you can re-download HikaShop 2.3.4 to get the modifications. Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 11 years 11 months ago | | [](/forum/25-install-update/872661-get-a-loop-in-the-checkout-error#178353) | [Get a loop in the checkout - error](/forum/25-install-update/872661-get-a-loop-in-the-checkout-error#178353 "-- url of the page with the problem -- : productosnuevaera.com/ -- HikaShop version -- : 2.3.3 -- Joomla version -- : 2.5.24 -- PHP version -- : 5.4.32 -- Browser(s) name and version -- : Chrome 38.0.2125.111 m I just upgraded to the new version but I get a loop when the checkout is done. So I had to go back to version 2.3.3 Business. Also lost an amendment on the bill and the cart, he had done so the subtotal is displayed without the tax and add the discount before tax, now the codes do not work and give error.") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 11 years 11 months ago, by [nuevaera](/forum/user/31146-nuevaera "View nuevaera's Profile") [Last Post](/forum/25-install-update/872661-get-a-loop-in-the-checkout-error#178407 "Hi, @southpaw3229 Depending your Joomla configuration, the user creation might require a email validation. At this moment it's not possible to login the user because it has not been activated. HikaShop read the Joomla configuration in order to know if he can (or not) login the user otherwise it will try to login ; but it is possible that the login made by HikaShop fails (but I don't know what could be the reasons exactly ; I just know that we call the Joomla login function so we can't be sure with the rest of plugins, etc). @nuevaera The system plugin "hikashop registration" which redirect the Joomla registration page to the HikaShop one got some errors that should be all fixed now. We updated the package so you can re-download HikaShop 2.3.4 to get the modifications. Regards,") 11 years 11 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:10 Views:1026 | [Last Post](/forum/25-install-update/872661-get-a-loop-in-the-checkout-error#178407 "Hi, @southpaw3229 Depending your Joomla configuration, the user creation might require a email validation. At this moment it's not possible to login the user because it has not been activated. HikaShop read the Joomla configuration in order to know if he can (or not) login the user otherwise it will try to login ; but it is possible that the login made by HikaShop fails (but I don't know what could be the reasons exactly ; I just know that we call the Joomla login function so we can't be sure with the rest of plugins, etc). @nuevaera The system plugin "hikashop registration" which redirect the Joomla registration page to the HikaShop one got some errors that should be all fixed now. We updated the package so you can re-download HikaShop 2.3.4 to get the modifications. Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 11 years 11 months ago | | [](/forum/25-install-update/872812-mysql-error-after-updating-from-essentials-to-bus#178349) | [MYSQL Error after updating from Essentials to Bus](/forum/25-install-update/872812-mysql-error-after-updating-from-essentials-to-bus#178349 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Firefox 33.0.2 -- Error-message(debug-mod must be tuned on) -- : 1253 COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name COLLATE utf8_general_ci,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM leca0_hikashop_order AS b LEFT JOIN leca0_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN leca0_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN leca0_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 30 I am getting the MYSQL error after upgrading from Essentials to Business on the ORDERS Page. The Orders page worked fine before on Essnetials. If i re-install essentials I can get the Orders page to work, but I purchased the Business version upgrade and need it for email settings and such. Thanks 1253 COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name COLLATE utf8_general_ci,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM leca0_hikashop_order AS b LEFT JOIN leca0_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN leca0_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN leca0_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 30") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 11 years 11 months ago, by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") [Last Post](/forum/25-install-update/872812-mysql-error-after-updating-from-essentials-to-bus#180128 "Hi, just fixed it by reloading the original file and for some reason it works now. Very strange....") 11 years 11 months ago by [Rokell](/forum/user/32710-rokell "View Rokell's Profile") | Replies:5 Views:951 | [Last Post](/forum/25-install-update/872812-mysql-error-after-updating-from-essentials-to-bus#180128 "Hi, just fixed it by reloading the original file and for some reason it works now. Very strange....") by [Rokell](/forum/user/32710-rokell "View Rokell's Profile") 11 years 11 months ago | | [](/forum/29-payment-methods/872789-authorize-net-question#178197) | [Authorize.net question](/forum/29-payment-methods/872789-authorize-net-question#178197 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Firefox 33.0.2 I am using Authorize.net and right now when i check out it automatically sends the customer a created and or confirmed order email. I don't want this to go out until they've actually paid via authorize.net. What prevents someone from bringing in the email and saying they want the product but they never paid. Thanks") Category: [Payment Methods](/forum/29-payment-methods "Discussions about the different payment methods for Hikashop") Topic started 11 years 11 months ago, by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") [Last Post](/forum/29-payment-methods/872789-authorize-net-question#178361 "I figured out i had to check YES on the Authorize.net plugin to send payment email. Thanks") 11 years 11 months ago by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") | Replies:2 Views:520 | [Last Post](/forum/29-payment-methods/872789-authorize-net-question#178361 "I figured out i had to check YES on the Authorize.net plugin to send payment email. Thanks") by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") 11 years 11 months ago | | [](/forum/35-orders-management/872785-getting-admin-emails-but-no-emails-to-customers#178159) | [Getting Admin emails but No emails to customers](/forum/35-orders-management/872785-getting-admin-emails-but-no-emails-to-customers#178159 "-- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.1.1 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Firefox 33.0.2 As the admin I am getting the admin confirmation email when the order is placed, but the customer is not getting a order confirmation email. I have tested by Joomla email settings and I am able to send messages via joomla. Here is a screen shot of my config.") Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management") Topic started 11 years 11 months ago, by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") [Last Post](/forum/35-orders-management/872785-getting-admin-emails-but-no-emails-to-customers#178359 "I upgraded to Business so I now see the email config area. Thanks") 11 years 11 months ago by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") | Replies:2 Views:827 | [Last Post](/forum/35-orders-management/872785-getting-admin-emails-but-no-emails-to-customers#178359 "I upgraded to Business so I now see the email config area. Thanks") by [southpaw3229](/forum/user/32732-southpaw3229 "View southpaw3229's Profile") 11 years 11 months ago | | [](/forum/27-checkout/872491-checkout-message#176535) | [Checkout message](/forum/27-checkout/872491-checkout-message#176535 "-- HikaShop version -- : HikaShop Business 2.3.4 -- Joomla version -- : 3.3 -- PHP version -- : 5.3.29 -- Browser(s) name and version -- : Firefox 32 Hello When I try to checkout, I get following message: "You cannot proceed to a guest checkout as some of the products in your cart require a registration to our website. Please register an account or remove these products from your cart in order to proceed." I can't figure out why this message appear. Can you help?") Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop") Topic started 12 years 5 days ago, by [mediasprint](/forum/user/34636-mediasprint "View mediasprint's Profile") [Last Post](/forum/27-checkout/872491-checkout-message#176581 "Thanks, it works now.") 12 years 4 days ago by [mediasprint](/forum/user/34636-mediasprint "View mediasprint's Profile") | Replies:4 Views:1366 | [Last Post](/forum/27-checkout/872491-checkout-message#176581 "Thanks, it works now.") by [mediasprint](/forum/user/34636-mediasprint "View mediasprint's Profile") 12 years 4 days ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.136 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)