Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

BIG Problem, Please heeeelppp


zxedxz

Recommended Posts

I had been trying to fix this problem for almost a week.. but i'm still gettting the same problem. Someone rescue me.

 

i)

1) Sometimes I get orders that has empty customer information, on the invoice and in admin. Billing address is fine. This errors happens sometimes only.

2) On the database, I get in the customer_default_address_id a weird number, like 30165. (Changing it back to the id that match with the address_id fixes the problem).

 

ii)

1) Sometimes I don't see the order. Everything is fine except that I can't see the order on the admin. My authorize.net does charges the order.

3) On the database, I get the wrong order_id. Changing it back to the right order_id on the table order, order_history, orders total, order_products, fixes it.

 

My problem is why this is happening? How can I prevent this from happening? Can this be a database problem? upgrades? Help.

 

I WILL KISS YOUR ASS IF YOU CAN HELP ME!!!!!!!!

Link to comment
Share on other sites

make sure that you have the latest authorizenet aim and PayPal IPN or PayPal Express Checkout contributions installed. Also, make sure you have them configured properly (i.e. on authorizenet set the return receipt and in PayPal set the IPN urls). Otherwise the orders will be charged by not entered in your database.

Link to comment
Share on other sites

 

 

Nono, The orders are saved into the database. It just input the wrong order_id. Same goes with the customer info which have the wrong customer_id

 

Any help on this?

Link to comment
Share on other sites

Assuming everything is configured correctly, you have the latest payment module contributions and they are installed correctly, your error is obviously not typical with osCommerce. Something would have had to have been changed or altered somewhere if the order id and customer id are being input to those tables wrong like you say. Without seeing the code and working through everything though it is almost impossible to solve here in the forum.

Link to comment
Share on other sites

Assuming everything is configured correctly, you have the latest payment module contributions and they are installed correctly, your error is obviously not typical with osCommerce. Something would have had to have been changed or altered somewhere if the order id and customer id are being input to those tables wrong like you say. Without seeing the code and working through everything though it is almost impossible to solve here in the forum.

 

The thing is, it only happen sometimes... not all the time. Also, I don't think it is the payment script. Since it happens even at create_account alone. Should I post my create_account code?

Link to comment
Share on other sites

The reason it could be payment is there are issues with some of the payment modules if the customer does not return to the site or in authorizenet the return receipt url isn't set. If the payment method doesn't come back to the site it won't log the order properly in osCommerce.

 

Posting the create_account.php file may be helpful, but I highly doubt the problem is originating there.

Link to comment
Share on other sites

Again, there is two different problem. The one i'm having the most problem is blank customer info. It inputs the wrong customer_id and default address into the database. It happens once in a while and not all the time.

Link to comment
Share on other sites

Hey there - from what I can tell you may have a timeout problem.

 

Can you give a better description of what you are using for your server environment, also this may be related to SSL, since it seems to be in areas where you would naturally use SSL and encrypted connection. If you are using a shared SSL cert this could be the problem - it all depends.

 

OSC is like a door with many locks and keys, if all the tumblers do no align properly, OSC kinda runs home to momma.

 

I would double check everything on your database - that is where I think the problem lies. If you are getting bad numbers only sometime, then you may not have auto_increment added, or the number sequence is damaged due to how OSC assigns numbers. I leave every unique primary field on auto_increment. Also, somehow you may be getting a bad md5 hash, I have no clue without dissecting everything you've done.

 

Remember, OSC is really made to work on MYSQL4. If you are using 5, it will bring it's own headaches and nonsense. If you are using earlier versions 3-, or on low cost shared hosting, this can produce unexpected results as well, as you are on virtual hosting and are at the whim of the person who is managing the space.

Nothing unreal exists

Link to comment
Share on other sites

Thanks for repplying and for your help.

 

The website is hosted on a dedicated sever, with geotrust ssl. Please check the website at www.vonita.com

 

I haven't edited anything in the database. As for auto_increment, can you point to me which field should have this? Here is my create_account.php file

 

