New customer account generates error

[swguy]

Take a screenshot of customer_info and customers so we can see them both in their current state.

[swguy]

Just do this through admin->tools->Install sql patches

insert into customers (customers_id) values (10);
insert into customers_info (customers_info_id) values (10);

(assuming your highest number in either table is less than 10; otherwise bump it to 1 higher than the highest number).
Then try creating an account using the shopping cart account creation process.

[michaelchu]

Just do this through admin->tools->Install sql patches

insert into customers (customers_id) values (10);
insert into customers_info (customers_info_id) values (10);

(assuming your highest number in either table is less than 10; otherwise bump it to 1 higher than the highest number).
Then try creating an account using the shopping cart account creation process.

Nope, same error with id 11 now.

[DrByte]

None of this should happen with unaltered core code, since it goes to great lengths to keep all the records in sync with each other.

You said you were deleting a "test customer". Did you first delete the orders associated with that customer?

[michaelchu]

The order was deleted along with the test customer.
I finally got around to compare the current customer.php with the original the only difference is the statements inserted by the customer referral add-on (see the following):

<!-- bof rmh -->
                <td class="dataTableHeadingContent" align="left" valign="top">
                  <?php echo (($_GET['list_order']=='id-asc' or $_GET['list_order']=='id-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_REFERRED_BY . '</span>' : TABLE_HEADING_REFERRED_BY); ?><br>
                  <a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=id-asc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='id-asc' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</b>'); ?></a>&nbsp;
                  <a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=id-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='id-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</b>'); ?></a>
                </td>
<!-- eof rmh -->

//rmh referral start
      $source_query = "select customers_info_source_id  from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . $customers->fields['customers_id'] . "'";
      $source = $db->Execute($source_query);
      $entry_referral = zen_get_sources_name($source->fields['customers_info_source_id'], $customers->fields['customers_id']);
//rmh referral end 

<!-- bof rmh -->
                <td class="dataTableContent"><?php echo $entry_referral; ?></td>
<!-- eof rmh -->

[michaelchu]

Here is a screen shot of the customers table.