Database Errors - Duplicate Entries - How Did You Hear About Us Mod

[alexsmith2709]

Couldnt edit my post but i've found a fix.

In /includes/modules/create_account.php (you may have this file in YOUR_TEMPLATE folder) i believe either by lack of instruction or concentration there was a block of code which i needed to delete.

Around line 329 you should have code that looks like this:

//rmh referral start
$query_insert= "insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id) values ('" . (int)$_SESSION['customer_id'] . "', '0', now(), '". (int)$source . "')";

$sql = "insert into " . TABLE_CUSTOMERS_INFO . "
(customers_info_id, customers_info_number_of_logons,
customers_info_date_account_created, customers_info_date_of_last_logon)
values ('" . (int)$_SESSION['customer_id'] . "', '1', now(), now())";
$db->Execute($query_insert);

$db->Execute($sql);

If you delete:

$sql = "insert into " . TABLE_CUSTOMERS_INFO . "
(customers_info_id, customers_info_number_of_logons,
customers_info_date_account_created, customers_info_date_of_last_logon)
values ('" . (int)$_SESSION['customer_id'] . "', '1', now(), now())";

It should work for you. If you examine the code you can see that the data is being inserted to the database twice.

Hope this helps people

[limelites]

Hi yeah, I meant to add a response to this last nigth but I was too tired by the tme I'd solved it. Like you, it turned out that another modification in my create_account.php was writing to the same table. In my case it was the 'COWA' mod. I just deleted the duplicate lines from the file and voila, the new mod worked perfectly.