<?php
/*
 $Id: create_account.php,v 1.65 2003/06/09 23:03:54 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

// needs to be included earlier to set the success message in the messageStack
 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CREATE_ACCOUNT);

// +Login Page a la Amazon
// redirect the customer to a friendly cookie-must-be-enabled page if cookies are disabled (or the session has not started)
 if ($session_started == false) {
tep_redirect(tep_href_link(FILENAME_COOKIE_USAGE));
 }

 if (isset($login_email_address)) $email_address = $login_email_address;
// -Login Page a la Amazon
 $process = false;
 // +Country-State Selector
 $refresh = false;
 if (isset($HTTP_POST_VARS['action']) && (($HTTP_POST_VARS['action'] == 'process') || ($HTTP_POST_VARS['action'] == 'refresh'))) {
if ($HTTP_POST_VARS['action'] == 'process')  $process = true;
if ($HTTP_POST_VARS['action'] == 'refresh') $refresh = true;
 // -Country-State Selector

if (ACCOUNT_GENDER == 'true') {
  if (isset($HTTP_POST_VARS['gender'])) {
	$gender = tep_db_prepare_input($HTTP_POST_VARS['gender']);
  } else {
	$gender = false;
  }
}
$firstname = tep_db_prepare_input($HTTP_POST_VARS['firstname']);
$lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);
if (ACCOUNT_DOB == 'true') $dob = tep_db_prepare_input($HTTP_POST_VARS['dob']);
$email_address = tep_db_prepare_input($HTTP_POST_VARS['email_address']);
// BOF Separate Pricing Per Customer, added: field for tax id number
if (ACCOUNT_COMPANY == 'true') { 
$company = tep_db_prepare_input($HTTP_POST_VARS['company']);
$company_tax_id = tep_db_prepare_input($HTTP_POST_VARS['company_tax_id']);
}
// EOF Separate Pricing Per Customer, added: field for tax id number
$street_address = tep_db_prepare_input($HTTP_POST_VARS['street_address']);
if (ACCOUNT_SUBURB == 'true') $suburb = tep_db_prepare_input($HTTP_POST_VARS['suburb']);
$postcode = tep_db_prepare_input($HTTP_POST_VARS['postcode']);
$city = tep_db_prepare_input($HTTP_POST_VARS['city']);
if (ACCOUNT_STATE == 'true') {
  $state = tep_db_prepare_input($HTTP_POST_VARS['state']);
  if (isset($HTTP_POST_VARS['zone_id'])) {
	$zone_id = tep_db_prepare_input($HTTP_POST_VARS['zone_id']);
  } else {
	$zone_id = false;
  }
}
$country = tep_db_prepare_input($HTTP_POST_VARS['country']);
$telephone = tep_db_prepare_input($HTTP_POST_VARS['telephone']);
$fax = tep_db_prepare_input($HTTP_POST_VARS['fax']);
if (isset($HTTP_POST_VARS['newsletter'])) {
  $newsletter = tep_db_prepare_input($HTTP_POST_VARS['newsletter']);
} else {
  $newsletter = false;
}
$password = tep_db_prepare_input($HTTP_POST_VARS['password']);
$confirmation = tep_db_prepare_input($HTTP_POST_VARS['confirmation']);

// +Country-State Selector
if ($process) {
// -Country-State Selector
$error = false;

if (ACCOUNT_GENDER == 'true') {
  if ( ($gender != 'm') && ($gender != 'f') ) {
	$error = true;

	$messageStack->add('create_account', ENTRY_GENDER_ERROR);
  }
}

if (strlen($firstname) < ENTRY_FIRST_NAME_MIN_LENGTH) {
  $error = true;

  $messageStack->add('create_account', ENTRY_FIRST_NAME_ERROR);
}

if (strlen($lastname) < ENTRY_LAST_NAME_MIN_LENGTH) {
  $error = true;

  $messageStack->add('create_account', ENTRY_LAST_NAME_ERROR);
}

if (ACCOUNT_DOB == 'true') {
  if (checkdate(substr(tep_date_raw($dob), 4, 2), substr(tep_date_raw($dob), 6, 2), substr(tep_date_raw($dob), 0, 4)) == false) {
	$error = true;

	$messageStack->add('create_account', ENTRY_DATE_OF_BIRTH_ERROR);
  }
}

if (strlen($email_address) < ENTRY_EMAIL_ADDRESS_MIN_LENGTH) {
  $error = true;

  $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR);
} elseif (tep_validate_email($email_address) == false) {
  $error = true;

  $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_CHECK_ERROR);
} else {
  $check_email_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");
  $check_email = tep_db_fetch_array($check_email_query);
  if ($check_email['total'] > 0) {
	$error = true;

	$messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR_EXISTS);
  }
}

if (strlen($street_address) < ENTRY_STREET_ADDRESS_MIN_LENGTH) {
  $error = true;

  $messageStack->add('create_account', ENTRY_STREET_ADDRESS_ERROR);
}

if (strlen($postcode) < ENTRY_POSTCODE_MIN_LENGTH) {
  $error = true;

  $messageStack->add('create_account', ENTRY_POST_CODE_ERROR);
}

if (strlen($city) < ENTRY_CITY_MIN_LENGTH) {
  $error = true;

  $messageStack->add('create_account', ENTRY_CITY_ERROR);
}

if (is_numeric($country) == false) {
  $error = true;

  $messageStack->add('create_account', ENTRY_COUNTRY_ERROR);
}

if (ACCOUNT_STATE == 'true') {
  // +Country-State Selector
  if ($zone_id == 0) {
  // -Country-State Selector
	  $error = true;

	  $messageStack->add('create_account', ENTRY_STATE_ERROR_SELECT);
	}
  } else {
	if (strlen($state) < ENTRY_STATE_MIN_LENGTH) {
	  $error = true;

	  $messageStack->add('create_account', ENTRY_STATE_ERROR);
	}
  }
}

if (strlen($telephone) < ENTRY_TELEPHONE_MIN_LENGTH) {
  $error = true;

  $messageStack->add('create_account', ENTRY_TELEPHONE_NUMBER_ERROR);
}


if (strlen($password) < ENTRY_PASSWORD_MIN_LENGTH) {
  $error = true;

  $messageStack->add('create_account', ENTRY_PASSWORD_ERROR);
} elseif ($password != $confirmation) {
  $error = true;

  $messageStack->add('create_account', ENTRY_PASSWORD_ERROR_NOT_MATCHING);
}

if ($error == false) {
  $sql_data_array = array('customers_firstname' => $firstname,
						  'customers_lastname' => $lastname,
						  'customers_email_address' => $email_address,
						  'customers_telephone' => $telephone,
						  'customers_fax' => $fax,
						  'customers_newsletter' => $newsletter,
						  'customers_password' => tep_encrypt_password($password));

  if (ACCOUNT_GENDER == 'true') $sql_data_array['customers_gender'] = $gender;
  if (ACCOUNT_DOB == 'true') $sql_data_array['customers_dob'] = tep_date_raw($dob);
  // BOF Separate Pricing Per Customer
  // if you would like to have an alert in the admin section when either a company name has been entered in
  // the appropriate field or a tax id number, or both then uncomment the next line and comment the default
  // setting: only alert when a tax_id number has been given
 //	if ( (ACCOUNT_COMPANY == 'true' && tep_not_null($company) ) || (ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id) ) ) { 
  if ( ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id)  ) { 
  $sql_data_array['customers_group_ra'] = '1';
  $sql_data_array['customers_group_id'] = '1';
  }
  // EOF Separate Pricing Per Customer
  tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);

  $customer_id = tep_db_insert_id();

  $sql_data_array = array('customers_id' => $customer_id,
						  'entry_firstname' => $firstname,
						  'entry_lastname' => $lastname,
						  'entry_street_address' => $street_address,
						  'entry_postcode' => $postcode,
						  'entry_city' => $city,
						  'entry_country_id' => $country);

  if (ACCOUNT_GENDER == 'true') $sql_data_array['entry_gender'] = $gender;
  if (ACCOUNT_COMPANY == 'true') { // BOF adapted for Separate Pricing Per Customer
  $sql_data_array['entry_company'] = $company;
  $sql_data_array['entry_company_tax_id'] = $company_tax_id;
  } // EOF adapted for Separate Pricing Per Customer
  if (ACCOUNT_SUBURB == 'true') $sql_data_array['entry_suburb'] = $suburb;
  if (ACCOUNT_STATE == 'true') {
	if ($zone_id > 0) {
	  $sql_data_array['entry_zone_id'] = $zone_id;
	  $sql_data_array['entry_state'] = '';
	} else {
	  $sql_data_array['entry_zone_id'] = '0';
	  $sql_data_array['entry_state'] = $state;
	}
  }

  tep_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array);

  //$address_id = tep_db_insert_id();
  $next_insert_value = tep_db_insert_id();
  $address_id = ($next_insert_value == 0 ? 1 : $next_insert_value);

  tep_db_query("update " . TABLE_CUSTOMERS . " set customers_default_address_id = '" . (int)$address_id . "' where customers_id = '" . (int)$customer_id . "'");

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

  if (SESSION_RECREATE == 'True') {
	tep_session_recreate();
  }
  // BOF Separate Pricing Per Customer
// register SPPC session variables for the new customer
// if there is code above that puts new customers directly into another customer group (default is retail)
// then the below code need not be changed, it uses the newly inserted customer group
  $check_customer_group_info = tep_db_query("select c.customers_group_id, cg.customers_group_show_tax, cg.customers_group_tax_exempt from " . TABLE_CUSTOMERS . " c left join " . TABLE_CUSTOMERS_GROUPS . " cg using(customers_group_id) where c.customers_id = '" . $customer_id . "'");
  $customer_group_info = tep_db_fetch_array($check_customer_group_info);
  $sppc_customer_group_id = $customer_group_info['customers_group_id'];
  $sppc_customer_group_show_tax = (int)$customer_group_info['customers_group_show_tax'];
  $sppc_customer_group_tax_exempt = (int)$customer_group_info['customers_group_tax_exempt'];
// EOF Separate Pricing Per Customer
// ################# START MODIFICATIONS HTML EMAIL #################
  $customer_gender = $gender;
  $customer_last_name = $lastname;
// ################# END MODIFICATIONS SEND HTML EMAIL #################
  $customer_first_name = $firstname;
  $customer_default_address_id = $address_id;
  $customer_country_id = $country;
  $customer_zone_id = $zone_id;
  tep_session_register('customer_id');
  tep_session_register('customer_first_name');
  tep_session_register('customer_default_address_id');
  tep_session_register('customer_country_id');
  tep_session_register('customer_zone_id');
  tep_session_register('sppc_customer_group_id');
  tep_session_register('sppc_customer_group_show_tax');
  tep_session_register('sppc_customer_group_tax_exempt');

// restore cart contents
  $cart->restore_contents();

// build the message content
// ################# START MODIFICATIONS HTML EMAIL #################
$Varlogo = ' '.VARLOGO.' ';
$Varhttp = ''.VARHTTP.'';
$Varstyle = ''.VARSTYLE.'';
$Vartable1 = ' '.VARTABLE1.' ' ;
$Vartable2 = ' '.VARTABLE2.' ' ;
$Vartextmail = EMAILWELCOME . EMAILTEXT . EMAILCONTACT . EMAILWARNING;
$Vartrcolor = ' '. TRCOLOR . '  ';
$Varmailfooter = '  ' . EMAIL_TEXT_FOOTER . ' <br><br> ' ;
$Varmailfooter2 = '  <a href="' . HTTP_SERVER . DIR_WS_CATALOG . '">'. HTTP_SERVER . DIR_WS_CATALOG .'</a> '. "\n" . '  <font size=-2>'.EMAIL_TEXT_FOOTERR .'</font> ';
$Varlastname = '' . $HTTP_POST_VARS['lastname'] . '';
// ################ End Added ##############

if (ACCOUNT_GENDER == 'true') {
   if ($HTTP_POST_VARS['gender'] == 'm') {
// ################# START MODIFICATIONS HTML EMAIL #################
//		 $email_text = EMAIL_GREET_MR;
  		$Vartextmail = EMAIL_GREET_MR . EMAILWELCOME . $Vartextwelcome . EMAILTEXT . EMAILCONTACT . EMAILWARNING;
// ################ End Added ##############
   } else {
// ################# START MODIFICATIONS HTML EMAIL #################
//		 $email_text = EMAIL_GREET_MS;
  		$Vartextmail = EMAIL_GREET_MS . EMAILWELCOME . $Vartextwelcome . EMAILTEXT . EMAILCONTACT . EMAILWARNING;
// ################ End Added ##############
   }
} else {
// ################# START MODIFICATIONS HTML EMAIL #################
//	  $email_text = EMAIL_GREET_NONE;
	 $Vartextmail = EMAILWELCOME . $Vartextwelcome . EMAILTEXT . EMAILCONTACT . EMAILWARNING;
// ################ End Added ##############
}

require(DIR_WS_MODULES . 'email/html_create_account_process.php');

if (EMAIL_USE_HTML == 'true') {
$email_text = $html_email_text;
} 
else
{
  $name = $firstname . ' ' . $lastname;

  if (ACCOUNT_GENDER == 'true') {
	 if ($gender == 'm') {
	   $email_text = sprintf(EMAIL_GREET_MR, $lastname);
	 } else {
	   $email_text = sprintf(EMAIL_GREET_MS, $lastname);
	 }
  } else {
	$email_text = sprintf(EMAIL_GREET_NONE, $firstname);
  }

$email_text .=  EMAILWELCOME . "\n\n" . EMAILTEXT ."\n\n" . EMAILCONTACT . 
			EMAIL_TEXT_FOOTER . "\n\n\n" .
			EMAIL_SEPARATOR . "\n" .
			EMAILWARNING . "\n\n";
$email_text .=  HTTP_SERVER . DIR_WS_CATALOG . "\n" . 
			EMAIL_TEXT_FOOTERR . "\n"; 
  $email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;
}
// ###### Added CCGV Contribution #########
 if (NEW_SIGNUP_GIFT_VOUCHER_AMOUNT > 0) {
$coupon_code = create_coupon_code();
$insert_query = tep_db_query("insert into " . TABLE_COUPONS . " (coupon_code, coupon_type, coupon_amount, date_created) values ('" . $coupon_code . "', 'G', '" . NEW_SIGNUP_GIFT_VOUCHER_AMOUNT . "', now())");
$insert_id = tep_db_insert_id($insert_query);
$insert_query = tep_db_query("insert into " . TABLE_COUPON_EMAIL_TRACK . " (coupon_id, customer_id_sent, sent_firstname, emailed_to, date_sent) values ('" . $insert_id ."', '0', 'Admin', '" . $email_address . "', now() )");

$email_text .= sprintf(EMAIL_GV_INCENTIVE_HEADER, $currencies->format(NEW_SIGNUP_GIFT_VOUCHER_AMOUNT)) . "\n\n" .
			   sprintf(EMAIL_GV_REDEEM, $coupon_code) . "\n\n" .
			   EMAIL_GV_LINK . tep_href_link(FILENAME_GV_REDEEM, 'gv_no=' . $coupon_code,'NONSSL', false) .
			   "\n\n";
 }
 if (NEW_SIGNUP_DISCOUNT_COUPON != '') {
	$coupon_code = NEW_SIGNUP_DISCOUNT_COUPON;
$coupon_query = tep_db_query("select * from " . TABLE_COUPONS . " where coupon_code = '" . $coupon_code . "'");
$coupon = tep_db_fetch_array($coupon_query);
	$coupon_id = $coupon['coupon_id'];		
$coupon_desc_query = tep_db_query("select * from " . TABLE_COUPONS_DESCRIPTION . " where coupon_id = '" . $coupon_id . "' and language_id = '" . (int)$languages_id . "'");
$coupon_desc = tep_db_fetch_array($coupon_desc_query);
$insert_query = tep_db_query("insert into " . TABLE_COUPON_EMAIL_TRACK . " (coupon_id, customer_id_sent, sent_firstname, emailed_to, date_sent) values ('" . $coupon_id ."', '0', 'Admin', '" . $email_address . "', now() )");
$email_text .= EMAIL_COUPON_INCENTIVE_HEADER .  "\n" .
			   sprintf("%s", $coupon_desc['coupon_description']) ."\n\n" .
			   sprintf(EMAIL_COUPON_REDEEM, $coupon['coupon_code']) . "\n\n" .
			   "\n\n";

 }
//	$email_text .= EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;
// ###### End Added CCGV Contribution #########
  tep_mail($name, $email_address, EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

// BOF Separate Pricing Per Customer: alert shop owner of account created by a company
  // if you would like to have an email when either a company name has been entered in
  // the appropriate field or a tax id number, or both then uncomment the next line and comment the default
  // setting: only email when a tax_id number has been given
 //	if ( (ACCOUNT_COMPANY == 'true' && tep_not_null($company) ) || (ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id) ) ) { 
  if ( ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id) ) { 
  $alert_email_text = "Please note that " . $firstname . " " . $lastname . " of the company: " . $company . " has created an account.";
  tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, 'Company account created', $alert_email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
  }
// EOF Separate Pricing Per Customer: alert shop owner of account created by a company
  if ($cart->count_contents() == 0) {
  tep_redirect(tep_href_link(FILENAME_CREATE_ACCOUNT_SUCCESS, '', 'SSL'));
	}
	else {
	tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL'));
	}
}
 }

 // +Country-State Selector 
if ($HTTP_POST_VARS['action'] == 'refresh') {$state = '';}
if (!isset($country)) $country = DEFAULT_COUNTRY;
// -Country-State Selector
 $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_CREATE_ACCOUNT, '', 'SSL'));
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<?php require('includes/form_check.js.php'); ?>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
<!-- body_text //-->
<?php echo tep_draw_form('create_account', tep_href_link(FILENAME_CREATE_ACCOUNT, '', 'SSL'), 'post', 'onSubmit="return check_form(create_account);"') . tep_draw_hidden_field('action', 'process'); ?>

<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr><td>
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr>
<td colspan="2" class="pageHeading"><?php echo HEADING_TITLE; ?></td>
</tr><tr>
<td class="smallText"><?php echo sprintf(TEXT_ORIGIN_LOGIN, tep_href_link(FILENAME_LOGIN, tep_get_all_get_params(), 'SSL')); ?></td>
<td class="smallText"><span class="inputRequirement"><?php echo FORM_REQUIRED_INFORMATION; ?></span></td>
</tr></table>

</td></tr>
<?php
 if ($messageStack->size('create_account') > 0) {
?>
<tr>
<td><?php echo $messageStack->output('create_account'); ?></td>
</tr>
<?php
 }
?>
<tr><td><br>
<!--Personal/Address Table -->
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr><td valign="top">

<table border="0" width="100%" cellspacing="0" cellpadding="2"><tr>
<td class="main"><b><?php echo CATEGORY_PERSONAL; ?></b></td>
</tr></table>

<table border="0" cellspacing="2" cellpadding="2">
<?php
 if (ACCOUNT_GENDER == 'true') {
?>
<tr>
<td class="main"><?php echo ENTRY_GENDER; ?></td>
<td class="main"><?php echo tep_draw_radio_field('gender', 'm') . '  ' . MALE . '  ' . tep_draw_radio_field('gender', 'f') . '  ' . FEMALE . ' ' . (tep_not_null(ENTRY_GENDER_TEXT) ? '<span class="inputRequirement">' . ENTRY_GENDER_TEXT . '</span>': ''); ?></td>
</tr>
<?php
 }
?>
<tr>
<td class="main"><?php echo ENTRY_FIRST_NAME; ?></td>
<td class="main"><?php echo '<nobr>' . tep_draw_input_field('firstname') . ' ' . (tep_not_null(ENTRY_FIRST_NAME_TEXT) ? '<span class="inputRequirement">' . ENTRY_FIRST_NAME_TEXT . '</span>': ''); ?></td>
</tr><tr>
<td class="main"><?php echo ENTRY_LAST_NAME; ?></td>
<td class="main"><?php echo tep_draw_input_field('lastname') . ' ' . (tep_not_null(ENTRY_LAST_NAME_TEXT) ? '<span class="inputRequirement">' . ENTRY_LAST_NAME_TEXT . '</span>': ''); ?></td>
</tr>
<?php
 if (ACCOUNT_DOB == 'true') {
?>
<tr>
<td class="main"><?php echo ENTRY_DATE_OF_BIRTH; ?></td>
<td class="main"><?php echo tep_draw_input_field('dob') . ' ' . (tep_not_null(ENTRY_DATE_OF_BIRTH_TEXT) ? '<span class="inputRequirement">' . ENTRY_DATE_OF_BIRTH_TEXT . '</span>': ''); ?></td>
</tr>
<?php
 }
?>
<tr>
<td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td>
<td class="main"><?php echo tep_draw_input_field('telephone') . ' ' . (tep_not_null(ENTRY_TELEPHONE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_TELEPHONE_NUMBER_TEXT . '</span>': ''); ?></td>
</tr><tr>
<td class="main"><?php echo ENTRY_FAX_NUMBER; ?></td>
<td class="main"><?php echo tep_draw_input_field('fax') . ' ' . (tep_not_null(ENTRY_FAX_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_FAX_NUMBER_TEXT . '</span>': ''); ?>
</tr><tr>
<td class="main"><?php echo ENTRY_EMAIL_ADDRESS; ?></td>
<td class="main"><?php echo tep_draw_input_field('email_address') . ' ' . (tep_not_null(ENTRY_EMAIL_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_EMAIL_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr></table>

<!-- Personal/Address Table Second Cell -->
</td><td valign="top">

<table border="0" width="100%" cellspacing="0" cellpadding="2"><tr>
<td class="main"><b><?php echo CATEGORY_ADDRESS; ?></b></td>
</tr><tr><td>
<table border="0" cellspacing="2" cellpadding="2"><tr>
<td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td>
			<td class="main"><?php echo tep_draw_input_field('street_address') . ' ' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td>
		  </tr>
<?php
 if (ACCOUNT_SUBURB == 'true') {
?>
		  <tr>
			<td class="main"><?php echo ENTRY_SUBURB; ?></td>
			<td class="main"><?php echo tep_draw_input_field('suburb') . ' ' . (tep_not_null(ENTRY_SUBURB_TEXT) ? '<span class="inputRequirement">' . ENTRY_SUBURB_TEXT . '</span>': ''); ?></td>
		  </tr>
<?php
 }
?>
		  <tr>
			<td class="main"><?php echo ENTRY_POST_CODE; ?></td>
<td class="main"><?php echo tep_draw_input_field('postcode') . ' ' . (tep_not_null(ENTRY_POST_CODE_TEXT) ? '<span class="inputRequirement">' . ENTRY_POST_CODE_TEXT . '</span>': ''); ?></td>
</tr><tr>
			<td class="main"><?php echo ENTRY_CITY; ?></td>
			<td class="main"><?php echo tep_draw_input_field('city') . ' ' . (tep_not_null(ENTRY_CITY_TEXT) ? '<span class="inputRequirement">' . ENTRY_CITY_TEXT . '</span>': ''); ?></td>
		  </tr>
<?php
 if (ACCOUNT_STATE == 'true') {
?>
		  <tr>
			<td class="main"><?php echo ENTRY_STATE; ?></td>
			<td class="main">
<?php
// +Country-State Selector
$zones_array = array();
	 $zones_query = tep_db_query("select zone_id, zone_name from " . TABLE_ZONES . " where zone_country_id = " . (int)$country . " order by zone_name");
while ($zones_values = tep_db_fetch_array($zones_query)) {
  $zones_array[] = array('id' => $zones_values['zone_id'], 'text' => $zones_values['zone_name']);
  }
if (count($zones_array) > 0) {
  echo tep_draw_pull_down_menu('zone_id', $zones_array, $zones_array[$zone_id - 1]['id']);
} else {
  echo tep_draw_input_field('state');
}
// -Country-State Selector

if (tep_not_null(ENTRY_STATE_TEXT)) echo ' <span class="inputRequirement">' . ENTRY_STATE_TEXT;
?>
			</td>
		  </tr>
<?php
 }
?>
<tr>
<td class="main"><?php echo ENTRY_COUNTRY; ?></td>
<td class="main"><?php echo tep_get_country_list('country',$country,'onChange="return refresh_form(create_account);"') . ' ' . (tep_not_null(ENTRY_COUNTRY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COUNTRY_TEXT . '</span>': ''); ?></td>
</tr></table>
</td></tr></table>
<!-- End Personal/Address Table -->
</td></tr></table>
<?php
 if (ACCOUNT_COMPANY == 'true') {
?>

<table border="0" width="100%" cellspacing="0" cellpadding="2"><tr>
<td class="main"><b><?php echo CATEGORY_COMPANY; ?></b></td>
</tr>
 <tr>
<td class="main">
  <span class="inputRequirement">Please fill this section if applying for salon prices. Orders are subject to approval. Vonita.com have the right to decline orders with unvalid license.</span></td>
 </tr>
 <tr><td>
<table border="0" cellspacing="2" cellpadding="2"><tr>
<td class="main"><?php echo ENTRY_COMPANY; ?></td>
<td class="main"><?php echo tep_draw_input_field('company') . ' ' . (tep_not_null(ENTRY_COMPANY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COMPANY_TEXT . '</span>': ''); ?></td>
</tr>
<!-- BOF Separate Pricing Per Customer: field for tax id number -->
		  <tr>
			<td class="main"><?php echo ENTRY_COMPANY_TAX_ID; ?></td>
			<td class="main"><?php echo tep_draw_input_field('company_tax_id') . ' ' . (tep_not_null(ENTRY_COMPANY_TAX_ID_TEXT) ? '<span class="inputRequirement">' . ENTRY_COMPANY_TAX_ID_TEXT . '</span>': ''); ?></td>
		  </tr>
<!-- EOF Separate Pricing Per Customer: field for tax id number -->
</table>
</td></tr></table>
<?php
 }
?>

<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr><td class="main"><b><?php echo CATEGORY_PASSWORD; ?></b>
</td></tr><tr><td>
<table border="0" cellspacing="2" cellpadding="2"><tr>
<td class="main"><?php echo ENTRY_PASSWORD; ?></td>
<td class="main"><?php echo tep_draw_password_field('password') . ' ' . (tep_not_null(ENTRY_PASSWORD_TEXT) ? '<span class="inputRequirement">' . ENTRY_PASSWORD_TEXT . '</span>': ''); ?>
</td>
<td class="main"><?php echo ENTRY_PASSWORD_CONFIRMATION; ?></td>
<td class="main"><?php echo tep_draw_password_field('confirmation') . ' ' . (tep_not_null(ENTRY_PASSWORD_CONFIRMATION_TEXT) ? '<span class="inputRequirement">' . ENTRY_PASSWORD_CONFIRMATION_TEXT . '</span>': ''); ?>
</td></tr></table>
</td></tr></table>

<table border="0" width="100%" cellspacing="0" cellpadding="2"><tr>
<td class="main"><b><?php echo CATEGORY_OPTIONS; ?></b>
</td></tr><tr><td>
<table border="0" cellspacing="2" cellpadding="2"><tr>
<td class="main"><?php echo ENTRY_NEWSLETTER; ?></td>
<td class="main"><?php echo tep_draw_checkbox_field('newsletter', '1') . ' ' . (tep_not_null(ENTRY_NEWSLETTER_TEXT) ? '<span class="inputRequirement">' . ENTRY_NEWSLETTER_TEXT . '</span>': ''); ?>
</td></tr></table>
</td></tr></table>

<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td class="dotback"> </td></tr>
<tr>
<td align="right"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?>
</td></tr></table>
</td></tr></table>
</form>
<!-- body_text_eof //-->
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php include(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
</table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php include(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Link to comment
Share on other sites

here is the structure of my database. Thank you very much.

 

CREATE TABLE `address_book` (
 `address_book_id` int(11) NOT NULL auto_increment,
 `customers_id` int(11) NOT NULL default '0',
 `entry_gender` char(1) NOT NULL default '',
 `entry_company` varchar(32) default NULL,
 `entry_company_tax_id` varchar(32) default NULL,
 `entry_firstname` varchar(32) NOT NULL default '',
 `entry_lastname` varchar(32) NOT NULL default '',
 `entry_street_address` varchar(64) NOT NULL default '',
 `entry_suburb` varchar(32) default NULL,
 `entry_postcode` varchar(10) NOT NULL default '',
 `entry_city` varchar(32) NOT NULL default '',
 `entry_state` varchar(32) default NULL,
 `entry_country_id` int(11) NOT NULL default '0',
 `entry_zone_id` int(11) NOT NULL default '0',
 PRIMARY KEY  (`address_book_id`),
 KEY `idx_address_book_customers_id` (`customers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1363;

CREATE TABLE `customers` (
 `customers_id` int(11) NOT NULL auto_increment,
 `customers_gender` char(1) NOT NULL default '',
 `customers_firstname` varchar(32) NOT NULL default '',
 `customers_lastname` varchar(32) NOT NULL default '',
 `customers_dob` datetime NOT NULL default '0000-00-00 00:00:00',
 `customers_email_address` varchar(96) NOT NULL default '',
 `customers_default_address_id` int(11) NOT NULL default '0',
 `customers_telephone` varchar(32) NOT NULL default '',
 `customers_fax` varchar(32) default NULL,
 `customers_password` varchar(40) NOT NULL default '',
 `customers_newsletter` char(1) default NULL,
 `customers_group_id` smallint(5) unsigned NOT NULL default '0',
 `customers_group_ra` enum('0','1') NOT NULL default '0',
 `customers_payment_allowed` varchar(255) NOT NULL default '',
 `customers_shipment_allowed` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`customers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1080;


CREATE TABLE `customers_info` (
 `customers_info_id` int(11) NOT NULL default '0',
 `customers_info_date_of_last_logon` datetime default NULL,
 `customers_info_number_of_logons` int(5) default NULL,
 `customers_info_date_account_created` datetime default NULL,
 `customers_info_date_account_last_modified` datetime default NULL,
 `global_product_notifications` int(1) default '0',
 PRIMARY KEY  (`customers_info_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `orders` (
 `orders_id` int(11) NOT NULL auto_increment,
 `customers_id` int(11) NOT NULL default '0',
 `customers_name` varchar(64) NOT NULL default '',
 `customers_company` varchar(32) default NULL,
 `customers_street_address` varchar(64) NOT NULL default '',
 `customers_suburb` varchar(32) default NULL,
 `customers_city` varchar(32) NOT NULL default '',
 `customers_postcode` varchar(10) NOT NULL default '',
 `customers_state` varchar(32) default NULL,
 `customers_country` varchar(32) NOT NULL default '',
 `customers_telephone` varchar(32) NOT NULL default '',
 `customers_email_address` varchar(96) NOT NULL default '',
 `customers_address_format_id` int(5) NOT NULL default '1',
 `delivery_name` varchar(64) NOT NULL default '',
 `delivery_company` varchar(32) default NULL,
 `delivery_street_address` varchar(64) NOT NULL default '',
 `delivery_suburb` varchar(32) default NULL,
 `delivery_city` varchar(32) NOT NULL default '',
 `delivery_postcode` varchar(10) NOT NULL default '',
 `delivery_state` varchar(32) default NULL,
 `delivery_country` varchar(32) NOT NULL default '',
 `delivery_address_format_id` int(5) NOT NULL default '0',
 `billing_name` varchar(64) NOT NULL default '',
 `billing_company` varchar(32) default NULL,
 `billing_street_address` varchar(64) NOT NULL default '',
 `billing_suburb` varchar(32) default NULL,
 `billing_city` varchar(32) NOT NULL default '',
 `billing_postcode` varchar(10) NOT NULL default '',
 `billing_state` varchar(32) default NULL,
 `billing_country` varchar(32) NOT NULL default '',
 `billing_address_format_id` int(5) NOT NULL default '0',
 `payment_method` varchar(32) NOT NULL default '',
 `cc_type` varchar(20) default NULL,
 `cc_owner` varchar(64) default NULL,
 `cc_number` varchar(32) default NULL,
 `cc_expires` varchar(4) default NULL,
 `last_modified` datetime default NULL,
 `date_purchased` datetime default NULL,
 `orders_status` int(5) NOT NULL default '0',
 `orders_date_finished` datetime default NULL,
 `ups_track_num` varchar(25) default NULL,
 `usps_track_num` varchar(25) default NULL,
 `fedex_track_num` varchar(25) default NULL,
 `currency` char(3) default NULL,
 `currency_value` decimal(14,6) default NULL,
 `qbi_imported` tinyint(2) unsigned NOT NULL default '0',
 `fedex_tracking` varchar(20) NOT NULL default '',
 PRIMARY KEY  (`orders_id`),
 KEY `qbi_imported` (`qbi_imported`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2147;

Link to comment
Share on other sites

Gosh darnit - everything looks fine -

 

umm, double check through phpmyadmin (or whatever databse manager) and check to see that the import worked properly.

 

when you look at the structure of the database, it will say auto_increment on the field. It's probably ok.

 

So, what you may have is a bug, or a problem with the live server. Can you check the raw logs on your site? I would look there and see what errors are being generated, it may point you in the right direction

 

running out of things to check - definitely look at the logs.

 

 

One last thing, your auto_increment is set to start at

 

AUTO_INCREMENT=2147;

 

I would start comparing problems and see what bad data is being generated, perhaps something is being truncated - you field size may be too small - jeez I am running out of options!

Nothing unreal exists

Link to comment
Share on other sites

Again, Thank you very much for your help.

 

I went to look at my error_log file and it is filled with 36mb of the similar error. Please let me know what it means.

 

PHP Warning: Invalid argument supplied for foreach() in 
/var/www/vhosts/vonita.com/httpdocs/includes/boxes/categories.php

 

PHP Warning: main(includes/languages/english/) [<a 
href='function.main'>function.main</a>]: failed to open stream: Operation not 
permitted in 
/var/www/vhosts/vonita.com/httpdocs/admin/includes/application_top.php on line

 PHP Warning: main() [<a 
href='function.include'>function.include</a>]: Failed opening 
'includes/languages/english/' for inclusion (include_path='.:') in 
/var/www/vhosts/vonita.com/httpdocs/admin/includes/application_top.php

Link to comment
Share on other sites

Still need help with this.

 

1) Customer_default_address_id in customer table still have the wrong id number (weird number with 6 digicts)

2) Order_id also have the same problem in order table and order total table.

 

 

HELP HEEEELP

Link to comment
Share on other sites

  • 2 weeks later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...