Jump to content

"County" error


Michal Kubacki

Recommended Posts

Hi, I keep receiving:

"The following errors were detected:

We seem to have a problem with your address ("Billing Address"). Please check the value for "County" before proceeding."

image.png.e9a6eaca30fce704ed881e88644a7e81.png

I'm using All In One Shipping extension, it seems to be set up correctly because it gives the right shipping options in accordance with the address - and there seems to be no problem with the address format. However, when trying to finish the transaction, the above error appears. I have no idea which element of the store triggers the error - is it the payment module, or anything else?

I'm UK based, the shop language is English UK.

Thanks in advance for your help.

 

Link to comment
Share on other sites

Welcome Michal Kubacki! Glad to see you made it to the forums.

When you received that error banner, you should have been taken to a screen for the customer to edit their address:
?_a=addressbook&action=edit&address_id=9 (or some number)

CubeCart wants to create an array of all possible state/county and country terms that will be used by other processes (shipping, payment, etc). This happens at User->formatAddress().

This error is triggered when the state/county cannot be found in the CubeCart_geo_zone database table. In CubeCart's admin, Countries/Zones, Zones tab, page down to the country section where the suspect address is located, then look for the correct spelling of the County.

  • Thanks 1
Link to comment
Share on other sites

Hi Bsmither! Thank you for your quick reply.

I have checked that already and it looks like it's all correct. I have used all the predefined values while adding zones and also while creating the address I used a drop-down option.

Please see the screenshots below, first is from my CubeCart control panel, second if from the failed transaction.

What could be the issue? Please let me know if you need more information.

 

MK

 

image.png.c1a3aef3df32a7b7feed741401cfda32.png

 

image.png.c804e34b10f387878a53a637e224e564.png

Edited by Michal Kubacki
Link to comment
Share on other sites

Hover your mouse over the Edit button. Your browser will show the URL that will be sent when clicked. Note the address_id value.

Back at the admin list of Zones, hover your mouse cursor over the Delete icon for 'Greater London'. Note the id value (maybe 469?).

Using an external database utility, look in CubeCart_addressbook. Find the record that has that value as the address_id.

Compare the database addressbook record 'state' column value with the 'Greater London' id value.

They should match.

One one point long ago in time, the 'state' column held the actual name of the state/county/province. That column still can hold actual names, but CubeCart now uses ID numbers.

 

  • Thanks 1
Link to comment
Share on other sites

I'm very grateful for your help. I'm not sure I understand you correctly.

I'm hovering here at the point of the error over the Edit button:

image.thumb.png.4023ef67f0b68aabb107690e6e7b9aa6.png

I get the address_id=1 but I think it relates to my address stored with all my customer details.

This is by hovering over Delete in my admin panel, as you suggested it is 469:

image.thumb.png.1397ae9173f8e36fa2c73b415393cabb.png

Now you are loosing me at the next point. Where should I go? I've used automatic installation provided with my hosting, I'm not feeling very confident playing with the files on the server.

Since I get the error message, I assume that the values are not correct. What should I do to fix it? Is there a patch to be installed? Something need to be deleted/reinstalled?

 

 

Link to comment
Share on other sites

We need to keep looking at where the code finds certain data objectionable.

You have an address_id of "1".

I would like for you to use an external database manager. If you are being hosted, you probably have a hosted account control panel (Cpanel, maybe?). One of the tools provided in your control panel is phpMyAdmin. Using this, you can look at the database directly.

Once you have phpMyAdmin showing you your database follow my instructions earlier.

  • Thanks 1
Link to comment
Share on other sites

OK, looks like I got myself in big trouble. I found the tools but I did not know the previous password for the database, so I changed it from the hosting panel. Now the whole thing is completely messed up, the shop panel is gone.

Yes, I have the access to the database from phpMyAdmin, but don't have the access to the shop and to the admin panel anymore. Is there any way to fix it from the database level?

the bit you asked about looks like that:

image.thumb.png.255f2cc87624ab4d91dcb80d2094b348.png

 

As I said, I had no previous experience in that and I did not feel very confident in getting into database. Please tell me is there a way to fix the shop?

And, in case it can be fixed, what should I do then to fix the address issue?

Link to comment
Share on other sites

Here is what I would like for you to do next:

In admin, Store Settings, Advanced tab, enable Debugging. Then, also add your IP address (www.whatismyip.com) in the adjacent field. Save.

On the storefront, bring that troublesome address up for editing. Because this can be done, I conclude there is a customer logged in? The customer with 'customer_id' of "1"?

When the web page comes up, presumably with the error message, at the bottom will be a list of SQL queries. Look for any that start with "SELECT CubeCart_addressbook". What is the complete query or queries?

Link to comment
Share on other sites

OK, I disabled the caching, now it worked (without IP). This is the message at the end:

PHP:
[Warning] /var/sites/t/tuborg-batteries.co.uk/public_html/classes/session.class.php:647 - is_writeable() [function.is-writeable.php]: Unable to find the wrapper "tcp" - did you forget to enable it when you configured PHP?[Notice] /var/sites/t/tuborg-batteries.co.uk/public_html/includes/functions.inc.php:527 - Undefined index: X-Forwarded-For[Notice] /var/sites/t/tuborg-batteries.co.uk/public_html/classes/tax.class.php:212 - Undefined variable: tax_table


GET:

'Before Sanitise:' =>
'_a' => addressbook
'After Sanitise:' =>
'_a' => addressbook

SESSION:

'__client' =>
'ip_address' => 92.8.39.172
'useragent' => Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36
'session_start' => 1515539360
'session_last' => 1515539360
'language' => en-GB
'user_language' => en-GB
'__system' =>
'token' => 1ec3e4819dc3dacf9d6314b5ad221ca2
'__basket' =>
'contents' =>
'ec7b1f33c55ea117a22786a01192a8ae' =>
'id' => 52
'quantity' => 1
'digital' => 0
'option_line_price' => 0
'total_price_each' => 1.00
'description' => test product
'name' => test
'product_code' => test
'product_weight' => 1
'tax_each' =>
'weight' => 1.0000
'discount' => 0.00
'subtotal' => 1.00
'total_tax' => 0.00
'total' => 1.00
'delivery_address' =>
'address_id' => 1
'customer_id' => 1
'billing' => 1
'default' => 1
'description' => Billing/Delivery Address
'title' =>
'first_name' => xxx
'last_name' => xxx
'company_name' =>
'line1' => xxx
'line2' =>
'town' => London
'state' => Greater London
'postcode' => xxx
'country' => United Kingdom
'hash' => 0158ae6e371460d2f502ac50e9ca2998
'state_id' => 469
'country_id' => 826
'state_abbrev' => GTL
'country_iso' => GB
'country_iso3' => GBR
'user_defined' => 1
'estimate' =>
'billing_address' =>
'address_id' => 1
'customer_id' => 1
'billing' => 1
'default' => 1
'description' => Billing/Delivery Address
'title' =>
'first_name' => Michal
'last_name' => Kubacki
'company_name' =>
'line1' => 109 Weavers Way
'line2' =>
'town' => London
'state' => Greater London
'postcode' => NW1 0XG
'country' => United Kingdom
'hash' => 0158ae6e371460d2f502ac50e9ca2998
'state_id' => 469
'country_id' => 826
'state_abbrev' => GTL
'country_iso' => GB
'country_iso3' => GBR
'user_defined' => 1
'estimate' =>
'shipping_hash' => 28cb11d21fd0cc4b5d0fd1ef49c4d499
'order_taxes' =>
'register' => 1
'confirm_addresses' => 1
'shipping' =>
'offset' => 1
'name' => All_In_One_Shipping
'product' => Free London delivery
'value' => 0.00
'tax_id' => 2
'tax' =>
'min_shipping_set' => 1
'__recaptcha' =>
'error' => The verification code was incorrect. Please try again.
'confirmed' =>
'__seo_retry' =>
'register' => 1

