X-Cart forums

[qualiteam]

There should be only "id" field in the address book table, no "addressid" one (it is indeed means "addressid", but called "id").

The "addressid" field should be added to the "xcart_register_field_values" table.

Hope it helps.

[carlisleglass]

Originally Posted by qualiteam

There should be only "id" field in the address book table, no "addressid" one (it is indeed means "addressid", but called "id").

The "addressid" field should be added to the "xcart_register_field_values" table.

Hope it helps.

For some reason my installation was causing php errors saying addressid was a missing field within address_book - unfortunately i don't have the error messages anymore, but adding addressid to the table stopped the error.

[CartOnSteroids.com]

Brilliant! This is really useful!

[alinush]

I'm getting this:

    SQL query   : SELECT COUNT(id) FROM xcart_address_book WHERE userid='0' AND addressid='S' LIMIT 1
    Error code  : 1054
    Description : Unknown column 'addressid' in 'where clause'
Request URI: /cart.php?mode=order_message&orderids=11970
Backtrace:
/home/user/public_html/xcart/include/func/func.db.php:291
/home/user/public_html/xcart/include/func/func.db.php:191
/home/user/public_html/xcart/include/func/func.db.php:542
/home/user/public_html/xcart/include/func/func.user.php:1210
/home/user/public_html/xcart/include/func/func.user.php:724
/home/user/public_html/xcart/include/checkout_init.php:304
/home/user/public_html/xcart/cart.php:119

[alinush]

Actually there's a set of errors on each completed order, from the same URL specified above

    SQL query   : SELECT COUNT(id) FROM xcart_address_book WHERE userid='0' AND addressid='0' LIMIT 1

    SQL query   : SELECT COUNT(id) FROM xcart_address_book WHERE userid=■ AND addressid=■ LIMIT 1

    SQL query   : SELECT COUNT(id) FROM xcart_address_book WHERE userid='0' AND addressid='B' LIMIT 1

    SQL query   : SELECT COUNT(id) FROM xcart_address_book WHERE userid='0' AND addressid='S' LIMIT 1

[qualiteam]

Oh, sorry. There seem to be an issue with the patch.

Please edit the include/func/func.user.php script and replace this code:

$_address_exists = func_query_first_cell("SELECT COUNT(id) FROM $sql_tbl[address_book] WHERE userid='$user' AND addressid='$address'") == 0 ? false : true;

with this:

$_address_exists = func_query_first_cell("SELECT COUNT(id) FROM $sql_tbl[address_book] WHERE userid='$user' AND id='$address'") == 0 ? false : true;

[qualiteam]

I've update the patch. So, it contains the fix provided above.

[alinush]

Thank you, this solved the problem.

For some reason though, the extra fields are invisible, even if the HTML code is there. Please see:

http://www.blueneon.ro/alinush/hidden.jpg

Also, how can we insert these fields between the other address book fields? For example, I need Address line 3 after Address line 2, but I can't insert it there:

http://www.blueneon.ro/alinush/fields.jpg

[qualiteam]

Repositioning is not supported, unfortunately.

Additional customization will be rquired e.g. in this template -> skin/%skin%/(main/modules)/address_fields.tpl

[qualiteam]

What browser do you use? Please clarify.