1054 - Unknown column 'customers_findus' in 'field list'

[amarbhanu]

i did one field add customers_findus in customers table then code modification in create_account.php when fill form then generate error:-

 

1054 - Unknown column 'customers_findus' in 'field list'

 

insert into customers (customers_firstname, customers_lastname, customers_email_address, customers_mobile, customers_findus, customers_telephone, customers_fax, customers_newsletter, customers_password, customers_gender) values ('sdfsdfsdf', 'sdfsdf', 'sdfsdfsd@dfsd.com', '456456', 'Google', '4564654645', '', '1', '29b395484da14b3c2b8f8c6b2397f27d:2d', '1')

 

 

Please suggest me why came that error i checked when customers_findus field delete then error not given but i need to add customers_findus field add so Please suggest me............

 

how to solve problem

[multimixer]

Does "customers_findus" exist in your database?

[♥mdtaylorlrim]

i did one field add customers_findus in customers table then code modification in create_account.php when fill form then generate error:-

 

1054 - Unknown column 'customers_findus' in 'field list'

 

insert into customers (customers_firstname, customers_lastname, customers_email_address, customers_mobile, customers_findus, customers_telephone, customers_fax, customers_newsletter, customers_password, customers_gender) values ('sdfsdfsdf', 'sdfsdf', 'sdfsdfsd@dfsd.com', '456456', 'Google', '4564654645', '', '1', '29b395484da14b3c2b8f8c6b2397f27d:2d', '1')

 

 

Please suggest me why came that error i checked when customers_findus field delete then error not given but i need to add customers_findus field add so Please suggest me............

 

how to solve problem

You must not have gotten the spelling right, or got it into the wrong table, or something. Check your database table for the customers_findus field.

[amarbhanu]

I checked spelling is not wrong customers_findus

[amarbhanu]

hi mdtaylorlrim & multimixer

 

i checked it not wrong customers_findus spelling.......................

 

customers_id customers_gender customers_firstname customers_lastname customers_dob customers_email_address customers_default_address_id customers_mobile customers_findus customers_telephone customers_fax customers_password customers_newsletter

 

 

i don't know why come so Please help me.........

[multimixer]

Does the field "customer_findus" exist in table customers of your database?

[amarbhanu]

Does the field "customer_findus" exist in table customers of your database?

 

yes............exist in table customers

[♥mdtaylorlrim]

yes............exist in table customers

Sounds like you need a second pair of eyes looking over your code. I know I can look at things for days and finally find a simple error that fixes everything. Maybe you're to that point.

[multimixer]

Can you say all relevant changes you did in the file 1 by 1?

[amarbhanu]

Can you say all relevant changes you did in the file 1 by 1?

 

DROP TABLE IF EXISTS customers;