COOKIE:

'_ga' => GA1.3.216241595.1511373319
'__utma' => 158398655.216241595.1511373319.1515432814.1515432814.1
'__utmz' => 158398655.1515432814.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
'CC_F274D447FF' => a5b0b92e163bbeee99f4a95dfb3e34d3
'_gid' => GA1.3.1560404950.1515536626
'_gat' => 1

MySQLi
Queries (111):
[1] INSERT INTO `w5bl_CubeCart_system_error_log` (`message`,`time`) VALUES ('[Warning] /var/sites/t/tuborg-batteries.co.uk/public_html/classes/session.class.php:647 - is_writeable() [function.is-writeable.php]: Unable to find the wrapper "tcp" - did you forget to enable it when you configured PHP?','1515539360'); -- (0.00541710853577 sec) [ERROR - NOT CACHED]
[2] DELETE FROM `w5bl_CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY)) ; -- (0.00641894340515 sec) [NOT CACHED]
[3] INSERT INTO `w5bl_CubeCart_system_error_log` (`message`,`time`) VALUES ('[Notice] /var/sites/t/tuborg-batteries.co.uk/public_html/includes/functions.inc.php:527 - Undefined index: X-Forwarded-For','1515539360'); -- (0.00607180595398 sec) [ERROR - NOT CACHED]
[4] DELETE FROM `w5bl_CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY)) ; -- (0.00440812110901 sec) [NOT CACHED]
[5] SELECT SQL_CALC_FOUND_ROWS * FROM `w5bl_CubeCart_sessions` WHERE w5bl_CubeCart_sessions.session_id = 'a5b0b92e163bbeee99f4a95dfb3e34d3' LIMIT 1; -- (0.00528597831726 sec) [NOT CACHED]
[6] SELECT FOUND_ROWS() as Count; -- (0.00452208518982 sec) [NOT CACHED]
[7] SELECT * FROM `w5bl_CubeCart_lang_strings` WHERE w5bl_CubeCart_lang_strings.language = 'en-GB' ; -- (0.00821995735168 sec) [CACHE WRITE]
[8] SELECT * FROM `w5bl_CubeCart_hooks` WHERE w5bl_CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.101340055466 sec) [CACHE WRITE]
[9] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `w5bl_CubeCart_code_snippet` WHERE w5bl_CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.00683498382568 sec) [CACHE WRITE]
[10] SELECT C.cat_id, C.cat_name, C.cat_parent_id, S.path FROM `w5bl_CubeCart_category` as C LEFT JOIN `w5bl_CubeCart_seo_urls` as S ON S.item_id=C.cat_id AND S.type='cat' AND S.custom='1' ORDER BY C.cat_id DESC -- (0.00433492660522 sec) [CACHE WRITE]
[11] SELECT `cat_id`, `cat_name` FROM `w5bl_CubeCart_category_language` WHERE w5bl_CubeCart_category_language.language = 'en-GB' ; -- (0.0030460357666 sec) [CACHE WRITE]
[12] SELECT SQL_CALC_FOUND_ROWS `array` FROM `w5bl_CubeCart_config` WHERE w5bl_CubeCart_config.name = 'logos' LIMIT 1; -- (0.00480794906616 sec) [CACHE WRITE]
[13] SELECT FOUND_ROWS() as Count; -- (0.00580787658691 sec) [NOT CACHED]
[14] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `w5bl_CubeCart_modules` WHERE w5bl_CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.0026171207428 sec) [CACHE WRITE]
[15] SELECT `folder` FROM `w5bl_CubeCart_modules` WHERE w5bl_CubeCart_modules.module = 'livehelp' AND w5bl_CubeCart_modules.status = '1' ; -- (0.00462007522583 sec) [CACHE WRITE]
[16] SELECT * FROM `w5bl_CubeCart_currency` WHERE w5bl_CubeCart_currency.code = 'GBP' ; -- (0.00477814674377 sec) [CACHE WRITE]
[17] SELECT SQL_CALC_FOUND_ROWS * FROM `w5bl_CubeCart_customer` WHERE w5bl_CubeCart_customer.customer_id = '1' LIMIT 1; -- (0.00606107711792 sec) [CACHE WRITE]
[18] SELECT FOUND_ROWS() as Count; -- (0.00419688224792 sec) [NOT CACHED]
[19] SELECT * FROM `w5bl_CubeCart_addressbook` WHERE w5bl_CubeCart_addressbook.customer_id = '1' ORDER BY billing DESC ; -- (0.00647807121277 sec) [NOT CACHED]
[20] SELECT `id` FROM `w5bl_CubeCart_geo_country` WHERE w5bl_CubeCart_geo_country.numcode = '826' ; -- (0.00593185424805 sec) [CACHE WRITE]
[21] SELECT * FROM `w5bl_CubeCart_geo_zone` WHERE w5bl_CubeCart_geo_zone.id = '469' ; -- (0.00690603256226 sec) [CACHE WRITE]
[22] SELECT `name` FROM `w5bl_CubeCart_geo_country` WHERE w5bl_CubeCart_geo_country.numcode = '826' ; -- (0.00565409660339 sec) [CACHE WRITE]
[23] SELECT * FROM `w5bl_CubeCart_geo_zone` WHERE w5bl_CubeCart_geo_zone.id = '469' ; -- (0.00569796562195 sec) [CACHE WRITE]
[24] SELECT `iso` FROM `w5bl_CubeCart_geo_country` WHERE w5bl_CubeCart_geo_country.numcode = '826' ; -- (0.00674700737 sec) [CACHE WRITE]
[25] SELECT `iso3` FROM `w5bl_CubeCart_geo_country` WHERE w5bl_CubeCart_geo_country.numcode = '826' ; -- (0.00511407852173 sec) [CACHE WRITE]
[26] SELECT * FROM `w5bl_CubeCart_geo_zone` WHERE w5bl_CubeCart_geo_zone.id = '469' ; -- (0.00706505775452 sec) [CACHE WRITE]
[27] SELECT gc.numcode, gz.id, gz.name FROM `w5bl_CubeCart_geo_zone` AS `gz` LEFT JOIN `w5bl_CubeCart_geo_country` AS `gc` ON gc.id=gz.country_id ORDER BY gc.name, gz.name ASC -- (0.00916290283203 sec) [CACHE WRITE]
[28] SELECT SQL_CALC_FOUND_ROWS `array` FROM `w5bl_CubeCart_config` WHERE w5bl_CubeCart_config.name = 'languages' LIMIT 1; -- (0.00680589675903 sec) [CACHE WRITE]
[29] SELECT * FROM `w5bl_CubeCart_currency` WHERE w5bl_CubeCart_currency.active = '1' ; -- (0.00772881507874 sec) [CACHE WRITE]
[30] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'login' ; -- (0.00698399543762 sec) [CACHE WRITE]
[31] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'register' ; -- (0.0066978931427 sec) [CACHE WRITE]
[32] SELECT SQL_CALC_FOUND_ROWS `array` FROM `w5bl_CubeCart_config` WHERE w5bl_CubeCart_config.name = 'Per_Category' LIMIT 1; -- (0.00824594497681 sec) [CACHE WRITE]
[33] SELECT SQL_CACHE T.tax_name AS type_name, D.display, D.name, R.id, R.type_id, R.tax_percent, R.goods, R.shipping, R.county_id FROM w5bl_CubeCart_tax_rates AS R, w5bl_CubeCart_tax_details AS D, w5bl_CubeCart_tax_class AS T, w5bl_CubeCart_geo_country AS C WHERE D.id = R.details_id AND C.numcode = R.country_id AND R.type_id = T.id AND D.status = 1 AND R.active = 1 AND R.country_id = 826 -- (0.0071849822998 sec) [CACHE WRITE]
[34] SELECT CI.* , C.status FROM `w5bl_CubeCart_category_index` AS CI, `w5bl_CubeCart_category` AS C WHERE CI.product_id = '52' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00419282913208 sec) [CACHE WRITE]
[35] SELECT SQL_CALC_FOUND_ROWS * FROM `w5bl_CubeCart_inventory` WHERE w5bl_CubeCart_inventory.product_id = '52' AND w5bl_CubeCart_inventory.status = '1' LIMIT 10 OFFSET 0; -- (0.00781202316284 sec) [CACHE WRITE]
[36] SELECT FOUND_ROWS() as Count; -- (0.00798082351685 sec) [NOT CACHED]
[37] SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `w5bl_CubeCart_option_matrix` WHERE w5bl_CubeCart_option_matrix.product_id = '52' AND w5bl_CubeCart_option_matrix.options_identifier = '' AND w5bl_CubeCart_option_matrix.status = '1' ; -- (0.00515198707581 sec) [CACHE WRITE]
[38] SELECT * FROM `w5bl_CubeCart_customer_membership` WHERE w5bl_CubeCart_customer_membership.customer_id = '1' ; -- (0.00427794456482 sec) [CACHE WRITE]
[39] SELECT `quantity`, `price` FROM `w5bl_CubeCart_pricing_quantity` WHERE w5bl_CubeCart_pricing_quantity.product_id = '52' AND w5bl_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00551009178162 sec) [CACHE WRITE]
[40] SELECT SQL_CACHE T.tax_name AS type_name, D.display, D.name, R.id, R.type_id, R.tax_percent, R.goods, R.shipping, R.county_id FROM w5bl_CubeCart_tax_rates AS R, w5bl_CubeCart_tax_details AS D, w5bl_CubeCart_tax_class AS T, w5bl_CubeCart_geo_country AS C WHERE D.id = R.details_id AND C.numcode = R.country_id AND R.type_id = T.id AND D.status = 1 AND R.active = 1 AND R.country_id = 826 -- (0.00335717201233 sec) [CACHE WRITE]
[41] INSERT INTO `w5bl_CubeCart_system_error_log` (`message`,`time`) VALUES ('[Notice] /var/sites/t/tuborg-batteries.co.uk/public_html/classes/tax.class.php:212 - Undefined variable: tax_table','1515539361'); -- (0.00470495223999 sec) [ERROR - NOT CACHED]
[42] DELETE FROM `w5bl_CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY)) ; -- (0.00313878059387 sec) [NOT CACHED]
[43] SELECT `basket` FROM `w5bl_CubeCart_saved_cart` WHERE w5bl_CubeCart_saved_cart.customer_id = '1' ; -- (0.00185799598694 sec) [NOT CACHED]
[44] UPDATE `w5bl_CubeCart_saved_cart` SET `basket` = 'a:1:{s:32:\"ec7b1f33c55ea117a22786a01192a8ae\";a:10:{s:2:\"id\";i:52;s:8:\"quantity\";i:1;s:7:\"digital\";s:1:\"0\";s:17:\"option_line_price\";i:0;s:16:\"total_price_each\";s:4:\"1.00\";s:11:\"description\";s:14:\"test product\r\n\";s:4:\"name\";s:4:\"test\";s:12:\"product_code\";s:4:\"test\";s:14:\"product_weight\";d:1;s:8:\"tax_each\";b:0;}}' WHERE w5bl_CubeCart_saved_cart.customer_id = '1'; -- (0.00272297859192 sec) [NOT CACHED]
[45] SELECT SQL_CALC_FOUND_ROWS `array` FROM `w5bl_CubeCart_config` WHERE w5bl_CubeCart_config.name = 'gift_certs' LIMIT 1; -- (0.00164389610291 sec) [CACHE WRITE]
[46] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'prod' AND w5bl_CubeCart_seo_urls.item_id = '52' ; -- (0.00257301330566 sec) [CACHE WRITE]
[47] SELECT SQL_CALC_FOUND_ROWS * FROM `w5bl_CubeCart_image_index` WHERE w5bl_CubeCart_image_index.product_id = '52' ORDER BY `main_img` DESC LIMIT 1; -- (0.000454902648926 sec) [CACHE WRITE]
[48] SELECT FOUND_ROWS() as Count; -- (0.00037693977356 sec) [NOT CACHED]
[49] SELECT * FROM `w5bl_CubeCart_filemanager` WHERE w5bl_CubeCart_filemanager.file_id = '12' ; -- (0.00182414054871 sec) [CACHE WRITE]
[50] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '0' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00117802619934 sec) [CACHE WRITE]
[51] SELECT `cat_id`, `cat_name` FROM `w5bl_CubeCart_category_language` WHERE w5bl_CubeCart_category_language.language = 'en-GB' ; -- (0.0015971660614 sec) [CACHE WRITE]
[52] SELECT C.`product_id`, I.`use_stock_level` FROM `w5bl_CubeCart_category_index` AS C INNER JOIN `w5bl_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 8 AND I.status = 1 -- (0.00146389007568 sec) [CACHE WRITE]
[53] SELECT COUNT(cat_id) AS Count FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '8' AND w5bl_CubeCart_category.status = '1'; -- (0.000489950180054 sec) [CACHE WRITE]
[54] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '8' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.000236988067627 sec) [CACHE WRITE]
[55] SELECT C.`product_id`, I.`use_stock_level` FROM `w5bl_CubeCart_category_index` AS C INNER JOIN `w5bl_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 7 AND I.status = 1 -- (0.000236034393311 sec) [CACHE WRITE]
[56] SELECT COUNT(cat_id) AS Count FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '7' AND w5bl_CubeCart_category.status = '1'; -- (0.000171184539795 sec) [CACHE WRITE]
[57] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '7' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.000173091888428 sec) [CACHE WRITE]
[58] SELECT C.`product_id`, I.`use_stock_level` FROM `w5bl_CubeCart_category_index` AS C INNER JOIN `w5bl_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 6 AND I.status = 1 -- (0.000240087509155 sec) [CACHE WRITE]
[59] SELECT COUNT(cat_id) AS Count FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '6' AND w5bl_CubeCart_category.status = '1'; -- (0.000612020492554 sec) [CACHE WRITE]
[60] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '6' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00196695327759 sec) [CACHE WRITE]
[61] SELECT C.`product_id`, I.`use_stock_level` FROM `w5bl_CubeCart_category_index` AS C INNER JOIN `w5bl_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 5 AND I.status = 1 -- (0.00242710113525 sec) [CACHE WRITE]
[62] SELECT COUNT(cat_id) AS Count FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '5' AND w5bl_CubeCart_category.status = '1'; -- (0.00274896621704 sec) [CACHE WRITE]
[63] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '5' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00267601013184 sec) [CACHE WRITE]
[64] SELECT C.`product_id`, I.`use_stock_level` FROM `w5bl_CubeCart_category_index` AS C INNER JOIN `w5bl_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 4 AND I.status = 1 -- (0.00330781936646 sec) [CACHE WRITE]
[65] SELECT COUNT(cat_id) AS Count FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '4' AND w5bl_CubeCart_category.status = '1'; -- (0.00287485122681 sec) [CACHE WRITE]
[66] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '4' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00369381904602 sec) [CACHE WRITE]
[67] SELECT C.`product_id`, I.`use_stock_level` FROM `w5bl_CubeCart_category_index` AS C INNER JOIN `w5bl_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 3 AND I.status = 1 -- (0.00261688232422 sec) [CACHE WRITE]
[68] SELECT COUNT(cat_id) AS Count FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '3' AND w5bl_CubeCart_category.status = '1'; -- (0.00186610221863 sec) [CACHE WRITE]
[69] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '3' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00254082679749 sec) [CACHE WRITE]
[70] SELECT C.`product_id`, I.`use_stock_level` FROM `w5bl_CubeCart_category_index` AS C INNER JOIN `w5bl_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 2 AND I.status = 1 -- (0.00275206565857 sec) [CACHE WRITE]
[71] SELECT COUNT(cat_id) AS Count FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '2' AND w5bl_CubeCart_category.status = '1'; -- (0.00397610664368 sec) [CACHE WRITE]
[72] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '2' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00331711769104 sec) [CACHE WRITE]
[73] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'cat' AND w5bl_CubeCart_seo_urls.item_id = '8' ; -- (0.00449204444885 sec) [CACHE WRITE]
[74] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'cat' AND w5bl_CubeCart_seo_urls.item_id = '7' ; -- (0.00484704971313 sec) [CACHE WRITE]
[75] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'cat' AND w5bl_CubeCart_seo_urls.item_id = '6' ; -- (0.00482296943665 sec) [CACHE WRITE]
[76] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'cat' AND w5bl_CubeCart_seo_urls.item_id = '5' ; -- (0.00445795059204 sec) [CACHE WRITE]
[77] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'cat' AND w5bl_CubeCart_seo_urls.item_id = '4' ; -- (0.00500202178955 sec) [CACHE WRITE]
[78] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'cat' AND w5bl_CubeCart_seo_urls.item_id = '3' ; -- (0.00717806816101 sec) [CACHE WRITE]
[79] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'cat' AND w5bl_CubeCart_seo_urls.item_id = '2' ; -- (0.00559115409851 sec) [CACHE WRITE]
[80] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'saleitems' ; -- (0.00492095947266 sec) [CACHE WRITE]
[81] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'certificates' ; -- (0.00599598884583 sec) [CACHE WRITE]
[82] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'search' ; -- (0.00658297538757 sec) [CACHE WRITE]
[83] SELECT SQL_CALC_FOUND_ROWS * FROM `w5bl_CubeCart_newsletter_subscriber` WHERE w5bl_CubeCart_newsletter_subscriber.email = '[email protected]' LIMIT 1; -- (0.00616598129272 sec) [CACHE WRITE]
[84] SELECT * FROM `w5bl_CubeCart_documents` WHERE w5bl_CubeCart_documents.doc_parent_id = '0' AND w5bl_CubeCart_documents.doc_status = '1' AND w5bl_CubeCart_documents.navigation_link = '1' ORDER BY `doc_order` ASC ; -- (0.00649499893188 sec) [CACHE WRITE]
[85] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'doc' AND w5bl_CubeCart_seo_urls.item_id = '2' ; -- (0.00590801239014 sec) [CACHE WRITE]
[86] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'doc' AND w5bl_CubeCart_seo_urls.item_id = '3' ; -- (0.00419402122498 sec) [CACHE WRITE]
[87] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'doc' AND w5bl_CubeCart_seo_urls.item_id = '4' ; -- (0.00692796707153 sec) [CACHE WRITE]
[88] SELECT SQL_CALC_FOUND_ROWS `array` FROM `w5bl_CubeCart_config` WHERE w5bl_CubeCart_config.name = 'Contact_Form' LIMIT 1; -- (0.00581002235413 sec) [CACHE WRITE]
[89] SELECT product_id FROM `w5bl_CubeCart_inventory` WHERE w5bl_CubeCart_inventory.status = '1' AND w5bl_CubeCart_inventory.featured = '1' ; -- (0.00496292114258 sec) [CACHE WRITE]
[90] SELECT CI.* , C.status FROM `w5bl_CubeCart_category_index` AS CI, `w5bl_CubeCart_category` AS C WHERE CI.product_id = '45' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00658392906189 sec) [CACHE WRITE]
[91] SELECT SQL_CALC_FOUND_ROWS * FROM `w5bl_CubeCart_inventory` WHERE w5bl_CubeCart_inventory.product_id = '45' LIMIT 1; -- (0.00565195083618 sec) [CACHE WRITE]
[92] SELECT FOUND_ROWS() as Count; -- (0.00656914710999 sec) [NOT CACHED]
[93] SELECT SQL_CALC_FOUND_ROWS * FROM `w5bl_CubeCart_image_index` WHERE w5bl_CubeCart_image_index.product_id = '45' ORDER BY `main_img` DESC LIMIT 1; -- (0.00542092323303 sec) [CACHE WRITE]
[94] SELECT FOUND_ROWS() as Count; -- (0.00482511520386 sec) [NOT CACHED]
[95] SELECT * FROM `w5bl_CubeCart_filemanager` WHERE w5bl_CubeCart_filemanager.file_id = '11' ; -- (0.00570797920227 sec) [CACHE WRITE]
[96] SELECT * FROM `w5bl_CubeCart_customer_membership` WHERE w5bl_CubeCart_customer_membership.customer_id = '1' ; -- (0.00368499755859 sec) [CACHE WRITE]
[97] SELECT `quantity`, `price` FROM `w5bl_CubeCart_pricing_quantity` WHERE w5bl_CubeCart_pricing_quantity.product_id = '45' AND w5bl_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00335788726807 sec) [CACHE WRITE]
[98] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `w5bl_CubeCart_inventory` WHERE w5bl_CubeCart_inventory.product_id = '45' LIMIT 1; -- (0.00478291511536 sec) [CACHE WRITE]
[99] SELECT FOUND_ROWS() as Count; -- (0.00188207626343 sec) [NOT CACHED]
[100] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'prod' AND w5bl_CubeCart_seo_urls.item_id = '45' ; -- (0.0019268989563 sec) [CACHE WRITE]
[101] SELECT `oi`.`product_id`, `i`.`name`, `i`.`price`, `i`.`sale_price`, `i`.`tax_type`, `i`.`tax_inclusive`, SUM(`oi`.`quantity`) as `quantity` FROM `w5bl_CubeCart_order_inventory` as `oi` JOIN `w5bl_CubeCart_inventory` as `i` WHERE `oi`.`product_id` = `i`.`product_id` AND `i`.`status` = 1 GROUP BY `oi`.`product_id` ORDER BY `quantity` DESC LIMIT 10; -- (0.00177097320557 sec) [CACHE WRITE]
[102] SELECT SQL_CALC_FOUND_ROWS `array` FROM `w5bl_CubeCart_config` WHERE w5bl_CubeCart_config.name = 'sfws_vehicle_make_model_version' LIMIT 1; -- (0.00229096412659 sec) [CACHE WRITE]
[103] SELECT FOUND_ROWS() as Count; -- (0.000686168670654 sec) [NOT CACHED]
[104] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `w5bl_CubeCart_modules` WHERE w5bl_CubeCart_modules.folder = 'sfws_vehicle_make_model_version' LIMIT 1; -- (0.000707149505615 sec) [CACHE WRITE]
[105] SELECT FOUND_ROWS() as Count; -- (0.00117611885071 sec) [NOT CACHED]
[106] SELECT `status` FROM `w5bl_CubeCart_modules` WHERE w5bl_CubeCart_modules.folder = 'SFWS_Vehicle_Make_Model_Version' ; -- (0.00171995162964 sec) [CACHE WRITE]
[107] SELECT DISTINCT vehicle_make FROM `w5bl_CubeCart_sfws_vehicle_mmv_vehicles` ORDER BY vehicle_make ASC -- (0.00375890731812 sec) [CACHE WRITE]
[108] SELECT `status` FROM `w5bl_CubeCart_modules` WHERE w5bl_CubeCart_modules.folder = 'SFWS_Vehicle_Make_Model_Version' ; -- (0.00201606750488 sec) [CACHE WRITE]
[109] SELECT DISTINCT vehicle_make FROM `w5bl_CubeCart_sfws_vehicle_mmv_vehicles` ORDER BY vehicle_make ASC -- (0.0019907951355 sec) [CACHE WRITE]
[110] SELECT `status` FROM `w5bl_CubeCart_modules` WHERE w5bl_CubeCart_modules.folder = 'SFWS_Vehicle_Make_Model_Version' ; -- (0.00215721130371 sec) [CACHE WRITE]
[111] SELECT DISTINCT vehicle_make FROM `w5bl_CubeCart_sfws_vehicle_mmv_vehicles` ORDER BY vehicle_make ASC -- (0.002925157547 sec) [CACHE WRITE]

