[DONE v1.3.0.2] SQL Error: Adding New Address Book Entry as Primary Address

Hi,

An SQL error occurs when adding a new address as the primary address to the address book. I looked into this and the error occurs in includes/modules/pages/address_book_process/header_php.php around line 222.

Replacing the line

$sql_data_array[] = array('fieldName'=>'customers_firstname', 'value'=>$firstname, 'type'=>'string');

with

$sql_data_array = array( array('fieldName'=>'customers_firstname', 'value'=>$firstname, 'type'=>'string') );

solves the problem as far as I can tell.

Initially, $sql_data_array is created to store data for a query that is performed on the address_book table. Once that query is executed, $sql_data_array is reused to execute another query, but this time on the customers table. The problem is that the variable is not reset and still holds data which corresponds to columns in the address_book table - columns which don't match up to the customers table. :)

Cheers!

-Kamil

What version of Zen Cart are you using?

What version of php are you using?

PHP version 4.4.2
Zen-cart version: 1.3.0.1

I was able to reproduce the error on a demo I found here: http://demo.opensourcecms.com/zencart/

Cheers!

-Kamil

Check the ID on your /pages/address_book_process/header_php.php

• @version $Id: header_php.php 3160 2006-03-11 01:37:18Z drbyte $

@version $Id: header_php.php 3160 2006-03-11 01:37:18Z drbyte $

Cheers!

-Kamil

Thanks for the confirmation ... :smile:

Bug confirmed. The posted fix works.

The correct line number to make the change is line 215, not line 222.

A variation of this fix will be in the next release (v1.3.0.2).

I have this same issue and I am using 1.3.7.1. My line of code does not look the same and I tried the fix and got a syntax error, so reverted back to what I had before.

My site is www.swansoninc.com

If you want to log in and see the error, you can use the e-mail [email protected] and the password 12345

My line of code was also not on 215 or 222, but it was 209.

My code looks like this:

$sql_data_array = array( array('fieldName'=>'customers_firstname', 'value'=>$firstname, 'type'=>'string') );
```This is under customer_default_address_id in the code. There is another line that looks the same under new_address_book_id.

Can anyone offer assistance on this? I am clueless as to what to do next. Thanks.

The issue discussed in this thread was fixed in v1.3.0.2.

Further discussion can take place in your other post on the same topic: http://www.zen-cart.com/forum/showthread.php?t=124092