CREATE TABLE `customers` (

`customers_id` int(11) NOT NULL auto_increment,

`customers_gender` char(1) NOT NULL,

`customers_firstname` varchar(32) NOT NULL,

`customers_lastname` varchar(32) NOT NULL,

`customers_dob` datetime NOT NULL default '0000-00-00 00:00:00',

`customers_email_address` varchar(96) NOT NULL,

`customers_default_address_id` int(11) default NULL,

`customers_mobile` varchar(32) NOT NULL,

`customers_findus` varchar(32) default NULL,

`customers_telephone` varchar(32) NOT NULL,

`customers_fax` varchar(32) default NULL,

`customers_password` varchar(40) NOT NULL,

`customers_newsletter` char(1) default NULL,

PRIMARY KEY (`customers_id`),

KEY `idx_customers_email_address` (`customers_email_address`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;

 

 

 

create_account.php

 

<?php

..........

 

'customers_mobile' => $mobile,

'customers_findus' => $findus,

 

.........

?>

and also others........

[multimixer]

and also others........

Somewhere there is the point

[amarbhanu]

Somewhere there is the point

 

create_account.php

 

<?php

.........

$telephone = tep_db_prepare_input($HTTP_POST_VARS['telephone']);

$findus = tep_db_prepare_input($HTTP_POST_VARS['findus']);

......

 

'customers_mobile' => $mobile,

'customers_findus' => $findus,

........................

........

 

?>

..................

..........

<tr>

<td class="main b_width"><strong><?php echo "Find us" ?></strong></td>

<td class="main width2_100"><select name="findus">

<option value="Google">Google</option>

<option value="Yahoo">Yahoo</option>

<option value="Other Search Engine">Other Search Engine</option>

<option value="Social Networking (Facebook)">Social Networking (Facebook)</option>

<option value="Word of Mouth">Word of Mouth</option>

<option value="Internet Article">Internet Article</option>

<option value="Other">Other</option>

</select>

</td>

</tr>

 

I did only like this type of code then given error........... 1054-Unknown column when form fill and submit..........

[amarbhanu]

 

multimixer please suggest me........... how to remove that problem.........

 

[amarbhanu]

Sounds like you need a second pair of eyes looking over your code. I know I can look at things for days and finally find a simple error that fixes everything. Maybe you're to that point.

 

please suggest me what is error....

[multimixer]

Can you post the complete file?

 

Please use code tags (look like this <> in the reply menu)

this is in code tags

[amarbhanu]

Can you post the complete file?

 

Please use code tags (look like this <> in the reply menu)

this is in code tags

 

<?php
/*
$Id: create_account.php 1739 2007-12-20 00:52:16Z hpdl $

osCommerce, Open Source E-Commerce Solutions
[url="http://www.oscommerce.com/"]http://www.oscommerce.com[/url]

Copyright © 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);

$process = false;
if (isset($HTTP_POST_VARS['action']) && ($HTTP_POST_VARS['action'] == 'process')) {
$process = true;

if (ACCOUNT_GENDER == 'true') {
	if (isset($HTTP_POST_VARS['gender'])) {
	$gender = tep_db_prepare_input($HTTP_POST_VARS['gender']);
	} else {
// 	$gender = false;
	$gender = true;

	}
}
$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']);
if (ACCOUNT_COMPANY == 'true') $company = tep_db_prepare_input($HTTP_POST_VARS['company']);
$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']);
$mobile = tep_db_prepare_input($HTTP_POST_VARS['mobile']);
$telephone = tep_db_prepare_input($HTTP_POST_VARS['telephone']);
$findus = tep_db_prepare_input($HTTP_POST_VARS['findus']);

$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']);

 $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) {
	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;
	$error = false;

	// $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') {
	$zone_id = 0;
	 $check_query = tep_db_query("select count(*) as total from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "'");
	$check = tep_db_fetch_array($check_query);
	 $entry_state_has_zones = ($check['total'] > 0);
	if ($entry_state_has_zones == true) {
	$zone_query = tep_db_query("select distinct zone_id from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' and (zone_name = '" . tep_db_input($state) . "' or zone_code = '" . tep_db_input($state) . "')");
	if (tep_db_num_rows($zone_query) == 1) {
	$zone = tep_db_fetch_array($zone_query);
	$zone_id = $zone['zone_id'];
	} else {
	$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_mobile' => $mobile,
	'customers_findus' => $findus,
	'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);

	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') $sql_data_array['entry_company'] = $company;
	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();

	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();
	}

	$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');

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

// build the message content
	$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 .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;
	tep_mail($name, $email_address, EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

	tep_redirect(tep_href_link(FILENAME_CREATE_ACCOUNT_SUCCESS, '', 'SSL'));
}
}

$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>Wireless Lighting Store - My Account <?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">
<script type="text/javascript" src="js/crawler.js"></script>
<script type="text/javascript" src="iepngfix_tilebg.js"></script>
<style type="text/css">
.ie6_png 			{behavior: url("iepngfix.htc") }
.ie6_png img		{behavior: url("iepngfix.htc") }
.ie6_png input		{behavior: url("iepngfix.htc") }
</style>
<!--[if IE]>
<script type="text/javascript" src="ie_png.js"></script>
<script type="text/javascript">
	ie_png.fix('.png');
</script>
<![endif]-->
<?php require('includes/form_check.js.php'); ?>
</head>
<body>
<!-- header //-->
<?php $tab_sel = 5; ?>
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" class="<?php echo MAIN_TABLE; ?>" cellspacing="0" cellpadding="0">
<tr>
<td class="<?php echo BOX_WIDTH_TD_LEFT; ?>"><table border="0" class="<?php echo BOX_WIDTH_LEFT; ?>" cellspacing="0" cellpadding="0">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td class="<?php echo CONTENT_WIDTH_TD; ?>"><?php echo panel_top(); ?><?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'); ?>

<?php echo tep_draw_top();?>

<?php echo tep_draw_title_top();?>

			<?php echo HEADING_TITLE; ?>

<?php echo tep_draw_title_bottom();?>

<?php echo tep_draw1_top();?>

<table cellpadding="0" cellspacing="0" border="0">
	<tr>
	<td class="smallText"><br><?php echo sprintf(TEXT_ORIGIN_LOGIN, tep_href_link(FILENAME_LOGIN, tep_get_all_get_params(), 'SSL')); ?></td>
	</tr>
	<tr>
	 <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	</tr>
<?php
if ($messageStack->size('create_account') > 0) {
?>
	 <tr>
	<td><?php echo $messageStack->output('create_account'); ?></td>
	 </tr>
</table>

<?php echo tep_pixel_trans();?>

<?php
}
?>

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

<?php echo tep_draw_infoBox_top();?>

	 	<table border="0" cellspacing="4" cellpadding="2">
<?php
/* if (ACCOUNT_GENDER == 'true') {
?>
	<tr>
	 <td class="main b_width"><strong><?php echo ENTRY_GENDER; ?></strong></td>
	<td class="main radio"><?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 b_width"><strong><?php echo ENTRY_FIRST_NAME; ?></strong></td>
	<td class="main width2_100"><?php echo 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 b_width"><strong><?php echo ENTRY_LAST_NAME; ?></strong></td>
	<td class="main width2_100"><?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 b_width"><strong><?php echo ENTRY_DATE_OF_BIRTH; ?></strong></td>
	<td class="main width2_100"><?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 b_width"><strong><?php echo ENTRY_EMAIL_ADDRESS; ?></strong></td>
	<td class="main width2_100"><?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>

<?php echo tep_draw_infoBox_bottom();?>

<?php
/*if (ACCOUNT_COMPANY == 'true') {
?>

<?php echo tep_pixel_trans();?>

<table cellpadding="0" cellspacing="0" border="0">
	<tr>
	<td class="main indent_2"><b><?php echo CATEGORY_COMPANY; ?></b></td>
	</tr>
</table>

<?php echo tep_draw_infoBox_top();?>

 		<table border="0" cellspacing="4" cellpadding="2">
<tr>
	<td class="main b_width"><strong><?php echo ENTRY_COMPANY; ?></strong></td>
	<td class="main width2_100"><?php echo tep_draw_input_field('company') . ' ' . (tep_not_null(ENTRY_COMPANY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COMPANY_TEXT . '</span>': ''); ?></td>
	</tr>
	</table>

<?php echo tep_draw_infoBox_bottom();?>

<?php
}*/
?>

<?php echo tep_pixel_trans();?>

 <table cellpadding="0" cellspacing="0" border="0">
<tr>
	<td class="main indent_2"><b><?php echo CATEGORY_ADDRESS; ?></b></td>
	</tr>
 </table>

<?php echo tep_draw_infoBox_top();?>

		<table border="0" cellspacing="4" cellpadding="2">
	<?php
if (ACCOUNT_SUBURB == 'true') {
?>
	<tr>
	<td class="main b_width"><strong><?php echo ENTRY_SUBURB; ?></strong></td>
	<td class="main width2_100"><?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 b_width"><strong><?php echo ENTRY_STREET_ADDRESS; ?></strong></td>
	<td class="main width2_100"><?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>


	<tr>
	<td class="main b_width"><strong><?php echo ENTRY_CITY; ?></strong></td>
	<td class="main width2_100"><?php echo tep_draw_input_field('city') . ' ' . (tep_not_null(ENTRY_CITY_TEXT) ? '<span class="inputRequirement">' . ENTRY_CITY_TEXT . '</span>': ''); ?></td>
	</tr>
 <tr>
	 <td class="main b_width"><strong><?php echo ENTRY_POST_CODE; ?></strong></td>
	<td class="main width2_100"><?php echo tep_draw_input_field('postcode') . ' ' . (tep_not_null(ENTRY_POST_CODE_TEXT) ? '<span class="inputRequirement">' . ENTRY_POST_CODE_TEXT . '</span>': ''); ?></td>
	</tr>
<?php
if (ACCOUNT_STATE == 'true') {
?>
	<tr>
	<td class="main b_width"><strong><?php echo ENTRY_STATE; ?></strong></td>
	<td class="main width2_100">
<?php
if ($process == true) {
	if ($entry_state_has_zones == true) {
	$zones_array = array();
	$zones_query = tep_db_query("select 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_name'], 'text' => $zones_values['zone_name']);
	}
	echo tep_draw_pull_down_menu('state', $zones_array);
	} else {
echo tep_draw_input_field('state');
	}
} else {
	 echo tep_draw_input_field('state');
}

if (tep_not_null(ENTRY_STATE_TEXT)) echo ' <span class="inputRequirement">' . ENTRY_STATE_TEXT;
?>
	 </td>
	</tr>
<?php
}
?>
<!--<tr>
	<td class="main b_width"><strong><?php //echo "Find us" ?></strong></td>
	<td class="main width2_100"><?php //echo tep_get_findus_list('findus') . ' ' . (tep_not_null(ENTRY_FINDUS_TEXT) ? '<span class="inputRequirement">' . ENTRY_FINDUS_TEXT . '</span>': ''); ?></td>
			</tr>
	 <tr>-->
 <tr>
	<!--<td class="main b_width"><strong><?php //echo ENTRY_COUNTRY; ?></strong></td>
	<td class="main width2_100"><?php //echo tep_get_country_list('country') . ' ' . (tep_not_null(ENTRY_COUNTRY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COUNTRY_TEXT . '</span>': ''); ?></td>
			</tr>-->

			<td class="main b_width"><strong><?php echo ENTRY_COUNTRY; ?></strong></td>
	<td class="main width2_100"><?php echo tep_get_country_list('country','222'); ?></td>
	</table>

<?php echo tep_draw_infoBox_bottom();?>

<?php echo tep_pixel_trans();?>

<table cellpadding="0" cellspacing="0" border="0">
	<tr>
	<td class="main indent_2"><b><?php echo CATEGORY_CONTACT; ?>% ' ' . (tep_not_null(ENTRY_MOBILE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_MOBILE_NUMBER_TEXT . '</span>': ''); ?></td>
	</tr>
 <tr>
	<td class="main b_width"><strong><?php echo "Find us" ?></strong></td>
	<td class="main width2_100"><select name="findus">
<option value="Google">Google</option>
<option value="Yahoo">Yahoo</option>
<option value="Other Search Engine">Other Search Engine</option>
<option value="Social Networking (Facebook)">Social Networking (Facebook)</option>
<option value="Word of Mouth">Word of Mouth</option>
<option value="Internet Article">Internet Article</option>
<option value="Other">Other</option>
</select>
</td>
		</tr>

	<!-- <tr>
	<td class="main b_width"><strong><%2 ' ' . (tep_not_null(ENTRY_MOBILE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_MOBILE_NUMBER_TEXT . '</span>': ''); ?></td>
	</tr>
 <tr>
	<td class="main b_width"><strong><?php echo "Find us" ?></strong></td>
	<td class="main width2_100"><select name="findus">
<option value="Google">Google</option>
<option value="Yahoo">Yahoo</option>
<option value="Other Search Engine">Other Search Engine</option>
<option value="Social Networking (Facebook)">Social Networking (Facebook)</option>
<option value="Word of Mouth">Word of Mouth</option>
<option value="Internet Article">Internet Article</option>
<option value="Other">Other</option>
</select>
</td>
		</tr>

	<!-- <tr>
	<td class="main b_width"><strong><?php //echo ENTRY_FAX_NUMBER; ?></strong></td>
	<td class="main width2_100"><?php //echo tep_draw_input_field('fax') . ' ' . (tep_not_null(ENTRY_FAX_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_FAX_NUMBER_TEXT . '</span>': ''); ?></td>
	</tr>-->
	</table>

<?php echo tep_draw_infoBox_bottom();?>

<?php echo tep_pixel_trans();?>

<?php echo tep_draw_infoBox_top();?>

		<table border="0" cellspacing="4" cellpadding="2">
	<tr>
	<td class="main b_width"><strong><?php echo ENTRY_NEWSLETTER; ?></strong></td>
	<td class="main radio"><?php echo tep_draw_checkbox_field('newsletter', '1') . ' ' . (tep_not_null(ENTRY_NEWSLETTER_TEXT) ? '<span class="inputRequirement">' . ENTRY_NEWSLETTER_TEXT . '</span>': ''); ?></td>
	</tr>
	</table>

<?php echo tep_draw_infoBox_bottom();?>

<?php echo tep_pixel_trans();?>

<table cellpadding="0" cellspacing="0" border="0">
	<tr>
	<td class="main indent_2"><b><?php echo CATEGORY_PASSWORD; ?></b></td>
	</tr>
</table>

<?php echo tep_draw_infoBox_top();?>

		<table border="0" cellspacing="4" cellpadding="2">
	<tr>
	<td class="main b_width"><strong><?php echo ENTRY_PASSWORD; ?></strong></td>
	<td class="main width2_100"><?php echo tep_draw_password_field('password') . ' ' . (tep_not_null(ENTRY_PASSWORD_TEXT) ? '<span class="inputRequirement">' . ENTRY_PASSWORD_TEXT . '</span>': ''); ?></td>
	</tr>
	<tr>
	 <td class="main b_width"><strong><?php echo ENTRY_PASSWORD_CONFIRMATION; ?></strong></td>
	 <td class="main width2_100"><?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>

<?php echo tep_draw_infoBox_bottom();?>

<?php echo tep_pixel_trans();?>

<?php echo tep_draw_infoBox2_top();?>

		<table border="0" width="100%" cellspacing="0" cellpadding="2">
			 <tr><td align="right"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></td></tr>
	</table>

<?php echo tep_draw_infoBox2_bottom();?>

<?php echo tep_draw1_bottom();?>

<?php echo tep_draw_bottom();?>

</form><div id="googleCheckoutLogo" align="right" style="padding-right:35px;"></div><script src='https://checkout.google.com/buttons/logos?merchant_id=836537751752247&loc=en_GB&f=png' ></script></td>
<!-- body_text_eof //-->
<!--<td class="<?php echo BOX_WIDTH_TD_RIGHT; ?>"><table border="0" class="<?php echo BOX_WIDTH_RIGHT; ?>" cellspacing="0" cellpadding="0">-->
<!-- 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 //-->
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
try {
var pageTracker = _gat._getTracker("UA-11037589-1");
pageTracker._trackPageview();
} catch(err) {}</script>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> 

[♥mdtaylorlrim]

I don't see that query in the first post anywhere in the code.... Anyone else?

[MrPhil]

Clearly you have a field name of customer_findus in some places and customers_findus in others. Probably the database field was defined for the former (no "s") and the code with the latter (with "s"). Did you create the database field manually? If so, you simply misspelled it. In any case, if all your code is consistently "customers", just change the name of the database field to match it.

[amarbhanu]

Clearly you have a field name of customer_findus in some places and customers_findus in others. Probably the database field was defined for the former (no "s") and the code with the latter (with "s"). Did you create the database field manually? If so, you simply misspelled it. In any case, if all your code is consistently "customers", just change the name of the database field to match it.

 

I checked there is not this types of error...........

[amarbhanu]

I don't see that query in the first post anywhere in the code.... Anyone else?

 

no any another code i did manual database update for customers_findus i did work only create_account.php some modification of code so please help me.......

[amarbhanu]

Thanks to all for good support.................:D

[MrPhil]

Well, the error message says that the code is requesting "customers_findus" and it's not being found. The database, in that table, does not contain a field by that name. Most likely you either forgot to add it, or put it in the wrong table, or misspelled it while adding it (including typos with invisible characters, such as x00 ?). It's got to be one of those three choices. If you're sure that the correct table contains "customers_findus", delete that field and carefully re-add it, to avoid typos (invisible characters in the name, etc.). If your keyboard is non-English (or at least, non-Latin alphabet), be very careful that you use the correct Latin characters and not something from another alphabet that "looks a lot like...".

 

Can you use phpMyAdmin to insert and query on that field (customers_findus)? If not, it indicates that there is something terribly wrong with the table. If deleting the field and re-adding it doesn't work, you'll have to bring in your hosting service to see what's wrong with your database. You might first try CHECK and REPAIR of the table just to see if anything shows up there.

[amarbhanu]

Well, the error message says that the code is requesting "customers_findus" and it's not being found. The database, in that table, does not contain a field by that name. Most likely you either forgot to add it, or put it in the wrong table, or misspelled it while adding it (including typos with invisible characters, such as x00 ?). It's got to be one of those three choices. If you're sure that the correct table contains "customers_findus", delete that field and carefully re-add it, to avoid typos (invisible characters in the name, etc.). If your keyboard is non-English (or at least, non-Latin alphabet), be very careful that you use the correct Latin characters and not something from another alphabet that "looks a lot like...".

 

Can you use phpMyAdmin to insert and query on that field (customers_findus)? If not, it indicates that there is something terribly wrong with the table. If deleting the field and re-adding it doesn't work, you'll have to bring in your hosting service to see what's wrong with your database. You might first try CHECK and REPAIR of the table just to see if anything shows up there.

 

thanks to all but here case different no any error in code error or mistake was in database name so create problem same same name but minor difference of position................

 

so again very thanks full to all ...........