Edited by Michal Kubacki
Link to comment
Share on other sites

Sorry, I misunderstood you, I have tried to finalise the transaction.

I had no trouble editing the address, the trouble starts while trying to pay for the item.

Should I try editing the address instead?

This is what I get after hitting EDIT:

 

 

MySQLi
Queries (105):
[1] INSERT INTO `w5bl_CubeCart_system_error_log` (`message`,`time`) VALUES ('[Warning] /var/sites/t/tuborg-batteries.co.uk/public_html/classes/session.class.php:647 - is_writeable() [function.is-writeable.php]: Unable to find the wrapper &quot;tcp&quot; - did you forget to enable it when you configured PHP?','1515540221'); -- (0.0175998210907 sec) [ERROR - NOT CACHED]
[2] DELETE FROM `w5bl_CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY)) ; -- (0.018040895462 sec) [NOT CACHED]
[3] INSERT INTO `w5bl_CubeCart_system_error_log` (`message`,`time`) VALUES ('[Notice] /var/sites/t/tuborg-batteries.co.uk/public_html/includes/functions.inc.php:527 - Undefined index: X-Forwarded-For','1515540222'); -- (0.0184478759766 sec) [ERROR - NOT CACHED]
[4] DELETE FROM `w5bl_CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY)) ; -- (0.0182340145111 sec) [NOT CACHED]
[5] SELECT SQL_CALC_FOUND_ROWS * FROM `w5bl_CubeCart_sessions` WHERE w5bl_CubeCart_sessions.session_id = 'a5b0b92e163bbeee99f4a95dfb3e34d3' LIMIT 1; -- (0.0159919261932 sec) [NOT CACHED]
[6] SELECT FOUND_ROWS() as Count; -- (0.0160059928894 sec) [NOT CACHED]
[7] SELECT * FROM `w5bl_CubeCart_lang_strings` WHERE w5bl_CubeCart_lang_strings.language = 'en-GB' ; -- (0.0163159370422 sec) [CACHE WRITE]
[8] SELECT * FROM `w5bl_CubeCart_hooks` WHERE w5bl_CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.0171799659729 sec) [CACHE WRITE]
[9] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `w5bl_CubeCart_code_snippet` WHERE w5bl_CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.0164339542389 sec) [CACHE WRITE]
[10] SELECT C.cat_id, C.cat_name, C.cat_parent_id, S.path FROM `w5bl_CubeCart_category` as C LEFT JOIN `w5bl_CubeCart_seo_urls` as S ON S.item_id=C.cat_id AND S.type='cat' AND S.custom='1' ORDER BY C.cat_id DESC -- (0.0170450210571 sec) [CACHE WRITE]
[11] SELECT `cat_id`, `cat_name` FROM `w5bl_CubeCart_category_language` WHERE w5bl_CubeCart_category_language.language = 'en-GB' ; -- (0.016352891922 sec) [CACHE WRITE]
[12] SELECT SQL_CALC_FOUND_ROWS `array` FROM `w5bl_CubeCart_config` WHERE w5bl_CubeCart_config.name = 'logos' LIMIT 1; -- (0.017655134201 sec) [CACHE WRITE]
[13] SELECT FOUND_ROWS() as Count; -- (0.0176110267639 sec) [NOT CACHED]
[14] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `w5bl_CubeCart_modules` WHERE w5bl_CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.0169160366058 sec) [CACHE WRITE]
[15] SELECT `folder` FROM `w5bl_CubeCart_modules` WHERE w5bl_CubeCart_modules.module = 'livehelp' AND w5bl_CubeCart_modules.status = '1' ; -- (0.0159680843353 sec) [CACHE WRITE]
[16] SELECT * FROM `w5bl_CubeCart_currency` WHERE w5bl_CubeCart_currency.code = 'GBP' ; -- (0.0150849819183 sec) [CACHE WRITE]
[17] SELECT SQL_CALC_FOUND_ROWS * FROM `w5bl_CubeCart_customer` WHERE w5bl_CubeCart_customer.customer_id = '1' LIMIT 1; -- (0.0176990032196 sec) [CACHE WRITE]
[18] SELECT FOUND_ROWS() as Count; -- (0.0168380737305 sec) [NOT CACHED]
[19] SELECT * FROM `w5bl_CubeCart_addressbook` WHERE w5bl_CubeCart_addressbook.customer_id = '1' AND w5bl_CubeCart_addressbook.address_id = '1' ; -- (0.016793012619 sec) [NOT CACHED]
[20] SELECT `numcode`, `name` FROM `w5bl_CubeCart_geo_country` WHERE w5bl_CubeCart_geo_country.status = '1' ORDER BY `name` ASC ; -- (0.0161299705505 sec) [CACHE WRITE]
[21] SELECT gc.numcode, gz.id, gz.name FROM `w5bl_CubeCart_geo_zone` AS `gz` LEFT JOIN `w5bl_CubeCart_geo_country` AS `gc` ON gc.id=gz.country_id ORDER BY gc.name, gz.name ASC -- (0.0195050239563 sec) [CACHE WRITE]
[22] SELECT SQL_CALC_FOUND_ROWS `array` FROM `w5bl_CubeCart_config` WHERE w5bl_CubeCart_config.name = 'languages' LIMIT 1; -- (0.0176529884338 sec) [CACHE WRITE]
[23] SELECT * FROM `w5bl_CubeCart_currency` WHERE w5bl_CubeCart_currency.active = '1' ; -- (0.0182049274445 sec) [CACHE WRITE]
[24] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'login' ; -- (0.0155470371246 sec) [CACHE WRITE]
[25] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'register' ; -- (0.0166659355164 sec) [CACHE WRITE]
[26] SELECT SQL_CALC_FOUND_ROWS `array` FROM `w5bl_CubeCart_config` WHERE w5bl_CubeCart_config.name = 'Per_Category' LIMIT 1; -- (0.0175700187683 sec) [CACHE WRITE]
[27] SELECT SQL_CACHE T.tax_name AS type_name, D.display, D.name, R.id, R.type_id, R.tax_percent, R.goods, R.shipping, R.county_id FROM w5bl_CubeCart_tax_rates AS R, w5bl_CubeCart_tax_details AS D, w5bl_CubeCart_tax_class AS T, w5bl_CubeCart_geo_country AS C WHERE D.id = R.details_id AND C.numcode = R.country_id AND R.type_id = T.id AND D.status = 1 AND R.active = 1 AND R.country_id = 826 -- (0.0162348747253 sec) [CACHE WRITE]
[28] SELECT CI.* , C.status FROM `w5bl_CubeCart_category_index` AS CI, `w5bl_CubeCart_category` AS C WHERE CI.product_id = '52' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.0179810523987 sec) [CACHE WRITE]
[29] SELECT SQL_CALC_FOUND_ROWS * FROM `w5bl_CubeCart_inventory` WHERE w5bl_CubeCart_inventory.product_id = '52' AND w5bl_CubeCart_inventory.status = '1' LIMIT 10 OFFSET 0; -- (0.0184690952301 sec) [CACHE WRITE]
[30] SELECT FOUND_ROWS() as Count; -- (0.0165030956268 sec) [NOT CACHED]
[31] SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `w5bl_CubeCart_option_matrix` WHERE w5bl_CubeCart_option_matrix.product_id = '52' AND w5bl_CubeCart_option_matrix.options_identifier = '' AND w5bl_CubeCart_option_matrix.status = '1' ; -- (0.0178060531616 sec) [CACHE WRITE]
[32] SELECT * FROM `w5bl_CubeCart_customer_membership` WHERE w5bl_CubeCart_customer_membership.customer_id = '1' ; -- (0.0180559158325 sec) [CACHE WRITE]
[33] SELECT `quantity`, `price` FROM `w5bl_CubeCart_pricing_quantity` WHERE w5bl_CubeCart_pricing_quantity.product_id = '52' AND w5bl_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.0159068107605 sec) [CACHE WRITE]
[34] SELECT SQL_CACHE T.tax_name AS type_name, D.display, D.name, R.id, R.type_id, R.tax_percent, R.goods, R.shipping, R.county_id FROM w5bl_CubeCart_tax_rates AS R, w5bl_CubeCart_tax_details AS D, w5bl_CubeCart_tax_class AS T, w5bl_CubeCart_geo_country AS C WHERE D.id = R.details_id AND C.numcode = R.country_id AND R.type_id = T.id AND D.status = 1 AND R.active = 1 AND R.country_id = 826 -- (0.0176339149475 sec) [CACHE WRITE]
[35] INSERT INTO `w5bl_CubeCart_system_error_log` (`message`,`time`) VALUES ('[Notice] /var/sites/t/tuborg-batteries.co.uk/public_html/classes/tax.class.php:212 - Undefined variable: tax_table','1515540223'); -- (0.0172019004822 sec) [ERROR - NOT CACHED]
[36] DELETE FROM `w5bl_CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY)) ; -- (0.0174858570099 sec) [NOT CACHED]
[37] SELECT `basket` FROM `w5bl_CubeCart_saved_cart` WHERE w5bl_CubeCart_saved_cart.customer_id = '1' ; -- (0.0163168907166 sec) [NOT CACHED]
[38] UPDATE `w5bl_CubeCart_saved_cart` SET `basket` = 'a:1:{s:32:\"ec7b1f33c55ea117a22786a01192a8ae\";a:10:{s:2:\"id\";i:52;s:8:\"quantity\";i:1;s:7:\"digital\";s:1:\"0\";s:17:\"option_line_price\";i:0;s:16:\"total_price_each\";s:4:\"1.00\";s:11:\"description\";s:14:\"test product\r\n\";s:4:\"name\";s:4:\"test\";s:12:\"product_code\";s:4:\"test\";s:14:\"product_weight\";d:1;s:8:\"tax_each\";b:0;}}' WHERE w5bl_CubeCart_saved_cart.customer_id = '1'; -- (0.0164592266083 sec) [NOT CACHED]
[39] SELECT SQL_CALC_FOUND_ROWS `array` FROM `w5bl_CubeCart_config` WHERE w5bl_CubeCart_config.name = 'gift_certs' LIMIT 1; -- (0.0186660289764 sec) [CACHE WRITE]
[40] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'prod' AND w5bl_CubeCart_seo_urls.item_id = '52' ; -- (0.0178680419922 sec) [CACHE WRITE]
[41] SELECT SQL_CALC_FOUND_ROWS * FROM `w5bl_CubeCart_image_index` WHERE w5bl_CubeCart_image_index.product_id = '52' ORDER BY `main_img` DESC LIMIT 1; -- (0.0169520378113 sec) [CACHE WRITE]
[42] SELECT FOUND_ROWS() as Count; -- (0.0174300670624 sec) [NOT CACHED]
[43] SELECT * FROM `w5bl_CubeCart_filemanager` WHERE w5bl_CubeCart_filemanager.file_id = '12' ; -- (0.0192210674286 sec) [CACHE WRITE]
[44] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '0' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.0169749259949 sec) [CACHE WRITE]
[45] SELECT `cat_id`, `cat_name` FROM `w5bl_CubeCart_category_language` WHERE w5bl_CubeCart_category_language.language = 'en-GB' ; -- (0.0181498527527 sec) [CACHE WRITE]
[46] SELECT C.`product_id`, I.`use_stock_level` FROM `w5bl_CubeCart_category_index` AS C INNER JOIN `w5bl_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 8 AND I.status = 1 -- (0.0180020332336 sec) [CACHE WRITE]
[47] SELECT COUNT(cat_id) AS Count FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '8' AND w5bl_CubeCart_category.status = '1'; -- (0.0159170627594 sec) [CACHE WRITE]
[48] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '8' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.0141451358795 sec) [CACHE WRITE]
[49] SELECT C.`product_id`, I.`use_stock_level` FROM `w5bl_CubeCart_category_index` AS C INNER JOIN `w5bl_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 7 AND I.status = 1 -- (0.0146450996399 sec) [CACHE WRITE]
[50] SELECT COUNT(cat_id) AS Count FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '7' AND w5bl_CubeCart_category.status = '1'; -- (0.0158579349518 sec) [CACHE WRITE]
[51] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '7' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.0175631046295 sec) [CACHE WRITE]
[52] SELECT C.`product_id`, I.`use_stock_level` FROM `w5bl_CubeCart_category_index` AS C INNER JOIN `w5bl_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 6 AND I.status = 1 -- (0.0186619758606 sec) [CACHE WRITE]
[53] SELECT COUNT(cat_id) AS Count FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '6' AND w5bl_CubeCart_category.status = '1'; -- (0.0181469917297 sec) [CACHE WRITE]
[54] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '6' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.0165100097656 sec) [CACHE WRITE]
[55] SELECT C.`product_id`, I.`use_stock_level` FROM `w5bl_CubeCart_category_index` AS C INNER JOIN `w5bl_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 5 AND I.status = 1 -- (0.0156490802765 sec) [CACHE WRITE]
[56] SELECT COUNT(cat_id) AS Count FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '5' AND w5bl_CubeCart_category.status = '1'; -- (0.0154910087585 sec) [CACHE WRITE]
[57] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '5' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.0149781703949 sec) [CACHE WRITE]
[58] SELECT C.`product_id`, I.`use_stock_level` FROM `w5bl_CubeCart_category_index` AS C INNER JOIN `w5bl_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 4 AND I.status = 1 -- (0.0158100128174 sec) [CACHE WRITE]
[59] SELECT COUNT(cat_id) AS Count FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '4' AND w5bl_CubeCart_category.status = '1'; -- (0.0159749984741 sec) [CACHE WRITE]
[60] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '4' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.014191865921 sec) [CACHE WRITE]
[61] SELECT C.`product_id`, I.`use_stock_level` FROM `w5bl_CubeCart_category_index` AS C INNER JOIN `w5bl_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 3 AND I.status = 1 -- (0.0164179801941 sec) [CACHE WRITE]
[62] SELECT COUNT(cat_id) AS Count FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '3' AND w5bl_CubeCart_category.status = '1'; -- (0.0176658630371 sec) [CACHE WRITE]
[63] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '3' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.0178701877594 sec) [CACHE WRITE]
[64] SELECT C.`product_id`, I.`use_stock_level` FROM `w5bl_CubeCart_category_index` AS C INNER JOIN `w5bl_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 2 AND I.status = 1 -- (0.0175180435181 sec) [CACHE WRITE]
[65] SELECT COUNT(cat_id) AS Count FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '2' AND w5bl_CubeCart_category.status = '1'; -- (0.0168168544769 sec) [CACHE WRITE]
[66] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `w5bl_CubeCart_category` WHERE w5bl_CubeCart_category.cat_parent_id = '2' AND w5bl_CubeCart_category.status = '1' AND w5bl_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.0171239376068 sec) [CACHE WRITE]
[67] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'cat' AND w5bl_CubeCart_seo_urls.item_id = '8' ; -- (0.0171868801117 sec) [CACHE WRITE]
[68] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'cat' AND w5bl_CubeCart_seo_urls.item_id = '7' ; -- (0.0186610221863 sec) [CACHE WRITE]
[69] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'cat' AND w5bl_CubeCart_seo_urls.item_id = '6' ; -- (0.235590934753 sec) [CACHE WRITE]
[70] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'cat' AND w5bl_CubeCart_seo_urls.item_id = '5' ; -- (0.0173349380493 sec) [CACHE WRITE]
[71] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'cat' AND w5bl_CubeCart_seo_urls.item_id = '4' ; -- (0.0171921253204 sec) [CACHE WRITE]
[72] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'cat' AND w5bl_CubeCart_seo_urls.item_id = '3' ; -- (0.0183131694794 sec) [CACHE WRITE]
[73] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'cat' AND w5bl_CubeCart_seo_urls.item_id = '2' ; -- (0.0160992145538 sec) [CACHE WRITE]
[74] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'saleitems' ; -- (0.0150139331818 sec) [CACHE WRITE]
[75] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'certificates' ; -- (0.0162661075592 sec) [CACHE WRITE]
[76] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'search' ; -- (0.0160570144653 sec) [CACHE WRITE]
[77] SELECT SQL_CALC_FOUND_ROWS * FROM `w5bl_CubeCart_newsletter_subscriber` WHERE w5bl_CubeCart_newsletter_subscriber.email = '[email protected]' LIMIT 1; -- (0.0180139541626 sec) [CACHE WRITE]
[78] SELECT * FROM `w5bl_CubeCart_documents` WHERE w5bl_CubeCart_documents.doc_parent_id = '0' AND w5bl_CubeCart_documents.doc_status = '1' AND w5bl_CubeCart_documents.navigation_link = '1' ORDER BY `doc_order` ASC ; -- (0.0189809799194 sec) [CACHE WRITE]
[79] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'doc' AND w5bl_CubeCart_seo_urls.item_id = '2' ; -- (0.0184168815613 sec) [CACHE WRITE]
[80] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'doc' AND w5bl_CubeCart_seo_urls.item_id = '3' ; -- (0.0175590515137 sec) [CACHE WRITE]
[81] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'doc' AND w5bl_CubeCart_seo_urls.item_id = '4' ; -- (0.017776966095 sec) [CACHE WRITE]
[82] SELECT SQL_CALC_FOUND_ROWS `array` FROM `w5bl_CubeCart_config` WHERE w5bl_CubeCart_config.name = 'Contact_Form' LIMIT 1; -- (0.0173349380493 sec) [CACHE WRITE]
[83] SELECT product_id FROM `w5bl_CubeCart_inventory` WHERE w5bl_CubeCart_inventory.status = '1' AND w5bl_CubeCart_inventory.featured = '1' ; -- (0.0188949108124 sec) [CACHE WRITE]
[84] SELECT CI.* , C.status FROM `w5bl_CubeCart_category_index` AS CI, `w5bl_CubeCart_category` AS C WHERE CI.product_id = '12' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.018324136734 sec) [CACHE WRITE]
[85] SELECT SQL_CALC_FOUND_ROWS * FROM `w5bl_CubeCart_inventory` WHERE w5bl_CubeCart_inventory.product_id = '12' LIMIT 1; -- (0.0334179401398 sec) [CACHE WRITE]
[86] SELECT FOUND_ROWS() as Count; -- (0.0163178443909 sec) [NOT CACHED]
[87] SELECT SQL_CALC_FOUND_ROWS * FROM `w5bl_CubeCart_image_index` WHERE w5bl_CubeCart_image_index.product_id = '12' ORDER BY `main_img` DESC LIMIT 1; -- (0.0172760486603 sec) [CACHE WRITE]
[88] SELECT FOUND_ROWS() as Count; -- (0.0166471004486 sec) [NOT CACHED]
[89] SELECT * FROM `w5bl_CubeCart_filemanager` WHERE w5bl_CubeCart_filemanager.file_id = '35' ; -- (0.0172879695892 sec) [CACHE WRITE]
[90] SELECT * FROM `w5bl_CubeCart_customer_membership` WHERE w5bl_CubeCart_customer_membership.customer_id = '1' ; -- (0.0170087814331 sec) [CACHE WRITE]
[91] SELECT `quantity`, `price` FROM `w5bl_CubeCart_pricing_quantity` WHERE w5bl_CubeCart_pricing_quantity.product_id = '12' AND w5bl_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.0175309181213 sec) [CACHE WRITE]
[92] SELECT SQL_CALC_FOUND_ROWS `stock_level` FROM `w5bl_CubeCart_inventory` WHERE w5bl_CubeCart_inventory.product_id = '12' LIMIT 1; -- (0.0183119773865 sec) [CACHE WRITE]
[93] SELECT FOUND_ROWS() as Count; -- (0.0190899372101 sec) [NOT CACHED]
[94] SELECT `path` FROM `w5bl_CubeCart_seo_urls` WHERE w5bl_CubeCart_seo_urls.type = 'prod' AND w5bl_CubeCart_seo_urls.item_id = '12' ; -- (0.0179710388184 sec) [CACHE WRITE]
[95] SELECT `oi`.`product_id`, `i`.`name`, `i`.`price`, `i`.`sale_price`, `i`.`tax_type`, `i`.`tax_inclusive`, SUM(`oi`.`quantity`) as `quantity` FROM `w5bl_CubeCart_order_inventory` as `oi` JOIN `w5bl_CubeCart_inventory` as `i` WHERE `oi`.`product_id` = `i`.`product_id` AND `i`.`status` = 1 GROUP BY `oi`.`product_id` ORDER BY `quantity` DESC LIMIT 10; -- (0.0210959911346 sec) [CACHE WRITE]
[96] SELECT SQL_CALC_FOUND_ROWS `array` FROM `w5bl_CubeCart_config` WHERE w5bl_CubeCart_config.name = 'sfws_vehicle_make_model_version' LIMIT 1; -- (0.0168240070343 sec) [CACHE WRITE]
[97] SELECT FOUND_ROWS() as Count; -- (0.0152158737183 sec) [NOT CACHED]
[98] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `w5bl_CubeCart_modules` WHERE w5bl_CubeCart_modules.folder = 'sfws_vehicle_make_model_version' LIMIT 1; -- (0.0152781009674 sec) [CACHE WRITE]
[99] SELECT FOUND_ROWS() as Count; -- (0.0155129432678 sec) [NOT CACHED]
[100] SELECT `status` FROM `w5bl_CubeCart_modules` WHERE w5bl_CubeCart_modules.folder = 'SFWS_Vehicle_Make_Model_Version' ; -- (0.0143349170685 sec) [CACHE WRITE]
[101] SELECT DISTINCT vehicle_make FROM `w5bl_CubeCart_sfws_vehicle_mmv_vehicles` ORDER BY vehicle_make ASC -- (0.0336499214172 sec) [CACHE WRITE]
[102] SELECT `status` FROM `w5bl_CubeCart_modules` WHERE w5bl_CubeCart_modules.folder = 'SFWS_Vehicle_Make_Model_Version' ; -- (0.0164790153503 sec) [CACHE WRITE]
[103] SELECT DISTINCT vehicle_make FROM `w5bl_CubeCart_sfws_vehicle_mmv_vehicles` ORDER BY vehicle_make ASC -- (0.0172798633575 sec) [CACHE WRITE]
[104] SELECT `status` FROM `w5bl_CubeCart_modules` WHERE w5bl_CubeCart_modules.folder = 'SFWS_Vehicle_Make_Model_Version' ; -- (0.0172488689423 sec) [CACHE WRITE]
[105] SELECT DISTINCT vehicle_make FROM `w5bl_CubeCart_sfws_vehicle_mmv_vehicles` ORDER BY vehicle_make ASC -- (0.0178608894348 sec) [CACHE WRITE]
 

