OsCommerce Error: insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values (‘0’, ‘0’, now())

Mr Mackintosh — Thu, 14 Jun 2007 12:33:15 +0000

Stumbled accross this nasty little error on a client’s installation of OsCommerce. The problem occurs when a new user is signing up, so this can be a real show stopper and cost sales!

Anyway thankfully I quickly found the solution and the fix is pretty quick and simple

catalog/includes/functions/database.php. Find the line relating to tep_db_insert_id and change it to:
function tep_db_insert_id( $link = 'db_link') { global $$link; return mysql_insert_id($$link); }

By the looks of the solution, perhaps problem occurs because of a non persistant database connection, or other subsequent queries having run.

http://forums.oscommerce.com/index.php?showtopic=155215

The post OsCommerce Error: insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values (‘0’, ‘0’, now()) appeared first on Mr Kirkland.

E-commerce – Mr Kirkland

OsCommerce Error: insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values (‘0’, ‘0’, now())