- Posts: 7
- Thank you received: 0
Billing Address not saving
- mnemonicimage
-
Topic Author
- Offline
Less
More
14 years 2 months ago #57693
by mnemonicimage
Billing Address not saving was created by mnemonicimage
I have an order placed. I go to fill out the billing address because it is asking for it twice in my notify areas. The popup opens, I fill out the form, I hit save and the popup fades away as if it took it then stays open with the billing address form still there. I close the popup and the billing address is not filled out and the new billing address button is still there. It will not save my billing address.
Please Log in or Create an account to join the conversation.
- mnemonicimage
-
Topic Author
- Offline
Less
More
- Posts: 7
- Thank you received: 0
14 years 2 months ago #57694
by mnemonicimage
Replied by mnemonicimage on topic Re: Billing Address not saving
I turned on debug and received this when trying to save the billing address in the popup window
Error: 500 - JDatabaseMySQLi::query: 1054 - Unknown column 'address_user_id' in 'where clause' SQL=SELECT count(*) as cpt FROM actst_hikashop_address WHERE address_user_id = 1 AND address_published = 1 AND address_default = 1
Error: 500 - JDatabaseMySQLi::query: 1054 - Unknown column 'address_user_id' in 'where clause' SQL=SELECT count(*) as cpt FROM actst_hikashop_address WHERE address_user_id = 1 AND address_published = 1 AND address_default = 1
Please Log in or Create an account to join the conversation.
- mnemonicimage
-
Topic Author
- Offline
Less
More
- Posts: 7
- Thank you received: 0
14 years 2 months ago #57695
by mnemonicimage
Replied by mnemonicimage on topic Re: Billing Address not saving
I found a bit more that might help resolve this issue.
atabaseMySQLi::query: 1054 - Unknown column 'a.address_user_id' in 'where clause' SQL=SELECT a.* FROM actst_hikashop_address AS a WHERE a.address_user_id=1 and a.address_published=1 ORDER BY a.address_default DESC, a.address_id DESC
Call stack
# Function Location
1 JSite->dispatch() JROOT/index.php:42
2 JComponentHelper::renderComponent() JROOT/includes/application.php:197
3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351
4 require_once() JROOT/libraries/joomla/application/component/helper.php:383
5 JController->execute() JROOT/components/com_hikashop/hikashop.php:53
6 checkoutController->step() JROOT/libraries/joomla/application/component/controller.php:760
7 checkoutController->display() JROOT/components/com_hikashop/controllers/checkout.php:170
8 hikashopController->display() JROOT/components/com_hikashop/controllers/checkout.php:1321
9 JController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1041
10 CheckoutViewCheckout->display() JROOT/libraries/joomla/application/component/controller.php:721
11 CheckoutViewCheckout->step() JROOT/components/com_hikashop/views/checkout/view.html.php:29
12 CheckoutViewCheckout->address() JROOT/components/com_hikashop/views/checkout/view.html.php:73
13 hikashopAddressClass->loadUserAddresses() JROOT/components/com_hikashop/views/checkout/view.html.php:323
14 JDatabase->loadObjectList() JROOT/administrator/components/com_hikashop/classes/address.php:70
15 JDatabaseMySQLi->execute() JROOT/libraries/joomla/database/database.php:1100
16 JError::raiseError() JROOT/libraries/joomla/database/database/mysqli.php:396
17 JError::raise() JROOT/libraries/joomla/error/error.php:251
atabaseMySQLi::query: 1054 - Unknown column 'a.address_user_id' in 'where clause' SQL=SELECT a.* FROM actst_hikashop_address AS a WHERE a.address_user_id=1 and a.address_published=1 ORDER BY a.address_default DESC, a.address_id DESC
Call stack
# Function Location
1 JSite->dispatch() JROOT/index.php:42
2 JComponentHelper::renderComponent() JROOT/includes/application.php:197
3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351
4 require_once() JROOT/libraries/joomla/application/component/helper.php:383
5 JController->execute() JROOT/components/com_hikashop/hikashop.php:53
6 checkoutController->step() JROOT/libraries/joomla/application/component/controller.php:760
7 checkoutController->display() JROOT/components/com_hikashop/controllers/checkout.php:170
8 hikashopController->display() JROOT/components/com_hikashop/controllers/checkout.php:1321
9 JController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1041
10 CheckoutViewCheckout->display() JROOT/libraries/joomla/application/component/controller.php:721
11 CheckoutViewCheckout->step() JROOT/components/com_hikashop/views/checkout/view.html.php:29
12 CheckoutViewCheckout->address() JROOT/components/com_hikashop/views/checkout/view.html.php:73
13 hikashopAddressClass->loadUserAddresses() JROOT/components/com_hikashop/views/checkout/view.html.php:323
14 JDatabase->loadObjectList() JROOT/administrator/components/com_hikashop/classes/address.php:70
15 JDatabaseMySQLi->execute() JROOT/libraries/joomla/database/database.php:1100
16 JError::raiseError() JROOT/libraries/joomla/database/database/mysqli.php:396
17 JError::raise() JROOT/libraries/joomla/error/error.php:251
Please Log in or Create an account to join the conversation.
- mnemonicimage
-
Topic Author
- Offline
Less
More
- Posts: 7
- Thank you received: 0
14 years 2 months ago #57696
by mnemonicimage
Replied by mnemonicimage on topic Re: Billing Address not saving
I also received this when I tried to add a product to the cart.
Error: 500 - JDatabaseMySQLi::query: 1054 - Unknown column 'address_published' in 'where clause' SQL=SELECT address_id FROM actst_hikashop_address WHERE address_published=1 AND address_user_id=1
Error: 500 - JDatabaseMySQLi::query: 1054 - Unknown column 'address_published' in 'where clause' SQL=SELECT address_id FROM actst_hikashop_address WHERE address_published=1 AND address_user_id=1
Please Log in or Create an account to join the conversation.
- mnemonicimage
-
Topic Author
- Offline
Less
More
- Posts: 7
- Thank you received: 0
14 years 2 months ago #57699
by mnemonicimage
Replied by mnemonicimage on topic Re: Billing Address not saving
Forget about this. I needed to switch the virtual server to my new fresh installed site's folder. Sorry about that.
Please Log in or Create an account to join the conversation.
Time to create page: 0.201 seconds