Link to comment
Share on other sites

Using a programmer's text editor, please verify that you have this code in the file /classes/user.class.php:

In the function formatAddress(), near line 435 (depends on the version of CubeCart):

// Check state
$country_id = getCountryFormat($address['country'], 'numcode', 'id');
if($user_defined && !CC_IN_ADMIN && $_GET['_a']!=='addressbook' && ((empty($address['state']) && !empty($address['country'])) || ($GLOBALS['db']->select('CubeCart_geo_zone',false, array($state_field => $address['state']))==false) && $GLOBALS['db']->select('CubeCart_geo_zone',false, array('country_id' => $country_id)))) {
	$address_description = empty($address['description']) ? '' : ' (&quot;'.$address['description'].'&quot;)';
	$GLOBALS['gui']->setError(sprintf($GLOBALS['language']->address['check_state'],$address_description));
	httpredir("?_a=addressbook&action=edit&address_id=".$address['address_id']);
	return false;
}

There have been some issues with this:
https://github.com/cubecart/v6/issues/1290
https://github.com/cubecart/v6/issues/1367
https://github.com/cubecart/v6/issues/1708

We may need to take another look at the database table CubeCart_geo_zone.

Please remind us what version of CubeCart you are using. Is this installation an upgrade from a CubeCart v5 version prior to CC5.2.2?

