Additional Customers Fields

[TheOracle]

[update customers set customers_default_address_id = '22', where customers_id = '22']

Special fix for you it would seem (since I cannot reproduce this problem).

In your create_account.php file,

find:

if (isset($_POST[$key]) && isset($table_fields[$key]) && eregi("^[[:alnum:]][a-z0-9_.-]*@[a-z0-9.-]+\.[a-z]{2,6}$", zen_db_prepare_input($_POST[$key])) && zen_validate_email($_POST[$key]) == true) {                              
                      $additional_sql .= "$key = '".zen_db_prepare_input($_POST[$key])."', ";
                  } elseif (isset($_POST[$key]) && isset($table_fields[$key]) && preg_match("/[a-zA-Z0-9\.\,;:%&#@!\^-_~`\"'\[\]\{\}\*\/\?\(\)\n\r]/", $_POST[$key])) {
                      $additional_sql .= "$key = '".zen_db_prepare_input(strip_tags($_POST[$key]))."', ";          
                  } // End of if statement. 

replace with:

if (isset($_POST[$key]) && isset($table_fields[$key]) && eregi("^[[:alnum:]][a-z0-9_.-]*@[a-z0-9.-]+\.[a-z]{2,6}$", zen_db_prepare_input($_POST[$key])) && zen_validate_email($_POST[$key]) == true) {                              
                      $additional_sql .= "$key = '".zen_db_prepare_input($_POST[$key])."'";
                  } elseif (isset($_POST[$key]) && isset($table_fields[$key]) && preg_match("/[a-zA-Z0-9\.\,;:%&#@!\^-_~`\"'\[\]\{\}\*\/\?\(\)\n\r]/", $_POST[$key])) {
                      $additional_sql .= "$key = '".zen_db_prepare_input(strip_tags($_POST[$key]))."'";          
                  } // End of if statement. 

Then, retry the same instructions as above. It should work now (perhaps it's another fix for mySQL v5.x).

[Blitz49]

Its not working still, I am still getting the same error. Forgot to test to input data, when I input a cellphone number I get this error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'customers_cellphone = '213-555-220 where customers_id = '32'' at line 2
in:
[update customers set customers_default_address_id = '32', customers_cellphone = '213-555-2200'customers_cellphone = '213-555-220 where customers_id = '32']

I think this code is the problem

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

[TheOracle]

In order to resolve this problem, I'd need direct access to your FTP server and try this out. Otherwise, it would be quite difficult to fix this. If you wish, send me your server details by email and I will take a look at it.

[Blitz49]

In order to resolve this problem, I'd need direct access to your FTP server and try this out. Otherwise, it would be quite difficult to fix this. If you wish, send me your server details by email and I will take a look at it.

Ok, email sent sxxxxxx######################.

[beilana]

Oracle,

I have noticed that this person may have drop-down date of birth installed.

If this is the case, part of the login gets redirected to Wishmagic for processing rather than <your_template>. You might want to duplicate your code there.

This may or may not be helpful.

Good Luck guys

[beilana]

Never mind - I was wrong. I am having the same problem. Let us all know when you fix it.

Thanks,

[rbepple]

I have finally gotten back to check the status of this MOD and thanks for your hard work and efforts on fixing this MOD. I was wondering what the newest version of the MOD is because I only can find v2.1 that was updated on the 17th and it looks like you did a update on the 22nd or some where around there. Do I need a paypal account to make a donation to you through paypal?

[beilana]

Just another user trying to help out -

Yes - they are fairly easy to set-up - I thought it was different at first, but you send it to his email address once you have set up your account.

[TheOracle]

Sorry for the delay in response. I seem to had difficulties with my internet connection (again) last night + this morning. It would seem to be back in normal now.

I have finally gotten back to check the status of this MOD and thanks for your hard work and efforts on fixing this MOD. I was wondering what the newest version of the MOD is because I only can find v2.1 that was updated on the 17th and it looks like you did a update on the 22nd or some where around there. Do I need a paypal account to make a donation to you through paypal?

Like I said; Package updated on my site. Do NOT trust the DEV team for the downloads section, they're too slow to update. Always check the upload date. Which is why, I have my own site for that (as I send updates to this topic to notify all users).

I have noticed that this person may have drop-down date of birth installed.

If this is the case, part of the login gets redirected to Wishmagic for processing rather than <your_template>. You might want to duplicate your code there.

Again, I do NOT do integration with other MODs unless it involves one of the override files from my package.

Do I need a paypal account to make a donation to you through paypal?

Not that I know of. You can donate directly by using your credit card I believe. If not, then - personally - I'd still suggest to create a paypal account in order to donate (for security reasons in the mean time).

I thought it was different at first, but you send it to his email address once you have set up your account.

Thanks for your input on this.

[rbepple]

Great job everthing works swell on both admin side and customers side, with one little error. I get this error on the customer registration:

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

Any help?