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

[kamil.tusznio]

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

[Ajeh]

What version of Zen Cart are you using?

What version of php are you using?

[kamil.tusznio]

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

[Ajeh]

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 $

[kamil.tusznio]

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

Cheers!

-Kamil

[Ajeh]

Thanks for the confirmation ...