create_account.php has stopped working ok

[earjw]

Hi folks,

I've run into problems with the create_account.php file.

Been running ok for a while, but now I get

0 -

insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id) values ('0', '0', now(), '0')

[TEP STOP]


When someone tries to create an account.

I've tracked it down to the line in the create_account.php

$customer_id = tep_db_insert_id();

just after

tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);

Not bringing back the correct value for $customer_id

The line

tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id) values ('" . (int)$customer_id . "', '0', now(), '". (int)$source . "')");


Is therefore trying to insert the record as customer_id 0 and this is where it bombs out.

Anbody got an idea why the function tep_db_insert_id() would stop working?

Regards,

- Earl