user name with hyphen causing error

when this user tries to access the storefront he's getting the following 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 'Regan' where customers_id = '893'' at line 1

update osc_customers set customers_username = 'Barry O'Regan' where customers_id = '893'

[TEP STOP]

when I remove the hyphen it works fine.

Any ideas for a fix other than chaging his name?

Thanks!
David

Hi,

Sorry about this.

You will need to edit your shop/includes/application_top.php

Find around line 525:

PHP Code:

$check_customer_query = tep_db_query("select customers_firstname, customers_default_address_id from " . TABLE_CUSTOMERS . "  where customers_id = '". $usersid ."'");

Add before it:

PHP Code:

$customers_gender = 'm'; $customers_default_address_id = '0'; $customers_newsletter = '1';

Find around line 528:

PHP Code:

  tep_db_query("insert into " . TABLE_CUSTOMERS . " (customers_id, customers_username, customers_gender, customers_firstname, customers_email_address, customers_default_address_id, customers_newsletter) VALUES ('$usersid', '$vbusername', 'm', '$vbusername', '$vbemail', '0', '1')");

Replace with:

PHP Code:

      $sql_data_array = array('customers_id' => $usersid,                               'customers_username' => $vbusername,                               'customers_gender' => $customers_gender,                               'customers_firstname' => $vbusername,                               'customers_email_address' => $vbemail,                               'customers_default_address_id' => $customers_default_address_id,                               'customers_newsletter' => $customers_newsletter);                          tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);

Find around line 576:

PHP Code:

  tep_db_query("update " . TABLE_CUSTOMERS . " set customers_username = '" . $vbusername . "' where customers_id = '" . $usersid . "'");

Replace with:

PHP Code:

      $sql_data_array = array('customers_username' => $vbusername);                tep_db_perform(TABLE_CUSTOMERS, $sql_data_array, 'update', "customers_id = '" . $usersid . "'");

Thanks for getting back so quickly.

I made the changes but when I uploaded the file I got this error message:

PHP Code:

Warning: require(packages/shop/includes/languages//FILENAME_DEFAULT) [function.require]: failed to open stream: No such file or directory in [path]/ :) /shop/shop.php on line 52 Warning: require(packages/shop/includes/languages//FILENAME_DEFAULT) [function.require]: failed to open stream: No such file or directory in [path]/ :) /shop/shop.php on line 52 Fatal error: require() [function.require]: Failed opening required 'packages/shop/includes/languages//FILENAME_DEFAULT' (include_path='.:/usr/lib/php:/usr/local/lib/php') in / :) / :) / :) / :) / :) /shop/shop.php on line 52

I'm wondering since I have the hide products from usergroups mod that maybe something was missed? If you need access again just let me know.
Thanks

Hi,

I have made the chances to your 'shop/includes/application_top.php', using the above code I posted.

Can you test it and let me know if it's ok.

Yes, it is working. Thanks again for your help!