Edited by bsmither
Link to comment
Share on other sites

Hi,

This is the info from my panel:

Technical Details

CubeCart Version
6.1.13
PHP Version (5.6 Recommended)
5.6.22
MySQL Version
5.7.17
Image folder size
8.79 MB
Download folder size
0.00 KB
Max. Upload filesize
100M
Browser user-agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36
Server Software
Apache

This is the code I found in the file you mentioned: image.thumb.png.d87aa57766d6250a1de3786c4b1f54ce.png

 

Link to comment
Share on other sites

You have the latest code. That means one or more of the conditions in the statement on line 458 is true when it should not be. This is the part of the code I am focusing on:

			if(
T			   $user_defined 
T			&& !CC_IN_ADMIN 
T			&& $_GET['_a']!=='addressbook' 
F=			&& (
	F		     (empty($address['state']) && !empty($address['country'])) 
			   || 
	F		     ($GLOBALS['db']->select('CubeCart_geo_zone',false, array($state_field => $address['state']))==false) 
			   && 
	T		      $GLOBALS['db']->select('CubeCart_geo_zone',false, array('country_id' => $country_id))
			   )
			) 

Using phpMyAdmin, execute each of these queries:

SELECT * FROM `CubeCart_geo_zone` WHERE CubeCart_geo_zone.id = '469';

SELECT * FROM `CubeCart_geo_zone` WHERE CubeCart_geo_zone.country_id = '225';

For each of those queries, do you get any records?

Link to comment
Share on other sites

Sorry, you need to prepend the table name with w5bl, so that it is `w5bl_CubeCart_geo_zone`.

SELECT * FROM `w5bl_CubeCart_geo_zone` WHERE w5bl_CubeCart_geo_zone.id = '469';

SELECT * FROM `w5bl_CubeCart_geo_zone` WHERE w5bl_CubeCart_geo_zone.country_id = '225';

The font makes it hard to tell the exact letters, so I leave it to you to determine the prefix.

Edited by bsmither
Link to comment
Share on other sites

So the queries return what they are supposed to. Logically, that just leaves this expression:
(empty($address['state']) && !empty($address['country']))
as the only remaining part of the condition that would result in the condition being true, thus the error message being generated.

We should take this to email as I would like to give you some deep-level diagnostic edits to really find where this problem is coming from.
 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...