Additional Customers Fields

[rbepple]

Also, I have noticed even though the user gets this error on there side the command still goes through and they create an account. If the customer backs up a page it shows them logged in and if they click on "view or change account information" everything is blank, yet on my side I see the new customer and if I click on there account I get this error:

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /www/freehostingnow.com/c/o/m/commtech/htdocs/catalog/admin/customers.php on line 1213

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /www/freehostingnow.com/c/o/m/commtech/htdocs/catalog/admin/customers.php on line 1213

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /www/freehostingnow.com/c/o/m/commtech/htdocs/catalog/admin/customers.php on line 1215

Warning: reset() [function.reset]: Passed variable is not an array or object in /www/freehostingnow.com/c/o/m/commtech/htdocs/catalog/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /www/freehostingnow.com/c/o/m/commtech/htdocs/catalog/admin/includes/classes/object_info.php on line 30

[TheOracle]

This problem seem to variate depending on mySQL versions.

In your includes/modules/<your_template>/create_account.php file,

I cannot reproduce this problem when using mySQL v4.x.

Very well. For now,

replace:

$sql = "update " . TABLE_CUSTOMERS . "
               set customers_default_address_id = '" . (int)$address_id . "', " . $additional_sql . "
               where customers_id = '" . (int)$_SESSION['customer_id'] . "'"; 

with:

$sql = "update " . TABLE_CUSTOMERS . "
               set customers_default_address_id = '" . (int)$address_id . "'" . $additional_sql . "
               where customers_id = '" . (int)$_SESSION['customer_id'] . "'"; 

This should fix the problem. I will try to find a universal fix for both mySQL versions eventually.

Also, I have noticed even though the user gets this error on there side the command still goes through and they create an account. If the customer backs up a page it shows them logged in and if they click on "view or change account information" everything is blank, yet on my side I see the new customer and if I click on there account I get this error:

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /www/freehostingnow.com/c/o/m/commtech/htdocs/catalog/admin/customers.php on line 1213

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /www/freehostingnow.com/c/o/m/commtech/htdocs/catalog/admin/customers.php on line 1213

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /www/freehostingnow.com/c/o/m/commtech/htdocs/catalog/admin/customers.php on line 1215

Warning: reset() [function.reset]: Passed variable is not an array or object in /www/freehostingnow.com/c/o/m/commtech/htdocs/catalog/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /www/freehostingnow.com/c/o/m/commtech/htdocs/catalog/admin/includes/classes/object_info.php on line 30 

Which version of PHP are you using again ? I surely can't reproduce this problem . . .

[rbepple]

I am using PHP 2.8. I changed includes/modules/<your_template>/create_account.php file as instructed earlier and that fixed that problem. But, now I get this error on the customer side:

Fatal error: Call to undefined function get_support_ticket_tables() in /www/freehostingnow.com/c/o/m/commtech/htdocs/catalog/includes/modules/classic/create_account.php on line 322

and this error on the admin side:

1054 Unknown column 'c.customers_default_address_id' in 'on clause'
in:
[select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id, c.customers_email_format, c.customers_group_pricing, c.customers_authorization, c.customers_referral, ac.field_name, ac.field_status from customers c, customers_additional ac left join address_book a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '6']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I have restored my TABLE_CUSTOMERS to a previous version and I still get this message.

[rbepple]

I was just wondering do I need to have phpBB installed, because I said no when installing Zen Cart?

[TheOracle]

I am using PHP 2.8.

Just hope you have the wrong line from your server info under the admin section there ... otherwise ... welcome to the past !

Fatal error: Call to undefined function get_support_ticket_tables() in /www/freehostingnow.com/c/o/m/commtech/htdocs/catalog/includes/modules/classic/create_account.php on line 322

Yikes !! - my fault.

In the same file,

remove that block:

if (!get_support_ticket_tables($_SESSION['customer_id'], 'check_if_support_ticket_tables_exists')) {
    get_support_ticket_tables($_SESSION['customer_id'], 'create_support_ticket_tables');
    } // End of if statement. 

This has absolutely nothing to do in there. Thanks for the catch. Package instantly updated.

I have restored my TABLE_CUSTOMERS to a previous version and I still get this message.

And ... do you see the customers_default_address_id field inside your backup table ? ...

[TheOracle]

Additional note to the above: Make sure to download the update from my site until the downloads refreshes my latest upload (in case you'd need it - in this case you don't since you already have the patch above).

[rbepple]

WOW!!!!! Thanks, It is finally wokring on the customer side! But, I still get the same error on the admin side saying:

1054 Unknown column 'c.customers_default_address_id' in 'on clause'
in:
[select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id, c.customers_email_format, c.customers_group_pricing, c.customers_authorization, c.customers_referral, ac.field_name, ac.field_status from customers c, customers_additional ac left join address_book a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '6']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I have checked my database TABLE_CUSTOMERS and customers_default_address_id does exist. I don't know why all of the fields have a letter in fromt of them on the error (its in the code too).

The 2.8 is the version of my phpAdmin, I am not sure what version of php I am using.

[TheOracle]

The 2.8 is the version of my phpAdmin, I am not sure what version of php I am using.

Go to your admin - > tools - > server info and copy & paste your:

- PHP Version
- mySQL Version
- Zen-Cart Version

if you're unsure of the specs you currently have. PHPMyAdmin should not be an issue for handling this MOD (unless it is a pretty old version but it ain't the case on this one).

[rbepple]

PHP Version = 5.1.6
Zen-Cart Version = 1.3.7
MySQL Version = 5.0.27

Also, with the admin error I posted above, I only get that message when I try to edit, delete or email a customer from the admin>customers

[TheOracle]

Also, with the admin error I posted above, I only get that message when I try to edit, delete or email a customer from the admin>customers

Both, PHP and mySQL, versions are the 5th and, again, has only been tested under the 4th. However, in your admin/customers.php file,

find:

$sql_update = "UPDATE " . TABLE_CUSTOMERS . " SET " . zen_db_output($additional_sql) . " WHERE customers_id = " . (int)$customers_id;
        $db->Execute($sql_update);
        // End of Additional Customers Fields. 

Comment it out:

/*$sql_update = "UPDATE " . TABLE_CUSTOMERS . " SET " . zen_db_output($additional_sql) . " WHERE customers_id = " . (int)$customers_id;
        $db->Execute($sql_update);*/
        // End of Additional Customers Fields. 

Then, go back to your admin -> customers page. Redo your operation you were telling me above. If you save the changes, will the error still appear ?