SEO URL Error during checkout Please Help!

[OffRoad1]

I installed Seo Url last week and when you go to checkout right after you create an account it goes to create_account.php then displays the following error:

 

0 -

 

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

 

[TEP STOP]

 

When I turn th SEO Url's off to false the checkout works fine. I want to be able to keep this on if anyone has seen this before after they installed SEO URL on there site plese let me know. Thanks

[Guest]

There are 2 fixes for this. The first requires you to edit the includes/functions/database.php file. Find this code:

  function tep_db_insert_id() {
return mysql_insert_id();
 }

and change it to this:

  function tep_db_insert_id() {
global $db_link;
if ( is_resource($db_link ){
	return mysql_insert_id($db_link);
} else {
	return mysql_insert_id();
}
 }

This passes the resource identifier to the mysql_insert_id() function and should correct the issue at the root level. In addition, you should modify the includes/configure.php file and change the USE_PCONNECT to false.

[OffRoad1]

There are 2 fixes for this. The first requires you to edit the includes/functions/database.php file. Find this code:

  function tep_db_insert_id() {
return mysql_insert_id();
 }

and change it to this:

  function tep_db_insert_id() {
global $db_link;
if ( is_resource($db_link ){
	return mysql_insert_id($db_link);
} else {
	return mysql_insert_id();
}
 }

This passes the resource identifier to the mysql_insert_id() function and should correct the issue at the root level. In addition, you should modify the includes/configure.php file and change the USE_PCONNECT to false.

 

I changed the database.php file like you said and the configure.php file then i checked the site and it just showed a white blank page for the domain. Then the changed the configure file back to the original and still the blank page on the domain. I then changed the database.php file back to the original and then my site came back up like normal. Any reason as to why this mod makes my whole site go blank?

[OffRoad1]

???? Can Someone Please Help

I changed the database.php file like you said and the configure.php file then i checked the site and it just showed a white blank page for the domain. Then the changed the configure file back to the original and still the blank page on the domain. I then changed the database.php file back to the original and then my site came back up like normal. Any reason as to why this mod makes my whole site go blank?